Program Tugas Akhirqu

private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {                                          

    jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
    entry_penduduk t = new entry_penduduk();
    t.show();
    jDesktopPane1.add(t);
           
}                                         

private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {                                          
    jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
   entry_lahir t = new entry_lahir();
   t.show();
   jDesktopPane1.add(t);
   
}                                         

private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {                                          
   jDesktopPane1.removeAll();
   jDesktopPane1.repaint();
   lap_bln_lahir_wafat t = new lap_bln_lahir_wafat();
   t.show();
   jDesktopPane1.add(t);
}                                         

private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {                                          
jDesktopPane1.removeAll();
   jDesktopPane1.repaint();
   lap_bln_pndh_pndhdtg t = new lap_bln_pndh_pndhdtg();
   t.show();
   jDesktopPane1.add(t);
   
}                                         

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                        

    this.dispose();
}                                       

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        

     try{
        pb = new ProcessBuilder("C:/WINDOWS/system32/odbcad32.exe");
        Process start = pb.start();
    }catch(Exception Se){}
}                                       

private void jDesktopPane2MouseMoved(java.awt.event.MouseEvent evt) {                                        

    koneksi();
}                                       

private void formMouseMoved(java.awt.event.MouseEvent evt) {                               

    koneksi();
}                              

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                        

     jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
  help t = new help();
    t.show();
    jDesktopPane1.add(t);
}                                       

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        

    jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
    jLabel2.setVisible(true);
    jDesktopPane1.add(jLabel2);
   
   
    jLabel7.setVisible(true);
    jDesktopPane1.add(jLabel7);
}                                       

private void jMenu7ActionPerformed(java.awt.event.ActionEvent evt) {                                      
    
}                                     

private void jMenuItem1ActionPerformed1(java.awt.event.ActionEvent evt) {                                           
   jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
    entry_wafat t = new entry_wafat();
    t.show();
    jDesktopPane1.add(t);
}                                          

private void jMenuItem2ActionPerformed1(java.awt.event.ActionEvent evt) {                                           
   jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
    entry_pindah t = new entry_pindah();
    t.show();
    jDesktopPane1.add(t);
}                                          

private void jMenuItem3ActionPerformed1(java.awt.event.ActionEvent evt) {                                           
    jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
    entry_pndhdtg t = new entry_pndhdtg();
    t.show();
    jDesktopPane1.add(t);
}                                          

private void jMenuItem4ActionPerformed1(java.awt.event.ActionEvent evt) {                                           
   jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
    lap_thn_lahir_wafat t = new lap_thn_lahir_wafat();
    t.show();
    jDesktopPane1.add(t);
}                                          

private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {                                          
   jDesktopPane1.removeAll();
    jDesktopPane1.repaint();
    lap_thn_pndh_pndhdtg t = new lap_thn_pndh_pndhdtg();
    t.show();
    jDesktopPane1.add(t);
}                                         

 public void koneksi(){
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
            status1.setVisible(true);
            status2.setVisible(false);

    }catch(Exception e)
    {
     status1.setVisible(false);
            status2.setVisible(true);
    }
    }

public entry_lahir() {
        initComponents();
      
        jPanel2.setVisible(false);
        tampil();
        agama.addItem("=Pilih Satu=");
       agama.addItem("Islam");agama.addItem("Kristen");agama.addItem("Hindu");agama.addItem("Budha");agama.addItem("Lain-lain");
        jekel.addItem("=Pilih Satu=");
        jekel.addItem("Laki-laki");jekel.addItem("Perempuan");
    
    }

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                        

     try {

            Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
           String SQL ="insert into dblahir values ('"+no_kk.getText()+"','"+nama.getText()+"','"+tempat.getText()+"','"+tglahir.getText()+"','"+almt.getText()+"','"+jekel.getSelectedItem()+"','"+agama.getSelectedItem()+"','"+nm_ayah.getText()+"','"+nm_ibu.getText()+"')";

           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"data Di simpan !!");

       

        } catch (Exception e) {
            System.out.println(e.getMessage());
            JOptionPane.showMessageDialog(null,"Error"+e.getMessage());
        
        }
     try {
           String a="",b="",c="",d="",f="",g="",h="",i="",j="",k="",l="",m="",n="";
           Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
           String SQL ="insert into dbpenduduk values ('"+a+"', '"+no_kk.getText()+"','"+nama.getText()+"','"+tempat.getText()+"','"+tglahir.getText()+"','"+almt.getText()+"','"+jekel.getSelectedItem()+"','"+agama.getSelectedItem()+"','"+j+"','"+k+"','"+l+"','"+m+"','"+n+"')";

           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"data Di simpan !!");
          
            no_kk.setText("");
            nama.setText("");
            tempat.setText("");
            tglahir.setText("");
            almt.setText("");
            jekel.setSelectedItem("");
            agama.setSelectedItem("");
            nm_ayah.setText("");
            nm_ibu.setText("");
           
           
            jPanel2.setVisible(false);
     }catch (Exception e) {  JOptionPane.showMessageDialog(null, ""+e);
            no_kk.setText("");
            nama.setText("");
            tempat.setText("");
            tglahir.setText("");
            almt.setText("");
            jekel.setSelectedItem("");
            agama.setSelectedItem("");
            nm_ayah.setText("");
            nm_ibu.setText("");
     }
}                                       

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
    jButton6.setVisible(true);
    jButton4.setVisible(false);

    jPanel2.setVisible(true);
          no_kk.setText("");
          nama.setText("");
          tglahir.setText("");
          almt.setText("");
          jekel.setSelectedItem("");
          agama.setSelectedItem("");
          nm_ayah.setText("");
          nm_ibu.setText("");
         no_kk.setEditable(true);
}                                       

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                        
// TODO add your handling code here:
            no_kk.setText("");
            nama.setText("");
            tglahir.setText("");
            almt.setText("");
            jekel.setSelectedItem("");
            agama.setSelectedItem("");
            nm_ayah.setText("");
            nm_ibu.setText("");
        jPanel2.setVisible(false);
}                                       

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
// TODO add your handling code here:
      jButton4.setVisible(true);
      jButton6.setVisible(false);
     
        try{

            dapat_dari_table();
            jPanel2.setVisible(true);
            no_kk.setEditable(false);
        }catch(Exception e) {
            JOptionPane.showMessageDialog(null, "Klik Record yang mau di edit","Pesan",JOptionPane.ERROR_MESSAGE);
        }
}                                       

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                        
// TODO add your handling code here:
     try{
             int table = jTable1.getSelectedRow();
    //mengambil data dari table
    String a = jTable1.getValueAt(table, 0).toString();
    String b = jTable1.getValueAt(table, 1).toString();
    String c = jTable1.getValueAt(table, 2).toString();
    try {
           Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
           String SQL ="Delete From dblahir  where no_kk = '"+a+"' ";

           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"Data Berhasil DiHapus !!");
           tampil();



            } catch (Exception e) {
                System.out.println(e.getMessage());
                JOptionPane.showMessageDialog(null,"Error"+e.getMessage());

            }
        }catch(Exception se) {
            JOptionPane.showMessageDialog(null, "Klik Record yang mau di Hapus ","ERROR",JOptionPane.ERROR_MESSAGE);
        }
}                                       

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                        
   java.sql.Statement st;
        jButton6.setVisible(false);
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
            String SQL="update dblahir set no_kk='"+no_kk.getText()+"',nama='"+nama.getText()+"',tempat='"+tempat.getText()+"',tglahir='"+tglahir.getText()+"' ,jekel='"+jekel.getSelectedItem()+"' where no_ktp='"+no_kk.getText()+"'";
            stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"Data Berhasil Di Edit !!");
           tampil();
            jPanel2.setVisible(false);
            no_kk.setText("");
            nama.setText("");
            tglahir.setText("");
            almt.setText("");
            jekel.setSelectedItem("");
            agama.setSelectedItem("");
            nm_ayah.setText("");
            nm_ibu.setText("");

        } catch (Exception e) {
            System.out.println(e.getMessage());
            JOptionPane.showMessageDialog(null,"Error"+e.getMessage());
            no_kk.setText("");
            nama.setText("");
            tglahir.setText("");
            almt.setText("");
            jekel.setSelectedItem("");
            agama.setSelectedItem("");
            nm_ayah.setText("");
            nm_ibu.setText("");
        
        }
}                                       

 

public void tampil(){
     DefaultTableModel tbl = new DefaultTableModel();
        tbl.addColumn("No KK");
        tbl.addColumn("Nama");
        tbl.addColumn("Tempat");
        tbl.addColumn("Tanggal Lahir");
        tbl.addColumn("Alamat");
        tbl.addColumn("Jenis Kelamin");
        tbl.addColumn("Agama");
        tbl.addColumn("Nama Ayah");
        tbl.addColumn("Nama Ibu");
        try
        {
            int nomor= 0 ;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con =DriverManager.getConnection("jdbc:odbc:penduduk","","");
            Statement stmt = (Statement) con.createStatement();
            ResultSet RS = stmt.executeQuery("select *from dblahir");
            while (RS.next())
            {
                tbl.addRow(new Object []{RS.getString(1),RS.getString(2),RS.getString(3),RS.getString(4),RS.getString(5),RS.getString(6),RS.getString(7),RS.getString(8),RS.getString(9)});
            }
            jTable1.setModel(tbl);
            RS.close();
            stmt.close();
            //con.close();
         
        }catch (Exception e)
        { System.err.println(e.getMessage());}
}

 public  void dapat_dari_table(){
    // perintah untuk menapilkan tabel ke dalam text
    int table = jTable1.getSelectedRow();
    //mengambil data dari table
    String a = jTable1.getValueAt(table, 0).toString();
    String b = jTable1.getValueAt(table, 1).toString();
    String c = jTable1.getValueAt(table, 2).toString();
    String d = jTable1.getValueAt(table,3).toString();
    String e = jTable1.getValueAt(table,4).toString();
    String f = jTable1.getValueAt(table,5).toString();
    String g = jTable1.getValueAt(table,6).toString();
    String h = jTable1.getValueAt(table,7).toString();
    String i = jTable1.getValueAt(table,7).toString();
     no_kk.setText(a);
     nama.setText(b);
     tempat.setText(c);
     tglahir.setText(d);
     almt.setText(e);
     jekel.setSelectedItem(f);
     agama.setSelectedItem(g);
     nm_ayah.setText(h);
     nm_ibu.setText(i); 
   
    }

 hari.addItem("=pilih salah satu=");
        hari.addItem("Senin"); hari.addItem("Selasa"); hari.addItem("Rabu");
        hari.addItem("Kamis"); hari.addItem("Jumat");  hari.addItem("Sabtu"); hari.addItem("Minggu");
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                        

     try {

            Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = con.createStatement();
           String SQL ="insert into dbmeninggal values ('"+no_ktp.getSelectedItem()+"','"+no_kk.getText()+"' , '"+nama.getText()+"','"+jekel.getText()+"','"+tgl_wafat.getText()+"','"+hari.getSelectedItem()+"' ,'"+tempat.getText()+"','"+sebab.getText()+"','"+desa.getText()+"' )";

           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"data Di simpan !!");
          
       

        } catch (Exception e)
        {
            System.out.println(e.getMessage());
            JOptionPane.showMessageDialog(null,"Error"+e.getMessage());
           
        }
       try {
                    Class.forName("sun.jdbc.odbc.JdbcOdbc");
                    Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
                    Statement stmt = con.createStatement();
                   String sql = "delete from dbpenduduk where no_ktp='"+no_ktp.getSelectedItem()+"'";
                    stmt.execute(sql);
                    JOptionPane.showMessageDialog(null, "Data Penduduk Sudah di Hapus");
                   tampil();
            no_ktp.setSelectedItem("");
            no_kk.setText("");
            nama.setText("");
            jekel.setText("");
            tgl_wafat.setText("");
            hari.setSelectedItem("");
            tempat.setText("");
            sebab.setText("");
            desa.setText("");
            jPanel2.setVisible(false);
                } catch (Exception e) {   JOptionPane.showMessageDialog(null, ""+e);
            no_ktp.setSelectedItem("");
            no_kk.setText("");
            nama.setText("");
            jekel.setText("");
            tgl_wafat.setText("");
            hari.setSelectedItem("");
            tempat.setText("");
            sebab.setText("");
            desa.setText("");
                }
  
    
}                                       

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
    jButton6.setVisible(true);
    jButton4.setVisible(false);

    jPanel2.setVisible(true);
         no_ktp.setSelectedItem("");
           no_kk.setText("");
            nama.setText("");
            jekel.setText("");
            tgl_wafat.setText("");
            hari.setSelectedItem("");
            tempat.setText("");
            sebab.setText("");
           desa.setText("");
         no_ktp.setEditable(true);
}                                       

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                        
// TODO add your handling code here:
        no_ktp.setSelectedItem("");
       no_kk.setText("");
        nama.setText("");
        jekel.setText("");
        tgl_wafat.setText("");
        hari.setSelectedItem("");
        tempat.setText("");
        sebab.setText("");
        desa.setText("");
        jPanel2.setVisible(false);
}                                       

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
// TODO add your handling code here:
      jButton4.setVisible(true);
      jButton6.setVisible(false);
     
        try{

            dapat_dari_table();
            jPanel2.setVisible(true);
            no_ktp.setEditable(false);
            no_kk.setEditable(false);
        }catch(Exception e) {
            JOptionPane.showMessageDialog(null, "Klik Record yang mau di edit","Pesan",JOptionPane.ERROR_MESSAGE);
        }
}                                       

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                        
// TODO add your handling code here:
     try{
             int table = jTable1.getSelectedRow();
    //mengambil data dari table
    String a = jTable1.getValueAt(table, 0).toString();
    String b = jTable1.getValueAt(table, 1).toString();
    String c = jTable1.getValueAt(table, 2).toString();
    try {
           Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
           String SQL ="Delete From dbmeninggal  where no_ktp = '"+a+"' ";

           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"Data Berhasil DiHapus !!");
           tampil();



            } catch (Exception e) {
                System.out.println(e.getMessage());
                JOptionPane.showMessageDialog(null,"Error"+e.getMessage());

            }
        }catch(Exception se) {
            JOptionPane.showMessageDialog(null, "Klik Record yang mau di Hapus ","ERROR",JOptionPane.ERROR_MESSAGE);
        }
}                                       

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                        
   java.sql.Statement st;
        jButton6.setVisible(false);
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
            String SQL="update dbmeninggal set nama='"+nama.getText()+"',jekel='"+jekel.getText()+"',tgl_wafat='"+tgl_wafat.getText()+"',hari='"+hari.getSelectedItem()+"' ,tempat'"+tempat.getText()+"',sebab='"+sebab.getText()+"',desa'"+desa.getText()+"' where no_ktp='"+no_ktp.getSelectedItem()+"'";
            stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"Data Berhasil Di Edit !!");
           tampil();
            jPanel2.setVisible(false);
           no_ktp.setSelectedItem("");
           no_kk.setText("");
            nama.setText("");
            jekel.setText("");
            tgl_wafat.setText("");
            hari.setSelectedItem("");
            tempat.setText("");
            sebab.setText("");
            desa.setText("");

        } catch (Exception e) {
            System.out.println(e.getMessage());
            JOptionPane.showMessageDialog(null,"Error"+e.getMessage());
            no_ktp.setSelectedItem("");
            no_kk.setText("");
            nama.setText("");
            jekel.setText("");
            tgl_wafat.setText("");
            hari.setSelectedItem("");
            tempat.setText("");
            sebab.setText("");
            desa.setText("");
        }
}                                       

private void no_ktpActionPerformed(java.awt.event.ActionEvent evt) {                                      
int ada=0;
       // String url = null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
            String SQL= "select*from dbpenduduk where  no_ktp='"+no_ktp.getSelectedItem()+"'";

            ResultSet rs = stmt.executeQuery(SQL);
            //stmt.executeUpdate(SQL);
            if(rs.next())
            {
                BarangAktif();
                no_kk.setText(rs.getString("no_kk"));
                nama.setText(rs.getString("nama"));
                jekel.setText(rs.getString("jekel"));
                desa.setText(rs.getString("desa"));
                ada=1;

            }

            if(ada==0)
            {
                try
                {
                     Class.forName("sun.jdbc.odbc.JdbcOdbc");
                   //Connection con = DriverManager.getConnection();
                     String url="jdbc:odbc:penduduk";
                     con =DriverManager.getConnection(url);
                    ResultSet rs2 = stmt.executeQuery("Select * from dbpenduduk where no_ktp='"+no_ktp.getSelectedItem()+"'");

                    if(rs2.next())
                    {
                        BarangAktif();
                        no_kk.setText(rs2.getString("no_kk"));
                        nama.setText(rs2.getString("nama"));
                        jekel.setText(rs2.getString("jekel"));
                        desa.setText(rs.getString("desa"));
                    }
                    else
                    {
                        BarangNonaktif();

                    }
                    rs.close();
                    stmt.close();
                    con.close();
                }
                catch(Exception e){ }
            }
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){ JOptionPane.showMessageDialog(null,e.getMessage());}
}                                     

  private void BarangAktif()
    {
        no_kk.setEnabled(true);
        nama.setEnabled(true);
        jekel.setEnabled(true);
        desa.setEnabled(true);
    }
private void BarangNonaktif()
    {
        no_kk.setEnabled(false);
        nama.setEnabled(false);
        jekel.setEnabled(false);
        desa.setEnabled(true);
    }

 public void tampilno_ktp(){
     no_ktp.addItem("");
    no_kk.setText("");
    nama.setText("");
     jekel.setText("");
      desa.setText("");
      try {
         Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
           ResultSet RS = stmt.executeQuery("select no_ktp from dbpenduduk");
          while (RS.next()) {
             String sa = RS.getString("no_ktp");
            no_ktp.addItem(sa);
           //String sb = RS.getString("no_kndrn");
           //no_kdrn.setText(sb);
          }
      } catch (Exception e) {
      }


  }

public void tampil(){
     DefaultTableModel tbl = new DefaultTableModel();
        tbl.addColumn("No KTP");
        tbl.addColumn("No KK");
        tbl.addColumn("Nama");
        tbl.addColumn("Jenis Kelamin");
        tbl.addColumn("Tanggal Wafat");
        tbl.addColumn("Hari");
        tbl.addColumn("Tempat");
        tbl.addColumn("Sebab");
        tbl.addColumn("Desa");
        try
        {
            int nomor= 0 ;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con =DriverManager.getConnection("jdbc:odbc:penduduk");
            Statement stmt = (Statement) con.createStatement();
            ResultSet RS = stmt.executeQuery("select *from dbmeninggal");
            while (RS.next())
            {
                tbl.addRow(new Object []{RS.getString(1),RS.getString(2),RS.getString(3),RS.getString(4),RS.getString(5),RS.getString(6),RS.getString(7),RS.getString(8),RS.getString(9)});
            }
            jTable1.setModel(tbl);
            RS.close();
            stmt.close();
            //con.close();
         
        }catch (Exception e)
        { System.err.println(e.getMessage());}
}

 public  void dapat_dari_table(){
    // perintah untuk menapilkan tabel ke dalam text
    int table = jTable1.getSelectedRow();
    //mengambil data dari table
    String a = jTable1.getValueAt(table, 0).toString();
    String b = jTable1.getValueAt(table, 1).toString();
    String c = jTable1.getValueAt(table, 2).toString();
    String d = jTable1.getValueAt(table,3).toString();
    String e = jTable1.getValueAt(table,4).toString();
    String f = jTable1.getValueAt(table,5).toString();
    String g = jTable1.getValueAt(table,6).toString();
    String h = jTable1.getValueAt(table,7).toString();
    String i = jTable1.getValueAt(table,8).toString();

            no_ktp.setSelectedItem(a);
            no_kk.setText(b);
            nama.setText(c);
            jekel.setText(d);
            tgl_wafat.setText(e);
            hari.setSelectedItem(f);
            tempat.setText(g);
            sebab.setText(h);
            desa.setText(i);   
   
    }

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                       
// TODO add your handling code here:
     try {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = con.createStatement();
           String SQL ="insert into dbpindah values ('"+no_srt.getText()+"' , '"+tglpindah.getText()+"' , '"+no_ktp.getSelectedItem()+"' , '"+nama.getText()+"' ,'"+tglahir.getText()+"' , '"+jekel.getText()+"','"+lurah.getText()+"' , '"+camat.getText()+"','"+kab.getText()+"','"+prov.getText()+"','"+alasan.getText()+"' ,'"+almt_asl.getText()+"','"+almt_skg.getText()+"' )";
                                                  
           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"data Di simpan !!");
           tampil();
        
         
         
   }
   catch (Exception e)
   {
       System.out.println(e.getMessage());
       JOptionPane.showMessageDialog(null,"Error"+e.getMessage());
         
   }
        try {
                    Class.forName("sun.jdbc.odbc.JdbcOdbc");
                    Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
                    Statement stmt = con.createStatement();
                   String sql = "delete from dbpenduduk where no_ktp='"+no_ktp.getSelectedItem()+"'";
                    stmt.execute(sql);
                    JOptionPane.showMessageDialog(null, "Data Penduduk Sudah di Hapus");
                   tampil();
            no_srt.setText("");
           tglpindah.setText("");
           nama.setText("");
           tglahir.setText("");
           jekel.setText("");
           lurah.setText("");
           camat.setText("");
           kab.setText("");
           prov.setText("");
           alasan.setText("");
           almt_asl.setText("");
           almt_skg.setText("");
           jPanel2.setVisible(false);
                } catch (Exception e) {   JOptionPane.showMessageDialog(null, ""+e);
            no_srt.setText("");
           tglpindah.setText("");
           nama.setText("");
           tglahir.setText("");
           jekel.setText("");
           lurah.setText("");
           camat.setText("");
           kab.setText("");
           prov.setText("");
           alasan.setText("");
           almt_asl.setText("");
           almt_skg.setText("");
                }
}                                      

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                       
// TODO add your handling code here:
    jButton6.setVisible(true);
    jButton7.setVisible(false);
  
    jPanel2.setVisible(true);
           no_srt.setText("");
           tglpindah.setText("");
           nama.setText("");
           tglahir.setText("");
           jekel.setText("");
           lurah.setText("");
           camat.setText("");
           kab.setText("");
           prov.setText("");
           alasan.setText("");
           almt_asl.setText("");
           almt_skg.setText("");
           no_srt.setEditable(true);
}                                      

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                       
// TODO add your handling code here:
     no_srt.setEditable(true);
           no_srt.setText("");
           tglpindah.setText("");
           nama.setText("");
           tglahir.setText("");
           jekel.setText("");
           lurah.setText("");
           camat.setText("");
           kab.setText("");
           prov.setText("");
           alasan.setText("");
           almt_asl.setText("");
           almt_skg.setText("");
          jPanel2.setVisible(false);
}                                      

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                       
// TODO add your handling code here:
      jButton7.setVisible(true);
      jButton6.setVisible(false);
    
    try{
  
    dapat_dari_table();
    jPanel2.setVisible(true);
    no_srt.setEditable(false);
    no_ktp.setEditable(false);
    }catch(Exception e)
    {
    JOptionPane.showMessageDialog(null, "Klik Record yang mau di edit","Pesan",JOptionPane.ERROR_MESSAGE);
    }
}                                      

private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {                                       
// TODO add your handling code here:
    jButton6.setVisible(false);
     try {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = con.createStatement();
           String SQL ="update  dbpindah set tglpindah = '"+tglpindah.getText()+"', no_ktp = '"+no_ktp.getSelectedItem()+"' ,nama = '"+nama.getText()+"'  ,tglahir = '"+tglahir.getText()+"' , jekel = '"+jekel.getText()+"',lurah='"+lurah.getText()+"' ,camat= '"+camat.getText()+"',kab='"+kab.getText()+"',prov='"+prov.getText()+"',alasan='"+alasan.getText()+"' ,almt_asl'"+almt_asl.getText()+"',almt_skg'"+almt_skg.getText()+"' where no_srt = '"+no_srt.getText()+"' ";
                                                  
           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"Data Berhasil Di Edit !!");
           tampil();
             jPanel2.setVisible(false);
           no_srt.setText("");
           tglpindah.setText("");
           nama.setText("");
           tglahir.setText("");
           jekel.setText("");
           lurah.setText("");
           camat.setText("");
           kab.setText("");
           prov.setText("");
           alasan.setText("");
           almt_asl.setText("");
           almt_skg.setText("");
         
   }
   catch (Exception e)
   {
       System.out.println(e.getMessage());
       JOptionPane.showMessageDialog(null,"Error"+e.getMessage());
           no_srt.setText("");
           tglpindah.setText("");
           nama.setText("");
           tglahir.setText("");
           jekel.setText("");
           lurah.setText("");
           camat.setText("");
           kab.setText("");
           prov.setText("");
           alasan.setText("");
           almt_asl.setText("");
           almt_skg.setText("");
   }
}                                      

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                       
// TODO add your handling code here:
    try{
     int table = jTable1.getSelectedRow();
    //mengambil data dari table
    String a = jTable1.getValueAt(table, 0).toString();
    String b = jTable1.getValueAt(table, 1).toString();
    String c = jTable1.getValueAt(table, 2).toString();
    try {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = con.createStatement();
           String SQL ="Delete From dbpindah  where no_srt = '"+a+"' ";
                                                  
           stmt.executeUpdate(SQL);
           stmt.close();
           JOptionPane.showMessageDialog(null,"Data Berhasil DiHapus !!");
           tampil();
         
        
         
   }
   catch (Exception e)
   {
       System.out.println(e.getMessage());
       JOptionPane.showMessageDialog(null,"Error"+e.getMessage());
      
   }
    }catch(Exception se)
    {
    JOptionPane.showMessageDialog(null, "Klik Record yang mau di Hapus ","ERROR",JOptionPane.ERROR_MESSAGE);
    }
}                                      

private void no_ktpActionPerformed(java.awt.event.ActionEvent evt) {                                     
   int ada=0;
       // String url = null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbc");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = (Statement) con.createStatement();
            String SQL= "select*from dbpenduduk where  no_ktp='"+no_ktp.getSelectedItem()+"'";

            ResultSet rs = stmt.executeQuery(SQL);
            //stmt.executeUpdate(SQL);
            if(rs.next())
            {
                BarangAktif();
                nama.setText(rs.getString("nama"));
                tglahir.setText(rs.getString("tglahir"));
                jekel.setText(rs.getString("jekel"));
                almt_asl.setText(rs.getString("desa"));
                ada=1;

            }

            if(ada==0)
            {
                try
                {
                     Class.forName("sun.jdbc.odbc.JdbcOdbc");
                   //Connection con = DriverManager.getConnection();
                     String url="jdbc:odbc:penduduk";
                     con =DriverManager.getConnection(url);
                    ResultSet rs2 = stmt.executeQuery("Select * from dbpenduduk where no_ktp='"+no_ktp.getSelectedItem()+"'");

                    if(rs2.next())
                    {
                        BarangAktif();
                        nama.setText(rs2.getString("nama"));
                        tglahir.setText(rs.getString("tglahir"));
                        jekel.setText(rs2.getString("jekel"));
                        almt_asl.setText(rs.getString("desa"));
                    }
                    else
                    {
                        BarangNonaktif();

                    }
                    rs.close();
                    stmt.close();
                    con.close();
                }
                catch(Exception e){ }
            }
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){ JOptionPane.showMessageDialog(null,e.getMessage());}
}                                    

 private void BarangAktif()
    {
        nama.setEnabled(true);
        tglahir.setEnabled(true);
        jekel.setEnabled(true);
         almt_asl.setEnabled(true);
    }
private void BarangNonaktif()
    {
        nama.setEnabled(false);
        tglahir.setEnabled(false);
        jekel.setEnabled(false);
         almt_asl.setEnabled(true);
    }

public void tampilnoktp(){
     no_ktp.addItem("");

      try {
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:penduduk");
           Statement stmt = con.createStatement();
          rs=stmt.executeQuery("select no_ktp from dbpenduduk");
          while (rs.next()) {
             String sa = rs.getString("no_ktp");
            no_ktp.addItem(sa);

          }
      } catch (Exception e) {
      }


  }

public void tampil(){
     DefaultTableModel tbl = new DefaultTableModel();
        tbl.addColumn("No Surat");
        tbl.addColumn("Tgl Pindah");
        tbl.addColumn("no_ktp");
        tbl.addColumn("Nama");
        tbl.addColumn("tgl Lahir");
        tbl.addColumn("Jenis Kelamin");
        tbl.addColumn("Kelurahan");
        tbl.addColumn("Kecamatan");
        tbl.addColumn("Kabupaten");
        tbl.addColumn("Provinsi");
        tbl.addColumn("Alasan");
        tbl.addColumn("Alamat Asal");
        tbl.addColumn("Alamat Sekarang");
        try
        {
            int nomor= 0 ;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con =DriverManager.getConnection("jdbc:odbc:penduduk");
            Statement stmt = con.createStatement();
            ResultSet RS = stmt.executeQuery("select *from dbpindah");
            while (RS.next())
            {
                tbl.addRow(new Object []{RS.getString(1),RS.getString(2),RS.getString(3),RS.getString(4),RS.getString(5),RS.getString(6),RS.getString(7),RS.getString(8),RS.getString(9),RS.getString(10),RS.getString(11),RS.getString(12),RS.getString(13)});
            }
            jTable1.setModel(tbl);
            RS.close();
            stmt.close();
            con.close();
        
        }catch (Exception e)
        { System.err.println(e.getMessage());}
}

 public  void dapat_dari_table(){
    // perintah untuk menapilkan tabel ke dalam text
    int table = jTable1.getSelectedRow();
    //mengambil data dari table
    String a = jTable1.getValueAt(table, 0).toString();
    String b = jTable1.getValueAt(table, 1).toString();
    String c = jTable1.getValueAt(table, 2).toString();
    String d = jTable1.getValueAt(table,3).toString();
    String e = jTable1.getValueAt(table,4).toString();
    String f = jTable1.getValueAt(table,5).toString();
    String g = jTable1.getValueAt(table,6).toString();
    String h = jTable1.getValueAt(table,7).toString();
    String i = jTable1.getValueAt(table,8).toString();
    String j = jTable1.getValueAt(table,9).toString();
    String k = jTable1.getValueAt(table,10).toString();
    String l = jTable1.getValueAt(table,11).toString();
    String m = jTable1.getValueAt(table,12).toString();
           no_srt.setText(a);
           tglpindah.setText(b);
           no_ktp.setSelectedItem(c);
           nama.setText(d);
           tglahir.setText(e);
           jekel.setText(f);
           lurah.setText(g);
           camat.setText(h);
           kab.setText(i);
           prov.setText(j);
           alasan.setText(k);
           almt_asl.setText(l);
           almt_skg.setText(m);  
  
    }