使用CppSQLite3访问SQLite数据库

使用CppSQLite3访问SQLite数据库

2014年4月9日16:33:59

C代码：

#include <stdlib.h> #include <stdio.h>#include "CppSQLite3.h"#include<iostream>using namespace std;int main(){printf("hello,world!\n");CppSQLite3DB db;  db.open("data.db3");/*db.execDML("create table test(id int,name char(20));");db.execDML("insert into test values (1,'xiufeiyang');");db.execDML("insert into test values (2,'lixueliang');");*/CppSQLite3Query query = db.execQuery("select * from test");  while(!query.eof())  {  cout<<"id:"<<query.getIntField("id")<<" name:"<<query.getStringField("name")<<endl;  query.nextRow();  }  query.finalize();  db.close();  system("pause");return 0;}