C++ 连接Oracle

欢迎技术交流。 QQ：138986722

刚刚学习了C++、感觉学东西还是动手比较学得快一点！

下面是一个ADO方式连接Oracle的小程序部分代码......

首先是Oracle的配置、在Oracle的安装路径下找到：Oracle\network\ADMIN\tnsnames.ora文件、配置一下连接配置

BOSS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = boss)
    )
  )

新建一个头文件、名为CDBOperation.h：

#pragma once
#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF", "adoEOF")
class CDBOperation
{
public:
	//初始化数据库操作需要的对象
	CDBOperation(void);
	~CDBOperation(void);

	//连接至数据库
	bool ConnToDB(char *ConnectionString, char *UserID, char *Password);

	//数据库操作函数
	//查询操作 删除以及添加
	_RecordsetPtr ExecuteWithResSQL(const char *);

private:
	void PrintErrorInfo(_com_error &);

private:
	//初始化数据库连接、命令、记录集
	_ConnectionPtr CreateConnPtr();
	_CommandPtr CreateCommPtr();
	_RecordsetPtr CreateRecsetPtr();

private:
	//数据库连接需要的连接、命令操作对象
	_ConnectionPtr m_pConnection;
	_CommandPtr m_pCommand;
};

新建一个c++源文件、名为CDBOperation.cpp：

#include "stdafx.h"
#include "DBOperation.h"
CDBOperation::CDBOperation(void)
{
	CoInitialize(NULL);
	m_pConnection = CreateConnPtr();
	m_pCommand = CreateCommPtr();
}
CDBOperation::~CDBOperation(void)
{
	m_pConnection->Close();
}
bool CDBOperation::ConnToDB(char *ConnectionString, char *UserID, char *Password)
{
	if (NULL == m_pConnection)
	{
		printf("Failed to create connection\n");
		return false;
	}
	try
	{
		HRESULT hr = m_pConnection->Open(ConnectionString, UserID, Password, NULL);
		if (TRUE == FAILED(hr))
		{
			return false;
		}
		m_pCommand->ActiveConnection = m_pConnection;
		return true;
	}
	catch(_com_error &e)
	{
		PrintErrorInfo(e);
		return false;
	}
}
_RecordsetPtr CDBOperation::ExecuteWithResSQL(const char *sql)
{
	try
	{
		m_pCommand->CommandText = _bstr_t(sql);
		_RecordsetPtr pRst = m_pCommand->Execute(NULL, NULL, adCmdText);
		return pRst;
	}
	catch(_com_error &e)
	{
		PrintErrorInfo(e);
		return NULL;
	}
}
void CDBOperation::PrintErrorInfo(_com_error &e)
{
	printf("Error infomation are as follows\n");
	printf("ErrorNo: %d\nError Message:%s\nError Source:%s\nError Description:%s\n", e.Error(), e.ErrorMessage(), (LPCTSTR)e.Source(), (LPCTSTR)e.Description());
}

_ConnectionPtr CDBOperation::CreateConnPtr()
{
	HRESULT hr;
	_ConnectionPtr connPtr;
	hr = connPtr.CreateInstance(__uuidof(Connection));
	if (FAILED(hr) == TRUE)
	{
		return NULL;
	}
	return connPtr;
}

_CommandPtr CDBOperation::CreateCommPtr()
{
	HRESULT hr;
	_CommandPtr commPtr;
	hr = commPtr.CreateInstance(__uuidof(Command));
	if (FAILED(hr) == TRUE)
	{
		return NULL;
	}
	return commPtr;
}

_RecordsetPtr CDBOperation::CreateRecsetPtr()
{
	HRESULT hr;
	_RecordsetPtr recsetPtr;
	hr = recsetPtr.CreateInstance(__uuidof(Command));
	if (FAILED(hr) ==TRUE)
	{
		return NULL;
	}
	return recsetPtr;
}

我的代码是放在MFC一个按钮Click事件里面的：

记住在处理事件的cpp文件中导入头文件：#include "DBOperation.h"

CDBOperation dbOper;
	bool bConn = dbOper.ConnToDB("Provider=OraOLEDB.Oracle.1;Persist Security Info=True;Data Source=boss", "用户名", "密码");
	if (false == bConn)
	{
		MessageBox((LPCTSTR)"连接数据库出现错误\0",0,0);
		return;
	}

	//查询
	_RecordsetPtr pRst;
	char sql[255] = {0};
	strcpy(sql, " select * from boss_test_table2 where rownum = 1 ");
	pRst = dbOper.ExecuteWithResSQL(sql);
	if (NULL == pRst)
	{
		MessageBox(_T("查询数据出现错误！\0"),0,0);
		return;
	}
	if (pRst->adoEOF)
	{
		pRst->Close();
		MessageBox((LPCTSTR)"There is no records in this table\0",0,0);
		return;
	}
	_variant_t vSno, vName;
	while (!pRst->adoEOF)
	{
		//pRst->MoveFirst(); //记录集指针移动到查询结果集的前面
		vSno = pRst->GetCollect(_variant_t("U_NUMBER"));
		vName = pRst->GetCollect(_variant_t("USERS_NAME"));
		MessageBox((LPCTSTR)(_bstr_t)vSno,0,0);
		pRst->MoveNext();
	} 

	strcpy(sql, "insert into boss_test_table2 (u_number, users_name, users_phone, status, customno_id) values ('0001', 'C+TTT+', '13999000000', 2, 'BPPPPPPPPPP')");
	pRst = dbOper.ExecuteWithResSQL(sql);
	if (NULL != pRst)
	{
		AfxMessageBox(_T("插入数据成功\n"));
	}
	//执行删除语句
	sprintf(sql, "delete boss_test_table2 where u_number = '%s'", "009"); 
	pRst = dbOper.ExecuteWithResSQL(sql);
	if (NULL != pRst) 
	{
		MessageBox(_T("删除数据成功\0"),0,0);
	}
	//执行更新语句
	sprintf(sql, "update boss_test_table2 set users_name = '%s' ", "C++反人类、MFC反社会");
	pRst = dbOper.ExecuteWithResSQL(sql);
	if (NULL != pRst)
	{
		MessageBox(_T("更新数据成功\0"),0,0); 
	}

哎呀、又有工单了.......一个JS浏览器的兼容问题、有得搞了......o(︶︿︶)o 唉！！！