@Override
public void updateBarang(barang barang) throws BarangException {
PreparedStatement statement = null;
try {
connection.setAutoCommit(false);
statement = connection.prepareStatement(updateBarang);
statement.setString(1, barang.getIdBarang());
statement.setString(2, barang.getIdBarcode());
statement.setString(3, barang.getNamaBarang());
statement.setString(4, barang.getTipe());
statement.setString(5, barang.getMerek());
statement.setInt(6, barang.getHargamodal());
statement.setInt(7, barang.getEceran());
statement.setInt(8, barang.getGrosir());
statement.setString(9, barang.getSatuan());
statement.setInt(10, barang.getStok());
statement.setInt(11, barang.getStokMinimum());
statement.setString(12, barang.getSupplier());
statement.setString(13, barang.getKeterangan());
try {
statement.setBlob(14, new FileInputStream(barang.getGambar()));
} catch (FileNotFoundException ex) {
Logger.getLogger(ReminderDaoImpl.class.getName()).log(Level.SEVERE, null, ex);
}
statement.setString(14, barang.getKategori());
statement.executeUpdate();
connection.commit();
} catch (SQLException exception) {
try {
connection.rollback();
} catch (SQLException ex) {
}
JOptionPane.showMessageDialog(null, "Insert barang gagal karena " + exception);
} finally {
try {
connection.setAutoCommit(true);
} catch (SQLException ex) {
}
if (statement != null) {
try {
statement.close();
} catch (SQLException exception) {
}
}
}
}
