Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public User editUserDetails(int userID ,String email, String password, String fName, String lName, String bio, String image) {
- boolean found = false;
- Connection c = DBHelperClass.getConnection();
- String query = "UPDATE user SET email= ? , password= ?,fName= ?,lName= ?,bio= ?,image=? WHERE userID= ?";
- if (c != null) {
- try {
- PreparedStatement inserter = c.prepareStatement(query);
- inserter.setString(1, email);
- inserter.setString(2, password);
- inserter.setString(3, fName);
- inserter.setString(4, lName);
- inserter.setString(5, bio);
- inserter.setString(6, image);
- inserter.setInt(7, userID);
- System.out.println("Update user: " + query);
- ResultSet resultSet = inserter.executeUpdate();
- inserter.executeUpdate();
- inserter.close();
- while (resultSet.next()) {
- this.setUserID(resultSet.getInt("userID"));
- this.email = resultSet.getString("email");
- this.setPassword(resultSet.getString("password"));
- this.type=resultSet.getString("type");
- this.fName=resultSet.getString("fName");
- this.lName=resultSet.getString("lName");
- found = true;
- }
- } catch (SQLException ex) {
- Logger.getLogger(User.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- return this;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement