使用自定义的类CSetODBC(一)

                                         

何志丹

1,理论上支持任何数据库,以Acess为例,结构如下图

body.clientHeight)this.width=body.clientHeight" src="http://www.338888.com/VCShare/images/upfile/2004615211236.jpg" onmousewheel="return yuzi_img(event,this)">

2,相关信息记录在ini或注册表中,其结构为:

[数据源]
DSN=TestODBC
UID=admin
PWD=

3,动态绑定一个类,更改GetDefaultConnect
CString CCharacterSet::GetDefaultConnect()
{
CSetODBC dlg;
CString strConnect = "ODBC;" + dlg.GetConnectStr();
return _T(strConnect);//动态取得ODBC
//return _T("ODBC;DSN=TestODBC");
}

4,使用
void CTestODBCDlg::OnRecordset()
{
CCharacterSet rs;
CSetODBC dlg;
rs.Open(dlg.GetWriteDBStyle());

{//增加记录
rs.AddNew();
rs.m_Name = "典韦";
rs.m_Age　= 60;
rs.m_country = "魏";
rs.Update();
}
{//修改记录
rs.MoveFirst();
while(!rs.IsEOF())
{
if("典韦" == rs.m_Name)
{
rs.Edit();
rs.m_Age = 59;
rs.Update();
}
rs.MoveNext();
}
}
{//删除记录
rs.MoveFirst();
while(!rs.IsEOF())
{
if("典韦" == rs.m_Name)
{
rs.Delete();
rs.Requery();
}
rs.MoveNext();
}
}
{//显示所有记录
rs.MoveFirst();
CString strOutPut;
while(!rs.IsEOF())
{
CString strRecord;
rs.m_Name.TrimLeft();
rs.m_Name.TrimRight();
rs.m_country.TrimLeft();
rs.m_country.TrimRight();
strRecord.Format("Name = %s /tCountry = %s /tAge = %d /n",rs.m_Name,rs.m_country,rs.m_Age);
strOutPut += strRecord ;
rs.MoveNext();
}
AfxMessageBox(strOutPut);
}
rs.Close();
}