Advertisement
Guest User

Untitled

a guest
Jul 12th, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. switch (option){
  2. case "FirstName": newUser.setFirstName(value);break;
  3. case "LastName": newUser.setLastName(value);break;
  4. case "PhoneNumber": newUser.setPhoneNr(value);break;
  5. case "Email": newUser.setEmail(value);break;
  6. case "UserName": newUser.setUsername(value);break;
  7. case "PassWord": newUser.setPassword(value);break;
  8. case "Status": newUser.setStatus(Boolean.parseBoolean(value));break;
  9. default:System.out.println("Error");break;
  10. }
  11.  
  12. String sql = "UPDATE user SET idUser=?,FirstName=?,LastName=?,PhoneNumber=?,Email=?,UserName=?,PassWord=?,Status=? WHERE idUser=?;";
  13.  
  14. stmt = conn.prepareStatement(sql);
  15. stmt.setInt(1, recordId);
  16. stmt.setString(2, newUser.getFirstName());;
  17. stmt.setString(3, newUser.getLastName());
  18. stmt.setString(4, newUser.getPhoneNr());
  19. stmt.setString(5, newUser.getEmail());;
  20. stmt.setString(6, newUser.getUsername());
  21. stmt.setString(7, newUser.getPhoneNr());
  22. stmt.setBoolean(8, newUser.isStatus());
  23. stmt.setInt(9, recordId);
  24. System.out.println("Update " + stmt);;
  25. stmt.execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement