public static void MAJCoordonnees() throws IOException {
   compteur = 0;
   DatabaseConnect BDD = new DatabaseConnect();
   BDD.Connexion();
   BDD.ViderTable("tb_stopscoordon");
   fis = new FileInputStream("res/coordonnees.csv");
   br = new BufferedReader(new InputStreamReader(fis, Charset.forName("UTF-8")));
   System.out.println(
       "Mise a jour de la table <tb_stopscoordon> en cours...\nVeuillez patienter...");
   while ((line = br.readLine()) != null) {
     String array[] = pattern.split(line, 0);
     if (array.length == 3) {
       try {
         BDD.Ajouter(
             "INSERT INTO tb_stopscoordon VALUES ("
                 + array[0]
                 + ","
                 + array[1]
                 + ","
                 + array[2]
                 + ")");
         compteur++;
       } catch (Exception err) {
       }
     }
   }
   System.out.println("Mise a jour terminee.\n" + compteur + " lignes ont ete ajoutees.");
   BDD.Deconnexion();
 }
  public static void readStops(String requete) throws IOException, SQLException {
    DatabaseConnect connexion = new DatabaseConnect();
    connexion.Connexion();
    Arret arr;
    arrs.clear();

    ResultSet test = connexion.Rechercher(requete);

    while (test.next()) {
      arr =
          new Arret(
              test.getString("stop_id"), test.getString("stop_name"), test.getString("stop_type"));
      arrs.put(Integer.valueOf(test.getString("stop_id")), arr);
    }
    connexion.Deconnexion();
  }
  public static void readStations(String requete) throws IOException, SQLException {
    DatabaseConnect connexion = new DatabaseConnect();
    connexion.Connexion();
    Station sta;
    stat.clear();

    ResultSet test = connexion.Rechercher(requete);

    while (test.next()) {
      sta =
          new Station(
              test.getString("parent_id"),
              test.getString("stop_type"),
              test.getString("stop_name"));
      stat.put(Integer.valueOf(test.getString("parent_id")), sta);
    }
    connexion.Deconnexion();
  }