我现在只会批量读取.//根据员工编号读取所有字段值
void Cinfo_base::GetData(CString cKSH)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置SELECT语句
_bstr_t vSQL;
vSQL = "SELECT * FROM info_base WHERE KSH=" + cKSH;
//执行SELETE语句
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
//返回各列的值
if (m_pRecordset->adoEOF && m_pRecordset->adoBOF)
{
Cinfo_base::Cinfo_base();
}
else
{
KSH = cKSH;
XM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("XM");
XBDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("XBDM");
CSRQ = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("CSRQ");
BYXXDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BYXXDM");
BJH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BJH");
MZDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MZDM");
ZZMMDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ZZMMDM");
YZBM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("YZBM");
KSLBDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("KSLBDM");
XJH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("XJH");
HKSZD = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("HKSZD");
LXDH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LXDH");
SFZH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("SFZH");
BZ = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BZ");
}
//断开与数据库的连接
m_AdoConn.ExitConnect();
}读取没有规律的记录怎么做?
void Cinfo_base::GetData(CString cKSH)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置SELECT语句
_bstr_t vSQL;
vSQL = "SELECT * FROM info_base WHERE KSH=" + cKSH;
//执行SELETE语句
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
//返回各列的值
if (m_pRecordset->adoEOF && m_pRecordset->adoBOF)
{
Cinfo_base::Cinfo_base();
}
else
{
KSH = cKSH;
XM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("XM");
XBDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("XBDM");
CSRQ = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("CSRQ");
BYXXDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BYXXDM");
BJH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BJH");
MZDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MZDM");
ZZMMDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ZZMMDM");
YZBM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("YZBM");
KSLBDM = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("KSLBDM");
XJH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("XJH");
HKSZD = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("HKSZD");
LXDH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LXDH");
SFZH = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("SFZH");
BZ = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BZ");
}
//断开与数据库的连接
m_AdoConn.ExitConnect();
}读取没有规律的记录怎么做?
解决方案 »
- 跪求 单服务器 多客户端数据交互源码 最好是VC的
- 一个进程中使用两个exe,实现模态对话框效果!
- 向老手求教(急):VC 中如何使用SSTab控件来实现多个View之间的切换?(火攻心)
- 高手进!
- 编译时出现这种奇怪的错误怎么办?
- CSocket::bind() 总是返回0。这是怎么回事啊?
- 朋友问个问题, 不知道咋答........
- 如何在程序启动时隐藏对话框,急需,最好有源代码
- 想认识对用ATL编写复合控件有经验的人,有几个问题请教?请留下你的联系方式
- 请问:在Class View 里面,类的成员函数前加上了一把黄色的钥匙,或一把灰色的琐头是什么意思啊。
- 紧急求助!!预编译问题!
- 高手进!
就象这样做
_RecordsetPtr Cinfo_base::Get()
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置SELECT语句
_bstr_t vSQL;
vSQL = "SELECT ksh,xm,xbdm,CSRQ FROM info_base where ksh='131100009'" ;
//执行SELETE语句
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
//返回各列的值
vSQL = "SELECT ksh,xm,xbdm,CSRQ FROM info_base where ksh='131100033'";
m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
return m_pRecordset;
//断开与数据库的连接
m_AdoConn.ExitConnect();
}