SunOS 5.10 sparc C/C++ 初学者之ORACLE

最新推荐文章于 2021-08-06 08:41:01 发布

钩子水手

最新推荐文章于 2021-08-06 08:41:01 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： C C++

本文链接：https://blog.youkuaiyun.com/lnpso/article/details/16855809

C C++ 专栏收录该内容

5 篇文章

订阅专栏

本文介绍如何配置OCCI环境并提供了一个使用C++编程语言连接Oracle数据库的示例。示例展示了创建环境、建立连接、执行查询及获取结果的全过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

OCCI环境

######################################### 
#       for Oracle
######################################### 
export ORACLE_HOME=/data/aifront/cpl/ora/10.2.0
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

<<helloOCCI.cpp>>

#include <occi.h>
#include <string>

using namespace std;
using namespace oracle::occi ;

int main() 
{
	try
	{
		string username = "ora";
		string password = "ora*123";
		/*
		$ORACLE_HOME/network/admin/tnsnames.ora 中
		oracle =
		  (DESCRIPTION =
		    (ADDRESS_LIST =
		      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
		    )
		    (CONNECT_DATA =
		      (SERVER = DEDICATED)
		      (SID = oradb)
		    )
		  )
		*/
		string connstr = "oracle"; 
		Environment* env = Environment::createEnvironment(Environment::OBJECT);;
		Connection* conn = env->createConnection( username.c_str() , password.c_str() , connstr.c_str() );
		cout << "连接成功！"<< endl;
		Statement* stmt = conn->createStatement();
		stmt->setSQL("select sysdate as p from dual");
		ResultSet* rs = stmt->executeQuery();
		while( rs->next() == true ) 
		{
			cout << rs->getString(1) << endl;
		}
		stmt->closeResultSet(rs);
		conn->terminateStatement(stmt);
		env->terminateConnection(conn);
		Environment::terminateEnvironment(env);
		cout << "关闭成功！"<< endl;
	} 
	catch(exception& ex)
	{
		cout << ex.what() << endl;
	}
}

<<makefile>

main:step_3
	CC -L/data/aifront/cpl/ora/10.2.0/lib32 -locci -lclntsh ./tmp/helloOCCI.o -o ./bin
step_3:step_2
	CC -c ./tmp/helloOCCI.s -o ./tmp/helloOCCI.o
step_2:step_1
	CC -S ./tmp/helloOCCI.i -o ./tmp/helloOCCI.s
step_1:
	CC -I/data/aifront/cpl/ora/10.2.0/rdbms/public -P ./src/helloOCCI.cpp -o ./tmp/helloOCCI.i
clean:
	rm -f ./tmp/* ./bin ./core

运行调试

[/data/aifront/cpl/others/demo03]make
CC -I/data/aifront/cpl/ora/10.2.0/rdbms/public -P ./src/helloOCCI.cpp -o ./tmp/helloOCCI.i
CC -S ./tmp/helloOCCI.i -o ./tmp/helloOCCI.s
CC -c ./tmp/helloOCCI.s -o ./tmp/helloOCCI.o
CC -L/data/aifront/cpl/ora/10.2.0/lib32 -locci -lclntsh ./tmp/helloOCCI.o -o ./bin
[/data/aifront/cpl/others/demo03]bin
连接成功！
21-NOV-13
关闭成功！
[/data/aifront/cpl/others/demo03]