public void update(User user) throws ServerException, SQLException {
	  PreparedStatement stmt = null;
	  Statement keyStmt = null;
	  ResultSet keyRS = null;
	  try {
		  String sql = "UPDATE users SET username = ?, password = ?, name_first = ?, name_last = ?, email = ?, indexed_records = ? where id = ?";
		  stmt = db.getConnection().prepareStatement(sql);
		  stmt.setString(1, user.getUsername());
		  stmt.setString(2, user.getPassword());
		  stmt.setString(3, user.getFirstName());
		  stmt.setString(4, user.getLastName());
		  stmt.setString(5, user.getEmail());
		  stmt.setInt(6, user.getIndexedRecords());
		  stmt.setInt(7, user.getID());
		  if (stmt.executeUpdate() == 1) {
			  System.out.println("SUCCESS");
		  } else {
			  System.out.println("UPDATE failed");
		  }
	  } catch (SQLException e) { e.printStackTrace(); }
	  finally {
		  if (stmt != null) stmt.close();
		  if (keyRS != null) keyRS.close();
		  if (keyStmt != null) keyStmt.close();
	  }
  }