code: public void remove(int profileId) {
          PreparedStatement statement = null;
  
          try (Connection sqlConnection = sqlService.getConnection()) {
              statement = sqlConnection.prepareStatement("DELETE FROM " + Constants.DB_TABLE_PROFILE +
                                                             " WHERE " + Constants.GENERIC_ID + " = ?");
              statement.setInt(1, profileId);
              statement.executeUpdate();
              statement.close();
              //also want to delete what is in the server redirect table
              statement = sqlConnection.prepareStatement("DELETE FROM " + Constants.DB_TABLE_SERVERS +
                                                             " WHERE " + Constants.GENERIC_PROFILE_ID + " = ?");
              statement.setInt(1, profileId);
              statement.executeUpdate();
              statement.close();
              //also want to delete the path_profile table
              statement = sqlConnection.prepareStatement("DELETE FROM " + Constants.DB_TABLE_PATH +
                                                             " WHERE " + Constants.GENERIC_PROFILE_ID + " = ?");
              statement.setInt(1, profileId);
              statement.executeUpdate();
              statement.close();
              //and the enabled overrides table
              statement = sqlConnection.prepareStatement("DELETE FROM " + Constants.DB_TABLE_ENABLED_OVERRIDE +
                                                             " WHERE " + Constants.GENERIC_PROFILE_ID + " = ?");
              statement.setInt(1, profileId);
              statement.executeUpdate();
              statement.close();
              //and delete all the clients associated with this profile including the default client
              statement = sqlConnection.prepareStatement("DELETE FROM " + Constants.DB_TABLE_CLIENT +
                                                             " WHERE " + Constants.GENERIC_PROFILE_ID + " = ?");
              statement.setInt(1, profileId);
              statement.executeUpdate();
              statement.close();
          } catch (SQLException e) {
              e.printStackTrace();
          } finally {
              try {
                  if (statement != null) {
                      statement.close();
                  }
              } catch (Exception e) {
              }
          }
      }
docs: Deletes data associated with the given profile ID
  
  @param profileId ID of profile