Guest User

Untitled

a guest
Apr 23rd, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.87 KB | None | 0 0
  1.         try (Connection con = DBConnect.connect()){
  2.             con.setAutoCommit(false);
  3.            
  4.             int recordID = DBRecord.insert(bean.getName(), bean.getTag(), bean.getScore(), bean.getYtid(), bean.getComment());
  5.             if (recordID == -1){
  6.                 lblMessage.setValue("Failed to submit the replay (DBRecord.insert)!");
  7.                 con.rollback();
  8.                 return;
  9.             }
  10.            
  11.             if (!DBPlayedBy.insert(con, recordID, playedByList)){
  12.                 lblMessage.setValue("Failed to submit the replay (DBPlayedBy.insert)!");
  13.                 con.rollback();
  14.                 return;
  15.             }
  16.            
  17.             lblMessage.setValue("Testing abort! Your replay should have not been saved in the database.");
  18.             con.rollback();
  19.             return;
  20.            
  21.             /*con.commit();
  22.             fieldYtId.setValue("");
  23.             lblMessage.setValue("The replay has been submitted!");*/
  24.         } catch (SQLException e) {
  25.             lblMessage.setValue("Failed to submit the replay!");
  26.             e.printStackTrace();
  27.         }
Add Comment
Please, Sign In to add comment