dbprj.cpp

数据库开发

// dbprj.cpp : Defines the entry point for the console application.
//

#include "stdafx.h"
#include "dbcheck.h"

CDBCheck dbcheck("DSN=db;UID=sa;PWD=sina.com");
BOOL SetUserInfo(CString strUserName)
{

	NODECURUSERINFO NodeCurUserInfo;
	NodeCurUserInfo.strUserName  =strUserName;
	NodeCurUserInfo.nUserLevel  =5;
	NodeCurUserInfo.nUserScore  =500;
	NodeCurUserInfo.nTotalCardCount  =20;
	NodeCurUserInfo.nVictoryCount  =5;
	NodeCurUserInfo.nBreakNetCount =3;
	NodeCurUserInfo.strEnterText ="I comes";
	NodeCurUserInfo.strExitText  ="I goes";
	NodeCurUserInfo.bShowRegardText  =TRUE;
	NodeCurUserInfo.bShowMoveText =TRUE;
	NodeCurUserInfo.bShowEnemyText =TRUE;
	NodeCurUserInfo.bShowSysInfo  =TRUE;
	NodeCurUserInfo.fRoomBreakRate =0.5;
	NodeCurUserInfo.nRoomNetSpeed=5000;
	NodeCurUserInfo.nRoomPlayNum =1;
	NodeCurUserInfo.nRoomTableNum =1;
	NodeCurUserInfo.strRoomName ="NO1";
	NodeCurUserInfo.bTableBreakRate =TRUE;
	NodeCurUserInfo.bTableDislike=TRUE;
	NodeCurUserInfo.bTableNetRate =TRUE;
	NodeCurUserInfo.fTableBreakRate =TRUE;
	NodeCurUserInfo.nTableNetRate =TRUE;
	NodeCurUserInfo.strAllFriend ="";
	NodeCurUserInfo.strAllEnemy="";
	NodeCurUserInfo.nEqualCount=2;
	NodeCurUserInfo.nLossCount=1;
	NodeCurUserInfo.bAgreeLook=1;
	return dbcheck.DoUpdateRecordset(strUserName,&NodeCurUserInfo);

}
int main(int argc, char* argv[])
{
	printf("Hello World!\n");
	printf("Dbcheck demo program!\n");
	NODECURUSERINFO info;
	if (dbcheck.IsUserValid("test","123",&info))
	//if check pass
	{ 
		Alert("Check UserName Password ok.\r\n");
		Alert("Read User information from database:\r\n");
		
		CString strFormat;
		
		strFormat="userlevel=%d,\r\n userscore=%d,\r\n ";
		strFormat+="totalcardcount=%d,\r\n victorycount=%d,\r\n breaknetcount=%d,\r\n ";
		strFormat+="entertext='%s',\r\n exittext='%s',\r\n showregardtext=%1d,\r\n showmovetext=%1d,\r\n ";
		strFormat+="showenemytext=%1d,\r\n ";
		strFormat+="showsysinfo=%1d,\r\n booltabbreakrate=%1d,\r\n booltabdislike=%1d,\r\n ";
		strFormat+="booltabnetrate=%1d,\r\n roombreakrate=%f,\r\n tablebreakrate=%f,\r\n ";
		strFormat+="roomnetspeed=%d,\r\n roomplaynum=%d,\r\n roomtablenum=%d,\r\n ";
		strFormat+="tablenetrate=%d,\r\n allenemy='%s',\r\n allfriend='%s',\r\n roomname='%s',\r\n ";
		strFormat+="equalcount=%d,\r\n losscount=%d,\r\n agreelook=%d\r\n ";
		
		printf(strFormat,5,
			info.nUserScore ,info.nTotalCardCount ,
			info.nVictoryCount ,info.nBreakNetCount ,
			info.strEnterText ,info.strExitText ,
			info.bShowRegardText ,info.bShowMoveText ,
			info.bShowEnemyText ,info.bShowSysInfo,
			info.bTableBreakRate,info.bTableDislike,info.bTableNetRate,
			info.fRoomBreakRate,info.fTableBreakRate,
			info.nRoomNetSpeed,info.nRoomPlayNum,info.nRoomTableNum,
			info.nTableNetRate,info.strAllEnemy,info.strAllFriend,
			info.strRoomName,info.nEqualCount,info.nLossCount,
			info.bAgreeLook);	

	}
	else
	{
		Alert("UserName Password check error.please check your user/pass.\r\n");
	}
	Alert("\r\nUpdate User:test info.\r\n");		

	if (SetUserInfo("test"))
		Alert("Update success.\r\n");
	else
		Alert("Update Fail.\r\n");
	return 0;
}