SQLite
public class Stmt extends Object
Field Summary | |
---|---|
protected int | error_code
Internal last error code for prepare()/step() methods. |
long | handle
Internal handle for the SQLite3 statement. |
Method Summary | |
---|---|
void | bind(int pos, int value)
Bind positional integer value to compiled SQLite3 statement. |
void | bind(int pos, long value)
Bind positional long value to compiled SQLite3 statement. |
void | bind(int pos, double value)
Bind positional double value to compiled SQLite3 statement. |
void | bind(int pos, byte[] value)
Bind positional byte array to compiled SQLite3 statement. |
void | bind(int pos, String value)
Bind positional String to compiled SQLite3 statement. |
void | bind(int pos)
Bind positional SQL null to compiled SQLite3 statement. |
int | bind_parameter_count()
Return number of parameters in compiled SQLite3 statement. |
int | bind_parameter_index(String name)
Return index of named parameter in compiled SQLite3 statement. |
String | bind_parameter_name(int pos)
Return name of parameter in compiled SQLite3 statement. |
void | bind_zeroblob(int pos, int length)
Bind positional zero'ed blob to compiled SQLite3 statement. |
void | clear_bindings()
Clear all bound parameters of the compiled SQLite3 statement. |
void | close()
Close the compiled SQLite3 statement. |
Object | column(int col)
Retrieve column data as object from exec'ed SQLite3 statement. |
byte[] | column_bytes(int col)
Retrieve blob column from exec'ed SQLite3 statement. |
int | column_count()
Retrieve number of columns of exec'ed SQLite3 statement. |
String | column_database_name(int col)
Return database name of column of SQLite3 statement. |
String | column_decltype(int col)
Return declared column type of SQLite3 statement. |
double | column_double(int col)
Retrieve double column from exec'ed SQLite3 statement. |
int | column_int(int col)
Retrieve integer column from exec'ed SQLite3 statement. |
long | column_long(int col)
Retrieve long column from exec'ed SQLite3 statement. |
String | column_origin_name(int col)
Return origin column name of column of SQLite3 statement. |
String | column_string(int col)
Retrieve string column from exec'ed SQLite3 statement. |
String | column_table_name(int col)
Return table name of column of SQLite3 statement. |
int | column_type(int col)
Retrieve column type from exec'ed SQLite3 statement. |
protected void | finalize()
Destructor for object. |
static void | internal_init()
Internal native initializer. |
boolean | prepare()
Prepare the next SQL statement for the Stmt instance. |
void | reset()
Reset the compiled SQLite3 statement without
clearing parameter bindings. |
boolean | step()
Perform one step of compiled SQLite3 statement.
|
Parameters: pos parameter index, 1-based value value of parameter
Parameters: pos parameter index, 1-based value value of parameter
Parameters: pos parameter index, 1-based value value of parameter
Parameters: pos parameter index, 1-based value value of parameter, may be null
Parameters: pos parameter index, 1-based value value of parameter, may be null
Parameters: pos parameter index, 1-based
Returns: int number of parameters
Parameters: name of parameter
Returns: int index of parameter, 1-based
Parameters: pos parameter index, 1-based
Returns: String parameter name
Parameters: pos parameter index, 1-based length byte size of zero blob
Parameters: col column number, 0-based
Returns: Object or null
Parameters: col column number, 0-based
Returns: byte[] column value
Returns: int number of columns
Parameters: col column number, 0-based
Returns: String or null
Parameters: col column number, 0-based
Returns: String or null
Parameters: col column number, 0-based
Returns: double column value
Parameters: col column number, 0-based
Returns: int column value
Parameters: col column number, 0-based
Returns: long column value
Parameters: col column number, 0-based
Returns: String or null
Parameters: col column number, 0-based
Returns: String column value
Parameters: col column number, 0-based
Returns: String or null
Parameters: col column number, 0-based
Returns: column type code, e.g. SQLite.Constants.SQLITE_INTEGER
Returns: true when the next piece of the SQL statement sequence has been prepared, false on end of statement sequence.
... try { Stmt s = db.prepare("select * from x; select * from y;"); s.bind(...); ... s.bind(...); while (s.step(cb)) { Object o = s.value(...); ... } // s.reset() for re-execution or // s.prepare() for the next piece of SQL while (s.prepare()) { s.bind(...); ... s.bind(...); while (s.step(cb)) { Object o = s.value(...); ... } } } catch (SQLite.Exception e) { s.close(); }
Returns: true when row data is available, false on end of result set.