Example #1
0
 /**
  * Update user.
  *
  * @param user user to update.
  * @throws SQLException
  */
 private void updateUser(Connection con, User user) throws SQLException {
   PreparedStatement pstmt = null;
   try {
     pstmt = con.prepareStatement(SQL_UPDATE_USER);
     int k = 1;
     pstmt.setString(k++, user.getPassword());
     pstmt.setString(k++, user.getFirstName());
     pstmt.setString(k++, user.getLastName());
     pstmt.setLong(k, user.getId());
     pstmt.executeUpdate();
   } finally {
     close(pstmt);
   }
 }