sql.cpp

万能sql读取 获取sql命令

void XXX::OnRefreshData(CListCtrl &m_List,CString sql)
{
	CString str,temp;
	m_List.DeleteAllItems();
	//m_messset.MoveFirst();
	CRecordset   *pRs;   
	pRs=new CRecordset(&m_database);   
	pRs->Open(CRecordset::forwardOnly,sql);
//CRecordset::dynaset	动态记录，可双向滚动。
//CRecordset::forwardOnly	只读，只能向前滚动
//CRecordset::dynamic	可双向滚动
	int i=0,j=0;
	int	Count=0;
	while(!pRs->IsEOF())
	{
		while(pRs->IsDeleted())
		{
			pRs->MoveNext();
		}
		j=0;
		pRs->GetFieldValue((short)j,str);
		str.TrimRight();
		m_List.InsertItem(i,str);
		for(int j=1;j < (pRs->GetODBCFieldCount());j++)
		{
			pRs->GetFieldValue((short)j,str);
			//		str=m_messset.m_SailorName;
			str.TrimRight();
			m_List.SetItemText(i,j,str);
	
		}
		pRs->MoveNext();
	}
	Count=pRs->GetRecordCount();//获得检索过的记录数
}