oracle测试程序,OCCI?测试程序

所谓OCCI就是 Oracle C++ Call Interface 的简写，即通过C++的方式访问oracle数据库。

一直以来都在用.net做oracle的客户端，最近的项目里用到了OCCI，正好学习一下。

测试环境如下：

Oracle Database 11.2.0.1

Oracle Instance Client 11.2.0.3

Visual Studio 2010

首先看一下测试程序的运行结果：如下图：

项目路径是..TestOCCI，下载的occi的dll和lib文件copy到occivc10的lib目录

然后就是代码

首先是stdafx.h

// stdafx.h : include file for standard system

include files,

// or project specific include files that are used frequently,

but

// are changed infrequently

//

#pragma once

#include “targetver.h”

#include

#include

#include

#include

// TODO: reference additional headers your program

requires here

其中iostream.h和occi.h是新加上去的

然后是程序代码了

//

TestOCCI.cpp : Defines the entry point for the console

application.

//

#include “stdafx.h”

using namespace std;

using namespace oracle::occi;

int _tmain(int argc, _TCHAR*

argv[])

{

cout

OCCI!”

const string user

= “ltdb”;

const string pass

= “ltdb”;

const string osid

= “ltdb”;

Environment* const env =

Environment::createEnvironment

(Environment::DEFAULT);

int ret =

0;

try

{

Connection* const con =

env->createConnection(user, pass,

osid);

cout

Statement *stmt = con->createStatement

(“Select sysdate from

dual”);

ResultSet *rs = stmt->executeQuery ();

rs->next();

Date dt = rs->getDate (1);

cout

in database: ”

cout

connection.”

env->terminateConnection (con);

}

catch (SQLException

ea)

{

cerr

connect: ”

();

ret = 1;

}

Environment::terminateEnvironment (env);

system(“PAUSE”);

return 0;

}

程序很简单，不解释了，感觉OCCI怎么入门是比较烦人的地方，尤其是要知道用什么库，还有项目怎么配置，一旦运行成功了就可以开始具体内容的学习了。

相关资源：鸿威台球室计费系统说明书_棋牌室管理系统-专业指导文档类资源…