Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void update(Coffee c) {
- String sql = "UPDATE COFFEES "
- + "SET PRICE = :price, SALES = :sales, TOTAL = :total "
- + "WHERE COF_NAME = :cof_name AND SUP_ID = :sup_id";
- Map<String, Object> parameters = new HashMap<>();
- parameters.put("price", c.getPrice().floatValue());
- parameters.put("sales", c.getSales());
- parameters.put("total", c.getTotal());
- parameters.put("cof_name", c.getName());
- parameters.put("sup_id", c.getSupplierId());
- jdbc.update(sql, parameters);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement