sqlite3

概述到官网下载sqlite-amalgamation-3080403.zip文件，解压出来就4个文件,直接添加到工程里就可以编译 使用了 shell.c sqlite3.c sqlite3.h sqlite3ext.h 可视化工具：sqlitebrowser 代码出处:http://blog.csdn.net/tszhao/article/details/6749758 void TestSqlite

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

shell.c

sqlite3.c

sqlite3.h

sqlite3ext.h

可视化工具：sqlitebrowser

代码出处:http://blog.csdn.net/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(?,?);",&zTail); char str[] = "Kevin"; int n = 23; sqlite3_bind_text(stmt,1,str,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,str2,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;",&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,number); r = sqlite3_step(stmt); } sqlite3_finalize(stmt); //关闭数据库 sqlite3_close(db); } #endif 总结

以上是内存溢出为你收集整理的sqlite3全部内容，希望文章能够帮你解决sqlite3所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。