| java.lang.Object
 com.caucho.db.sql.Query
All known Subclasses: com.caucho.db.sql.DeleteQuery, com.caucho.db.sql.UpdateQuery, com.caucho.db.sql.SelectQuery, com.caucho.db.sql.CreateQuery, com.caucho.db.sql.TempQuery, com.caucho.db.sql.InsertQuery, com.caucho.db.sql.DropQuery,
| Query | | abstract public class Query (Code) | | |
| Method Summary | |
| protected void | bind()
Binds the query. | | protected Expr | bind(String tableName, String columnName)
Returns a bound expression for the specified table.column. | | public void | clearParameters()
Clears the paramters. | | abstract public void | execute(QueryContext queryCtx, Transaction xa)
Executes the query. | | protected void | freeRows(TableIterator[] rows, int rowLength)
Frees any blocks for the rows. | | protected void | generateWhere(Expr whereExpr)
Optimize the where and order the from items. | | public int | getDataFields()
Returns the number of temporary data fields. | | public Database | getDatabase()
Returns the owning database. | | public FromItem[] | getFromItems()
Returns any from items. | | public ArrayList<SubSelectParamExpr> | getParamExprs()
Returns the param exprs. | | public Query | getParent()
| | String | getSQL()
Returns the SQL. | | public SubSelectExpr | getSubSelect()
Gets the parent sub-select. | | public Expr[] | getWhereExprs()
| | public boolean | isGroup()
| | public boolean | isReadOnly()
| | public boolean | isSelect()
Returns true for select queries. | | protected boolean | nextTuple(TableIterator[] rows, int rowLength, QueryContext queryContext, Transaction xa)
Returns the next tuple from the query. | | public void | setBinaryStream(int index, InputStream is, int length)
| | public void | setBoolean(int index, boolean value)
Sets the indexed parameter as a boolean. | | public void | setDataFields(int fieldCount)
Sets the number of temporary data fields. | | public void | setDate(int index, long value)
Sets the indexed parameter as a date value. | | public void | setDouble(int index, double value)
Sets the indexed parameter as a double. | | protected void | setFromItems(FromItem[] fromItems)
Sets from items. | | protected void | setFromItems(ArrayList<FromItem> fromItems)
Sets from items. | | public void | setGroup(boolean isGroup)
Sets the current number of group fields. | | public void | setLimit(int limit)
| | public void | setLong(int index, long value)
Sets the indexed parameter as a long. | | public void | setParams(ParamExpr[] params)
Sets the params. | | public void | setParent(Query query)
| | public void | setString(int index, String value)
Sets the indexed parameter as a string. | | public void | setSubSelect(SubSelectExpr subSelect)
Sets the parent sub-select. | | public void | setWhereExpr(Expr expr)
Sets the where expr. | | protected void | setWhereExprs(Expr[] whereExprs)
Sets the where exprs. | | protected boolean | start(TableIterator[] rows, int rowLength, QueryContext queryContext, Transaction xa)
Starts the query. |
| clearParameters | | public void clearParameters()(Code) | | Clears the paramters.
|
| freeRows | | protected void freeRows(TableIterator[] rows, int rowLength)(Code) | | Frees any blocks for the rows.
|
| generateWhere | | protected void generateWhere(Expr whereExpr) throws SQLException(Code) | | Optimize the where and order the from items.
|
| getDataFields | | public int getDataFields()(Code) | | Returns the number of temporary data fields.
|
| getDatabase | | public Database getDatabase()(Code) | | Returns the owning database.
|
| getFromItems | | public FromItem[] getFromItems()(Code) | | Returns any from items.
|
| getParent | | public Query getParent()(Code) | | Gets the parent query
|
| getWhereExprs | | public Expr[] getWhereExprs()(Code) | | Returns the where exprs
|
| isGroup | | public boolean isGroup()(Code) | | Sets true for group operations
|
| isReadOnly | | public boolean isReadOnly()(Code) | | |
| isSelect | | public boolean isSelect()(Code) | | Returns true for select queries.
|
| setBinaryStream | | public void setBinaryStream(int index, InputStream is, int length)(Code) | | Sets the indexed parameter as a binary stream
|
| setBoolean | | public void setBoolean(int index, boolean value)(Code) | | Sets the indexed parameter as a boolean.
|
| setDataFields | | public void setDataFields(int fieldCount)(Code) | | Sets the number of temporary data fields.
|
| setDate | | public void setDate(int index, long value)(Code) | | Sets the indexed parameter as a date value.
|
| setDouble | | public void setDouble(int index, double value)(Code) | | Sets the indexed parameter as a double.
|
| setFromItems | | protected void setFromItems(FromItem[] fromItems)(Code) | | Sets from items.
|
| setGroup | | public void setGroup(boolean isGroup)(Code) | | Sets the current number of group fields.
|
| setLimit | | public void setLimit(int limit)(Code) | | Sets the maximum entires
|
| setLong | | public void setLong(int index, long value)(Code) | | Sets the indexed parameter as a long.
|
| setParent | | public void setParent(Query query)(Code) | | Sets the parent query
|
| setString | | public void setString(int index, String value)(Code) | | Sets the indexed parameter as a string.
|
| setSubSelect | | public void setSubSelect(SubSelectExpr subSelect)(Code) | | Sets the parent sub-select.
|
| setWhereExpr | | public void setWhereExpr(Expr expr)(Code) | | Sets the where expr.
|
| setWhereExprs | | protected void setWhereExprs(Expr[] whereExprs)(Code) | | Sets the where exprs.
|
|
|