Advertisement
Guest User

Untitled

a guest
Nov 17th, 2019
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. public void setTeamsForUser(User user, Team ... teams) {
  2. Connection con = null;
  3. PreparedStatement prepared = null;
  4. try {
  5. con = DriverManager.getConnection(URL);
  6. con.setAutoCommit(false);
  7. con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
  8. prepared = con.prepareStatement(SQL_INSERT_PAIR);
  9. prepared.setInt(1, user.getId());
  10. for (Team team : teams) {
  11. prepared.setInt(2, team.getId());
  12. prepared.executeUpdate();
  13. }
  14. con.commit();
  15. } catch (SQLException ex) {
  16. rollback(con);
  17. ex.printStackTrace();
  18. } finally {
  19. close(prepared);
  20. close(con);
  21. }
  22. }
  23.  
  24. public void deleteTeam(Team team) {
  25. Connection con = null;
  26. PreparedStatement prepar = null;
  27. try {
  28. con = DriverManager.getConnection(URL);
  29. prepar = con.prepareStatement(SQL_DELETE_TEAM_BY_NAME);
  30. prepar.setString(1, team.getName());
  31. prepar.executeUpdate();
  32. } catch (SQLException ex) {
  33. ex.printStackTrace();
  34. } finally {
  35. close(prepar);
  36. close(con);
  37. }
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement