Question

求C++连接oracle 数据库的代码

Answer 1

#include <DbManager.h>
#include <iostream>

using namespace std;

using namespace oracle::occi;

const string sqlString("select empno, ename from employee");

int main(int argc, char **argv)

{
if (argc != 2)
{
cerr << "\nUsage: " << argv[0] << " <db-user-name>\n" << endl;
exit(1);
}

// Initialize OracleServices

DbManager* dbm = NULL;

OracleServices* oras = NULL;

Statement *stmt = NULL;

ResultSet *resultSet = NULL;

try
{

// Obtain OracleServices object with the default args.

dbm = new DbManager(userName);

oras = dbm->getOracleServices();

// Obtain a connection

Connection * conn = oras->connection();

// Create a statement

stmt = conn->createStatement(sqlString);

int empno;

string ename;

// Execute query to get a resultset

resultSet = stmt->executeQuery();

while (resultSet->next())
{

empno = resultSet->getInt(1); // get the first column returned by the query;

ename = resultSet->getString(2); // get the second column returned by the query

if (resultSet->isNull(1))
{
cout << "Employee Number is null... " << endl;
}
if (resultSet->isNull(2))
{
cout << "Employee Name is null..." << endl;
}

cout << empno << "\t" << ename <<endl;

}

// Close ResultSet and Statement

stmt->closeResultSet(resultSet);

conn->terminateStatement(stmt);

// Close Connection and OCCI Environment

delete dbm;

}
catch (SQLException& ex)
{
if (dbm != NULL)
{
dbm->rollbackActions(ex, stmt, resultSet); // free resources and rollback transaction
}
}

return 0;
}

追问

希望能给出示例源码

Answer 2

MS 的ODBC 驱动就行了。
不过在处理BLOB 问题的时候 会出现问题

你得到oracle 的官网上下 他的 ODBC 驱动 才可以。
安装后 和普通的ODBC 开发没区别

注意的就是再插入BLOB 对象类型的时候 先要插入一行空的 再进行update希望有所提示，有空到51cto,365testing进一步交流!