Semua

CLASS BUKU
package tugas10;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
public class Buku {
    private String isbn, judul, pengarang, penerbit;

    public Buku() {
        isbn = "";
        judul = "";
        pengarang = "";
        penerbit = "";
    }
    public Buku(String isbn, String judul, String pengarang, String penerbit){
        this.isbn = isbn;
        this.judul = judul;
        this.pengarang = pengarang;
        this.penerbit = penerbit;
    }
    public void tambah()
    {
        Connection conn = null;

        try
        {
            String jdbcDriver = "org.gjt.mm.mysql.Driver";
            Class.forName(jdbcDriver);

            String url = "jdbc:mysql://localhost:3306/perpustakaan";
            String user = "root";
            String pwd = "";

            conn = DriverManager.getConnection(url, user, pwd);

            String sqlInsert = "insert into buku values("
                    + "'" + this.isbn + "',"
                    + "'" + this.judul + "',"
                    + "'" + this.pengarang + "',"
                    + "'" + this.penerbit + "');";

            int status = Koneksi.execute(sqlInsert);
            if (status == 1)
            {
                JOptionPane.showMessageDialog(null, "Data Berhasil Ditambah", "SUKSES", JOptionPane.INFORMATION_MESSAGE);
            }

            else
            {
                JOptionPane.showMessageDialog(null, "Data Gagal Ditambah", "ERROR", JOptionPane.WARNING_MESSAGE);
            }
        }

        catch (ClassNotFoundException cnfe)
        {
            cnfe.printStackTrace();
        }

        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }

        finally
        {
            try
            {
                if(conn != null)
                {
                    conn.close();
                }
            }

            catch(SQLException sqle)
            {
                sqle.printStackTrace();
            }
        }
    }
    public void hapus()
    {
        Connection conn = null;

        try
        {
            String jdbcDriver = "org.gjt.mm.mysql.Driver";
            Class.forName(jdbcDriver);

            String url = "jdbc:mysql://localhost:3306/perpustakaan";
            String user = "root";
            String pwd = "";

            conn = DriverManager.getConnection(url, user, pwd);

            String sqlDelete = "delete from buku where isbn ='" + this.isbn +"';";

            int status = Koneksi.execute(sqlDelete);
            if (status == 1)
            {
                JOptionPane.showMessageDialog(null, "Data Berhasil Dihapus", "SUKSES", JOptionPane.INFORMATION_MESSAGE);
            }

            else
            {
                JOptionPane.showMessageDialog(null, "Data Gagal Dihapus", "ERROR", JOptionPane.WARNING_MESSAGE);
            }
        }

        catch (ClassNotFoundException cnfe)
        {
            cnfe.printStackTrace();
        }

        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }

        finally
        {
            try
            {
                if(conn != null)
                {
                    conn.close();
                }
            }

            catch(SQLException sqle)
            {
                sqle.printStackTrace();
            }
        }
    }
    public void update()
    {
        Connection conn = null;

        try
        {
            String jdbcDriver = "org.gjt.mm.mysql.Driver";
            Class.forName(jdbcDriver);

            String url = "jdbc:mysql://localhost:3306/perpustakaan";
            String user = "root";
            String pwd = "";

            conn = DriverManager.getConnection(url, user, pwd);

            String sqlUpdate = "update buku set "
                    + "judul ='" + this.judul + "',"
                    + "pengarang ='" + this.pengarang + "',"
                    + "penerbit ='" + this.penerbit + "'"
                    + "where isbn ='" + this.isbn + "';";

            int status = Koneksi.execute(sqlUpdate);
            if (status == 1)
            {
                JOptionPane.showMessageDialog(null, "Data Berhasil Diupdate", "SUKSES", JOptionPane.INFORMATION_MESSAGE);
            }

            else
            {
                JOptionPane.showMessageDialog(null, "Data Gagal Diupdate", "ERROR", JOptionPane.WARNING_MESSAGE);
            }
        }

        catch (ClassNotFoundException cnfe)
        {
            cnfe.printStackTrace();
        }

        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }

        finally
        {
            try
            {
                if(conn != null)
                {
                    conn.close();
                }
            }

            catch(SQLException sqle)
            {
                sqle.printStackTrace();
            }
        }
    }
}


FORM CRUD
package tugas10;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class CRUD extends javax.swing.JDialog {
    public CRUD(java.awt.Frame parent, boolean modal) {
        super(parent, modal);
        initComponents();
    }
    public void selectData () throws SQLException
    {
        String kolom[] = {"isbn", "judul", "pengarang", "penerbit"};
        DefaultTableModel dtm = new DefaultTableModel(null, kolom);
        String SQL = "SELECT * from buku";
        ResultSet rs = Koneksi.executeQuery(SQL);

        try
        {
            while(rs.next())
            {
                String isbn = rs.getString(1);
                String judul = rs.getString(2);
                String pengarang = rs.getString(3);
                String penerbit = rs.getString(4);
                String data[] = {isbn, judul, pengarang, penerbit};
                dtm.addRow(data);
            }
        }

        catch (Exception e)
        {
            Logger.getLogger(CRUD.class.getName()).log(Level.SEVERE, null, e);
        }

        tblData.setModel(dtm);
    }
    private void clearall(){
        tisbn.setText(null);
        tjudul.setText(null);
        tpengarang.setText(null);
        tpenerbit.setText(null);
    }
private void btambahActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        if(tisbn.getText().equals("") || tjudul.getText().equals("") || tpengarang.getText().equals("") || tpenerbit.getText().equals(""))
        {
            JOptionPane.showMessageDialog(this, "HarapLengkapi Data","ERROR", JOptionPane.WARNING_MESSAGE);
        }
        else
        {
            Buku buku1 = new Buku(tisbn.getText(), tjudul.getText(), tpengarang.getText(), tpenerbit.getText());
            buku1.tambah();
            clearall();
            try {
                selectData();
            } catch (SQLException ex) {
                Logger.getLogger(CRUD.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }

    private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        int baris = tblData.getSelectedRow();
        if (baris != -1)
        {
        if(tisbn.getText().equals(""))
        {
            JOptionPane.showMessageDialog(this, "HarapLengkapi Data","ERROR", JOptionPane.WARNING_MESSAGE);
        }
        else
        {
            Buku buku1 = new Buku(tisbn.getText(), tjudul.getText(), tpengarang.getText(), tpenerbit.getText());
            buku1.hapus();
            clearall();
            try {
                selectData();
            } catch (SQLException ex) {
                Logger.getLogger(CRUD.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
        }
        else
        {
            JOptionPane.showMessageDialog(this, "Pilih Baris Data Terlebih Dahulu", "ERROR", JOptionPane.WARNING_MESSAGE);
        }
    }

    private void bupdateActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        if(tisbn.getText().equals("") || tjudul.getText().equals("") || tpengarang.getText().equals("") || tpenerbit.getText().equals(""))
        {
            JOptionPane.showMessageDialog(this, "HarapLengkapi Data","ERROR", JOptionPane.WARNING_MESSAGE);
        }
        else
        {
            Buku buku1 = new Buku(tisbn.getText(), tjudul.getText(), tpengarang.getText(), tpenerbit.getText());
            buku1.update();
            clearall();
            try {
                selectData();
            } catch (SQLException ex) {
                Logger.getLogger(CRUD.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }

    private void brefreshActionPerformed(java.awt.event.ActionEvent evt) {
        try {
            selectData();
        } catch (SQLException ex) {
            Logger.getLogger(CRUD.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    private void tblDataMouseClicked(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
        int baris = tblData.getSelectedRow();
        if (baris != -1)
        {
            tisbn.setText(tblData.getValueAt(baris, 0).toString());
            tjudul.setText(tblData.getValueAt(baris, 1).toString());
            tpengarang.setText(tblData.getValueAt(baris, 2).toString());
            tpenerbit.setText(tblData.getValueAt(baris, 3).toString());
        }
    }

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        clearall();
    }
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                CRUD dialog = new CRUD(new javax.swing.JFrame(), true);
                dialog.addWindowListener(new java.awt.event.WindowAdapter() {
                    @Override
                    public void windowClosing(java.awt.event.WindowEvent e) {
                        System.exit(0);
                    }
                });
                dialog.setVisible(true);
            }
        });
    }
CLASS KONEKSI
package tugas10;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Driver;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
public class Koneksi {
    private static Connection koneksi;

    public static Connection getConnection() throws SQLException {
        if (koneksi == null) {
            new Driver();
            koneksi = DriverManager.getConnection("jdbc:mysql://localhost:3306/perpustakaan", "root", "");
        }
        return koneksi;
    }
    public static int execute(String SQL) throws SQLException
    {
        int status = 0;
        Connection koneksi = getConnection();

        try
        {
            Statement st = koneksi.createStatement();
            status = st.executeUpdate(SQL);
        }

        catch(Exception e)
        {
            Logger.getLogger(Koneksi.class.getName()).log(Level.SEVERE, null, e);
        }

        return status;
    }
    public static ResultSet executeQuery(String SQL) throws SQLException
    {
        ResultSet rs = null;
        Connection koneksi = getConnection();

        try
        {
            Statement st = koneksi.createStatement();
            rs = st.executeQuery(SQL);
        }

        catch (Exception e)
        {
            Logger.getLogger(Koneksi.class.getName()).log(Level.SEVERE, null, e);
        }

        return rs;
    }
}
FORM MENU
private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        CRUD form1 = new CRUD(this, true);
        form1.setVisible(true);
    }
FORM MAIN
public static void main(String[] args) throws SQLException {
        // TODO code application logic here
        Koneksi.getConnection();
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Menu().setVisible(true);
            }
        });