Membuat Form Karyawan 2

Sambungan source code Form Karyawan

 private void prosesdeleteData(String id_karyawan) {
 try { query = "delete from karyawan where id_karyawan='" + id_karyawan + "'";
PreparedStatement presttmt = db.koneksi.prepareStatement(query);
 presttmt.executeUpdate(query);
}catch (SQLException se) {
JOptionPane.showMessageDialog(null, "Terjadi kesalahan hapus data! error :"+ se, "Kesalahan", JOptionPane.ERROR_MESSAGE);
System.exit(0); }
}

 /** Creates new form FormKaryawan
*/

 public FormKaryawan() {
initComponents();
db = new Database();
db.koneksiDatabase();
 isikanTabel();
bersihText();
 }

 /** This method is called from within the constructor to
 * initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/ @SuppressWarnings("unchecked")

private void btnAddActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
tambahBaru(); aktifText(true);
aktifSimpan(true);
 modeOperasi = "INSERT";
}

private void btnEditActionPerformed(java.awt.event.ActionEvent evt) {
 // TODO add your handling code here:
aktifText(true);
 aktifSimpan(true);
 txtIdKaryawan.setEnabled(false);
 modeOperasi = "UPDATE";
 }

private void btnBatalActionPerformed(java.awt.event.ActionEvent evt) {
 // TODO add your handling code here:
tampilkanDiText();
aktifSimpan(false);
aktifText(false);
modeOperasi = "";
}

private void btnExitActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
 dispose();
}

private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String id_karyawan = txtIdKaryawan.getText();
if (id_karyawan.equals(""))
{ JOptionPane.showMessageDialog(null, "Nama User tidak boleh kosong", "Kesalahan",JOptionPane.INFORMATION_MESSAGE);
txtIdKaryawan.requestFocus();
return; }
String nama = txtNama.getText();
String password = txtPassword.getText();
 if (nama.equals("")){
 JOptionPane.showMessageDialog(null, "Nama tidak boleh kosong", "Kesalahan",JOptionPane.INFORMATION_MESSAGE);
txtNama.requestFocus();
 return; }
if (password.equals("")) {
JOptionPane.showMessageDialog(null, "Password tidak boleh kosong", "Kesalahan", JOptionPane.INFORMATION_MESSAGE);
 txtPassword.requestFocus();
return; }
String alamat = txtAlamat.getText();
String notelp = txtNotelp.getText();
 String level = "user";
if (rbUser.isSelected() == true) {
level = "user";
} else { level = "admin"; }

if (modeOperasi.equalsIgnoreCase("INSERT")) {
prosesinsertData(id_karyawan, nama, alamat, notelp, level, password); JOptionPane.showMessageDialog(null, "Data Karyawan bernama " + txtNama.getText() +
" berhasil disimpan", "Informasi", JOptionPane.INFORMATION_MESSAGE);
} else { prosesupdateData(id_karyawan, nama, alamat, notelp, level, password); JOptionPane.showMessageDialog(null, "Data karyawan bernama " + txtNama.getText()
+ " berhasil diupdate", "Informasi", JOptionPane.INFORMATION_MESSAGE);
} isikanTabel();
}

private void btnHapusActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if (JOptionPane.showConfirmDialog(null, "Apakah anda ingin menghapus data bernama " + txtNama.getText() + " ini?", "Pertanyaan", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE) == JOptionPane.YES_OPTION) {
String id_karyawan = txtIdKaryawan.getText().toString();
 try { query = "SELECT * FROM olahdata where nama_user='" + id_karyawan + "'";
st = db.koneksi.createStatement();
rs = st.executeQuery(query);
if (rs.next()) { JOptionPane.showMessageDialog(null, "Data karyawan bernama " + txtNama.getText() + " masih dipakai", "Informasi",
JOptionPane.INFORMATION_MESSAGE);
} else { prosesdeleteData(id_karyawan);
 JOptionPane.showMessageDialog(null, "Data karyawan bernama " + txtNama.getText()
+ " berhasil dihapus", "Informasi", JOptionPane.INFORMATION_MESSAGE);
 isikanTabel(); }
} catch (Exception DBException) {
System.err.println("Error ="+ DBException); } }
}

private void btnNextActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int brsSkrg, brsAkhir;
brsSkrg = tbKaryawan.getSelectedRow();
brsAkhir = tbKaryawan.getRowCount() -1;
if (brsSkrg < brsAkhir) {
kursor = brsSkrg + 1;
} else { kursor = brsAkhir;
} tbKaryawan.setRowSelectionInterval(kursor, kursor);
tampilkanDiText();
}

private void btnPrevActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int brsSkrg;
brsSkrg = tbKaryawan.getSelectedRow();
if (brsSkrg > 0) {
kursor = brsSkrg - 1;
} else { kursor = 0;
} tbKaryawan.setRowSelectionInterval(kursor, kursor);
tampilkanDiText();
}

private void btnFirstActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
kursor = 0;
tbKaryawan.setRowSelectionInterval(kursor, kursor);
tampilkanDiText();
}

private void btnLastActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
kursor = tbKaryawan.getRowCount() - 1;
tbKaryawan.setRowSelectionInterval(kursor, kursor);
tampilkanDiText();
}

private void tbKaryawanMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
tampilkanDiText();
}

Semoga berguna bagi anda semua...!