|
||||||||||
前のクラス 次のクラス | フレームあり フレームなし | |||||||||
概要: 入れ子 | フィールド | コンストラクタ | メソッド | 詳細: フィールド | コンストラクタ | メソッド |
java.lang.Objectorg.sqlite.Database
public class Database
sqlite3 wrapper class.
NOTE: SQLite 3.3.5 based.
フィールドの概要 | |
---|---|
protected java.util.Properties |
info
|
コンストラクタの概要 | |
---|---|
Database(java.lang.String filename,
java.util.Properties info)
|
メソッドの概要 | |
---|---|
void |
beginTransaction(TransactionType type)
begin transaction. |
int |
changes()
invoke sqlite3_changes() function. |
void |
clearAuthorizer()
invoke sqlite3_set_authorizer() function. |
void |
clearAuthorizer(Authorizer auth)
invoke sqlite3_set_authorizer() function. |
void |
clearBusyHandler()
invoke sqlite3_set_authorizer() function. |
void |
clearBusyHandler(BusyHandler busy)
invoke sqlite3_busy_handler() function. |
void |
clearCommitHook()
invoke sqlite3_commit_hook() function. |
void |
clearCommitHook(CommitHook hook)
invoke sqlite3_commit_hook() function. |
void |
clearProgressHandler()
invoke sqlite3_progress_handler() function. |
void |
clearProgressHandler(ProgressHandler prog)
invoke sqlite3_progress_handler() function. |
void |
clearRollbackHook()
invoke sqlite3_rollback_hook() function. |
void |
clearRollbackHook(RollbackHook hook)
invoke sqlite3_rollback_hook() function. |
void |
clearUpdateHook()
invoke sqlite3_update_hook() function. |
void |
clearUpdateHook(UpdateHook hook)
invoke sqlite3_update_hook() function. |
void |
close()
invoke sqlite3_close() function. |
void |
commitTransaction()
commit toransaction. |
void |
createCollation(Collator col)
invoke sqlite3_create_collation() function. |
void |
createFunction(Function func)
invoke sqlite3_create_function() function. |
void |
disableSharedCache()
invoke sqlite3_enable_shared_cache(false) function. |
void |
dropCollation(Collator col)
invoke sqlite3_create_function() function. |
void |
dropFunction(Function func)
invoke sqlite3_create_function() function. |
void |
enableSharedCache()
invoke sqlite3_enable_shared_cache(true) function. |
int |
execute(java.lang.String sql)
invoke sqlite3_exec() function. |
protected void |
finalize()
|
boolean |
getAutoCommit()
invoke sqlite3_get_autocommit() function. |
int |
getBusyTimeout()
Retrieves the timeout(ms) value. |
ColumnMetaData |
getColumnMetaData(java.lang.String dbName,
java.lang.String tableName,
java.lang.String columnName)
invoke sqlite3_table_column_metadata() function. |
java.lang.String |
getProductName()
It always returns "SQLite". |
void |
interrupt()
invoke sqlite3_interrupt() function. |
boolean |
isClosed()
Retrieves whether this Database object has been closed. |
boolean |
isInMemoryMode()
|
boolean |
isReadOnly()
|
long |
lastInsertRowId()
invoke sqlite3_last_insert_rowid() function. |
void |
pragma(java.lang.String[] commands)
execute PRAGMA commands by sqlite3_exec() finction. |
Statement |
prepare(java.lang.String sql)
create UNMANAGED Statement instance. |
Statement |
prepare(java.lang.String sql,
SQLite3StmtPtrPtr ppStmt)
create MANAGED Statement instance. |
java.util.List<Statement> |
prepareMultiple(java.lang.String sql)
create multiple UNMANAGED Statement instance. |
void |
rollbackTransaction()
rollback transaction. |
void |
setAuthorizer(Authorizer auth)
invoke sqlite3_set_authorizer() function. |
void |
setBusyHandler(BusyHandler busy)
invoke sqlite3_busy_handler() function. |
void |
setBusyTimeout(int ms)
invoke sqlite3_busy_timeout() function. |
void |
setCommitHook(CommitHook hook)
invoke sqlite3_commit_hook() function. |
void |
setProgressHandler(ProgressHandler prog)
invoke sqlite3_progress_handler() function. |
void |
setRollbackHook(RollbackHook hook)
invoke sqlite3_rollback_hook() function. |
void |
setUpdateHook(UpdateHook hook)
invoke sqlite3_update_hook() function. |
int |
totalChanges()
invoke sqlite3_total_changes() function. |
クラス java.lang.Object から継承されたメソッド |
---|
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
フィールドの詳細 |
---|
protected final java.util.Properties info
コンストラクタの詳細 |
---|
public Database(java.lang.String filename, java.util.Properties info) throws java.sql.SQLException
java.sql.SQLException
メソッドの詳細 |
---|
public java.lang.String getProductName()
public boolean isInMemoryMode()
public boolean isReadOnly()
public boolean isClosed()
public void close() throws java.sql.SQLException
java.sql.SQLException
public boolean getAutoCommit()
public void setBusyTimeout(int ms) throws java.sql.SQLException
ms
- milliseconds
java.sql.SQLException
public int getBusyTimeout()
public int execute(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
public void pragma(java.lang.String[] commands) throws java.sql.SQLException
commands
- command list
java.sql.SQLException
public void beginTransaction(TransactionType type) throws java.sql.SQLException
type
- transaction type.
java.sql.SQLException
public void commitTransaction() throws java.sql.SQLException
java.sql.SQLException
public void rollbackTransaction() throws java.sql.SQLException
java.sql.SQLException
public Statement prepare(java.lang.String sql, SQLite3StmtPtrPtr ppStmt) throws java.sql.SQLException
sql
- ppStmt
-
java.sql.SQLException
public Statement prepare(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
public java.util.List<Statement> prepareMultiple(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
public void interrupt() throws java.sql.SQLException
java.sql.SQLException
public int changes()
public int totalChanges()
public long lastInsertRowId()
public ColumnMetaData getColumnMetaData(java.lang.String dbName, java.lang.String tableName, java.lang.String columnName) throws java.sql.SQLException
dbName
- tableName
- columnName
-
java.sql.SQLException
public void createFunction(Function func) throws java.sql.SQLException
func
- User-Defined function
java.sql.SQLException
public void dropFunction(Function func) throws java.sql.SQLException
func
- User-Defined function
java.sql.SQLException
public void createCollation(Collator col) throws java.sql.SQLException
col
- User-Defined Collating Sequences
java.sql.SQLException
public void dropCollation(Collator col) throws java.sql.SQLException
col
- User-Defined Collating Sequences
java.sql.SQLException
public void setAuthorizer(Authorizer auth) throws java.sql.SQLException
auth
-
java.sql.SQLException
public void clearAuthorizer(Authorizer auth) throws java.sql.SQLException
auth
-
java.sql.SQLException
public void clearAuthorizer() throws java.sql.SQLException
java.sql.SQLException
public void setBusyHandler(BusyHandler busy) throws java.sql.SQLException
busy
- busy handler
java.sql.SQLException
public void clearBusyHandler(BusyHandler busy) throws java.sql.SQLException
busy
- busy handler
java.sql.SQLException
public void clearBusyHandler() throws java.sql.SQLException
java.sql.SQLException
public void setProgressHandler(ProgressHandler prog)
prog
- progress handler
java.sql.SQLException
public void clearProgressHandler(ProgressHandler prog)
prog
- progress handler
java.sql.SQLException
public void clearProgressHandler()
java.sql.SQLException
public void setCommitHook(CommitHook hook)
hook
- commit hoot
java.sql.SQLException
public void clearCommitHook(CommitHook hook)
hook
- commit hoot
java.sql.SQLException
public void clearCommitHook()
java.sql.SQLException
public void setRollbackHook(RollbackHook hook)
hook
- rollback hoot
java.sql.SQLException
public void clearRollbackHook(RollbackHook hook)
hook
- rollback hoot
java.sql.SQLException
public void clearRollbackHook()
java.sql.SQLException
public void setUpdateHook(UpdateHook hook)
hook
- update hoot
java.sql.SQLException
public void clearUpdateHook(UpdateHook hook)
hook
- update hoot
java.sql.SQLException
public void clearUpdateHook()
java.sql.SQLException
public void enableSharedCache() throws java.sql.SQLException
java.sql.SQLException
public void disableSharedCache() throws java.sql.SQLException
java.sql.SQLException
protected void finalize() throws java.lang.Throwable
java.lang.Object
内の finalize
java.lang.Throwable
|
||||||||||
前のクラス 次のクラス | フレームあり フレームなし | |||||||||
概要: 入れ子 | フィールド | コンストラクタ | メソッド | 詳細: フィールド | コンストラクタ | メソッド |