Advertisement
Guest User

Untitled

a guest
Dec 26th, 2016
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. public User editUserDetails(int userID ,String email, String password, String fName, String lName, String bio, String image) {
  2.  
  3. boolean found = false;
  4. Connection c = DBHelperClass.getConnection();
  5. String query = "UPDATE user SET email= ? , password= ?,fName= ?,lName= ?,bio= ?,image=? WHERE userID= ?";
  6.  
  7. if (c != null) {
  8. try {
  9. PreparedStatement inserter = c.prepareStatement(query);
  10. inserter.setString(1, email);
  11. inserter.setString(2, password);
  12. inserter.setString(3, fName);
  13. inserter.setString(4, lName);
  14. inserter.setString(5, bio);
  15. inserter.setString(6, image);
  16. inserter.setInt(7, userID);
  17.  
  18. System.out.println("Update user: " + query);
  19. ResultSet resultSet = inserter.executeUpdate();
  20. inserter.executeUpdate();
  21. inserter.close();
  22.  
  23. while (resultSet.next()) {
  24. this.setUserID(resultSet.getInt("userID"));
  25. this.email = resultSet.getString("email");
  26. this.setPassword(resultSet.getString("password"));
  27. this.type=resultSet.getString("type");
  28. this.fName=resultSet.getString("fName");
  29. this.lName=resultSet.getString("lName");
  30. found = true;
  31.  
  32. }
  33. } catch (SQLException ex) {
  34. Logger.getLogger(User.class.getName()).log(Level.SEVERE, null, ex);
  35. }
  36.  
  37. }
  38. return this;
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement