Name | Arguments | Description |
---|---|---|
close | Closes this prepared statement. | |
dumpResult | fileName limit promptSegment | Dumps the whole result or up to limit rows into a tableDump file. If fileName is not specified, use the table name (of the first column) suffixed with ".tdmp". The optional promptSegment is an integer such as 100; if specified, whenever every so many rows are saved to the file, a dot indicator is printed to system out. This is a helpful hint for large table dumping which can take a long while. |
getColumnAttributes getColumnAttrs | Returns the column attributes for this query as an instance of TableData. | |
getPreparedStatement |
Returns the prepared statement (an instance of java.sql.PreparedStatement )
for this query.
| |
getResult | limit | This is a convenience method that returns the whole result or up to limit, if specified; the result is either an array if the result has only one column, or a TableData if multiple columns are selected. |
getResultSet |
Returns the result set (an instance of java.sql.ResultSet )
of the last query run.
| |
getResultSetMetaData |
Returns the meta data for the result set (an instance of java.sql.ResultSet )
of the last query run.
| |
getResultSetType | Returns the result set type, which is one of these: "forward_only", "scroll_insensitive" or "scroll_sensitive". | |
getSQL | Returns the SQL statement for this query. | |
hasResult | Returns true if the last run has results. | |
next | Returns true if the result still has rows, and moves the result set pointer to the next row. Valied only after a run. |