Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- switch (option){
- case "FirstName": newUser.setFirstName(value);break;
- case "LastName": newUser.setLastName(value);break;
- case "PhoneNumber": newUser.setPhoneNr(value);break;
- case "Email": newUser.setEmail(value);break;
- case "UserName": newUser.setUsername(value);break;
- case "PassWord": newUser.setPassword(value);break;
- case "Status": newUser.setStatus(Boolean.parseBoolean(value));break;
- default:System.out.println("Error");break;
- }
- String sql = "UPDATE user SET idUser=?,FirstName=?,LastName=?,PhoneNumber=?,Email=?,UserName=?,PassWord=?,Status=? WHERE idUser=?;";
- stmt = conn.prepareStatement(sql);
- stmt.setInt(1, recordId);
- stmt.setString(2, newUser.getFirstName());;
- stmt.setString(3, newUser.getLastName());
- stmt.setString(4, newUser.getPhoneNr());
- stmt.setString(5, newUser.getEmail());;
- stmt.setString(6, newUser.getUsername());
- stmt.setString(7, newUser.getPhoneNr());
- stmt.setBoolean(8, newUser.isStatus());
- stmt.setInt(9, recordId);
- System.out.println("Update " + stmt);;
- stmt.execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement