C++ 连接Oracle
来源:互联网 发布:知乎 刘志军高铁贡献 编辑:程序博客网 时间:2024/06/11 22:04
欢迎技术交流。 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 唉!!!
- C连接Oracle(转)
- c#oracle连接
- C语言连接Oracle
- C#连接Oracle数据库
- c#,oracle的连接字符串
- C#(.Net) 连接 ORACLE数据库
- linux C/C++ 连接oracle
- jdbc连接Oracle 12c
- C#Winform连接Oracle数据库
- PLSQL 连接 oracle 12c
- Oracle 12c JDBC 连接
- OCI连接oracle 12C
- navicat连接oracle 12c
- C语言连接oracle实例
- C#.NET连接oracle的客户端方式
- C#.NET连接oracle的客户端方式
- 使用Pro *C连接Oracle 数据库
- pro*c连接oracle 简单增删改
- Node.js零起点开发(二)-require的用法
- MySql中文乱码错误 mysql error 1366 incorrect string value 不能插入中文字符
- [置顶] android 实现发送彩信方法 (MMS),非调用系统彩信界面
- regulator
- 数据库 视图
- C++ 连接Oracle
- 条码配置正式库与测试库同步
- 十步构建大型网站架构
- 三年工作感悟
- VC多文档初始框架视图最大化
- 获取一个表内的外键字段名,以及外键字段名对应的外键表名
- Linux C 编程实战--阅读笔记
- 最高法院对灵武死刑案进行远程视频提讯复核-死刑复核-杀人案
- 前途...