public List<Produk> tampilProduk() throws SQLException {
List<Produk> lp = new ArrayList<Produk>();
Connection c = dataSource.getConnection();
String sqlTampil = "SELECT * FROM produk";
PreparedStatement psTampil = c.prepareStatement(sqlTampil);
ResultSet rs = psTampil.executeQuery();
while (rs.next()) {
Produk p = new Produk();
p.setId(rs.getInt("id"));
p.setKodeProduk(rs.getString("kodeProduk"));
p.setNama(rs.getString("nama"));
p.setHarga(rs.getBigDecimal("harga"));
p.setTerakhirUpadate(rs.getDate("terakhirUpdate"));
lp.add(p);
}
c.close();
return lp;
}
