Sqlite3简单应用
发布时间:2020-12-12 20:09:11 所属栏目:百科 来源:网络整理
导读:sqlite3 *db;sqlite3_stmt *stat;char *zErrMsg = 0;char buffer2[1024]="0";int result = sqlite3_open16(_T("testh.db"),db);;if(result == SQLITE_OK){AfxMessageBox(_T("success1"));}else{AfxMessageBox(_T("fail1"));}sqlite3_exec(db,"CREATE TABLE l
sqlite3 *db; sqlite3_stmt *stat; char *zErrMsg = 0; char buffer2[1024]="0"; int result = sqlite3_open16(_T("testh.db"),&db);; if(result == SQLITE_OK) { AfxMessageBox(_T("success1")); } else { AfxMessageBox(_T("fail1")); } sqlite3_exec(db,"CREATE TABLE list1 (fliename varchar(128) UNIQUE,fzip blob,ntest int,ntest1 int);",&zErrMsg); if (zErrMsg) { AfxMessageBox(_T("fail2")); sqlite3_free(zErrMsg); } //sqlite3_prepare 第一个参数是sqlite3 * 指针; //第二个参数是sql 字符串,可以包含多个sql语句; //第三个参数是sql 字符串长度,-1 sqlite 自己计算; //第四个参数是sqlite3_stmt ** 类型返回的是sql 解析的语句; //第个参数是const char *pzTail 用于指向zSql中下个sql语句开始的地址上,所以pzTail并没有重新开辟内存空间; const char *pzTail =NULL; const char *zSql = "insert into list1 values ('2.bmp',?,1); insert into list1 values ('2.bmp',1);"; int nRet = sqlite3_prepare(db,zSql,-1,&stat,&pzTail); FILE *fp; long filesize = 0; char * ffile; fp = fopen("2.bmp","rb"); if(fp != NULL) { fseek(fp,SEEK_END); filesize = ftell(fp); fseek(fp,SEEK_SET); ffile = new char[filesize+1]; size_t sz = fread(ffile,sizeof(char),filesize+1,fp); fclose(fp); } //sqlite3_bind_xxx 函数第一个参数是sqlite3_prepare 后的sqlite3_stmt 指针变量; //第二个参数是列的索引(从索引0开始); sqlite3_bind_blob(stat,1,ffile,filesize,NULL); delete(ffile); sqlite3_bind_int(stat,2,100); sqlite3_step(stat); //每次调用sqlite3_prepare 函数sqlite 会重新开辟sqlite3_stmt空间,; //所以在使用同一个sqlite3_stmt 指针再次调用sqlite3_prepare 前; //需要调用sqlite3_finalize先释放空间; sqlite3_finalize(stat); //-------------------------------------- sqlite3_prepare(db,"select * from list1;",0); //在调用sqlite3_column_count获取查询结果列信息的时候不需要先执行sqlite3_step就可以获取; int nColNum = sqlite3_column_count(stat); int r = sqlite3_step(stat); //在调用sqlite3_column_type 和sqlite3_column_name获取列类型和列名称信息前需要先执行sqlite3_step; /*; #define SQLITE_INTEGER 1 #define SQLITE_FLOAT 2 #define SQLITE_TEXT 3 #define SQLITE_BLOB 4 #define SQLITE_NULL 5 */ int colType = sqlite3_column_type(stat,0); const char *pchColName = sqlite3_column_name(stat,0); colType = sqlite3_column_type(stat,1); pchColName = sqlite3_column_name(stat,1); colType = sqlite3_column_type(stat,2); pchColName = sqlite3_column_name(stat,2); colType = sqlite3_column_type(stat,3); pchColName = sqlite3_column_name(stat,3); while(r == SQLITE_ROW) { const void * test = sqlite3_column_blob(stat,1); int size = sqlite3_column_bytes(stat,1); sprintf(buffer2,"%s",test); FILE *fp2; fp2 = fopen("outfile.bmp","wb"); if(fp2 != NULL) { size_t ret = fwrite(test,size,fp2); fclose(fp2); } const unsigned char * ptest = sqlite3_column_text(stat,0); int ntest = sqlite3_column_int(stat,2); int ntest1 = sqlite3_column_int(stat,3); r = sqlite3_step(stat); } sqlite3_finalize(stat); sqlite3_close(db); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- c# – Parallel.ForEach停止与最后几个项目并行
- flashback之flashback database
- Cocos2d-x中添加显示文字的三种方式 LabelTTF 、LabelBMFon
- c# – 如果一个方法返回一个接口,它是什么意思?
- bitbake错误:sqlite3.OperationalError: unable to open d
- Cocos Creator 调用php接口,c#,java思路相同
- 通过JAXB看XML外部实体注入(XML External Entity)
- c# – HttpWebRequest – 操作已超时
- 如何在Oracle中创建正整数列?
- iPhone – 入门