//////////////////////////////////////////////////////////////////////////////////////
//
//??FileName????:???KDBbase.cpp
//??Version?????:???1.0
//??Creater?????:???Xia?Yong
//??Date????????:???2008-01-11?09:34:39
//??Comment?????:???訪問數據庫
//////////////////////////////////////////////////////////////////////////////////////

#include?“stdafx.h“
#include?“KDBbase.h“
#include?“errmsg.h“

static?const?unsigned?long?MYSQL5_VERSION_ID?=?50000;?//?MySQL?5?Version?ID

BOOL?MySQL_CheckCaseInsensitive（MYSQL*?pHandle）
{
????BOOL????????bResult?????????=?false;
????int?????????nRetCode????????=?0;
????char????????szSQL[]?????????=?“show?variables?like?\‘lower_case_table_names\‘“;
????MYSQL_RES*??pResultSet??????=?NULL;
????MYSQL_ROW???Row?????????????=?NULL;
????unsigned????uFieldCount?????=?0;
????
????assert（pHandle）;

????nRetCode?=?MySQL_Query（pHandle?szSQL）;
????KGLOG_PROCESS_ERROR（nRetCode）;

????pResultSet?=?mysql_store_result（pHandle）;
????KGLOG_PROCESS_ERROR（pResultSet）;

????uFieldCount?=?mysql_num_fields（pResultSet）;????
????KGLOG_PROCESS_ERROR（uFieldCount?==?2）;

????Row?=?mysql_fetch_row（pResultSet）;
????KGLOG_PROCESS_ERROR（Row）;

????nRetCode?=?strcmp（Row[1]?“1“）;
????if?（nRetCode）
????{
????????KGLogPrintf（KGLOG_ERR?“[DB]?DB?error?lower_case_table_names?-->?1\n“）;
????????goto?Exit0;
????}

????bResult?=?true;
Exit0:
????if?（pResultSet）
????{
????????mysql_free_result（pResultSet）;
????????pResultSet?=?NULL;
????}
????return?bResult;
}

BOOL?MySQL_CheckCharacterSet（MYSQL*?pHandle）
{
????BOOL????????bResult?????????=?false;
????int?????????nRetCode????????=?0;
????char????????szSQL[]?????????=?“show?variables?like?\‘character_set_database\‘“;
????MYSQL_RES*??pResultSet??????=?NULL;
????MYSQL_ROW???Row?????????????=?NULL;
????unsigned????uFieldCount?????=?0;

????assert（pHandle）;
????
????//?get?database?character?set
????nRetCode?=?MySQL_Query（pHandle?szSQL）;
????KGLOG_PROCESS_ERROR（nRetCode）;

????pResultSet?=?mysql_store_result（pHandle）;
????KGLOG_PROCESS_ERROR（pResultSet）;

????uFieldCount?=?mysql_num_fields（pResultSet）;????
????KGLOG_PROCESS_ERROR（uFieldCount?==?2）;

????Row?=?mysql_fetch_row（pResultSet）;
????KGLOG_PROCESS_ERROR（Row）;

????KGLOG_PROCESS_ERROR（Row[1]）;

????nRetCode?=?mysql_set_character_set（pHandle?Row[1]）;????
????KGLOG_PROCESS_ERROR（nRetCode?==?0）;

????bResult?=?true;
Exit0:
????if?（pResultSet）
????{
????????mysql_free_result（pResultSet）;
????????pResultSet?=?NULL;
????}
????return?bResult;
}

MYSQL*?MySQL_Connect（
????const?char?cszDBAddr[]?const?char?cszDBName[]?int?nPort?
????const?char?cszUserName[]?const?char?cszPassword[]
）
{
????MYSQL*????????pResult???????????????????=?NULL;
????int???????????nRetCode??????????????????=?false;
????MYSQL*????????pDBHandle?????????????????=?NULL;
????MYSQL*????????pTmpHandle????????????????=?NULL;
????my_bool???????bReconnectFlag????????????=?0;
????unsigned?long?ulMy

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????????22??2010-01-08?09:06??Server\JX3ServerMergeTool\CVS\Entries

?????文件?????????28??2010-01-08?09:06??Server\JX3ServerMergeTool\CVS\Entries.Extra

?????文件?????????46??2010-01-08?09:06??Server\JX3ServerMergeTool\CVS\Entries.Extra.Old

?????文件?????????37??2010-01-08?09:06??Server\JX3ServerMergeTool\CVS\Entries.Old

?????文件?????????41??2009-12-16?06:13??Server\JX3ServerMergeTool\CVS\Repository

?????文件?????????61??2009-12-16?06:13??Server\JX3ServerMergeTool\CVS\Root

?????文件?????????25??2010-01-08?09:05??Server\JX3ServerMergeTool\CVS\Tag

?????文件?????????75??2010-01-08?09:05??Server\JX3ServerMergeTool\doc\CVS\Entries

?????文件?????????32??2010-01-08?09:05??Server\JX3ServerMergeTool\doc\CVS\Entries.Extra

?????文件?????????32??2010-01-07?06:04??Server\JX3ServerMergeTool\doc\CVS\Entries.Extra.Old

?????文件?????????75??2010-01-07?06:04??Server\JX3ServerMergeTool\doc\CVS\Entries.Old

?????文件?????????45??2009-12-16?06:13??Server\JX3ServerMergeTool\doc\CVS\Repository

?????文件?????????61??2009-12-16?06:13??Server\JX3ServerMergeTool\doc\CVS\Root

?????文件?????????25??2010-01-08?09:05??Server\JX3ServerMergeTool\doc\CVS\Tag

?????文件??????60416??2009-11-25?11:41??Server\JX3ServerMergeTool\doc\合服策略.doc

?????文件???????1220??2010-01-08?09:05??Server\JX3ServerMergeTool\src\CVS\Entries

?????文件????????592??2010-01-08?09:05??Server\JX3ServerMergeTool\src\CVS\Entries.Extra

?????文件????????592??2010-01-07?06:04??Server\JX3ServerMergeTool\src\CVS\Entries.Extra.Old

?????文件???????1220??2010-01-07?06:04??Server\JX3ServerMergeTool\src\CVS\Entries.Old

?????文件?????????45??2009-12-16?06:13??Server\JX3ServerMergeTool\src\CVS\Repository

?????文件?????????61??2009-12-16?06:13??Server\JX3ServerMergeTool\src\CVS\Root

?????文件?????????25??2010-01-08?09:05??Server\JX3ServerMergeTool\src\CVS\Tag

?????文件???????5959??2010-01-06?06:04??Server\JX3ServerMergeTool\src\JX3ServerMergeTool.vcproj

?????文件???????9079??2009-12-08?14:14??Server\JX3ServerMergeTool\src\KDBbase.cpp

?????文件???????3437??2009-12-22?06:06??Server\JX3ServerMergeTool\src\KDBbase.h

?????文件???????1152??2009-11-24?18:06??Server\JX3ServerMergeTool\src\KFellowshipDef.h

?????文件???????1281??2009-12-22?06:06??Server\JX3ServerMergeTool\src\KMailDef.h

?????文件???????2936??2009-12-18?06:06??Server\JX3ServerMergeTool\src\KMergeSettings.cpp

?????文件????????636??2009-12-14?18:08??Server\JX3ServerMergeTool\src\KMergeSettings.h

?????文件??????58644??2010-01-08?09:05??Server\JX3ServerMergeTool\src\KMergeTool.cpp

............此處省略770個文件信息