1,利用SQL词句理论上可以使用任何数据库,以sql为例.
body.clientHeight)this.width=body.clientHeight" src="http://www.338888.com/VCShare/images/upfile/200461521239.jpg" onmousewheel="return yuzi_img(event,this)">
2,使用方法
void CTestODBCDlg::OnUseSql() { CSetODBC dlg; dlg.SetFileName( "f://setodbc.con"); dlg.SetAppName("test"); const CString strConnect = dlg.GetConnectStr();//获得连接串 CString strSQL; CDatabase db; db.OpenEx(strConnect);//打开数据库 {//追加记录 strSQL = "insert into character(Name,Country,Age) values(/'he/',/'china/',24)"; db.ExecuteSQL(strSQL); } {//删除记录 strSQL.Format("delete from character where Age = %d",24); db.ExecuteSQL(strSQL); } {//修改记录 strSQL.Format("update character set age = 25 where name = /'he/'"); db.ExecuteSQL(strSQL); } //显示所有记录 { CString strOutPut ; CRecordset rs(&db); rs.Open(CRecordset::snapshot,"select * from character"); int nField = rs.GetODBCFieldCount(); while(!rs.IsEOF()) { for(int i = 0 ; i < nField ; i++) { CString strTemp; rs.GetFieldValue((short)i,strTemp); strTemp.TrimLeft(); strTemp.TrimRight(); strOutPut +=(strTemp + '/t'); } strOutPut += "/n"; rs.MoveNext(); } rs.Close(); AfxMessageBox(strOutPut); } db.Close(); }
3,相关信息记录在f://setodbc.con,其内容为:
[test] DSN=testodbc_sql UID=sa PWD=
4,如果用户想重新设置ODBC,则:
void CTestODBCDlg::OnResetOdbc() { CSetODBC dlg; dlg.SetFileName( "f://setodbc.con"); dlg.SetAppName("test"); const CString strConnect = dlg.GetConnectStr(true);//重新设置ODBC }