public static List<Advancement> findAllAdvancements() {
    if (!connector.checkForDataBaseConnection()) {
      return null;
    }

    List<Advancement> advancementList = new ArrayList<Advancement>();

    try {
      Statement statement = connector.createStatement();
      ResultSet rs = statement.executeQuery("SELECT * FROM advancement ORDER BY name");

      while (rs.next()) {
        Advancement advancement = new Advancement();
        advancement.setId(rs.getInt(KeyConst.ADVANCEMENT_ID.getName()));
        advancement.setName(rs.getString(KeyConst.ADVANCEMENT_NAME.getName()));
        advancement.setImgPath(rs.getString(KeyConst.ADVANCEMENT_IMG_PATH.getName()));
        advancementList.add(advancement);
      }

    } catch (Exception e) {
      return null;
    }

    return advancementList;
  }
  public static Advancement findByName(String name) {
    if (!connector.checkForDataBaseConnection()) {
      return null;
    }

    Advancement advancement = null;

    try {
      Statement statement = connector.createStatement();
      ResultSet rs =
          statement.executeQuery("SELECT * FROM advancement WHERE name LIKE '" + name + "'");

      if (rs.next()) {
        advancement = new Advancement();
        advancement.setId(rs.getInt(KeyConst.ADVANCEMENT_ID.getName()));
        advancement.setName(rs.getString(KeyConst.ADVANCEMENT_NAME.getName()));
        advancement.setImgPath(rs.getString(KeyConst.ADVANCEMENT_IMG_PATH.getName()));
      }

    } catch (Exception e) {
      return null;
    }

    return advancement;
  }
  public static List<String> getNameList() {
    if (!connector.checkForDataBaseConnection()) {
      return null;
    }

    List<String> advancementList = new ArrayList<String>();

    try {
      Statement statement = connector.createStatement();
      ResultSet rs = statement.executeQuery("SELECT name FROM advancement ORDER BY name");

      while (rs.next()) {
        advancementList.add(rs.getString(KeyConst.ADVANCEMENT_NAME.getName()));
      }

    } catch (Exception e) {
      return null;
    }

    return advancementList;
  }