abc22.java

private void hapus(){
    String query;

    query = "DELETE FROM tbl_barang WHERE kode_barang=?";
    PreparedStatement statement;
    Connection connection;

    try {
        connection = Koneksi.koneksiDatabase();
        statement = connection.prepareStatement(query);
        statement.setString(1, iKodeBarang.getText());

        int hasil = statement.executeUpdate();
        if(hasil == 1){
            JOptionPane.showMessageDialog(this, "DATA BARANG TELAH DIHAPUS");
        }
    } catch (SQLException ex){
        JOptionPane.showMessageDialog(this, ex.getMessage());
    }
}
/*** hapus, cari ***/
private void cari(){
    try{
        String pertanyaan = "Masukan kode barang yang akan dicari";
        String kode = JOptionPane.showInputDialog(this, pertanyaan);
        if(!kode.trim().equals("")){
            String query = "SELECT * FROM tbl_barang WHERE kode_barang = ?";
            PreparedStatement statement;
            Connection connection;
            try{
               connection = Koneksi.koneksiDatabase();
               statement = connection.prepareStatement(query);
               statement.setString(1, kode);
               ResultSet rs = statement.executeQuery();
               if(rs.next()){
                   iKodeBarang.setText(rs.getString("kode_barang"));
                   iNamaBarang.setText(rs.getString("nama_barang"));
                   iJenis.setSelectedItem(rs.getString("jenis_barang"));
               }
            } catch (SQLException e){
                JOptionPane.showMessageDialog(this, "Data barang tidak ada");
                resetFrom();
            }
        }
    } catch (HeadlessException e){
        JOptionPane.showMessageDialog(this, e.getMessage());
    }
}