SQLite 3.7.13的加密解密（六）―― 使用方法

#include <stdio.h>

#include <stdlib.h>

#include "sqlite3.h"

#define sqlite3_STATIC

extern int sqlite3_key(sqlite3 *db,const voID *pKey,int nKey);

static int _callback_exec(voID * notused,int argc,char ** argv,char ** aszColname)

{

int i;

for ( i=0; i<argc; i++ )

{

printf( "%s = %s\r\n",aszColname[i],argv[i] == 0 ? "Nul" : argv[i] );

}

return 0;

}

int main(int argc,char * argv[])

{

const char * ssql;

char * pErrMsg = 0;

int ret = 0;

sqlite3 * db = 0;

//创建数据库

ret = sqlite3_open("d:\encrypt.db",&db);

//添加密码

ret = sqlite3_key( db,"dcg",3 );

//在内存数据库中创建表

ssql = "create table class(name varchar(20),student);";

sqlite3_exec( db,ssql,_callback_exec,&pErrMsg );

//插入数据

ssql = "insert into class values('mem_52911','zhaoyun');";

sqlite3_exec( db,"sans-serif"; mso-ascii-Font-family:Consolas;mso-hansi-Font-family:Consolas;mso-bIDi-Font-family: Consolas;color:#3F7F5F">取得数据并显示

ssql = "select * from class;";

sqlite3_exec( db,"sans-serif"; mso-ascii-Font-family:Consolas;mso-hansi-Font-family:Consolas;mso-bIDi-Font-family: Consolas;color:#3F7F5F">关闭数据库

sqlite3_close(db);

db = 0;

return 0;

}