public Client ChercherClient(String login) {
        try {
            String sql = "SELECT * FROM User WHERE login='" + login + "' AND role='Client'";
            ResultSet rs = crud.exeRead(sql);
            Client c = new Client();
            while (rs.next()) {
               c.setLogin(rs.getString("login"));
                c.setNom(rs.getString("nom"));
                c.setPrenom(rs.getString("prenom"));
                c.setAdresse(rs.getString("adresse"));
                c.setTelephone(rs.getInt("telephone"));
                c.setDateDeNaissance(rs.getString("dateDeNaissance"));
                c.setSexe(rs.getString("sexe"));;
            }
            return c;

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