typedef结构sqlite3 sqlite3; int sqlite3_open(常量字符*,sqlite3**); int sqlite3_open16(const void*,sqlite3**); int sqlite3_close(sqlite3*); const char*sqlite3_errmsg(sqlite3*); const void*sqlite3_errmsg16(sqlite3*); int sqlite3_errcode(sqlite3*);
#定义SQLITE_OK 0/*成功结果*/ #定义SQLITE_ERROR 1/*SQL错误或缺少数据库*/ #define SQLITE_INTERNAL 2/*SQLITE中的内部逻辑错误*/ #define SQLITE_PERM 3/*拒绝访问权限*/ #define SQLITE_ABORT 4/*回调例程请求中止*/ #define SQLITE_BUSY 5/*数据库文件被锁定*/ #define SQLITE_LOCKED 6/*数据库中的表被锁定*/ #define SQLITE_NOMEM 7/*malloc()失败*/ #define SQLITE_READONLY 8/*尝试写入只读数据库*/ #define SQLITE_INTERRUPT 9/*操作被SQLITE_INTERRUPT()终止*/ #define SQLITE_IOERR 10/*发生了某种磁盘I/O错误*/ #define SQLITE_CORRUPT 11/*数据库磁盘映像格式错误*/ #define SQLITE_NOTFOUND 12/*(仅限内部)找不到表或记录*/ #define SQLITE_FULL 13/*由于数据库已满,插入失败*/ #define SQLITE_CANTOPEN 14/*无法打开数据库文件*/ #define SQLITE_PROTOCOL 15/*数据库锁定协议错误*/ #define SQLITE_EMPTY 16/*(仅限内部)数据库表为空*/ #define SQLITE_SCHEMA 17/*数据库模式已更改*/ #define SQLITE_TOOBIG 18/*表的一行数据太多*/ #define SQLITE_CONSTRAINT 19/*由于违反约束而中止*/ #define SQLITE_MISMATCH 20/*数据类型不匹配*/ #定义SQLITE_MISUSE 21/*库使用不正确*/ #define SQLITE_NOLFS 22/*使用主机上不支持的操作系统功能*/ #define SQLITE_AUTH 23/*授权被拒绝*/ #define SQLITE_ROW 100/*SQLITE_step()有另一行就绪*/ #define SQLITE_DONE 101/*SQLITE_step()已完成执行*/
typedef int(*sqlite_callback)(void*,int,char**,char**); int sqlite3_exec(sqlite3*,const char*sql,sqlite_callback,void*,char**);
typedef结构sqlite3_stmt sqlite3_stmt; int sqlite3_prepare(sqlite3*,常量字符*,int,sqlite3_stmt**,常量字符**); int sqlite3_prepare16(sqlite3*,const void*,int,sqlite3_stmt**,const void**); int sqlite3_finalize(sqlite3_stmt*); int sqlite3_reset(sqlite3_stmt*);
int sqlite3_bind_blob(sqlite3_stmt*,int,const void*,int n,void(*)(void*)); int sqlite3_bind_double(sqlite3_stmt*,int,double); int sqlite3_bind_int(sqlite3_stmt*,int,int); int sqlite3_bind_int64(sqlite3_stmt*,int,long long int); int sqlite3_bind_null(sqlite3_stmt*,int); int sqlite3_bind_text(sqlite3_stmt*,int,const char*,int n,void(*)(void*)); int sqlite3_bind_text16(sqlite3_stmt*,int,const void*,int n,void(*)(void*)); int sqlite3_bind_value(sqlite3_stmt*,int,const sqlite3_ value*);
int sqlite3_step(sqlite3_stmt*);
const void*sqlite3_column_blob(sqlite3_stmt*,int iCol); int sqlite3_column_bytes(sqlite3_stmt*,int iCol); int sqlite3_column_bytes16(sqlite3_stmt*,int iCol); int sqlite3_column_count(sqlite3_stmt*); const char*sqlite3_column_decltype(sqlite3_stmt*,int iCol); const void*sqlite3_column_decltype16(sqlite3_stmt*,int iCol); 双sqlite3_column_double(sqlite3_stmt*,int iCol); int sqlite3_column_int(sqlite3_stmt*,int iCol); long long int sqlite3_column_int64(sqlite3_stmt*,int iCol); const char*sqlite3_column_name(sqlite3_stmt*,int iCol); const void*sqlite3_column_name16(sqlite3_stmt*,int iCol); const unsigned char*sqlite3_column_text(sqlite3_stmt*,int iCol); const void*sqlite3_column_text16(sqlite3_stmt*,int iCol); int sqlite3_column_type(sqlite3_stmt*,int iCol);
#定义SQLITE_INTEGER 1 #定义SQLITE_FLOAT 2 #定义SQLITE_TEXT 3 #定义SQLITE_BLOB 4 #定义SQLITE_NULL 5
typedef结构sqlite3_value sqlite3_值; int sqlite3_create_function( 方形3*, const char*zFunctionName, int n阿尔格, int eTextRep, 无效*, void(*xFunc)(sqlite3_context*,int,sqlite3_value**), void(*xStep)(sqlite3_context*,int,sqlite3_value**), 无效(*xFinal)(sqlite3_context*) ); int sqlite3_create_function16( 方形3*, const void*zFunctionName, int nArg中, int eTextRep, 无效*, void(*xFunc)(sqlite3_context*,int,sqlite3_value**), void(*xStep)(sqlite3_context*,int,sqlite3_value**), 无效(*xFinal)(sqlite3_context*) ); #定义SQLITE_UTF8 1 #定义SQLITE_UTF16 2 #定义SQLITE_UTF16BE 3 #定义SQLITE_UTF16LE 4 #定义SQLITE_ANY 5
const void*sqlite3_value_blob(sqlite3_ value*); int sqlite3_value_bytes(sqlite3_value*); int sqlite3_value_bytes16(sqlite3_ value*); 双sqlite3_value_double(sqlite3~value*); int sqlite3_value_int(sqlite3_值*); long long int sqlite3_value_int64(sqlite3_ value*); const unsigned char*sqlite3_value_text(sqlite3_value*); const void*sqlite3_value_text16(sqlite3_值*); int sqlite3_value_type(sqlite3_值*);
void*sqlite3_aggregate_context(sqlite3_context*,int nbyte); 无效*sqlite3_user_data(sqlite3_context*); void sqlite3_result_blob(sqlite3_context*,const void*,int n,void(*)(void*)); 无效sqlite3_result_double(sqlite3_context*,double); void sqlite3_result_error(sqlite3_context*,const char*,int); void sqlite3_result_error16(sqlite3_context*,const void*,int); 无效sqlite3_result_int(sqlite3_context*,int); void sqlite3_result_int64(sqlite3_context*,long long int); 无效sqlite3_result_null(sqlite3_context*); void sqlite3_result_text(sqlite3_context*,const char*,int n,void(*)(void*)); void sqlite3_result_text16(sqlite3_context*,const void*,int n,void(*)(void*)); 无效sqlite3_result_value(sqlite3_context*,sqlite3_ value*); void*sqlite3_get_auxdata(sqlite3_context*,int); void sqlite3_set_auxdata(sqlite3_context*,int,void*,void(*)(void*));
sqlite3_create_collation(sqlite3*,const char*zName,int eTextRep,void*, int(*xCompare)(void*,int,const void*); sqlite3_create_collation16(sqlite3*,const void*zName,int eTextRep,void*, int(*xCompare)(void*,int,const void*); sqlite3_collation_needed(sqlite3*,void*, void(*)(void*,sqlite3*,int eTextRep,const char*); sqlite3_collation_needed16(sqlite3*,void*, void(*)(void*,sqlite3*,int eTextRep,const void*);