test.cpp

该模块完成的主要功能是让用户通过调用提供的打开数据库、执行SQL语句、关闭数据库三个主要的函数

#include "..\sqldll\clsdbtools.h"
#include "..\sqldll\clsrecordset.h"

int main()
{	
	int nRet = 0, nRet1 = 0, nRet2 = 0;
	char szOriginResult[10240];

	memset(szOriginResult, 0, 10240);

	
	
	/********************
	* 1.SQLite DB Test	*
	********************/
	ClsDbTools pDb;

#ifdef _FORLINUX_
	pDb.OpenDatabase("./target");
#else
 	pDb.OpenDatabase("target");
#endif

	//replaceChar
	char szObjResult[10240];
	char *strOrigin = "1'2''3'''";
	pDb.replaceChar(strOrigin, szObjResult);
	printf("strOrigin\t=\t%s\n",strOrigin);
	printf("szObjResult\t=\t%s\n\n\n",szObjResult);

	//Execute
	nRet = pDb.Execute("create table test (id int not null, desc varchar(100))");
	printf("nRet=%d\n",nRet);

	//Execute
	sprintf(szOriginResult,"insert into test values('1', '%s')", szObjResult);
	printf("%s\n",szOriginResult);
	nRet = pDb.Execute(szOriginResult);
	printf("nRet=%d\n",nRet);

	//Execute
	sprintf(szOriginResult,"insert into test values('2', '%s')", szObjResult);
	printf("%s\n",szOriginResult);
	nRet = pDb.Execute(szOriginResult);
	printf("nRet=%d\n",nRet);

	//Execute
	sprintf(szOriginResult,"insert into test values('3', '%s')", szObjResult);
	printf("%s\n",szOriginResult);
	nRet = pDb.Execute(szOriginResult);
	printf("nRet=%d\n",nRet);

	//Execute
	sprintf(szOriginResult,"insert into test values('4', '%s')", szObjResult);
	printf("%s\n",szOriginResult);
	nRet = pDb.Execute(szOriginResult);
	printf("nRet=%d\n",nRet);


	
	/********************
	* 2.Record Set Test	*
	********************/
	nRet = pDb.Execute("select * from test");
	if( 0 == nRet){
		ClsRecordset *pRec = new ClsRecordset(&pDb);

		//getRecordCount
		int nRecordCount=0;
		nRet = pRec->getRecordCount(&nRecordCount);
		printf("nRet=%d, nRecordCount=%d\n", nRet, nRecordCount);

		//getFieldCount
		int nFieldCount=0;
		nRet = pRec->getFieldCount(&nFieldCount);
		printf("nRet=%d, nFieldCount=%d\n", nRet, nFieldCount);

		//getFieldName
		nRet = pRec->getFieldName(0, szOriginResult);
		printf("nRet=%d, %s\n", nRet, szOriginResult);

		//getFieldIndex
		int nFieldNum=0;
		nRet = pRec->getFieldIndex("desc", &nFieldNum);
		printf("nRet=%d, %d\n", nRet, nFieldNum);

		//MoveFirst
		nRet1 = pRec->MoveFirst();
		nRet2 = pRec->getFieldValue(1, szOriginResult);
		printf("nRet1=%d, nRet2=%d\n%s\n", nRet1, nRet2, szOriginResult);
		
		//MoveNext
		nRet1 = pRec->MoveNext();
		nRet2 = pRec->getFieldValue("id", szOriginResult);
		printf("nRet1=%d, nRet2=%d\n%s\n", nRet1, nRet2, szOriginResult);
		
		//MovePrevious
		nRet1 = pRec->MovePrevious();
		nRet2 = pRec->getFieldValue("id", szOriginResult);
		printf("nRet1=%d, nRet2=%d\n%s\n", nRet1, nRet2, szOriginResult);
		
		//Move
		nRet1 = pRec->Move(2);
		nRet2 = pRec->getFieldValue("desc", szOriginResult);
		printf("nRet1=%d, nRet2=%d\n%s\n", nRet1, nRet2, szOriginResult);
		
		//MoveLast
		nRet1 = pRec->MoveLast();
		nRet2 = pRec->getRecordStr(szOriginResult, "|");
		printf("nRet1=%d, nRet2=%d\n%s\n", nRet1, nRet2, szOriginResult);
		
		//getPosition
		int iPosition;
		nRet = pRec->getPosition(&iPosition);
		printf("nRet=%d, %d\n", nRet, iPosition);

		//getRecord
		nRet = pRec->getRecord(szOriginResult, "//");
		printf("nRet=%d\n%s\n", nRet, szOriginResult);
		delete pRec;

	}
	pDb.CloseDatabase();

	return 0;

}