Advertisement
Guest User

Untitled

a guest
Apr 29th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.62 KB | None | 0 0
  1. String sqlIdentifier = "select nextval('sequence_items')";
  2. PreparedStatement pst = conn.prepareStatement(sqlIdentifier);
  3. ResultSet rs = pst.executeQuery();
  4. long id = 0;
  5. if (rs.next()) {
  6.       id = rs.getLong("nextval");
  7. }
  8. String insertTableSQL = "INSERT into items(id, name, price, category_id) values(?, ?, ?, ?)";
  9. PreparedStatement statement = conn.prepareStatement(insertTableSQL);
  10. statement.setLong(1, id);
  11. statement.setString(2, instance.getName());
  12. statement.setDouble(3, instance.getPrice());
  13. statement.setInt(4, instance.getCategory().ordinal());
  14. statement.executeUpdate();
  15. instance.setId(id);
  16. statement.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement