[C++] 一个C++版本的Sqlite3封装--SmartDb

void TestPerformance(){  SmartDB db;  db.Open("test.db");   //打开数据库  const string sqlcreat = "CREATE TABLE if not exists TestInfoTable(ID INTEGER NOT NULL, KPIID INTEGER, CODE INTEGER, V1 INTEGER, V2 INTEGER, V3 REAL, V4 TEXT);";  if (!db.Excecute(sqlcreat))  //执行sql语句    return;  boost::timer t;  const string sqlinsert = "INSERT INTO TestInfoTable(ID, KPIID, CODE, V1, V2, V3, V4) VALUES(?, ?, ?, ?, ?, ?, ?);";  bool ret = db.Prepare(sqlinsert);  db.Begin();  for (size_t i = 0; i < 10; i++) //00000  {    ret = db.ExcecuteArgs(i, i, i, i, i, i + 1.25, "it is a test");    if (!ret)      break;  }  if (ret)    db.Commit(); //提交事务  else    db.RollBack(); //回滚  cout << t.elapsed() << endl;  t.restart();  //100w 3.5-4秒左右  auto p = db.Query("select * from TestInfoTable");  cout << t.elapsed() << endl;  cout << "size: " << p->Size() << endl;  //100W 4秒左右    rapidjson::StringBuffer buffer;    rapidjson::PrettyWriter<rapidjson::StringBuffer> pretty_writer(buffer);  //PrettyWriter是格式化的json，如果是Writer则是换行空格压缩后的json    p->Accept(pretty_writer);    //打印到屏幕    //cout<<"the json output:"<<endl;   cout<<buffer.GetString()<<endl;  //遍历查询结果  rapidjson::Value& infoArray  = *p;  for ( int i = 0; i < p->Size(); ++i )  {    const rapidjson::Value& object = infoArray[i];    printf("%d. Id: %d  KpiId: %d, v3: %f, v4: %s\n",i,      object["ID"].GetInt(), object["KPIID"].GetInt(),object["V3"].GetDouble(),object["V4"].GetString());  }}