abc21.java

private void resetFrom(){
    iKodeBarang.setText("");
    iNamaBarang.setText("");
    iJenis.setSelectedItem("Mudah Robek");
}
/*** add, edit ***/
private void simpan(){
    String query;

    query = "INSERT INTO tbl_barang (kode_barang, nama_barang, jenis_barang) VALUES (?, ?, ?)";
    PreparedStatement statement;
    Connection connection;

    try {
        connection = Koneksi.koneksiDatabase();
        statement = connection.prepareStatement(query);
        statement.setString(1, iKodeBarang.getText());
        statement.setString(2, iNamaBarang.getText());
        statement.setString(3, iJenis.getSelectedItem().toString());

        int hasil = statement.executeUpdate();
        if(hasil == 1){
            JOptionPane.showMessageDialog(this, "DATA BARANG TELAH DISIMPAN");
            resetFrom();
        }
    } catch (SQLException ex){
        JOptionPane.showMessageDialog(this, ex.getMessage());
    }
}

private void ubah(){
    String query;

    query = "UPDATE tbl_barang SET nama_barang=?, jenis_barang=? WHERE kode_barang=?";
    PreparedStatement statement;
    Connection connection;

    try {
        connection = Koneksi.koneksiDatabase();
        statement = connection.prepareStatement(query);
        statement.setString(6, iKodeBarang.getText());
        statement.setString(1, iNamaBarang.getText());
        statement.setString(2, iJenis.getSelectedItem().toString());

        int hasil = statement.executeUpdate();
        if(hasil == 1){
            JOptionPane.showMessageDialog(this, "DATA BARANG TELAH DIPERBAHARUI");
        }
    } catch (SQLException ex){
        JOptionPane.showMessageDialog(this, ex.getMessage());
    }
}