使用sqlite3的一个C语言例子

编译方法： gcc -g -lsqlite3 a.c -o a

#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>
#include <string.h>

int main(int argc,char **argv)
{
    int rc,i,ncols;
    sqlite3 *db;
    sqlite3_stmt *stmt;
    char *sql;
    const char *tail;
    //打开数据

    rc=sqlite3_open("lite3db",&db);
    if (rc)
    {
        fprintf(stderr,"Can't open database: %s\n",sqlite3_errmsg(db));
        sqlite3_close(db);
        exit(1);
    }

    sql="select * from t";
    //预处理

    rc=sqlite3_prepare(db,sql,(int)strlen(sql),&stmt,&tail);
    if (rc!=SQLITE_OK)
    {
        fprintf(stderr,"SQLerror:%sn",sqlite3_errmsg(db));
    }

    rc=sqlite3_step(stmt);
    ncols=sqlite3_column_count(stmt);
    while (rc==SQLITE_ROW)
    {

        for (i=0; i<ncols; i++)
        {
            if(i==0)
            {
                fprintf(stderr,"'%s'",sqlite3_column_text(stmt,i));
            }
            else
            {
                fprintf(stderr,",'%s'",sqlite3_column_text(stmt,i));
            }
        }
        fprintf(stderr,"\n");
        rc=sqlite3_step(stmt);
    }
    //释放statement

    sqlite3_finalize(stmt);
    //关闭数据库

    sqlite3_close(db);
    return 0;
}