#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?<		cout?<		cout?<
		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?<		tmStart?=?time（0）;
		cout?<		db.execDML（“begin?transaction;“）;
		cout?<
		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?<		tmEnd?=?time（0）;

		////////////////////////////////////////////////////////////////////////////////
		//?Demonstrate?CppSQLiteDB::execScalar（）
		////////////////////////////////////////////////////////////////////////////////
		cout?<		cout?<
		////////////////////////////////////////////////////////////////////////////////
		//?Re-cr

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????8218??2015-07-04?02:25??CppSQLite3.h
?????目錄???????????0??2015-07-04?03:10??demo\
?????文件?????????850??2015-06-29?13:42??demo\demo.sln
?????文件?????????849??2015-06-29?13:22??demo\demo.sln.old
?????文件???????13312??2015-06-29?13:57??demo\demo.suo
?????文件????????9728??2015-06-29?13:41??demo\demo.suo.old
?????文件????????6905??2015-06-29?13:22??demo\demo.vcproj
?????文件????????2651??2015-06-29?13:41??demo\demo.vcproj.PC-201205301933.hadoop.user
?????文件????????9887??2015-06-29?13:42??demo\demo.vcxproj
?????文件?????????929??2015-06-29?13:42??demo\demo.vcxproj.filters
?????文件?????????143??2015-06-29?13:42??demo\demo.vcxproj.user
?????文件????????8567??2015-06-29?13:45??demo\main.cpp
?????文件??????379816??2015-06-27?02:48??sqlite3.h
?????文件?????3199714??2015-07-04?03:08??sqlite3.lib
?????文件?????2719260??2015-07-04?03:08??sqlite3_d.lib
?????目錄???????????0??2015-07-04?03:10??src\
?????文件?????????368??2011-02-23?07:32??src\clear.bat
?????目錄???????????0??2015-07-04?03:09??src\sqlite3\
?????文件???????35892??2015-07-04?02:32??src\sqlite3\CppSQLite3.cpp
?????文件????????8218??2015-07-04?02:25??src\sqlite3\CppSQLite3.h
?????文件???????19310??2010-01-18?11:31??src\sqlite3\codec.c
?????文件????????3285??2010-02-05?00:25??src\sqlite3\codec.h
?????文件????????9755??2015-07-04?03:00??src\sqlite3\codecext.c
?????文件???????52938??2010-03-25?00:43??src\sqlite3\extensionfunctions.c
?????文件??????102338??2009-09-12?01:07??src\sqlite3\rijndael.c
?????文件????????6749??2009-09-12?00:58??src\sqlite3\rijndael.h
?????文件???????33153??2010-01-18?12:05??src\sqlite3\sha2.c
?????文件????????5067??2010-01-18?11:58??src\sqlite3\sha2.h
?????文件???????89695??2011-06-29?01:08??src\sqlite3\shell.c
?????文件?????4524292??2011-06-29?01:08??src\sqlite3\sqlite3.c
?????文件????????4606??2011-07-22?11:50??src\sqlite3\sqlite3.def
............此處省略9個(gè)文件信息