sqlite3

发布时间：2020-12-12 23:53:51 所属栏目：百科来源：网络整理

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

到官网下载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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!