public static void insertAllDepartements(Vector<Departement> departements) {
  try {
    Connection conn = createConnection();
    Statement stat = conn.createStatement();
    stat.executeUpdate("DELETE FROM departements;");  
    PreparedStatement prep = conn.prepareStatement("INSERT INTO departements VALUES (?, ?, ?);");
			
    for (int i=0; i<departements.size(); i++) {
      prep.setInt(1, departements.get(i).getNumero());
      prep.setString(2, departements.get(i).getTitre());
      int actif;
      if (departements.get(i).getActif()==true) actif = 1;
        else actif = 0;
      prep.setInt(3, actif);
      prep.addBatch();
    }	
    conn.setAutoCommit(false);
    prep.executeBatch();
    conn.setAutoCommit(true);
    conn.close();
  }
  catch ( Exception e) { 
    e.printStackTrace();
  }
}