-
VS2013 Sqlite3 操作指令
- extern "C"{
- #include "sqlite3.h"
- };
-
- #pragma comment(lib,"sqlite.lib")
-
-
- 下载是我简单作用sqlite3的代码,不好看,请包涵!
-
- 详细教程在这:http:
-
- void CMySqliteDlg::OnBnClickedOk()
- {
-
-
- CTime m_time;
- m_time=CTime::GetCurrentTime();
- FILE *fp=fopen("debug.txt","a+");
- fprintf(fp,"
------------------------%s------------------------
"
- ,m_time.Format(_T("%Y-%m-%d %H:%M:%S %A")));
-
- ::sqlite3 *db=NULL;
- ::sqlite3_stmt *stmt;
- char *sql=NULL,*error=NULL;
- const char *tail=NULL;
- int res;
- res=::sqlite3_open("MySqlite.db",&db);
- if(res!=SQLITE_OK){
- ::sqlite3_close(db);
- fprintf(fp,"open database is failure:%s
",::sqlite3_errmsg(db));
- return;
- }else fprintf(fp,"open database is success!
");
-
-
- sql="create table if not exists MyTable(Row integer primary key autoincrement,Content text)";
- res=::sqlite3_exec(db,sql,NULL,NULL,&error);
- if(res!=SQLITE_OK){
- ::sqlite3_close(db);
- fprintf(fp,"error create table:%s %s
",error,::sqlite3_errmsg(db));
- return;
- }else fprintf(fp,"table is created
");
-
-
-
- sql="insert or replace into MyTable(Row,Content) values(?,?)";
-
- res=::sqlite3_prepare_v2(db,sql,-1,&stmt,&tail);
- if(res!=SQLITE_OK){
- ::sqlite3_close(db);
- fprintf(fp,"insert is failure:%s %s
",tail,::sqlite3_errmsg(db));
- return;
- }
- for(int i=0;i<3;i++){
-
- ::sqlite3_bind_text(stmt,2,"数据库数据",-1,NULL);
- if(::sqlite3_step(stmt)!=SQLITE_DONE){
- fprintf(fp,"error update table:%s
",::sqlite3_errmsg(db));
- }
- ::sqlite3_reset(stmt);
- }
- ::sqlite3_finalize(stmt);
-
- sql="delete from MyTable where Row=2";
-
- res=::sqlite3_exec(db,sql,NULL,NULL,&error);
- if(res!=SQLITE_OK){
- ::sqlite3_close(db);
- fprintf(fp,"delete error:%s %s
",error,::sqlite3_errmsg(db));
- return;
- }else fprintf(fp,"delete is success
");
- ::sqlite3_finalize(stmt);
-
- sql="update MyTable set Content='修改后的数据' where Row=3";
- res=::sqlite3_exec(db,sql,NULL,NULL,&error);
- if(res!=SQLITE_OK){
- ::sqlite3_close(db);
- fprintf(fp,"update error:%s %s
",error,::sqlite3_errmsg(db));
- return;
- }else fprintf(fp,"update is success
");
- ::sqlite3_finalize(stmt);
-
- sql="select Row,Content from MyTable order by Row";
- res=::sqlite3_prepare_v2(db,sql,-1,&stmt,&tail);
- if(res!=SQLITE_OK){
- ::sqlite3_close(db);
- fprintf(fp,"query is failure:%s %s
",tail,::sqlite3_errmsg(db));
- return;
- }
- while(::sqlite3_step(stmt)==SQLITE_ROW){
- static int cnt=::sqlite3_column_count(stmt);
- for(int i=0;i<cnt;i++){
- fprintf(fp,"Data:%s
",::sqlite3_column_text(stmt,i));
- }
-
- }
-
- ::sqlite3_finalize(stmt);
-
- ::sqlite3_close(db);
- ::fclose(fp);
- }
-
相关阅读:
CentOS(RedHat) 6.2 Samba share权限拒绝访问
Android NDK调试C++源码(转)
linux du命令: 显示文件、目录大小
网络游戏的同步
游戏开发辅助库
Unity3D 200个插件免费分享
C#UDP同步实例
C#UDP(接收和发送源码)源码完整
C#完整的通信代码(点对点,点对多,同步,异步,UDP,TCP)
内置函数及匿名函数
-
原文地址:https://www.cnblogs.com/ransn/p/8125330.html
Copyright © 2020-2023
润新知