vc odbc

来源：互联网发布：mac 磁盘修复编辑：程序博客网时间：2024/06/06 01:54

CDatabase m_dbAgent;
m_dbAgent.OpenEx("DSN=EIDSQL;UID=sa;PWD=123456");
CString sql,str;
//CTime tCurTime;
CString strCurTime;
CRecordset *p_rs=new CRecordset;    //定义记录集对象指针
p_rs->m_pDatabase=&m_dbAgent;    //使数据库指向m_dbAgent
sql = _T("select getdate() as CurTime");    //使用集函数查询对象个数
p_rs->Open(AFX_DB_USE_DEFAULT_TYPE,sql);    //获得有效的查询记录集
p_rs->GetFieldValue("CurTime",strCurTime); //取出查询记录集中的数据
p_rs->Close();
m_dbAgent.Close();
delete p_rs;

// CUserSet

CUserSet *m_pUserSet;
CUserSet m_UserSet;

IMPLEMENT_DYNAMIC(CUserSet, CRecordset)

CUserSet::CUserSet(CDatabase* pdb)
: CRecordset(pdb)
{
//{{AFX_FIELD_INIT(CUserSet)
m_ID = 0;
m_PC_IP = _T("");
m_ProgramVersion = 0;
m_UserAuthority = 0;
m_nFields = 4;
m_pUserSet = &m_UserSet;
//}}AFX_FIELD_INIT
m_nDefaultType = dynaset;
}

CString CUserSet::GetDefaultConnect()
{
return _T("ODBC;DSN=EIDSQL;UID=sa;PWD=123456;");
}

CString CUserSet::GetDefaultSQL()
{
return _T("[dbo].[User1407]");
}

void CUserSet::DoFieldExchange(CFieldExchange* pFX)
{
//{{AFX_FIELD_MAP(CUserSet)
pFX->SetFieldType(CFieldExchange::outputColumn);
RFX_Long(pFX, _T("[ID]"), m_ID);
RFX_Text(pFX, _T("[PC_IP]"), m_PC_IP);
RFX_Long(pFX, _T("[ProgramVersion]"), m_ProgramVersion);
RFX_Long(pFX, _T("[UserAuthority]"), m_UserAuthority);
//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CUserSet diagnostics

#ifdef _DEBUG
void CUserSet::AssertValid() const
{
CRecordset::AssertValid();
}

void CUserSet::Dump(CDumpContext& dc) const
{
CRecordset::Dump(dc);
}
#endif //_DEBUG