database.cpp

水手俱乐部,有关数据库的搜索代码,可以进行添加,修改,以及删除

// Database.cpp: implementation of the CDatabase class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "水手俱乐部R.h"
#include "Database.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CDatabase::CDatabase()
{
	jn.CreateInstance(_uuidof(Connection));
	rst.CreateInstance(_uuidof(Recordset));
	//建立连接
	jn->ConnectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=jianing;Data Source=(local)";	
	try 
	{
		jn->Open(L"",L"",L"",adConnectUnspecified);
	}
	catch(_com_error * e)
	{
		AfxMessageBox("连接出错");
	}
}

CDatabase::~CDatabase()
{
	jn->Close;
}

_RecordsetPtr CDatabase::DealWithData(CString msql)
{//执行SQL语句
	
	rst->raw_Close();
	try 
	{
		rst->CursorLocation = adUseClient;
		rst->Open((_bstr_t)msql,jn.GetInterfacePtr(),adOpenKeyset,adLockOptimistic, adCmdText); 
		
	}
	catch(...)
	{
		AfxMessageBox("数据库出错");
	}

	
	return rst;
}