ODBC连接数据库_odbc_config.ini

        ::GetPrivateProfileString(_T("DataBaseConfig"),_T("DatabaseName"),_T("aut_uc"),DatabaseName,100,csConfigFilePath+_T("Config.ini"));
::GetPrivateProfileString(_T("DataBaseConfig"),_T("DatabaseSeverAddress"),_T("10.0.0.200"),DatabaseSeverAddress,100,csConfigFilePath+_T("Config.ini"));
::GetPrivateProfileString(_T("DataBaseConfig"),_T("DatabaseUserId"),_T("root"),DatabaseUserId,100,csConfigFilePath+_T("Config.ini"));
::GetPrivateProfileString(_T("DataBaseConfig"),_T("DatabaseUserPasswd"),_T("admin"),DatabaseUserPasswd,100,csConfigFilePath+_T("Config.ini"));

    SqlConnectExpress.Format(_T("ODBC;DSN=mysql;DATABASE=%s;Driver={MySQL ODBC 5.1 Driver};SERVER=%s;UID=%s;PASSWORD=%s;"),

LPCTSTR(DatabaseName), LPCTSTR(DatabaseSeverAddress), LPCTSTR(DatabaseUserId), LPCTSTR(DatabaseUserPasswd));
try
{
m_pdb=new CDatabase;
//m_pdb->Open(_T("aut_uc"),FALSE,FALSE,SqlConnectExpress);

m_pdb->OpenEx(SqlConnectExpress,0);
}
catch (const CDBException *pDBEx)
{
if (NULL != pDBEx)
{
AfxMessageBox(_T("数据库连接失败！请确认数据库参数配置是否正确！"));
return FALSE;
}

}

        CUserSet UserSet;
UserSet.m_pDatabase=((CCLogAuthenticaApp*)AfxGetApp())->m_pdb;
UserSet.Open(CRecordset::snapshot);//open时可带SQL语句

   //使用CRecordSet类进行查询

UserSet.MoveFirst();
while (!UserSet.IsEOF())
{

UserSet.属性;//操作

UserSet.MoveNext();

}

UserSet.Close();

if(m_pdb!=NULL)
m_pdb->Close();

Update操作(其他操作类似)

CString csSql=_T("UPDATE `autotransfertag` set VideoAutoTag=0 where VideoAutoTag=1");

        m_pdb->ExecuteSQL(csSql);

RecordFileSet在执行MoveLast()才能查出记录数

                RecordFileSet.MoveLast();
m_nAllPage=RecordFileSet.GetRecordCount();