Package | Description |
---|---|
jsqlite |
Modifier and Type | Method and Description |
---|---|
protected void |
Backup._finalize() |
void |
Backup.backup()
Perform the backup in one step.
|
Backup |
Database.backup(Database dest,
String destName,
String srcName)
Initiate a database backup, SQLite 3.x only.
|
int |
Stmt.bind_parameter_count()
Return number of parameters in compiled SQLite3 statement.
|
int |
Stmt.bind_parameter_index(String name)
Return index of named parameter in compiled SQLite3 statement.
|
String |
Stmt.bind_parameter_name(int pos)
Return name of parameter in compiled SQLite3 statement.
|
void |
Stmt.bind_zeroblob(int pos,
int length)
Bind positional zero'ed blob to compiled SQLite3 statement.
|
void |
Stmt.bind(int pos)
Bind positional SQL null to compiled SQLite3 statement.
|
void |
Stmt.bind(int pos,
byte[] value)
Bind positional byte array to compiled SQLite3 statement.
|
void |
Stmt.bind(int pos,
double value)
Bind positional double value to compiled SQLite3 statement.
|
void |
Stmt.bind(int pos,
int value)
Bind positional integer value to compiled SQLite3 statement.
|
void |
Stmt.bind(int pos,
long value)
Bind positional long value to compiled SQLite3 statement.
|
void |
Stmt.bind(int pos,
String value)
Bind positional String to compiled SQLite3 statement.
|
void |
Stmt.clear_bindings()
Clear all bound parameters of the compiled SQLite3 statement.
|
void |
Stmt.close()
Close the compiled SQLite3 statement.
|
void |
Database.close()
Close the underlying SQLite database file.
|
byte[] |
Stmt.column_bytes(int col)
Retrieve blob column from exec'ed SQLite3 statement.
|
int |
Stmt.column_count()
Retrieve number of columns of exec'ed SQLite3 statement.
|
String |
Stmt.column_database_name(int col)
Return database name of column of SQLite3 statement.
|
String |
Stmt.column_decltype(int col)
Return declared column type of SQLite3 statement.
|
double |
Stmt.column_double(int col)
Retrieve double column from exec'ed SQLite3 statement.
|
int |
Stmt.column_int(int col)
Retrieve integer column from exec'ed SQLite3 statement.
|
long |
Stmt.column_long(int col)
Retrieve long column from exec'ed SQLite3 statement.
|
String |
Stmt.column_origin_name(int col)
Return origin column name of column of SQLite3 statement.
|
String |
Stmt.column_string(int col)
Retrieve string column from exec'ed SQLite3 statement.
|
String |
Stmt.column_table_name(int col)
Return table name of column of SQLite3 statement.
|
int |
Stmt.column_type(int col)
Retrieve column type from exec'ed SQLite3 statement.
|
Object |
Stmt.column(int col)
Retrieve column data as object from exec'ed SQLite3 statement.
|
boolean |
Vm.compile()
Compile the next SQL statement for the SQLite VM instance.
|
Vm |
Database.compile(String sql)
Compile and return SQLite VM for SQL statement.
|
Vm |
Database.compile(String sql,
String[] args)
Compile and return SQLite VM for SQL statement.
|
void |
SQLDump.dump() |
void |
Database.exec(String sql,
Callback cb)
Execute an SQL statement and invoke callback methods
for each row of the result set.
|
void |
Database.exec(String sql,
Callback cb,
String[] args)
Execute an SQL statement and invoke callback methods
for each row of the result set.
|
protected void |
Backup.finish()
Finish a backup.
|
TableResult |
Database.get_table(String sql)
Convenience method to retrieve an entire result
set into memory.
|
TableResult |
Database.get_table(String sql,
int maxrows)
Convenience method to retrieve an entire result
set into memory.
|
TableResult |
Database.get_table(String sql,
int maxrows,
String[] args)
Convenience method to retrieve an entire result
set into memory.
|
TableResult |
Database.get_table(String sql,
String[] args)
Convenience method to retrieve an entire result
set into memory.
|
void |
Database.get_table(String sql,
String[] args,
TableResult tbl)
Convenience method to retrieve an entire result
set into memory.
|
void |
Database.key(byte[] ekey)
Specify key for encrypted database.
|
void |
Database.key(String skey)
Specify key for encrypted database.
|
static long |
Database.long_from_julian(String s)
Make long value from julian date for java.lang.Date
|
void |
Database.open_aux_file(String filename)
Open SQLite auxiliary database file for temporary
tables.
|
Blob |
Database.open_blob(String db,
String table,
String column,
long row,
boolean rw)
Open an SQLite3 blob.
|
void |
Database.open(String filename,
int mode)
Open an SQLite database file.
|
void |
Database.open(String filename,
int mode,
String vfs)
Open an SQLite database file.
|
void |
Database.open(String filename,
int mode,
String vfs,
boolean ver2)
Open an SQLite database file.
|
int |
Backup.pagecount()
Return the total number of pages in the backup source database.
|
boolean |
Stmt.prepare()
Prepare the next SQL statement for the Stmt instance.
|
Stmt |
Database.prepare(String sql)
Prepare and return SQLite3 statement for SQL.
|
void |
Database.rekey(byte[] ekey)
Change the key of a encrypted database.
|
void |
Database.rekey(String skey)
Change the key of a encrypted database.
|
int |
Backup.remaining()
Return number of remaining pages to be backed up.
|
void |
Stmt.reset()
Reset the compiled SQLite3 statement without
clearing parameter bindings.
|
void |
SQLRestore.restore() |
void |
Database.set_encoding(String enc)
Set character encoding.
|
boolean |
Stmt.step()
Perform one step of compiled SQLite3 statement.
|
boolean |
Vm.step(Callback cb)
Perform one step on compiled SQLite VM.
|
boolean |
Backup.step(int n)
Perform a backup step.
|
void |
Vm.stop()
Abort the compiled SQLite VM.
|
Copyright © 2014. All rights reserved.