public class DataSet extends Sql
Constructor and Description |
---|
DataSet(DataSet parent,
Closure where) |
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 SqlWhereVisitor |
getSqlVisitor() |
java.util.List |
rows()
Returns a List of all of the rows from the table a DataSet
represents
|
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, FLOAT, getConnection, getDataSource, getParameters, 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, setObject, setParameters, 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 void each(Closure closure) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String getSql()
public java.util.List getParameters()
protected SqlWhereVisitor getSqlVisitor()
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