public static String[] getAllSchoolName(BaseSetting bs) {

        if (bs == null) {
            System.out.println("school - BS NULL");
        } else {

            //On initialise la liste des écoles
            ArrayList<String> list = new ArrayList<>();
            try {
                //

                //Si la connexion à la base est correcte
                if (bs.testerConnexion()) {
                    
                    //SQL
                    String query = "SELECT name_sch from School";
                    bs.setStatement(bs.getConnection().createStatement());
                    bs.setResult_set(bs.getStatement().executeQuery(query));

                    //Parcours des résultats
                    while (bs.getResult_set().next()) {
                        list.add(bs.getResult_set().getString("name_sch"));
                    }
                    
                    //Mise sous la forme d'un tableau
                    String res[] = new String[list.size()];

                    //Remplissage
                    for (int i = 0; i < list.size(); i++) {
                        res[i] = list.get(i);
                    }

                    return res;
                }

            } catch (SQLException ex) {
                Logger.getLogger(Manipulation.class.getName()).log(Level.SEVERE, null, ex);
            }
        }

        return null;
    }