public static List<Entreprise> selectEntreprise()  throws SQLException {
      
        String query = null;
        List<Entreprise> entreprise = new ArrayList<Entreprise>();
        ResultSet resultat;
        try {
           
            query = "SELECT * from ENTREPRISE order by ENTNOM";
            PreparedStatement pStatement = (PreparedStatement) ConnectionBDD.getInstance().getPreparedStatement(query);
            resultat = pStatement.executeQuery(query);

            while (resultat.next()) {
               // System.out.println(resultat.getString("PAYS"));
                 Entreprise  ee =  new Entreprise(resultat.getInt("ID_ENTREPRISE"),resultat.getInt("ID_VILLE"), resultat.getString("ENTNOM"), resultat.getString("ENTADRESSE1"), resultat.getString("ENTADRESSE2"));
                entreprise.add(ee);
            }

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

        }
        
        return entreprise;

        
    }