Guest User

Untitled

a guest
Dec 9th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. dataSource.setURL("jdbc:mysql://localhost:3306/Ceaserstone?authReconnect=true&useSSL=false&allowMultiQueries=true");
  2.  
  3. UserBean user = null;
  4. PreparedStatement preparedStatement = null;
  5. try (Connection connection = dataSource.getConnection();) {
  6. preparedStatement = connection.prepareStatement("UPDATE user SET status = ? WHERE id = ?; SELECT id, status FROM user WHERE id = ?");
  7. preparedStatement.setBoolean(1, userBean.isStatus());
  8. preparedStatement.setInt(2, userBean.getId());
  9. preparedStatement.setInt(3, userBean.getId());
  10.  
  11. ResultSet resultSet = preparedStatement.executeQuery();
  12.  
  13. } finally {
  14. if(preparedStatement != null) preparedStatement.close();
  15. }
  16. return user;
Add Comment
Please, Sign In to add comment