public static ActionType SelectActionComById(int id) throws SQLException {
        String query ="";
        ActionType Action = new ActionType();
        ResultSet resultat;

        try {
            query = "SELECT * from ACTION_TYPE  where ID_ACTION_TYPE=? ";
            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, id);
            resultat = pStatement.executeQuery();
            while (resultat.next()) {
               
                 Action = new ActionType(resultat.getInt("ID_ACTION_TYPE"),resultat.getString("TYP_LIB"));
            }

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

        }
        return Action;
    }