docs: public List<Group> findAllGroups() {
          ArrayList<Group> allGroups = new ArrayList<Group>();
          PreparedStatement queryStatement = null;
          ResultSet results = null;
          try (Connection sqlConnection = sqlService.getConnection()) {
              queryStatement = sqlConnection.prepareStatement("SELECT * FROM "
                                                                  + Constants.DB_TABLE_GROUPS +
                                                                  " ORDER BY " + Constants.GROUPS_GROUP_NAME);
              results = queryStatement.executeQuery();
              while (results.next()) {
                  Group group = new Group();
                  group.setId(results.getInt(Constants.GENERIC_ID));
                  group.setName(results.getString(Constants.GROUPS_GROUP_NAME));
                  allGroups.add(group);
              }
          } catch (SQLException e) {
              e.printStackTrace();
          } finally {
              try {
                  if (results != null) {
                      results.close();
                  }
              } catch (Exception e) {
              }
              try {
                  if (queryStatement != null) {
                      queryStatement.close();
                  }
              } catch (Exception e) {
              }
          }
  
          return allGroups;
      }