@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; }