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