linux下连接oracle数据库

《linux下连接oracle数据库》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、源代码 C++代码1.#include   2.#include   3.#include "occi.h"  4.using namespace oracle::occi;  5.using namespace std;  6.  7.int main()  8.{  9.        string usr="sys";  10.        string pwd="orcl";  11.        string SID="ORCL";  //注意大小写12.        string date;  13.  14.        Envir

2、onment *env=Environment::createEnvironment(Environment::OBJECT);  15.        Connection *conn= env->createConnection(usr,pwd,SID);//all strings  16.        if(conn)  17.                cout<<"success createConnection!"<

3、endl;  20.  21.        Statement *stmt = conn->createStatement();  22.        string sSQL = "select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual";  23.        stmt->setSQL(sSQL);  24.  1.  2.        ResultSet *rs = stmt->executeQuery();  3.        if(rs->next())  4.        {  5.             

4、   date = rs->getString(1);  6.        }  7.  8.        cout<<"now time :"<terminateConnection(conn);  11.        Environment::terminateEnvironment(env);  12.  13.        return 0;  14.}  15.    #include#include#include"occi.h"usingnamespaceoracl

5、e::occi;usingnamespacestd;intmain(){stringusr="sys";stringpwd="orcl";stringSID="ORCL";stringdate;Environment*env=Environment::createEnvironment(Environment::OBJECT);Connection*conn=env->createConnection(usr,pwd,SID);//allstringsif(conn)cout<<"successcreateConnection!"<

6、eConnection!"<createStatement();stringsSQL="selectto_char(sysdate,'yyyy-mm-ddhh24:mi:ss')fromdual";stmt->setSQL(sSQL);ResultSet*rs=stmt->executeQuery();if(rs->next()){date=rs->getString(1);}cout<<"nowtime:"<terminateConnection(conn);Environment::terminat

7、eEnvironment(env);return0;} 我linux上安装oracle路径：/u01/app/oracle/product/10.2.0/db_1 编译命令：g++-oconn-L/u01/app/oracle/product/10.2.0/db_1/lib-L/u01/oracle/product/10.2.0/db_1/rdbms/libconn_db.cpp问题一：编译时报如下错误：    Shel