Program Simpan, Edit, Hapus dan Cari dengan Java Netbeans dan MySQL

Pada latihan sebelumnya di project pustaka_keliling017, cara membuat login kita tambahkan tabel buku :

tambahkan sebuat class dengan nama mahasiswa, disain form seperti tampilan berikut :

Berikut Koding nya :

package pustaka_keliling017;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
/**
 *
 * @author ANDESKB
 */
public class buku017 extends javax.swing.JFrame {
public Connection conn;
public Statement cn;
    /**
     * Creates new form buku017
     */
    public buku017() {
        initComponents();
        bersih();
        tampil();
        pertama();
        jButton6.requestFocus();
    }

//prosedur koneksi
    public  void koneksi(){
    try{
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/aplikasi_rental","root","");
        cn = conn.createStatement();
    }catch (Exception e){
        JOptionPane.showMessageDialog(null,"koneksi gagal..");
        System.out.println(e.getMessage());
        }
}
//prosedure bersih    
public  void bersih(){
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
}

//prosedur pertama tampil atau load
public void pertama(){
    jTextField2.setEditable(false);
    jTextField3.setEditable(false);
    jTextField4.setEditable(false);
    jTextField5.setEditable(false);
    jTextField6.setEditable(false);
    jButton1.setEnabled(false);
    jButton2.setEnabled(false);
    jButton4.setEnabled(false);
}

//prosedur no otomatis
public void noauto(){
    try{
koneksi();
String sql = "Select id as no from buku ORDER by id desc";
ResultSet rs = cn.executeQuery(sql);

if (rs.next())
{
int no_t = Integer.parseInt(rs.getString("no")) + 1;
jTextField2.setText(Integer.toString(no_t));
}
else{
int no_t = 001;
jTextField2.setText(Integer.toString(no_t));
}
rs.close();
}catch (Exception e){

}
}
//prosedur tambah baru
public void baru(){
    noauto();
    jTextField2.setEditable(false);
    jTextField3.setEditable(true);
    jTextField4.setEditable(true);
    jTextField5.setEditable(true);
    jTextField6.setEditable(true);
    jButton1.setEnabled(true);
    jButton2.setEnabled(false);
    jButton4.setEnabled(false);
}

//prosedur tampil
public  void tampil(){
    DefaultTableModel tabelModel=new DefaultTableModel();
    tabelModel.addColumn("ID Buku");
    tabelModel.addColumn("Judul Buku");
    tabelModel.addColumn("Penerbit");
    tabelModel.addColumn("Pengarang");
    
    try{
koneksi();
String sql = "Select * from buku order by id asc";
ResultSet rs = cn.executeQuery(sql);
while (rs.next())
{
tabelModel.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
});
}
jTable2.setModel(tabelModel);

}catch (Exception e){
JOptionPane.showMessageDialog(null, "Ada Kesalahan");
}
}
//prosedur pencarian buku
public void caribuku(){
 DefaultTableModel tabelnyo = new DefaultTableModel();
tabelnyo.addColumn("id");
tabelnyo.addColumn("judul");
tabelnyo.addColumn("penerbit");
tabelnyo.addColumn("pengarang");
try{
koneksi();
String sql = "Select * from buku where id like '%" + jTextField6.getText() + "%'" +
"or judul like '%" + jTextField6.getText() +  "%'";
ResultSet rs = cn.executeQuery(sql);
while (rs.next()) {
tabelnyo.addRow(new Object[]{
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4)
});
}
jTable2.setModel(tabelnyo);

}catch (Exception e){
}

}

**koding simpan
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        try{

koneksi();
String sql = "insert into buku values ('"+ jTextField2.getText()+"', '" + jTextField3.getText() + "' , '" + jTextField4.getText() + "' , '" + jTextField5.getText() + "')";
cn.executeUpdate(sql);
conn.close();

tampil();
bersih();
JOptionPane.showMessageDialog(null,"Data Berhasil di Simpan");

}catch (Exception e){
JOptionPane.showMessageDialog(null,"Proses penyimpanan gagal/koneksi gagal..");
System.out.println(e.getMessage());
}

    } 

** koding ubah
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here
        try{
koneksi();
String sql =( "update buku set judul='"+ jTextField3.getText() +"' ,penerbit='" + 
jTextField4.getText()+ "',pengarang='" + 
jTextField5.getText()+ "' where id='" + jTextField2.getText() + "'");
cn.executeUpdate(sql);
conn.close();

tampil();
bersih();
JOptionPane.showMessageDialog(null,"Data Berhasil Diubah ");
jButton1.setEnabled(true);
jButton2.setEnabled(false);
jButton4.setEnabled(false);
jTextField2.setEnabled(true);
}catch (Exception e){
JOptionPane.showMessageDialog(null,"Proses update gagal/koneksi gagal..");
System.out.println(e.getMessage());
}

    }   

** Koding hapus
 private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        try{

koneksi();
String sql = "delete from buku where id='"+ jTextField2.getText() +"'";
cn.executeUpdate(sql);
conn.close();

tampil();
bersih();
JOptionPane.showMessageDialog(null,"Data berhasil di Hapus");
jButton1.setEnabled(true);
jButton2.setEnabled(false);
jButton4.setEnabled(false);
jTextField2.setEnabled(true);
}catch (Exception e){
JOptionPane.showMessageDialog(null,"Proses hapus gagal/koneksi gagal..");
System.out.println(e.getMessage());
}

    }

**koding klik tabel
 private void jTable2MouseClicked(java.awt.event.MouseEvent evt) {                                     
        // TODO add your handling code here:
        int table = jTable2.getSelectedRow();
//mengambil data dari table
String a = jTable2.getValueAt(table, 0).toString();
String b = jTable2.getValueAt(table, 1).toString();
String c = jTable2.getValueAt(table, 2).toString();
String d = jTable2.getValueAt(table, 3).toString();

jTextField2.setText(a);
jTextField3.setText(b);
jTextField4.setText(c);
jTextField5.setText(d);

jTextField2.setEnabled(false);
jTextField3.requestFocus();
jButton1.setEnabled(false);
jButton2.setEnabled(true);
jButton4.setEnabled(true);
    }                                    


**pemanggilan  pencarian
    private void jTextField6KeyPressed(java.awt.event.KeyEvent evt) {                                       
        // TODO add your handling code here:
     caribuku();

    }     
**button bersih
 private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        bersih();
        jButton1.setEnabled(true);
jButton2.setEnabled(false);
jButton4.setEnabled(false);
jTextField2.setEnabled(true);
    }                                                                         
                              

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

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