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

来源：互联网发布：怎样做淘宝直通车编辑：程序博客网时间：2024/05/17 04:32

OCCI环境

######################################### #       for Oracle######################################### export ORACLE_HOME=/data/aifront/cpl/ora/10.2.0export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATHexport 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_3CC -L/data/aifront/cpl/ora/10.2.0/lib32 -locci -lclntsh ./tmp/helloOCCI.o -o ./binstep_3:step_2CC -c ./tmp/helloOCCI.s -o ./tmp/helloOCCI.ostep_2:step_1CC -S ./tmp/helloOCCI.i -o ./tmp/helloOCCI.sstep_1:CC -I/data/aifront/cpl/ora/10.2.0/rdbms/public -P ./src/helloOCCI.cpp -o ./tmp/helloOCCI.iclean:rm -f ./tmp/* ./bin ./core

运行调试

[/data/aifront/cpl/others/demo03]makeCC -I/data/aifront/cpl/ora/10.2.0/rdbms/public -P ./src/helloOCCI.cpp -o ./tmp/helloOCCI.iCC -S ./tmp/helloOCCI.i -o ./tmp/helloOCCI.sCC -c ./tmp/helloOCCI.s -o ./tmp/helloOCCI.oCC -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]