VC SQL2000 获取总的行数两种方法

最新推荐文章于 2025-08-24 16:28:01 发布

原创最新推荐文章于 2025-08-24 16:28:01 发布 · 1.6k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

VC/SQL

本文介绍使用ADO通过两种方法查询数据库并获取记录总数的过程。方法一采用分步查询的方式，而方法二则直接通过COUNT函数计算特定字段的不同值数量。

// 方法1 CString strSQL; //1 strSQL.Format("SELECT SID FROM Equipment group by SID");//得到总的行数 CoInitialize(NULL); _ConnectionPtr m_pConnection; _RecordsetPtr m_pRecordset; try{ m_pConnection.CreateInstance("ADODB.Connection"); m_pConnection->CursorLocation=adUseClient; //1 游标类型 m_pConnection->ConnectionString="Provider=SQLOLEDB.1;Password=; / Persist Security Info=True;User ID=sa;Initial Catalog=PTMSE"; m_pConnection->Open("","","",adConnectUnspecified);// } catch(...) { MessageBox("数据库连接失败!"); } m_pRecordset=m_pConnection->Execute((_bstr_t)strSQL,NULL,adCmdText);//select * from History_Record authors // CString str=(LPCSTR)_bstr_t(m_pRecordset->Fields->GetCount());//得到查询字段长度 //1。 // long count=(long)(m_pRecordset->GetRecordCount());//();// long count=(long)(m_pRecordset->RecordCount); CString str; str.Format("%d",count); MessageBox(str); m_pRecordset->Close(); m_pConnection->Close(); m_pRecordset.Release(); m_pConnection.Release(); CoUninitialize(); //方法2： CString strSQL; //2{{{ strSQL.Format("SELECT count(distinct(SID)) as Total FROM Equipment");// CoInitialize(NULL); _ConnectionPtr m_pConnection; _RecordsetPtr m_pRecordset; try{ m_pConnection.CreateInstance("ADODB.Connection"); m_pConnection->CursorLocation=adUseClient; //1 游标类型 m_pConnection->ConnectionString="Provider=SQLOLEDB.1;Password=; / Persist Security Info=True;User ID=sa;Initial Catalog=PTMSE"; m_pConnection->Open("","","",adConnectUnspecified); } catch(...) { MessageBox("数据库连接失败!"); } m_pRecordset=m_pConnection->Execute((_bstr_t)strSQL,NULL,adCmdText);//select * from History_Record authors // 2。 // CString str=(LPCSTR)(_bstr_t)m_pRecordset->GetCollect("Total");//直接由程序得到结果，总的纪录数 // MessageBox(str); m_pRecordset->Close(); m_pConnection->Close(); m_pRecordset.Release(); m_pConnection.Release(); CoUninitialize();

标签

#sql #security #null #数据库