@Override
public List<barang> getBarangbyKeterangan(String keterangan) throws BarangException {
List<barang> list = new ArrayList<barang>();
PreparedStatement statement = null;
barang barang = null;
try {
connection.setAutoCommit(false);
statement = connection.prepareStatement(getByket);
statement.setString(1, "%" + keterangan + "%");
ResultSet rs = statement.executeQuery();
while (rs.next()) {
barang = new barang();
barang.setIdBarang(rs.getString("idbarang"));
barang.setIdBarcode(rs.getString("idbarcode"));
barang.setNamaBarang(rs.getString("namabarang"));
barang.setTipe(rs.getString("tipe"));
barang.setMerek(rs.getString("merek"));
barang.setHargamodal(rs.getInt("hargamodal"));
barang.setEceran(rs.getInt("eceran"));
barang.setGrosir(rs.getInt("grosir"));
barang.setSatuan(rs.getString("satuan"));
barang.setStok(rs.getInt("stok"));
barang.setStokMinimum(rs.getInt("stok_minimum"));
barang.setSupplier(rs.getString("supplier"));
barang.setKeterangan(rs.getString("keterangan"));
barang.setGambarHasil(rs.getBlob("gambar"));
barang.setKategori(rs.getString("kategori"));
list.add(barang);
}
connection.commit();
// return list;
} catch (SQLException exception) {
try {
connection.rollback();
} catch (SQLException ex) {
}
// throw new barangException(exception.getMessage());
} finally {
try {
connection.setAutoCommit(true);
} catch (SQLException ex) {
}
if (statement != null) {
try {
statement.close();
} catch (SQLException exception) {
}
}
}
return list;
}
