Advertisement
Guest User

Untitled

a guest
Jun 13th, 2016
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. public User getUserById (int id) {
  2. User user = null;
  3. try {
  4. Connection conn = ConnectionManager.getConnection();
  5. String query = "SELECT userName, userPassword FROM User WHERE id = ?";
  6. PreparedStatement pstmt = conn.prepareStatement(query);
  7. pstmt.setInt(1, id);
  8. ResultSet rset = pstmt.executeQuery();
  9.  
  10. if (rset.next()) {
  11. String userName = rset.getString(1);
  12. String userPassword = rset.getString(2);
  13. user = new User (userName, userPassword);
  14. }
  15. rset.close();
  16. pstmt.close();
  17. } catch (SQLException e) {
  18. e.printStackTrace();
  19. }
  20. return user;
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement