SQLiteC++Wrapper是一个C++语言对SQLite的最小封装包。
示例代码1：
#iclude<strig>#iclude<iostream>#iclude<stdexcept>usigamespacestd;#iclude"sqlite3x.hpp"usigamespacesqlite3x;itmai(void){ try{ sqlite3_coectioco("test.db"); itcout=co.executeit( "selectcout(*)" "fromsqlite_master" "whereame='t_test';"); if(cout==0){ co.executeoquery( "createtablet_test(umber,strig);"); } sqlite3_trasactiotras(co); { sqlite3_commadcmd(co, "isertitot_testvalues(?,?);"); cmd.bid(2,"foobar",6); for(iti=0;i<10000;++i){ cmd.bid(1,i); cmd.executeoquery(); } } //iftrasgoesoutofscope(duetoaexceptioor //aythigelse)beforecalligcommit(),itwill //automaticallyrollback() tras.commit(); } catch(exceptio&ex){ cerr<<"ExceptioOccured:"<<ex.what()<<edl; } retur0;}示例代码2：
#iclude<iostream>#iclude<stdexcept>usigamespacestd;#iclude"sqlite3x.hpp"usigamespacesqlite3x;itmai(void){ try{ sqlite3_coectioco("test.db"); sqlite3_commadcmd(co,"select*fromt_test;"); sqlite3_readerreader=cmd.executereader(); while(reader.read()){ cout<<reader.getcolame(0)<<":" <<reader.getit(0)<<edl; } } catch(exceptio&ex){ cerr<<"ExceptioOccured:"<<ex.what()<<edl; } retur0;}
评论