Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. String abb = "ab";
  2. String cdd = "cd";
  3. UserPass user = UserDb.selectUser(abb,cdd);
  4. out.println(user);
  5.  
  6. public class UserPass {
  7. String username;
  8. String password;
  9.  
  10. public UserPass(){
  11. this.username ="";
  12. this.password ="";
  13. }
  14.  
  15. public void setUserName(String username) {
  16. this.username = username;
  17. }
  18.  
  19. public String getUserName(){
  20. return username;
  21. }
  22. }
  23.  
  24. String query = "select user_name from UserPass where user_name = ? AND user_password = ? " ;
  25.  
  26. try{
  27. ps = connection.prepareStatement(query);
  28. ps.setString(1, username);
  29. ps.setString(2, password);
  30.  
  31. rs = ps.executeQuery();
  32.  
  33. if (rs.getString("user_name") != null) {
  34. UserPass up = new UserPass();
  35. up.setUserName(rs.getString("user_name"));
  36. return up;
  37.  
  38. } else {
  39. return null;
  40. }
  41. }
  42.  
  43. rs = ps.executeQuery();
  44. if (rs.next()) {
  45. UserPass up = new UserPass();
  46. up.setUserName(rs.getString("user_name"));
  47. return up;
  48. } else {
  49. return null;
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement