Android Sqlite3 api调用整理

SQLiteConnection Native

nativeopen

//Opening A New Database Connection

int sqlite3_open_v2(
  const char *filename,   /* Database filename (UTF-8) */
  sqlite3 **ppDb,         /* OUT: SQLite db handle */
  int flags,              /* Flags */
  const char *zVfs        /* Name of VFS module to use */
);

//Closing A Database Connection

int sqlite3_close(sqlite3*);

//Set A Busy Timeout

int sqlite3_busy_timeout(sqlite3*, int ms);

//Memory Allocation Subsystem

void sqlite3_free(void*);

//Tracing And Profiling Functions

void *sqlite3_trace(sqlite3*,
   void(*xTrace)(void*,const char*), void*);
void *sqlite3_profile(sqlite3*,
   void(*xProfile)(void*,const char*,sqlite3_uint64), void*);

nativeClose

//Closing A Database Connection

int sqlite3_close(sqlite3*);

nativeFinalizeStatement

//Destroy A Prepared Statement Object

int sqlite3_finalize(sqlite3_stmt *pStmt);

nativeGetParameterCount

//Number Of SQL Parameters

int sqlite3_bind_parameter_count(sqlite3_stmt*);

nativeIsReadOnly

//Determine If An SQL Statement Writes The Database

int sqlite3_stmt_readonly(sqlite3_stmt *pStmt);

nativeGetColumnCount

//Number Of Columns In A Result Set

int sqlite3_column_count(sqlite3_stmt *pStmt);

//Binding Values To Prepared Statements

nativeBindNull

int sqlite3_bind_null(sqlite3_stmt*, int);

nativeBindLong

int sqlite3_bind_int64(sqlite3_stmt*, int, sqlite3_int64);

nativeBindDouble

int sqlite3_bind_double(sqlite3_stmt*, int, double);

nativeBindString

int sqlite3_bind_text16(sqlite3_stmt*, int, const void*, int, void(*)(void*));

nativeBindBlob

int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void(*)(void*));

nativeResetStatementAndClearBindings

//Reset A Prepared Statement Object

int sqlite3_reset(sqlite3_stmt *pStmt);

//Reset All Bindings On A Prepared Statement

int sqlite3_clear_bindings(sqlite3_stmt*);

executeNonQuery

executeOneRowQuery

nativeExecuteForLastInsertedRowId

//Evaluate An SQL Statement

int sqlite3_step(sqlite3_stmt*);

nativeExecuteForCursorWindow

//Number Of Columns In A Result Set

int sqlite3_column_count(sqlite3_stmt *pStmt);

//Evaluate An SQL Statement

int sqlite3_step(sqlite3_stmt*);

//Reset A Prepared Statement Object

int sqlite3_reset(sqlite3_stmt *pStmt);

nativeGetDbLookaside

//Database Connection Status

int sqlite3_db_status(sqlite3*, int op, int *pCur, int *pHiwtr, int resetFlg);

nativeResetCancel

//Query Progress Callbacks

void sqlite3_progress_handler(sqlite3*, int, int(*)(void*), void*);

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容