VS2013 Sqlite3 操作指令

extern "C"{
#include "sqlite3.h"
};

#pragma comment(lib,"sqlite.lib")
/*
为什么要 extern “C” ？这是C++的基础。要在 C++里使用一段 C 的代码，必须要用 extern “C” 括起来。C++跟 C虽然语法上有重叠，但是它们是两个不同的东西，内存里的布局是完全不同的，在C++编译器里不用extern “C”括起C代码，会导致编译器不知道该如何为 C 代码描述内存布局。可能在 sqlite3.c 里人家已经把整段代码都 extern “C” 括起来了，但是你遇到一个.c 文件就自觉的再括一次，也没什么不好。
*/

//-----------------------------------------------------OK,尽情的爽吧---------------------------------------------------//

下载是我简单作用sqlite3的代码，不好看，请包涵！

 详细教程在这：http://download.csdn.net/detail/q775968375/5970059

void CMySqliteDlg::OnBnClickedOk()
{
    // TODO: 在此添加控件通知处理程序代码
    //CDialogEx::OnOK();
    CTime m_time;
    m_time=CTime::GetCurrentTime();//获取当前时间日期
    FILE *fp=fopen("debug.txt","a+");
    fprintf(fp,"\n------------------------%s------------------------\n"
        ,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\n",::sqlite3_errmsg(db));
        return;
    }else fprintf(fp,"open database is success!\n");

        //create table
        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\n",error,::sqlite3_errmsg(db));
          return;
        }else fprintf(fp,"table is created\n");


        //insert
        sql="insert or replace into MyTable(Row,Content) values(?,?)";
        //sqlite3_prepare_v2的作用是将UTF-8格式的SQL语句转换为编译后的语句，并返回指向该语句的指针
        res=::sqlite3_prepare_v2(db,sql,-1,&stmt,&tail);
        if(res!=SQLITE_OK){
          ::sqlite3_close(db);
          fprintf(fp,"insert is failure:%s %s\n",tail,::sqlite3_errmsg(db));
          return;
        }
        for(int i=0;i<3;i++){
        //::sqlite3_bind_int(stmt,1,0);//1:id  2:data
        ::sqlite3_bind_text(stmt,2,"数据库数据",-1,NULL);
        if(::sqlite3_step(stmt)!=SQLITE_DONE){
            fprintf(fp,"error update table:%s\n",::sqlite3_errmsg(db));
         }
        ::sqlite3_reset(stmt); //重新初始化该sqlite3_stmt对象绑定的变量。
        }
        ::sqlite3_finalize(stmt);
        //delete
        sql="delete from MyTable where Row=2";
        //res=::sqlite3_prepare_v2(db,sql,-1,&stmt,&tail);
        res=::sqlite3_exec(db,sql,NULL,NULL,&error);
        if(res!=SQLITE_OK){
          ::sqlite3_close(db);
          fprintf(fp,"delete error:%s %s\n",error,::sqlite3_errmsg(db));
          return;
        }else fprintf(fp,"delete is success\n");
        ::sqlite3_finalize(stmt);
        //update
        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\n",error,::sqlite3_errmsg(db));
          return;
        }else fprintf(fp,"update is success\n");
        ::sqlite3_finalize(stmt);
        //query
        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\n",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\n",::sqlite3_column_text(stmt,i));
            }
            /*
            int row=::sqlite3_column_int(stmt,0);
            char *rowData=(char*)::sqlite3_column_text(stmt,1);
            if(rowData==NULL)rowData="NULL";
            */
        }
        //释放statement
        ::sqlite3_finalize(stmt);
        //关闭数据库
        ::sqlite3_close(db);
        ::fclose(fp);
}