简单数据库操作

 

#pragma once

 

class CAccseeDB

{

public:

CAccseeDB(void);

~CAccseeDB(void);

 

void ExecuteSQL(CString strSQL);

void Query(CString strSQL, CRecordset* prs);

CDBVariant QueryOne(CString strSQL);

protected:

CDatabase m_db;

};

#include "StdAfx.h" #include "AccseeDB.h" CAccseeDB::CAccseeDB(void) { CString strDriver = "MICROSOFT ACCESS DRIVER (*.mdb)"; CString strDSN; strDSN.Format("ODBC;DRIVER={%s};UID=;PWD=;DBQ=H://db1.mdb", strDriver); m_db.Open(NULL,0,0,strDSN); } CAccseeDB::~CAccseeDB(void) { m_db.Close(); } void CAccseeDB::ExecuteSQL(CString strSQL) { m_db.ExecuteSQL(strSQL); } void CAccseeDB::Query(CString strSQL, CRecordset* prs) { prs->m_pDatabase = &m_db; prs->Open(CRecordset::forwardOnly, strSQL); } CDBVariant CAccseeDB::QueryOne(CString strSQL) { CDBVariant var; CRecordset rs; Query(strSQL, &rs); if(!rs.IsBOF()) { rs.GetFieldValue((short)0,var); rs.Close(); } return var; } try { } catch(CDBException e)  {   AfxMessageBox("Database Error:" + e.m_strError);  }