mysql输出字段名_vc 连接,mysql怎么输出表中的字段名呀，请您指教

#include"data.h"voidDate::sql_insert(_bstr_tsql){ADOConnm_AdoConn;m_AdoConn.OnInitADOConn();_bstr_tvSQL;vSQL=sql;//插入信息m_AdoConn.ExecuteSQL(vSQL);m_AdoConn.ExitConnec...

#include"data.h"

void Date::sql_insert(_bstr_t sql)

{

ADOConn m_AdoConn;

m_AdoConn.OnInitADOConn();

_bstr_t vSQL;

vSQL=sql;

//插入信息

m_AdoConn.ExecuteSQL(vSQL);

m_AdoConn.ExitConnect();

MessageBox(NULL,"保存体检信息成功！" , "提示", 0);

}

//--------------------------------------------------------------------------------------------

//2.2 SELECT查询

//--------------------------------------------------------------------------------------------

void Date::sql_select(_bstr_t sql)

{

ADOConn m_AdoConn;

ADOConn m_pConnection;

m_AdoConn.OnInitADOConn();

_bstr_t vSQL;

vSQL=sql;

_RecordsetPtr m_pRecordset;

m_pRecordset=m_AdoConn.GetRecordSet(vSQL);

m_pRecordset.CreateInstance(_uuidof(Recordset));

m_pRecordset->Open(vSQL,m_AdoConn.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);

_variant_t va,vb,vc;

cout<

m_pRecordset->MoveFirst();

Date osg;

int i=0;

while(!m_pRecordset->adoEOF)

{

osg.a[i]=m_pRecordset->GetCollect(_variant_t((long)0));

osg.e[i]=m_pRecordset->GetCollect(_variant_t((long)1));

osg.f[i]=m_pRecordset->GetCollect(_variant_t((long)2));

osg.g[i]=m_pRecordset->GetCollect(_variant_t((long)3));

osg.h[i]=m_pRecordset->GetCollect(_variant_t((long)4));

osg.l[i]=m_pRecordset->GetCollect(_variant_t((long)5));

cout.setf(ios::left);

BOOL Date::GetFieldsName(_RecordsetPtr RcdPtr, int nField, _variant_t & strFieldName)

{

if(NULL == RcdPtr || nField >= RcdPtr->GetFields()->Count)

return FALSE;

_variant_t vt((long)nField);

strFieldName.Format(_T("%s"), (char*)(RcdPtr->GetFields()->Item[vt]->Name));

return true;

}

//获取字段个数函数

int Date::GetFieldsCount(_RecordsetPtr RcdPtr)

{

int nCount=0;

if(NULL != RcdPtr)

{

nCount = RcdPtr->GetFields()->Count;

}

return nCount;

}

展开