comandfun.cpp

将图片以blob数据的形式

// ComandFun.cpp: implementation of the CComandFun class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "PHOTOINSERT.h"
#include "ComandFun.h"

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

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

CComandFun::CComandFun()
{

}

CComandFun::~CComandFun()
{

}

void CComandFun::ConnDB()
{
	m_pConn = NULL;
	m_pRecord = NULL;

	CString		m_username="FGBKZK";
	CString 	m_passwd="FGBKZK";
	CString 	m_dbserver="FGBKZK";
	HRESULT     hr;
	try 
 	{
		hr = m_pConn.CreateInstance("ADODB.Connection");///创建Connection对象
		CString dbfile = "Provider=OraOLEDB.Oracle.1;Data Source=" + m_dbserver +
       ";User ID=" + m_username + "; Password=" + m_passwd;

		if(SUCCEEDED(hr)) 
 		{
 			if(m_pConn->State )
 				m_pConn->Close ();
 			
			m_pConn->ConnectionTimeout=5;  //超时时间设置为5 second
			hr = m_pConn->Open((_bstr_t)dbfile,"","",adModeUnknown);
		}
 	} 
	 catch(_com_error e)///捕捉异常 
 	{
 		CString errormessage; 
 		errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage()); 
 		AfxMessageBox(errormessage);///显示错误信息 
 	} 

}

void CComandFun::closeConn()
{
	m_pConn->Close();
}