1.添加ODBC 类
2.定义数据库链接
#define DATABASE_OPEN_SQL "DRIVER={Progress OpenEdge 10.2B Driver};DSN=asd;DB=zxc;UID=vfr;PWD=kjh;HOST=192.0.21.45;PORT=54198;"
3.操作数据库
CRecordset rs;
odbc m_odbc;
void GetSQLData()//查询
{
m_odbc.Open(NULL,false,false,_T(DATABASE_OPEN_SQL),true);
if(m_odbc.IsOpen())
{
rs.m_pDatabase = &m_odbc;
CString s;
rs.Open(CRecordset::forwardOnly, _T("select * from pub.els_name"));//表名els_name
if(rs.IsOpen())
{
CString strVal;
while(!rs.IsEOF())
{
rs.GetFieldValue((short)0,strVal);//获取第一行第一列数据
rs.GetFieldValue((short)1,strVal);//获取第一行第二列数据
//依此类推
//...
//
rs.MoveNext();//搜索下一行数据
}
}
m_odbc.Close();
}
}
void Insert()//插入
{
m_odbc.Open(NUL