groovy.sql
Class DataSet
java.lang.Object
groovy.sql.Sql
groovy.sql.DataSet
public class DataSet
- extends Sql
Represents an extent of objects
- Version:
- $Revision: 10922 $
- Author:
- Chris Stevenson, Paul King, James Strachan
Fields inherited from class groovy.sql.Sql |
ARRAY, BIGINT, BINARY, BIT, BLOB, BOOLEAN, CHAR, CLOB, DATALINK, DATE, DECIMAL, DISTINCT, DOUBLE, FLOAT, INTEGER, JAVA_OBJECT, log, LONGVARBINARY, LONGVARCHAR, NULL, NUMERIC, OTHER, REAL, REF, SMALLINT, STRUCT, TIME, TIMESTAMP, TINYINT, VARBINARY, VARCHAR |
Methods inherited from class groovy.sql.Sql |
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 |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
DataSet
public DataSet(Sql sql,
java.lang.Class type)
DataSet
public DataSet(Sql sql,
java.lang.String table)
add
public void add(java.util.Map values)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
findAll
public DataSet findAll(Closure where)
sort
public DataSet sort(Closure sort)
reverse
public DataSet reverse()
each
public void each(Closure closure)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
getSql
public java.lang.String getSql()
getParameters
public java.util.List getParameters()
getSqlWhereVisitor
protected SqlWhereVisitor getSqlWhereVisitor()
getSqlOrderByVisitor
protected SqlOrderByVisitor getSqlOrderByVisitor()
createView
public DataSet createView(Closure criteria)
rows
public java.util.List rows()
throws java.sql.SQLException
- Returns a List of all of the rows from the table a DataSet
represents
- Returns:
- Returns a list of GroovyRowResult objects from the dataset
- Throws:
java.sql.SQLException
- if a database error occurs
firstRow
public java.lang.Object firstRow()
throws java.sql.SQLException
- Returns the first row from a DataSet's underlying table
- Returns:
- Returns the first GroovyRowResult object from the dataset
- Throws:
java.sql.SQLException
- if a database error occurs