public static List<Stock> selectStock() throws SQLException {

        String query = null;
        List<Stock> stocks = new ArrayList<Stock>();
        ResultSet resultat;
        try {

            query = "SELECT * from STOCK ";
            PreparedStatement pStatement = (PreparedStatement) ConnectionBDD.getInstance().getPreparedStatement(query);
            resultat = pStatement.executeQuery(query);

            while (resultat.next()) {
                // System.out.println(resultat.getString("PAYS"));
            Stock   stock = new Stock(resultat.getInt("ID_STOCK"),resultat.getInt("ID_ARTICLE"), resultat.getInt("STSTOCK"), resultat.getInt("STMINI"),resultat.getInt("STMAXI"), resultat.getDate("STDATEMAJ"),resultat.getFloat("STMARGE"),resultat.getFloat("STTTC"));
                stocks.add(stock);
            }

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

        }

        return stocks;

        
    }