-
大小: 3.47MB文件類型: .zip金幣: 2下載: 0 次發(fā)布日期: 2023-10-29
- 語言: 數(shù)據(jù)庫
- 標簽: sqlite3??x64??lib??CppSQLite3DB??
資源簡介
最新版本的sqlite3 64位靜態(tài)庫(不需要帶dll),VS2010編譯的,如果需要32位的自行編譯就行了,里面包含demo和源碼
CppSQLite3DB db;
db.open(DB_NAME);
string temp = "select value from config where key='aaaa'";
CppSQLite3Query q = db.execQuery(temp.c_str());
temp.clear();
while (!q.eof())
{
temp.append(q.fieldValue(0));
printf(temp.c_str());
q.nextRow();
}
CppSQLite3DB db;
db.open(DB_NAME);
string temp = "select value from config where key='aaaa'";
CppSQLite3Query q = db.execQuery(temp.c_str());
temp.clear();
while (!q.eof())
{
temp.append(q.fieldValue(0));
printf(temp.c_str());
q.nextRow();
}

代碼片段和文件信息
#include?
#include?
#include?“../CppSQLite3.h“
#ifdef?_DEBUG
#???????pragma?comment(lib?“../sqlite3_d.lib“)
#else
#???????pragma?comment(lib?“../sqlite3.lib“)
#endif
using?namespace?std;
const?char*?gszFile?=?“test.db“;
int?main(int?argc?char**?argv)
{
try
{
int?i?fld;
time_t?tmStart?tmEnd;
CppSQLite3DB?db;
cout?<“SQLite?Header?Version:?“?< cout?<“SQLite?Library?Version:?“?< cout?<“SQLite?Library?Version?Number:?“?<
remove(gszFile);
db.open(gszFile);
cout?< cout?< db.execDML(“create?table?emp(empno?int?empname?char(20));“);
cout?< ////////////////////////////////////////////////////////////////////////////////
//?Execute?some?DML?and?print?number?of?rows?affected?by?each?one
////////////////////////////////////////////////////////////////////////////////
cout?< int?nRows?=?db.execDML(“insert?into?emp?values?(7?‘David?Beckham‘);“);
cout?<
nRows?=?db.execDML(“update?emp?set?empname?=?‘Christiano?Ronaldo‘?where?empno?=?7;“);
cout?<
nRows?=?db.execDML(“delete?from?emp?where?empno?=?7;“);
cout?<
////////////////////////////////////////////////////////////////////////////////
//?Transaction?Demo
//?The?transaction?could?just?as?easily?have?been?rolled?back
////////////////////////////////////////////////////////////////////////////////
int?nRowsToCreate(25000);
cout?< cout?<“?rows?please?wait...“?< tmStart?=?time(0);
cout?<“PRE-TXN?AUTO?COMMIT=“?<(db.IsAutoCommitOn()???“Y“?:?“N“)?< db.execDML(“begin?transaction;“);
cout?<“IN-TXN?AUTO?COMMIT=“?<(db.IsAutoCommitOn()???“Y“?:?“N“)?<
for?(i?=?0;?i? {
char?buf[128];
sprintf(buf?“insert?into?emp?values?(%d?‘Empname%06d‘);“?i?i);
db.execDML(buf);
}
db.execDML(“commit?transaction;“);
cout?<“POST-TXN?AUTO?COMMIT=“?<(db.IsAutoCommitOn()???“Y“?:?“N“)?< tmEnd?=?time(0);
////////////////////////////////////////////////////////////////////////////////
//?Demonstrate?CppSQLiteDB::execScalar()
////////////////////////////////////////////////////////////////////////////////
cout?< cout?<
////////////////////////////////////////////////////////////////////////////////
//?Re-cr
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-06-29?13:47??sqlite3\
?????文件????????8193??2007-07-12?21:27??sqlite3\CppSQLite3.h
?????目錄???????????0??2015-06-29?14:00??sqlite3\demo\
?????文件?????????850??2015-06-29?13:42??sqlite3\demo\demo.sln
?????文件?????????849??2015-06-29?13:22??sqlite3\demo\demo.sln.old
?????文件???????13312??2015-06-29?13:57??sqlite3\demo\demo.suo
?????文件????????9728??2015-06-29?13:41??sqlite3\demo\demo.suo.old
?????文件????????6905??2015-06-29?13:22??sqlite3\demo\demo.vcproj
?????文件????????2651??2015-06-29?13:41??sqlite3\demo\demo.vcproj.PC-201205301933.hadoop.user
?????文件????????9887??2015-06-29?13:42??sqlite3\demo\demo.vcxproj
?????文件?????????929??2015-06-29?13:42??sqlite3\demo\demo.vcxproj.filters
?????文件?????????143??2015-06-29?13:42??sqlite3\demo\demo.vcxproj.user
?????文件????????8567??2015-06-29?13:45??sqlite3\demo\main.cpp
?????目錄???????????0??2015-06-29?13:38??sqlite3\demo\x64\
?????目錄???????????0??2015-06-29?13:58??sqlite3\demo\x64\Debug\
?????目錄???????????0??2015-06-29?13:58??sqlite3\demo\x64\Release\
?????文件??????791552??2015-06-29?13:57??sqlite3\demo\x64\Release\demo.exe
?????文件??????379816??2015-06-27?02:48??sqlite3\sqlite3.h
?????文件?????3120756??2015-06-29?13:56??sqlite3\sqlite3.lib
?????文件?????2650378??2015-06-29?13:56??sqlite3\sqlite3_d.lib
?????目錄???????????0??2015-06-29?14:00??sqlite3\src\
?????文件?????????368??2011-02-23?07:32??sqlite3\src\clear.bat
?????目錄???????????0??2015-06-29?14:01??sqlite3\src\sqlite3\
?????文件????????1242??2015-06-29?13:51??sqlite3\src\sqlite3.sln
?????文件???????17408??2015-06-29?14:00??sqlite3\src\sqlite3.suo
?????文件???????19310??2010-01-18?11:31??sqlite3\src\sqlite3\codec.c
?????文件????????3285??2010-02-05?00:25??sqlite3\src\sqlite3\codec.h
?????文件????????9748??2010-08-23?22:11??sqlite3\src\sqlite3\codecext.c
?????文件???????35791??2007-07-12?22:15??sqlite3\src\sqlite3\CppSQLite3.cpp
?????文件????????8193??2015-06-29?13:51??sqlite3\src\sqlite3\CppSQLite3.h
?????文件???????52938??2010-03-25?00:43??sqlite3\src\sqlite3\extensionfunctions.c
............此處省略14個文件信息
評論
共有 條評論