Overview | Package | Class | Tree | Deprecated | Index | Help
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES

## Package com.tonbeller.jpivot.param

Implements Session Parameters.

See:
Description

Interface Summary
ParameterProvider | creates a list of SessionParameter from a member.
SqlAccess | provides information about members that may be used in (drill-thru) SQL queries

Class Summary
AbstractParamProvider |
MemberParamProvider | creates a SessionParam from a member
PropertyParamProvider | creates a SessionParam from a member property
PropertyPrefixParamProvider | Default implementation for ParameterProvider.
SetParameterTag | looks for a http parameter with a certain name.

## Package com.tonbeller.jpivot.param Description

Implements Session Parameters.

A SessionParam is a parameter that can modify MDX and SQL queries. The parameters are held in a SessionParamPool. There is one pool per HttpSession.

SessionParam may be created in several ways:

- by some application logic. For example at login-time there may be some parameters that restrict the data a user is allowed to see
- by clicking on a member in the JPivot table `ClickableMemberTag`
- by clicking on a hyperlink `com.tonbeller.jpivot.param.ParamLinkTag`

Parameters may be used in sql queries. Example for JSTL's sql tag:

    <jsp:useBean id="paramPool" class="com.tonbeller.jpivot.param.SessionParamPool" scope="session"/>

    <sql:query var="result" dataSource="${myDataSource}">
      SELECT ...
      FROM ...
      WHERE CUSTOMERID = ?
      <sql:param value="${paramPool.CUSTOMERID.sqlValue}"/>
    </sql:query>

Overview | Package | Class | Tree | Deprecated | Index | Help
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES