Advertisement
tahg

Untitled

Oct 24th, 2017
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. public int createId(String fileset, int runid, int stepid, int steporder, String project, String user) {
  2. String stmt = "INSERT INTO v3addin.dbo.v3link (li_fileset, li_runid, li_stepid, li_steporder, li_project, li_user, li_start, li_explain) "
  3. + "VALUES(?, ?, ?, ?, ?, ?, GETUTCDATE(), 'Record created')";
  4. try (PreparedStatement ps = conn.prepareStatement(stmt, Statement.RETURN_GENERATED_KEYS)) {
  5. ps.setString(1, fileset);
  6. ps.setInt(2, runid);
  7. ps.setInt(3, stepid);
  8. ps.setInt(4, steporder);
  9. ps.setString(5, project);
  10. ps.setString(6, user);
  11. ps.executeUpdate();
  12. ResultSet rs = ps.getGeneratedKeys();
  13. if (rs.next()) { return rs.getInt(1); }
  14. } catch (SQLException e) {
  15. // Hopefully key already exists, but could be another error.
  16. }
  17. return 0;
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement