public class DataSet extends Sql
Constructor and Description |
---|
DataSet(Sql sql,
java.lang.Class type) |
DataSet(Sql sql,
java.lang.String table) |
Modifier and Type | Method and Description |
---|---|
void |
add(java.util.Map values) |
DataSet |
createView(Closure criteria) |
void |
each(Closure closure) |
DataSet |
findAll(Closure where) |
java.lang.Object |
firstRow()
Returns the first row from a DataSet's underlying table
|
java.util.List |
getParameters() |
java.lang.String |
getSql() |
protected SqlOrderByVisitor |
getSqlOrderByVisitor() |
protected SqlWhereVisitor |
getSqlWhereVisitor() |
DataSet |
reverse() |
java.util.List |
rows()
Returns a List of all of the rows from the table a DataSet
represents
|
DataSet |
sort(Closure sort) |
ARRAY, asSql, BIGINT, BINARY, BIT, BLOB, BOOLEAN, call, call, call, call, call, CHAR, CLOB, close, closeResources, closeResources, commit, configure, createConnection, DATALINK, dataSet, dataSet, DATE, DECIMAL, DISTINCT, DOUBLE, eachRow, eachRow, eachRow, eachRow, execute, execute, execute, executeInsert, executeInsert, executeInsert, executeUpdate, executeUpdate, executeUpdate, expand, findWhereKeyword, firstRow, firstRow, firstRow, FLOAT, getConnection, getDataSource, getParameters, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, in, inout, INTEGER, JAVA_OBJECT, loadDriver, LONGVARBINARY, LONGVARCHAR, newInstance, newInstance, newInstance, newInstance, newInstance, newInstance, NULL, nullify, NUMERIC, OTHER, out, query, query, query, queryEach, queryEach, queryEach, REAL, REF, resultSet, rollback, rows, rows, rows, rows, setObject, setParameters, setResultSetConcurrency, setResultSetHoldability, setResultSetType, SMALLINT, STRUCT, TIME, TIMESTAMP, TINYINT, VARBINARY, VARCHAR, withStatement
public DataSet(Sql sql, java.lang.Class type)
public DataSet(Sql sql, java.lang.String table)
public void add(java.util.Map values) throws java.sql.SQLException
java.sql.SQLException
public DataSet reverse()
public void each(Closure closure) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String getSql()
public java.util.List getParameters()
protected SqlWhereVisitor getSqlWhereVisitor()
protected SqlOrderByVisitor getSqlOrderByVisitor()
public java.util.List rows() throws java.sql.SQLException
java.sql.SQLException
- if a database error occurspublic java.lang.Object firstRow() throws java.sql.SQLException
java.sql.SQLException
- if a database error occurs