
COMPUTER ENGINEERING
1999 25 10 Vol.25 No.10 1999



ODBCVisual C++5.0 MFCݿӦó
ϲ
ժҪϸWindows 95ӦVisual C++ODBC MFCݿӦó򿪷ľ巽ͼɣMFCODBCлƣ˲Ӧʵ
ؼʣݿ⣬ODBCMFC
The ODBC Based Visual C++5.0 MFC Database Application Development
Yang Xizhong
(Department of Civil Engneeing,Guangdong University,Guangzhou,510090)
AbstractThe paper discusses upon the technology and method for developing ODBC MFC database application by Visual C++5.0,and then analyzes the running mechanism of MFC and ODBC.At last some application code is given.
Key wordsDatabase;ODBC;MFC
ϵݿϵͳķչ൱첢õ㷺ӦáͬݿϵͳݽṹĲ죬ɸݿڹͨݹ1993ģ΢һֳODBCݿ⻥ʹݿӦóĿ߲عݿַ͡ṹԼݿĹϵϸڣѶԲͬݿķʼ򵥵صһݿķʡĿǰODBCѵõݿҵĹ㷺֧֣WindowsOS/2Macintoshƽ̨ODBCͿߣݿ⡢̼߳Ӧ̶ṩODBC֧֡
1ODBCص
Visual C++ṩODBCйصMFCDatabaseCRecordSetCRecordView,CDatabaseṩԴӽӿڣͨʵֶԴĲCRecordSetṩ˴Դȡļ¼ڽӦóûֱӣCRecordViewͼͨؼʾݿеļ¼MFCݿӦóַǳҪݽƣ(1)Ӧó漴ԻеĿؼCRecordSetĳԱͨDDXԻݴDoDataExchange(CDataExchange*pDX)(2)CRecordsetĳԱͨRFX¼ֶݽDoFieldExchange(CFieldExchange*pFX)ԴӦֶν

ͼ1 Ҫݽ
2ӦODBCݿ̵Ĳ
(1) ϵͳעԴݿ⣬Microsoft Accessһݿļstudent.mdb,ݿStudentInfoȻWindow95Ŀ岢˫ODBC32ͼ,עʵݿ⡣
(2) AppWizardݿӦóڴУҪҪݿԣѡDatabase view with file supportѡDatabase view without file supportѡѡҪݿⲢѡҪıѡȱʡ
(3) ݿӦó֧ݿԵĴ롣
3ݿ¼ʾ
ӦԴ༭ԶԻ޸ģݿ¼ֶεͣڶԻмӦʾı༭;̬ǩÿ༭ԶԻIDźԡÿ༭ݿ¼һֶΣȻClassWizardʹԻеÿ༭ؼͼ¼ӦĳԱӡѡm_pSet->m_StudentNameа󶨣ͨѡӦóCRecordSetеĳԱΪӦóͼؼԱӶؼԴ֮ӡʱгͿʾݿеݡ
4֧ݿԵĴ
4.1 ݿ
ɵݿӦóͼаһָCRecordSet¼ָm_pSetָ뽨ͼ¼֮ϵʹͼܽ׵ʾ¼ӦĲѯ
¼
m_pSet->AddNew();//һռ¼
UpdateData(FALSE);//ÿռ¼ˢ¿ؼʾ
ɾ¼
m_pSet->Delete();//ɾǰ¼
m_pSet->MoveNext();
if(m_pSet->IsEOF())//Ƿڼ¼ĩβ
m_pSet->MoveLast();
if(m_pSet->IsBOF())//Ƿڼ¼ͷ
m_pSet->SetFieldNull(NULL);
UpdateData(FALSE);//ͼʾ
༭¼
m_pSet->Edit();
洢¼
UpdateData(TRUE);//ݴӿؼ͵¼
if(m_pSet->CanUpdate())//ȷԴǷɸ
m_pSet->Update();//¼¼ӵԴ
m_pSet->Requery();//ؽ¼
UpdateData(FALSE)////ˢͼʾ
4.2 ݿ͹
ݿȹرռ¼趨ֶSQLOrderbyַm_strSortȻٴ򿪼¼
m_pSet->Close();//رռ¼
m_pSet->m_strSort="Name";//ֶ
m_pSet->Open();//´򿪼¼
UpdateData(FALSE);//źļ¼ͼ
ݿ:ȹرռ¼趨ַSQLWherem_strFilterȻٴ򿪼¼
m_pSet->Close();//رռ¼
m_pSet->m_strFilter="Name='Yang'";//ùַ
m_pSet->Open();//´򿪼¼
int Recount=m_pSet->GetRecordCount();
if (Recount==0){
m_pSet->Close();
m_pSet->m_strFilter="";
m_pSet->Open();}
UpdateData(FALSE);
5ݿĶ
Visual C++5.0 AppWizardݿӦóʱͨѡԴĵвʱݿӦóҪʵͬʱԶвзʵ֣
5.1 ͬϲ
ݿӦóClassWizardµCRecordSetʱԴͬʱѡʱɵCRecordSetǽѡĸֶμһͬÿһͬ3:table1,table2,table3(table1table2Ľṹͬ)Ĳִ룺
voidCMydbSet::DoFieldExchange(CFieldExchange*pFX)
{//{{AFX_FIELD_MAP(CMydbSet)
pFX->SetFieldType(CFieldExchange::outputColumn);
RFX_Text(pFX,_T("[table1].[name]"),m_name);

RFX_Text(pFX,_T("[IDCard]"),m_IDCard);
//}}AFX_FIELD_MAP
}
CString CMydbSet::GetDefaultSQL()
{
return_T("[table1],[table2],[table3]");
}
5.2 ͬʱ첽
ʱݿӦóҪ첽ʱClassWizardԴеĸֱ𴴽ԵCRecordSetйʵֶԸв
5.3 ͬͶл
ݿӦóҪ첽ĶͬṹΪͬʱҲɶԴеĸֱ𴴽ԵCRecordSetйʵֶԸв˱̹ԣͨͬCRecordSet࣬ԷǵĹɴ󲿷ͬģڸԵĳԱGetDefaultSQL()صıͬһĸúΪ
CString CSet1::GetDefaultSQL()
{return_T("[table1]");
}
ݿӦó򴴽µCRecordSetʱѡݿѡһ˺ٶԸĳԱGetDefaultSQL()޸ģΪһַڴĳض֮ǰַͨ_T("[table2]")ַTableNameͿʵͬһCRecordSetԶͬж磺
CString CSet1::GetDefaultSQL()
{return_T(TableName);
}
6
ӦVisual C++5.0ODBCMFCݿӦóĿɲݿ⣬ҲݿϵͳĲûɽͬݿķʼ򵥵صһݿķʣ˿ĹʹõĿֲԺݿĶԼԡ
߼飺ϲУ1964УڣоGISݿϵͳAuto CADĿý弼
ߵλ㶫ҵѧľϵ510090
ο
1 Kruglinski D J.ӡ.Visual C++Ļ.廪ѧ ,1994
2 Gregory K,.Visual C++5ʹֲ.еҵ ,1998
ոڣ1999-02-09
