public ArrayList<Client> readAll(){
        ArrayList<Client> lesClients=new ArrayList<>();
        try {
            Statement stmt=theConnection.createStatement();
            ResultSet resultQ=null;
            resultQ=stmt.executeQuery("SELECT * FROM client;");
            while (resultQ.next()){
                Client resultat=new Client(resultQ.getInt("id"),resultQ.getString("nom"),resultQ.getString("prenom"),resultQ.getString("mail"));
                lesClients.add(resultat);
            }
            resultQ.close();
            stmt.close();
              
        }
        catch(SQLException ex){
            System.out.println("SQLException:"+ex.getMessage());
            System.out.println("SQLState:"+ex.getSQLState());
            System.out.println("code Erreur:"+ex.getErrorCode());
        }
        return lesClients;
    }
}