FrmListBuku.java

private void getData(){
        String kolom[] ={"ID Buku","Judul","No ISBN","Penulis","Penerbit","Stok","Harga","Diskon (%)"};
        DefaultTableModel table = new DefaultTableModel(null,kolom);
        String col = cboKeyword.getSelectedItem().toString();
        String key = txtCari.getText();
        try{
            String SQL = "Select idBuku,judul,noIsbn,penulis,penerbit,stock,hargajual,diskon from buku";
            ResultSet rs = koneksi.executeQuery(SQL);
            while(rs.next()){
                table.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)
                });
            }
        }catch(Exception e){
            System.out.println(e);
        }
        tblBuku.setModel(table);
    }

    private void search(){
        String kolom[] ={"ID Buku","Judul","No ISBN","Penulis","Penerbit","Stok","Harga","PPN","Diskon"};
        DefaultTableModel table = new DefaultTableModel(null,kolom);
        try{
            String column = cboKeyword.getSelectedItem().toString();
            String parameter = " where "+column+" like '%"+txtCari.getText()+"%'";
            String SQL = "Select idBuku,judul,noIsbn,penulis,penerbit,stock,hargajual,ppn,diskon from buku"+parameter;

            ResultSet rs = koneksi.executeQuery(SQL);
            while(rs.next()){
                table.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)
                });
            }

            tblBuku.setModel(table);
        }catch(Exception e){
            System.out.println(e);
        }
    }

    private void getDataForUpdate(){
        try{
            int i = tblBuku.getSelectedRow();
            String idBuku = tblBuku.getValueAt(i, 0).toString();
            if(i != -1){
                FrmBuku buku = new FrmBuku();
                buku.setIdBuku(idBuku);
                buku.setUpdate(true);
                buku.setVisible(true);
            }

        }catch(Exception e){
            JOptionPane.showMessageDialog(rootPane, "Silahkan Pilih Data Terlebih Dahulu!",
                    "Informasi",JOptionPane.INFORMATION_MESSAGE);
        }
    }

    private void hapusData(){
        try{
            int i = tblBuku.getSelectedRow();
            String id = tblBuku.getValueAt(i, 0).toString();
            String Judul = tblBuku.getValueAt(i, 1).toString();
            if(JOptionPane.showConfirmDialog(rootPane,
                    "Anda Yakin Akan Menghapus\nData "+Judul,"Informasi",
                    JOptionPane.OK_CANCEL_OPTION,JOptionPane.INFORMATION_MESSAGE)
                    ==JOptionPane.OK_OPTION){
                String query = "delete from buku where idBuku = '"+id+"'";
                int a = koneksi.execute(query);
                if(a>0){
                    JOptionPane.showMessageDialog(rootPane, "Data Berhasil Dihapus!",
                            "Success",JOptionPane.INFORMATION_MESSAGE);
                    getData();
                }else{
                    JOptionPane.showMessageDialog(rootPane, "Data Gagal Dihapus!",
                            "Gagal",JOptionPane.WARNING_MESSAGE);
                }
            }
        }catch(Exception e){
            JOptionPane.showMessageDialog(rootPane, "Silahkan Pilih Data Terlebih Dahulu!",
                    "Informasi",JOptionPane.INFORMATION_MESSAGE);
        }
    }

private void keluar(){
if(JOptionPane.showConfirmDialog(rootPane, "Anda Akan Keluar Dari Daftar buku?",
            "Informasi",JOptionPane.CANCEL_OPTION,
            JOptionPane.INFORMATION_MESSAGE)==JOptionPane.OK_OPTION)this.dispose();
}