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

int select_callback(void *data,int col_count,char **col_values,char **col_name)
{
    //每條記錄回調(diào)一次該函數(shù)，有多少條就回調(diào)多少次
    int i;
    for(i=0;i<col_count;i++)
    {
        printf("%s=%s\n",col_name[i],col_values[i]==0?"NULL":col_values[i]);
    }
    return 0;
}

int main(int argc,char **argv)
{
    //創(chuàng)建數(shù)據(jù)庫(kù)表
    const char *SQL1="create table users(id int PRIMARY KEY,name varchar(20),birthday datetime);";
    //向數(shù)據(jù)庫(kù)插入數(shù)據(jù)
    const char *SQL2="insert into users values(1,'myd','2013-10-9');";
    const char *SQL3="insert into users values(2,'myd','2013-10-9');";
    //從數(shù)據(jù)庫(kù)查詢數(shù)據(jù)
    const char *SQL4="select * from users;";
    char *ErrMsg=0;
    int  ret = 0;
    //連接數(shù)據(jù)庫(kù)
    sqlite3 *db =0;
    ret=sqlite3_open("./DataBase",&db);
    if(ret != SQLITE_OK)
    {
        fprintf(stderr,"無(wú)法打開(kāi)數(shù)據(jù)庫(kù):%s",sqlite3_errmsg(db));
        return 1;
    }
    printf("數(shù)據(jù)庫(kù)連接成功！\n");
    //執(zhí)行建表
    ret = sqlite3_exec(db,SQL1,0,0,&ErrMsg);
    if(ret != SQLITE_OK)
    {
        fprintf(stderr,"SQL Error:%s\n",ErrMsg);
        sqlite3_free(ErrMsg);
    }
    //執(zhí)行插入記錄SQL語(yǔ)句
    ret = sqlite3_exec(db,SQL2,0,0,&ErrMsg);
    if(ret !=SQLITE_OK)
    {
        printf("插入數(shù)據(jù)成功\n");
    }
    ret = sqlite3_exec(db,SQL3,0,0,&ErrMsg);
    {
        printf("插入數(shù)據(jù)成功\n");
    }
    //查詢數(shù)據(jù)表內(nèi)容
    printf("查詢數(shù)據(jù)表內(nèi)容\n");
    sqlite3_exec(db,SQL4,select_callback,0,&ErrMsg);
    //關(guān)閉數(shù)據(jù)庫(kù)
    sqlite3_close(db);
    db = 0;
    printf("數(shù)據(jù)庫(kù)關(guān)閉成功！\n");

    return 0;
}

CFLAGS=-L /usr/local/sqlite-autoconf-3070400/lib -I/usr/local/sqlite-autoconf-307040/include  -lsqlite3

all: sqlite.o sqlite

sqlite:sqlite.o
 gcc sqlite.o -o sqlite $(CFLAGS)

sqlite.o:sqlite.c
 gcc -c sqlite.c $(CFLAGS)
clean:
 rm -rf sqlite *.o