java.lang.Objectorg.objectweb.telosys.common.TelosysObject
org.objectweb.telosys.dal.dataset.SQLDataSetDefinition
The "definition" for a SQLDataSet
It contains the SQL request that will be used to load the SQLDataSet
Constructor Summary | |
SQLDataSetDefinition(java.lang.String sSqlSelectRequest)
Constructor for a full SQL request in a single string. |
|
SQLDataSetDefinition(java.lang.String sSqlSelectRequest,
int[] paramTypes)
Constructor for full SQL request in a single string, with parameters. |
|
SQLDataSetDefinition(java.lang.String sSqlSelect,
java.lang.String sSqlFrom,
java.lang.String sSqlWhere,
java.lang.String sSqlOption)
Constructor. |
|
SQLDataSetDefinition(java.lang.String sSqlSelect,
java.lang.String sSqlFrom,
java.lang.String sSqlWhere,
java.lang.String sSqlOption,
int[] paramTypes)
Constructor. |
Method Summary | |
void |
alterWhere(Criteria criterias)
Changes the initial SQL where clause using criteria to build the new WHERE clause dynamicaly NB: if the SQLDataSet definition is static, this method cannot be used ( throws a TelosysRuntimeException ) |
java.lang.Object[] |
castParameters(java.lang.String[] strParams)
Casts all the given parameters from String to the appropriate type |
int |
getDatabaseId()
|
int |
getFirstRowForPage(int iPage)
Return the first row of the given page (calculated with "lines per page") |
java.lang.String |
getFullSqlCount()
Return the full SQL request for count(*) |
java.lang.String |
getFullSqlSelect()
Return the full SQL request to retrieve data |
int |
getLastRowForPage(int iPage)
Return the last row of the given page (calculated with "lines per page") |
int |
getLinesPerPage()
|
int |
getMaxRows()
|
int |
getNbParams()
Return the number of parameters expected to execute the SQL request |
java.lang.String |
getParametersTypes()
Returns a string containing all the parameters types (to be used as a debug information) |
java.lang.String |
getSqlFrom()
|
java.lang.String |
getSqlOption()
|
java.lang.String |
getSqlSelect()
|
java.lang.String |
getSqlWhere()
|
void |
setDatabaseId(int v)
Set the id of the database to use |
void |
setLinesPerPage(int v)
Set the number of lines per page (cannot exceeded the maximum number of rows) |
void |
setMaxRows(int v)
Set the maximum number of rows |
Methods inherited from class org.objectweb.telosys.common.TelosysObject |
error, error, error, getFlagTrace, info, setFlagTrace, trace, warn |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public SQLDataSetDefinition(java.lang.String sSqlSelectRequest)
sSqlSelectRequest
- public SQLDataSetDefinition(java.lang.String sSqlSelectRequest, int[] paramTypes)
sSqlSelectRequest
- paramTypes
- public SQLDataSetDefinition(java.lang.String sSqlSelect, java.lang.String sSqlFrom, java.lang.String sSqlWhere, java.lang.String sSqlOption)
sSqlSelect
- sSqlFrom
- sSqlWhere
- sSqlOption
- public SQLDataSetDefinition(java.lang.String sSqlSelect, java.lang.String sSqlFrom, java.lang.String sSqlWhere, java.lang.String sSqlOption, int[] paramTypes)
sSqlSelect
- sSqlFrom
- sSqlWhere
- sSqlOption
- paramTypes
- Method Detail |
public void alterWhere(Criteria criterias)
criterias
- public void setMaxRows(int v)
v
- public void setLinesPerPage(int v)
v
- public void setDatabaseId(int v)
v
- public java.lang.String getSqlSelect()
public java.lang.String getSqlWhere()
public java.lang.String getSqlFrom()
public java.lang.String getSqlOption()
public int getNbParams()
public int getLinesPerPage()
public int getMaxRows()
public int getDatabaseId()
public java.lang.String getParametersTypes()
public java.lang.String getFullSqlCount()
public java.lang.String getFullSqlSelect()
public int getFirstRowForPage(int iPage)
iPage
- :
page number (from 1 to N )
public int getLastRowForPage(int iPage)
iPage
- :
page number (from 1 to N )
public java.lang.Object[] castParameters(java.lang.String[] strParams) throws TelosysException
strParams
- array of String parameters
TelosysException