Lanjutan Pembuatan database Java GUI dengan MySQL

Penambahan Button (LIHAT, EDIT , SEARCH , HAPUS)

SEBELUM

SESUDAH

• Change Variabel Name Button LIHAT Ubah menjadi (btnlihat)
• Change Variabel Name Button EDIT Ubah menjadi (btnedit)
• Change Variabel Name Button SEARCH Ubah menjadi (btncari)
• Change Variabel Name Button HAPUS Ubah menjadi (btnhapus)

#Source code button LIHAT

try{
        Object [] rows={"id","Nama","No Kontak","Alamat","Status"};
     dtm=new DefaultTableModel(null,rows);   
    Table.setModel(dtm);
    Table.setBorder(null);
    jScrollPane1.setVisible(true);
    jScrollPane1.setViewportView(Table);
    int no=1;
    String id_kontak="",nama_kontak="",no_kontak="",alamat="",status="";
    try{
        String sql="select * from data_kontak";
        Statement stat=con.createStatement();
        ResultSet rs=stat.executeQuery(sql);
        while (rs.next()){
            id_kontak=rs.getString("id_kontak");
            nama_kontak=rs.getString("nama_kontak");
            no_kontak=rs.getString("no_kontak");
            alamat=rs.getString("Alamat");
            status=rs.getString("status");
            
            String [] tampil={""+id_kontak,nama_kontak,no_kontak,alamat,status};
            dtm.addRow(tampil);
        }
    }catch (SQLException e){
                e.printStackTrace();
                JOptionPane.showMessageDialog(null,"Query Salah"+e);
                }
    }catch (Exception e){
        e.printStackTrace();
    }
    }//GEN-LAST:event_btnlihatActionPerformed

#Source Code Button EDIT

int ok=JOptionPane.showConfirmDialog(null,"Apakah Kamu Yakin Ingin Update Record Ini ??","Confirmation",JOptionPane.YES_NO_CANCEL_OPTION);
    try 
    {
        String sql="update data_kontak set id_kontak=?,nama_kontak=?,no_kontak=?,Alamat=?,status=?where id_kontak='"+id_kontakTextField.getText()+"'";
        PreparedStatement st=con.prepareStatement(sql);
        if(ok==0)
        {
            try
            {
                st.setString(1,id_kontakTextField.getText

());
                st.setString(2,nama_kontakTextField.getText

());

                st.setString(3,no_kontakTextField.getText

());
                st.setString(4,alamat_kontakTextField.getText());
st.setString(5(String)statusComboBox.getSelectedItem());
                st.executeUpdate();
                
                JOptionPane.showMessageDialog(null,"Data Sukses Di Update");
            }catch (Exception e)
            {
                JOptionPane.showMessageDialog(null,"Data Gagal Di Update");
            }
        }
        }catch (Exception e){}
    }//GEN-LAST:event_btneditActionPerformed

#Source Code Button SEARCH

try{
        res=stat.executeQuery("select * from data_kontak where"+"id_kontak='"+id_kontakTextField.getText()+"'");
        while(res.next())
        {nama_kontakTextField.setText(res.getString("nama_kontak"));
        no_kontakTextField.setText(res.getString("no_kontak"));
        alamat_kontakTextField.setText(res.getString("alamat"));
        statusComboBox.setSelectedItem(res.getString("status"));
        }
    }
catch (Exception e){
JOptionPane.showMessageDialog(rootPane,e);
}
    }//GEN-LAST:event_btnsearchActionPerformed

#Source Code Button HAPUS

int ok=JOptionPane.showConfirmDialog(null, "Apakah Kamu Yakin Ingin Menghapus Record Ini ??","Confirmation" ,JOptionPane.YES_NO_CANCEL_OPTION);
    if(ok==0)
    {
      try
      {String sql="delete from data_kontak where id_kontak='"+id_kontakTextField.getText()+"'";
      PreparedStatement st= con.prepareStatement(sql);
      st.executeUpdate();
      JOptionPane.showMessageDialog(null,"Data Berhasil Dihapus");
      } catch (Exception e) 
      {
          JOptionPane.showMessageDialog(null,"Data Gagal Diahpus");
        }
      }       
    }//GEN-LAST:event_btnhapusActionPerformed

#Source Code Button HAPUS

int ok=JOptionPane.showConfirmDialog(null, "Apakah Kamu Yakin Ingin Menghapus Record Ini ??","Confirmation" ,JOptionPane.YES_NO_CANCEL_OPTION);
    if(ok==0)
    {
      try
      {String sql="delete from data_kontak where id_kontak='"+id_kontakTextField.getText()+"'";
      PreparedStatement st= con.prepareStatement(sql);
      st.executeUpdate();
      JOptionPane.showMessageDialog(null,"Data Berhasil Dihapus");
      } catch (Exception e) 
      {
          JOptionPane.showMessageDialog(null,"Data Gagal Diahpus");
        }
      }       
    }//GEN-LAST:event_btnhapusActionPerformed
Hasil


  #Tambahkan Source Code Ini pada konstruktor
private DefaultTableModel dtm;

#KLIK KANAN TABLE->EVENTS->KEY-> Mouse Clicked
Masukkan Source Code
int i = Table.getSelectedRow();
    if(i==-1){
    return;
    }
String code = (String)Table.getValueAt(i,0);
String code1 = (String)Table.getValueAt(i,1);
String code2 = (String)Table.getValueAt(i,2);
String code3 = (String)Table.getValueAt(i,3);
String code4 = (String)Table.getValueAt(i,4);
id_kontakTextField.setText(code);
nama_kontakTextField.setText(code1);
no_kontakTextField.setText(code2);
alamat_kontakTextField.setText(code3);
statusComboBox.setSelectedItem(code4);
    }//GEN-LAST:event_TableMouseClicked