复制代码 代码如下:

#include<stdio.h>

#include<sqlite3.h>

int select_callback(void *data,int col_count,char **col_values,char **col_name)

{

//每条记录回调一次该函数，有多少条就回调多少次

int i;

for(i=0;i<col_count;i++)

{

printf("%s=%sn",col_name[i],col_values[i]==0?"NULL":col_values[i]);

}

return 0;

}

int main(int argc,char **argv)

{

//创建数据库表

const char *SQL1="create table users(id int PRIMARY KEY,name varchar(20),birthday datetime);";

//向数据库插入数据

const char *SQL2="insert into users values(1,'myd','2013-10-9');";

const char *SQL3="insert into users values(2,'myd','2013-10-9');";

//从数据库查询数据

const char *SQL4="select * from users;";

char *ErrMsg=0;

int ret = 0;

//连接数据库

sqlite3 *db =0;

ret=sqlite3_open("./DataBase",&db);

if(ret != SQLITE_OK)

{

fprintf(stderr,"无法打开数据库:%s",sqlite3_errmsg(db));

return 1;

}

printf("数据库连接成功！n");

//执行建表

ret = sqlite3_exec(db,SQL1,0,0,&ErrMsg);

if(ret != SQLITE_OK)

{

fprintf(stderr,"SQL Error:%sn",ErrMsg);

sqlite3_free(ErrMsg);

}

//执行插入记录SQL语句

ret = sqlite3_exec(db,SQL2,0,0,&ErrMsg);

if(ret !=SQLITE_OK)

{

printf("插入数据成功n");

}

ret = sqlite3_exec(db,SQL3,0,0,&ErrMsg);

{

printf("插入数据成功n");

}

//查询数据表内容

printf("查询数据表内容n");

sqlite3_exec(db,SQL4,select_callback,0,&ErrMsg);

//关闭数据库

sqlite3_close(db);

db = 0;

printf("数据库关闭成功！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