public void update(Field field) throws ServerException, SQLException {
	 	PreparedStatement stmt = null;
	  Statement keyStmt = null;
	  ResultSet keyRS = null;
	  try {
		  String sql = "UPDATE fields SET project_id = ?, title = ?, xcoord = ?, "+
		  						 "width = ?, help_html = ?, known_data = ? where id = ?";
		  stmt = db.getConnection().prepareStatement(sql);
		  stmt.setInt(1, field.getProjectId());
		  stmt.setString(2, field.getTitle());
		  stmt.setInt(3, field.getXcoord());
		  stmt.setInt(4, field.getWidth());
		  stmt.setString(5, field.getHtmlHelp());
		  stmt.setString(6, field.getKnownData());
		  stmt.setInt(7, field.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();
	  }
	}