java.lang.Objectorg.objectweb.telosys.common.TelosysObject
org.objectweb.telosys.dal.dataset.SQLDataSetDefinition
Constructor Summary | |
SQLDataSetDefinition(java.lang.String sSqlSelectRequest)
SQLDataSet definition constructor for full SQL request in a single string. |
|
SQLDataSetDefinition(java.lang.String sSqlSelectRequest,
int[] paramTypes)
SQLDataSet definition 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)
SQLDataSet definition constructor. |
|
SQLDataSetDefinition(java.lang.String sSqlSelect,
java.lang.String sSqlFrom,
java.lang.String sSqlWhere,
java.lang.String sSqlOption,
int[] paramTypes)
SQLDataSet definition constructor. |
Method Summary | |
void |
alterWhere(Criteria criterias)
Change the initial SQL where clause using a criteria set 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)
|
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()
|
java.lang.String |
getSqlFrom()
|
java.lang.String |
getSqlOption()
|
java.lang.String |
getSqlSelect()
|
java.lang.String |
getSqlWhere()
|
void |
setDatabaseId(int v)
|
void |
setLinesPerPage(int v)
|
void |
setMaxRows(int v)
|
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)
public void setLinesPerPage(int v)
public void setDatabaseId(int 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
TelosysException