使用自定义的类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();

}