sqlite3-优快云博客

本文介绍如何使用SQLite数据库，包括数据库的安装与配置方法、创建表、插入数据及查询等基本操作。通过一个完整的示例代码，展示了如何利用C语言进行SQLite数据库的操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

到官网下载sqlite-amalgamation-3080403.zip文件，解压出来就4个文件,直接添加到工程里就可以编译使用了

shell.c

sqlite3.c

sqlite3.h

sqlite3ext.h

可视化工具：sqlitebrowser

代码出处:http://blog.youkuaiyun.com/tszhao/article/details/6749758

void TestSqlite3()

{
sqlite3 *db;
sqlite3_stmt * stmt;
const char *zTail;

//打开数据库
int r = sqlite3_open("mysqlite.db",&db) ;
if(r)
{
printf("%s",sqlite3_errmsg(db));
}

//创建Table
sqlite3_prepare(db,
"CREATE TABLE players ( ID INTEGER PRIMARY KEY, name TEXT, age INTERER );",
-1,&stmt,&zTail);
sqlite3_step(stmt);
sqlite3_finalize(stmt);

//插入数据
sqlite3_prepare(db,
"INSERT INTO players (name,age) VALUES(?,?);",
-1,&stmt,&zTail);

char str[] = "Kevin";
int n = 23;
sqlite3_bind_text(stmt,1,str,-1,SQLITE_STATIC);
sqlite3_bind_int(stmt,2,n);
r = sqlite3_step(stmt);
if( r!=SQLITE_DONE){
printf("%s",sqlite3_errmsg(db));
}
sqlite3_reset(stmt);

//插入第二个数据
char str2[] = "Jack";
int n2 = 16;
sqlite3_bind_text(stmt,1,str2,-1,SQLITE_STATIC);
sqlite3_bind_int(stmt,2,n2);
r = sqlite3_step(stmt);
if( r!=SQLITE_DONE){
printf("%s",sqlite3_errmsg(db));
}
sqlite3_finalize(stmt);

//查询所有数据
sqlite3_prepare(db,
"SELECT ID, name, age FROM players ORDER BY age;",
-1,&stmt,&zTail);
r = sqlite3_step(stmt);
int number;
int id;
const unsigned char * name;
while( r == SQLITE_ROW ){
id = sqlite3_column_int( stmt, 0 );
name = sqlite3_column_text( stmt,1 );
number = sqlite3_column_int( stmt, 2 );
printf("ID: %d Name: %s Age: %d /n",id,name,number);
r = sqlite3_step(stmt);
}
sqlite3_finalize(stmt);

//关闭数据库
sqlite3_close(db);
}
#endif