java.lang.Objectorg.objectweb.telosys.common.TelosysObject
org.objectweb.telosys.common.data.DataSet
org.objectweb.telosys.common.data.UpdatableDataSet
org.objectweb.telosys.dal.dataset.SQLDataSet
DataSet designed to be loaded with a SQL request
Constructor Summary | |
SQLDataSet(SQLDataSetDefinition def)
Creates a new SQLDataSet using the given definition |
|
SQLDataSet(SQLDataSetDefinition def,
Criteria crit)
Creates a new SQLDataSet using the given definition and the given dynamic criterias |
|
SQLDataSet(SQLDataSetDefinition def,
java.lang.String[] paramValues)
Creates a new SQLDataSet using the given definition and the given parameters values |
Method Summary | |
int |
count()
Returns the number of lines corresponding to the WHERE parameters (just count with SELECT COUNT, the lines are not loaded in the DataSet) |
boolean |
endOfResultSet()
Indicates if the last line of the ResultSet is loaded in the DataSet This method is significant only after a load() or loadPage() |
java.lang.String |
getSqlRequest()
Returns the SQL request used to load the DataSet |
int |
load()
Loads the DataSet using its definition |
int |
load(java.lang.Object obj)
Loads the DataSet using its definition and the given object |
int |
loadPage(int iPage)
Load a given page (set of rows) using the LinesPerPage parameter of the definition IE : with 10 lines per page ... |
Methods inherited from class org.objectweb.telosys.common.data.UpdatableDataSet |
addRow, addRow, replaceObject, replaceRow |
Methods inherited from class org.objectweb.telosys.common.data.DataSet |
getBoolean, getByte, getDataRow, getDate, getDouble, getFloat, getInt, getLong, getObject, getRowCount, getShort, getSortColumn, getSqlDate, getString, getString, initBeforeLoad, isEmpty, isSortedBy, isSortedInAscendingOrder, isSortedInDescendingOrder, iterator, sort, sort, sortIgnoreCase, sortIgnoreCase |
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 SQLDataSet(SQLDataSetDefinition def) throws TelosysException
def
- the DataSet definition without parameter
TelosysException
public SQLDataSet(SQLDataSetDefinition def, java.lang.String[] paramValues) throws TelosysException
def
- the DataSet definition with parametersparamValues
- array of parameters values
TelosysException
public SQLDataSet(SQLDataSetDefinition def, Criteria crit) throws TelosysException
def
- the DataSet definition without parametercrit
- the dynamic criterias
TelosysException
Method Detail |
public java.lang.String getSqlRequest()
public int load() throws TelosysException
DataSet
load
in class DataSet
TelosysException
public int load(java.lang.Object obj) throws TelosysException
DataSet
load
in class DataSet
obj
- useful parameter for the load operation ( cannot be null )TelosysException
public int loadPage(int iPage) throws TelosysException
iPage
- the page number (from 1 to N)
TelosysException
- ( if the page number is < 0 )public boolean endOfResultSet()
public int count() throws TelosysException
TelosysException