public void simpan(Produk p) throws Exception {
psInsert.setString(1, p.getKode());
psInsert.setString(2, p.getNama());
psInsert.setBigDecimal(3, p.getHarga());
psInsert.setDate(4, new java.sql.Date(p.getTerakhirUpdate().getTime()));
hasil = psInsert.executeUpdate();
}
public void simpanProduk(Produk p) throws SQLException {
Connection c = dataSource.getConnection();
String sqlSimpan =
"INSERT INTO `produk`(`kodeProduk`, `nama`, `harga`, `terakhirUpdate`) VALUES (?,?,?,?)";
PreparedStatement psSimpan = c.prepareStatement(sqlSimpan);
psSimpan.setString(1, p.getKodeProduk());
psSimpan.setString(2, p.getNama());
psSimpan.setBigDecimal(3, p.getHarga());
psSimpan.setDate(4, new java.sql.Date(p.getTerakhirUpdate().getTime()));
psSimpan.executeUpdate();
c.close();
}
