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);
}
