Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String sqlIdentifier = "select nextval('sequence_items')";
- PreparedStatement pst = conn.prepareStatement(sqlIdentifier);
- ResultSet rs = pst.executeQuery();
- long id = 0;
- if (rs.next()) {
- id = rs.getLong("nextval");
- }
- String insertTableSQL = "INSERT into items(id, name, price, category_id) values(?, ?, ?, ?)";
- PreparedStatement statement = conn.prepareStatement(insertTableSQL);
- statement.setLong(1, id);
- statement.setString(2, instance.getName());
- statement.setDouble(3, instance.getPrice());
- statement.setInt(4, instance.getCategory().ordinal());
- statement.executeUpdate();
- instance.setId(id);
- statement.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement