public static List<ActionType> selectActionType() throws SQLException {

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

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

            while (resultat.next()) {
                
                ActionType ac = new ActionType(resultat.getInt("ID_ACTION_TYPE"), resultat.getString("TYP_LIB"));
                Action.add(ac);
            }

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

        }
        return Action;
    }