΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
1999 18 1 Vol.18 No.1 1999



VC 5.0¿ݿӿӦ
÷ϼƼ
ժҪVC 5.0»MFC⿪ݿӿӦóķ
ؼʣݿӿڡMFC⡡ݿ⻥ODBC
ODBCMicrosoft Windows Open Services Architecture(WOSA)ݿⲿ֣ṩAPIʹӦóԴݿϵͳ(DBMS)ͨODBCնû1ӦóзʲͬݿеݡMFCݿĿ꣬ҪΪԱṩڷODBCԴĸ߼C++Microsoft Windows APIǻODBCģԱ֤ڲɲԡͨ²ҪֱӵODBC API
ͼ1˵ӦóݿࡢODBCDBMS֮Ĺϵ

ͼ1ݿӦóιϵ
1MFCݿ
1.1CDatabase(ݿ)
ҪԴӡ1CDatabase1ԴԺ󣬿ɹ¼ԴʹҪرCDatabase󣬽䳷1µӡ
1.2CRecordset(¼)
Ӧó򴴽¼1ʱҪָԴҪõı͸ñСVCӦóܻԶдCRecordsetGetDefaultSQLԱظñơӦóͨ¼1RFX(¼ֶν)ʽֶݳԱԴĶӦ֮䴫ݡ
1.3CRecordView(¼)
ֱ1¼ö̬ݽ(DDE)ʽѼ¼ǰ¼ֶεֵ͵ʽУѸ¹Ϣͻص¼Сṩ1ڶԻԴģݿʽƱӳؼ¼ֶݳԱ
2VC 5.0ʵӦóݿĽӿ
ͨ1ӽMFCݿ༰ݿ࿪ݿӿӦõķװ32λODBC Driver Manager̬ӿ32λODBCPowerBuilder 5.0п1Ϣݿ⣬Ϊbookcase.pblΪӦýӿݿ⡣忪Ϊ
1.AppWizardУڵĵĿ(ĿΪdbtest.mdp)ڹݿ֧ѡѡ3(4)ߵҪǵ4ѡ1ݿ⣬1ļļڱ桰֮ϢʹûáͿٻָݿĶ滻ӡġData Sourceť1ݿѡԻѡڡODBCԴ(ѡbookcaseԴ)ѡ¼ΪsnapshotͣOKťѡݿԻڸöԻгѡݿбѡӵıOKءò贴ӦóݿӵࡢļԴ
2.Ӧó档Դģ壬߻ῴAppWizardԶ1IDΪIDDDBTESTFORMĶԻģԴԴӦûĽ档нöԻƳ5༭(ʾ¼ֵ)IDŷֱΪIDCEDIT1IDCEDIT2IDCEDIT5ڱ༭ǰӦ̬ıֱΪߡ硱۸񡱣ݼ顱
3.Ѽ¼ֶView˵ClassWizardԻڴ˰ѡбкͼ¼ҲɴӼ¼ȥһЩҪжӦݳԱɸ¼¼Էӳ仯ԴСЩܶClassWizardѡCDbtestSetMember Variablesʵ֣ǳ򵥣˴׸
󣬴dbtestSet.hļԶ±
class CDbtestSet:public CRecordset
{ public:

//{{AFX-FIELD(CDbtestSet,CRecordset)
CString m-booktitle;
CString m-bookauthor;
CString m-bookpublisher;
CString m-bookprice;
CString m-bookabstract;
//}}AFX-FIELD

}
ͬʱCDbtestSet.cppļеDoFieldExchange(CFieldExchange*pFX)нѡбкͼ¼ֶݳԱ£
void CDbtestSet::DoFieldExchange(CFieldExchange*pFX)
{
//{{AFX-FIELDMAP(CDbtestSet)
pFX->SetFieldType(CFieldExchange::outputColumn);
RFX-Text(pFX,-T(book-title"),m-book-title);
RFX-Text(pFX,-T(book-author"),m-book-author);
RFX-Text(pFX,-T(book-publisher"),m-book-publisher);
RFX-Text(pFX,-T(book-price"),m-book-price);
RFX-Text(pFX,-T(book-abstract"),m-bookabstract);
//}}AFXFIELDMAP
}
4.ѸʽĿӳɼ¼ֶΡCRecordViewݿʽҪö̬ݽ(DDE)ڸʽĿʽؼ¼ֶݳԱ֮佻ݡԣҪĹǰѸʽĿӳ䵽¼У£
(1)ѡClassWizardMember Variables
(2)Class NameУѡ¼֣
(3)Control IDsУѡ1ID(ΪIDC-EDIT1IDC-EDIT5)
(4)ѡAdd Variableť1ÿصı
(5)Add Member VariableԻУͨѡMember Variable Nameбе1¼ݳԱѡ1
(6)ѡOKťرAdd Member VariableԻ
(7)Լ¼Ҫӳɼ¼ֶݳԱÿƣظ(3)(6)
(8)ѡOKťرClassWizard
⣬Visual C++Ի༭Ǵ򿪵ģʵֲݾ
ѡʽе1ƣCTRL˫꣬Class WizardAdd Member VariableԻ򣬴пɰѼ¼1ֶݳԱÿ
裬dbtestView.hļ¼1ԱmpSet,ñΪ1ָ¼ָ롣
dbtestView.cppļɴ£
void CDbtestView::DoDataExchange(CDataExchange*pDX)
{
CRecordView::DoDataExchange(pDX);
//{{AFX-DATA-MAP(CDbtestView)
DDX-FieldText(pDX,IDC-EDIT1,m-pSet->m-book-abstract,m-pSet);
DDX-FieldText(pDX,IDC-EDIT2,m-pSet->m-book-title,m-pSet);
DDX-FieldText(pDX,IDC-EDIT3,m-pSet->m-book-author,m-pSet);
DDX-FieldText(pDX,IDC-EDIT4,m-pSet->m-book-publisher,m-pSet);
DDX-FieldText(pDX,IDC-EDIT5,m-pSet->m-book-price,m-pSet);
//}}AFX-DATA-MAP
}
5.ӡ
ʱѾ1ݿӿӦó򣬶߿ִͨд˳ڽϿӦݿбݡ
6.Ҫʵ֡¼˼¼ǿܣ£
(1)Լ¼ָ˳ڹ֮󣬵OpenԱ֮ǰ¼дͨCDbtestSetĹ캯ʵ֡У£
CDbtestSet::CDbtestSet(CDatabase*pdb)
:CRecordset(pdb)
{
mstrSort=bookprice DESC,bookauthor ASC";
}
УDESCָУASCָСָ2׼Ȱ1׼ֵٰͬ2׼ơ
(2)Լ¼ָ׼ڹ֮󣬵OpenԱ֮ǰ¼Ĺ׼򡣱CDbtestSetĹ캯ʵ֣£
CDbtestSet::CDbtestSet(CDatabase*pdb)
:CRecordset(pdb)
{
mstrFilter=bookprice=`34.00'";
}
ӦóֻʾΪ34.00ԪĿ
ˣѳɼ򵥵ݿӿӦÿΪ߸õMFCݿϵ򿪷˼·м¼󡢼¼Ĺϵܽᣬͼ2

ͼ2¼¼Ķϵ
ͨĽͼΪϸؽVC5.0¿ݿӿӦó˼·̡ϣڴ˻Ͽ1ƵݿӿӦó
ߵλ人ѧѧԺ(430072)
ο
1Σ֣.Microsoft Visual C++2.0 for Win32ȫ(һ)ûָ.廪ѧ磬1996
2Τ.Visual C++Աοֲ.ѧ磬1995
(ոڣ1998-7-13)
