surat

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package project;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.io.*;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;

/**
 *
 * @author Rency
 */
public class Surat {

    private String noSurat,  perihal,  pengirim,  penerima;
    private int tglSrt,  blnSrt,  thnSrt;
    private int tglDiterima,  blnDiterima,  thnDiterima;

    public Surat() {
    }

    public Surat(String noSurat, String perihal, int tglSrt, int blnSrt, int thnSrt,
            int tglDiterima, int blnDiterima, int thnDiterima,
            String pengirim, String penerima) {
        this.noSurat = noSurat;
        this.perihal = perihal;
        this.tglSrt = tglSrt;
        this.blnSrt = blnSrt;
        this.thnSrt = thnSrt;
        this.tglDiterima = tglDiterima;
        this.blnDiterima = blnDiterima;
        this.thnDiterima = thnDiterima;
        this.pengirim = pengirim;
        this.penerima = penerima;
    }

    public void save() throws IOException {
        JFileChooser chooser = new JFileChooser();
        int option = chooser.showSaveDialog(chooser);

        if (option == JFileChooser.APPROVE_OPTION) {
            String file = chooser.getSelectedFile().getPath();
            File outFile = new File(file);
            FileOutputStream outFileStream = new FileOutputStream(outFile, true);
            PrintWriter outStream = new PrintWriter(outFileStream);
         
           
            String surat = null;

            surat = this.getNoSurat() + ":" + this.getPerihal() + ":" + this.getTglSrt() + "/" + this.getBlnSrt() + "/" +
                    this.getThnSrt() + ":" + this.getTglDiterima() + "/" + this.getBlnDiterima() + "/" + this.getThnDiterima() + ":" +
                    this.getPengirim() + ":" + this.getPenerima()+"\n";

            outStream.println(surat);
            outStream.close();
           
        } else {
            JOptionPane.showMessageDialog(null, "ERROR");
        }

    }

    public String getNoSurat() {
        return noSurat;
    }

    public void setNoSurat(String nomor) {
        this.noSurat = nomor;
    }

    public String getPerihal() {
        return perihal;
    }

    public void setPerihal(String perihal) {
        this.perihal = perihal;
    }

    public String getPengirim() {
        return pengirim;
    }

    public void setPengirim(String kirim) {
        this.pengirim = kirim;
    }

    public String getPenerima() {
        return penerima;
    }

    public void setPenerima(String terima) {
        this.penerima = terima;
    }

    public static ArrayList addData(String no, String perihal, int tgl1, int bln1, int thn1,
            int tgl2, int bln2, int thn2,
            String pengirim, String penerima) throws SQLException, ClassNotFoundException {

        ArrayList result = null;
        DataHandler1 dataHandler = new DataHandler1();
        dataHandler.getDBConnection();
        Connection conn = dataHandler.conn;
        Statement stmt = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                ResultSet.CONCUR_UPDATABLE);

        String query = "INSERT INTO surat VALUES ('" + no + "', '" + perihal + "', " + tgl1 + "," + bln1 + "," + thn1 + "," + tgl2 + "," + bln2 + "," + thn2 + ", '" + pengirim + "', '" + penerima + "')";

        result = new ArrayList();
        try {
            result.add(stmt.executeUpdate(query));
        } catch (SQLException ex) {
            System.out.println("error : " + ex.getMessage());
        }
        conn.close();
        return result;

    }

    public static ArrayList displaySuratMasuk() throws SQLException, ClassNotFoundException {
        ArrayList result = null;
        DataHandler1 dataHandler = new DataHandler1();
        dataHandler.getDBConnection();
        Connection conn = dataHandler.conn;
        Statement stmt = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                ResultSet.CONCUR_UPDATABLE);

        String query2 = "Select * from surat";
        result = new ArrayList();

        ResultSet rset = stmt.executeQuery(query2);
        while (rset.next()) {
            Surat temp = new Surat(rset.getString(1),
                    rset.getString(2),
                    rset.getInt(3),
                    rset.getInt(4),
                    rset.getInt(5),
                    rset.getInt(6),
                    rset.getInt(7),
                    rset.getInt(8),
                    rset.getString(9),
                    rset.getString(10));

            result.add(temp);
        }

        conn.close();
        return result;
    }

    public static ArrayList searchPengirim(String keyword) throws SQLException, ClassNotFoundException {
        ArrayList result = null;
        DataHandler1 dataHandler = new DataHandler1();
        dataHandler.getDBConnection();
        Connection conn = dataHandler.conn;
        Statement stmt = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_READ_ONLY);

        String query = "SELECT * from surat " + "where pengirim like '%" + keyword + "%'";
        ResultSet rset = stmt.executeQuery(query);
        result = new ArrayList();
        while (rset.next()) {
            Surat temp = new Surat(rset.getString(1),
                    rset.getString(2),
                    rset.getInt(3),
                    rset.getInt(4),
                    rset.getInt(5),
                    rset.getInt(6),
                    rset.getInt(7),
                    rset.getInt(8),
                    rset.getString(9),
                    rset.getString(10));
            result.add(temp);

        }
        conn.close();
        return result;
    }

    public static ArrayList searchPenerima(String keyword) throws SQLException, ClassNotFoundException {
        ArrayList result = null;
        DataHandler1 dataHandler = new DataHandler1();
        dataHandler.getDBConnection();
        Connection conn = dataHandler.conn;
        Statement stmt = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_READ_ONLY);


        String query = "SELECT * FROM surat where penerima like '%" + keyword + "%'";

        ResultSet rset = stmt.executeQuery(query);
        result = new ArrayList();
        while (rset.next()) {
            Surat temp = new Surat(rset.getString(1),
                    rset.getString(2),
                    rset.getInt(3),
                    rset.getInt(4),
                    rset.getInt(5),
                    rset.getInt(6),
                    rset.getInt(7),
                    rset.getInt(8),
                    rset.getString(9),
                    rset.getString(10));
            result.add(temp);
        }
        conn.close();
        return result;
    }

    public static ArrayList searchPerihal(String keyword) throws SQLException, ClassNotFoundException {
        ArrayList result = null;
        DataHandler1 dataHandler = new DataHandler1();
        dataHandler.getDBConnection();
        Connection conn = dataHandler.conn;
        Statement stmt = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_READ_ONLY);
        String query = "SELECT * FROM surat where perihal like '%" + keyword + "%'";

        ResultSet rset = stmt.executeQuery(query);
        result = new ArrayList();
        while (rset.next()) {
            Surat temp = new Surat(rset.getString(1),
                    rset.getString(2),
                    rset.getInt(3),
                    rset.getInt(4),
                    rset.getInt(5),
                    rset.getInt(6),
                    rset.getInt(7),
                    rset.getInt(8),
                    rset.getString(9),
                    rset.getString(10));
            result.add(temp);

        }
        conn.close();
        return result;
    }

    public static ArrayList searchBlnThn(int bln, int thn) throws SQLException, ClassNotFoundException {
        ArrayList result = null;
        DataHandler1 dataHandler = new DataHandler1();
        dataHandler.getDBConnection();
        Connection conn = dataHandler.conn;
        Statement stmt = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_READ_ONLY);
        String query = "SELECT * FROM surat where bln_diterima = " + bln + " AND thn_diterima = " + thn;


        ResultSet rset = stmt.executeQuery(query);
        result = new ArrayList();
        while (rset.next()) {
            Surat temp = new Surat(rset.getString(1),
                    rset.getString(2),
                    rset.getInt(3),
                    rset.getInt(4),
                    rset.getInt(5),
                    rset.getInt(6),
                    rset.getInt(7),
                    rset.getInt(8),
                    rset.getString(9),
                    rset.getString(10));
            result.add(temp);

        }
        conn.close();
        return result;
    }

    public static ArrayList searchBln(int bln) throws SQLException, ClassNotFoundException {
        ArrayList result = null;
        DataHandler1 dataHandler = new DataHandler1();
        dataHandler.getDBConnection();
        Connection conn = dataHandler.conn;
        Statement stmt = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_READ_ONLY);
        String query = "SELECT * FROM surat where bln_diterima = " + bln;
//        ResultSet rset = stmt.execute(query);
        ResultSet rset = stmt.executeQuery(query);
        result = new ArrayList();
        while (rset.next()) {

            Surat temp = new Surat(rset.getString(1),
                    rset.getString(2),
                    rset.getInt(3),
                    rset.getInt(4),
                    rset.getInt(5),
                    rset.getInt(6),
                    rset.getInt(7),
                    rset.getInt(8),
                    rset.getString(9),
                    rset.getString(10));
            result.add(temp);
        }
        conn.close();
        return result;
    }

    public int getTglSrt() {
        return tglSrt;
    }

    public void setTglSrt(int tglSrt) throws Exception {
        this.tglSrt = tglSrt;
    }

    public int getBlnSrt() {
        return blnSrt;
    }

    public void setBlnSrt(int blnSrt) throws Exception {
        this.blnSrt = blnSrt;
    }

    public int getThnSrt() {
        return thnSrt;
    }

    public void setThnSrt(int thnSrt) throws Exception {
        this.thnSrt = thnSrt;
    }

    public int getTglDiterima() {
        return tglDiterima;
    }

    public void setTglDiterima(int tglDiterima) throws Exception {
        this.tglDiterima = tglDiterima;
    }

    public int getBlnDiterima() {
        return blnDiterima;
    }

    public void setBlnDiterima(int blnDiterima) throws Exception {
        this.blnDiterima = blnDiterima;
    }

    public int getThnDiterima() {
        return thnDiterima;
    }

    public void setThnDiterima(int thnDiterima) throws Exception {
        this.thnDiterima = thnDiterima;
    }
}