Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dataSource.setURL("jdbc:mysql://localhost:3306/Ceaserstone?authReconnect=true&useSSL=false&allowMultiQueries=true");
- UserBean user = null;
- PreparedStatement preparedStatement = null;
- try (Connection connection = dataSource.getConnection();) {
- preparedStatement = connection.prepareStatement("UPDATE user SET status = ? WHERE id = ?; SELECT id, status FROM user WHERE id = ?");
- preparedStatement.setBoolean(1, userBean.isStatus());
- preparedStatement.setInt(2, userBean.getId());
- preparedStatement.setInt(3, userBean.getId());
- ResultSet resultSet = preparedStatement.executeQuery();
- } finally {
- if(preparedStatement != null) preparedStatement.close();
- }
- return user;
Add Comment
Please, Sign In to add comment