main.cpp

在VC中用DB-Library快速访问SQL Server数据库技术

#include "DBLib.h"
#include "DBCursor.h"

void main()
{
	//CDBLib测试-begin
	CDBLib dblib;
	//设置登录信息：用户名、口令、数据库服务器名、所要用的数据库名
	dblib.SetDBLibInfo("sa","1234567","geosis-1","pubs");

	if(dblib.LoginDatabaseServer())
		printf("Login Successed\n");
	else
	{
		printf("Login Failed\n");
		return;
	}

	printf("%s \n",dblib.GetDatabaseName());
	printf("%s \n",dblib.GetDBServerName());
	printf("%s \n",dblib.GetDBUserName());
	printf("%s \n",dblib.GetDBUserPassWD());

	//CDBCursor测试-begin
	CDBCursor dbCursor;
	dbCursor.SetDBCursorProc(dblib.GetDBProc());

	CString strSQL = " select title_id,title,type from titles ";
	UINT CursorRows = 2;//每次取出2条记录
	dbCursor.OpenDBCursor(strSQL,CUR_KEYSET,CUR_READONLY,(UINT)CursorRows);
	
	int rows,cols;
	rows = dbCursor.GetRowsNumber();
	cols = dbCursor.GetColsNumber();
	printf("\nThere are %d records and %d cols in table titles \n",rows,cols);

	CStringList colList;
	dbCursor.GetCursorColNameInfo(colList);

	dbCursor.DBCursorBind();
	//第一次移动游标
	int retcode = dbCursor.DBCursorFetch( FETCH_FIRST,0 );
	printf("%s \n",dbCursor.GetCellText(0,0));
	printf("%s \n",dbCursor.GetCellText(0,1));
	printf("%s \n",dbCursor.GetCellText(0,2));

	printf("\n");

	printf("%s \n",dbCursor.GetCellText(1,0));
	printf("%s \n",dbCursor.GetCellText(1,1));
	printf("%s \n",dbCursor.GetCellText(1,2));

	printf("\n");
	//第二次移动游标
	dbCursor.DBCursorFetch( FETCH_NEXT,0 );
	printf("%s \n",dbCursor.GetCellText(2,0));
	printf("%s \n",dbCursor.GetCellText(2,1));
	printf("%s \n",dbCursor.GetCellText(2,2));

	printf("\n");

	printf("%s \n",dbCursor.GetCellText(3,0));
	printf("%s \n",dbCursor.GetCellText(3,1));
	printf("%s \n",dbCursor.GetCellText(3,2));

	//关闭游标
	dbCursor.CloseDBCursor();
	//CDBCursor测试-end

	dblib.LogoutDatabaseServer();
	//CDBLib测试-end

	char c;
	scanf("%c",&c);
	exit(0);
}