資源簡介
Oracle OCCI 連接示例程序
準備工作:
http://www.oracle.com/technetwork/database/occidownloads-083553.html
1. 修改 項目屬性-> C++ -> 常規 ->附加包含目錄 , 指向你自己的 occi.h所在目錄, 我的是 D:\Oracle\product\11.2.0\dbhome_1\OCI\include
2. 確認 項目屬性-> C++ -> 代碼生成 -> 運行庫為 多線程DLL(/MD), 否則從ResultSet中getString() 會 crash
3. 修改 項目屬性-> 鏈接器 -> 附加庫目錄 , 指向你的MSVC OCCI lib 和dll所在目錄, 我的是: D:\Oracle\product\11.2.0\dbhome_1\OCI\lib\MSVC\vc9

代碼片段和文件信息
#include?
#include?
using?namespace?std;
using?namespace?oracle::occi;?
#pragma?comment(lib“oraocci11.lib“)
const?string?username?=?“root“;?
const?string?password?=?“hello“;?
const?string?connstr?=?“//192.168.0.103:1521/test“;?
void?main()
{
???try
???{
??????Environment?*env?=?Environment::createEnvironment(Environment::DEFAULT);?
??????Connection?*conn?=?env->createConnection(usernamepasswordconnstr);?
??????cout?<“Success!“?<
??????Statement?*stmt?=?conn->createStatement(“select?*?from?TEST_TABLE“);
??????ResultSet?*rs?=?stmt->executeQuery();
??????while(rs->next()){
?????????cout?<<“Name:?“<?rs->getString(1)?<“Id:?“?<getInt(2)?<“??Age:?“?<getInt(3)?< ??????}
??????stmt->closeResultSet(rs);
??????conn->terminateStatement(stmt);
??????env->terminateConnection(conn);?
???}?
???catch(SQLException?&e)?
???{
??????cout?<???}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????1239??2014-11-15?00:20??Demos.sln
?????目錄???????????0??2014-11-19?22:37??test1\
?????文件?????????951??2014-11-19?22:37??test1\db.cpp
?????目錄???????????0??2014-11-15?00:14??test1\Debug\
?????文件????????7330??2014-11-15?00:14??test1\Debug\BuildLog.htm
?????文件???????56670??2014-11-15?00:14??test1\Debug\db.obj
?????文件??????????65??2014-11-14?23:16??test1\Debug\mt.dep
?????文件????????2048??2014-11-15?00:14??test1\Debug\OCCI_demo.exe.em
?????文件????????2112??2014-11-15?00:14??test1\Debug\OCCI_demo.exe.em
?????文件?????????663??2014-11-14?23:16??test1\Debug\test1.exe.em
?????文件?????????728??2014-11-14?23:16??test1\Debug\test1.exe.em
?????文件?????????621??2014-11-14?23:16??test1\Debug\test1.exe.intermediate.manifest
?????文件??????314368??2014-11-15?00:14??test1\Debug\vc90.idb
?????文件??????315392??2014-11-15?00:14??test1\Debug\vc90.pdb
?????文件????????6765??2014-11-19?22:26??test1\test1.vcproj
?????文件????????2615??2014-11-19?22:26??test1\test1.vcproj.use-PC.Administrator.user
?????目錄???????????0??2014-11-15?01:57??test1\x64\
?????目錄???????????0??2014-11-19?22:38??test1\x64\Debug\
?????文件????????6760??2014-11-19?22:14??test1\x64\Debug\BuildLog.htm
?????目錄???????????0??2014-11-15?01:58??test1\x64\Release\
?????文件????????6724??2014-11-15?01:58??test1\x64\Release\BuildLog.htm
?????文件??????202017??2014-11-15?01:58??test1\x64\Release\db.obj
?????文件??????????65??2014-11-15?01:58??test1\x64\Release\mt.dep
?????文件?????????381??2014-11-15?01:58??test1\x64\Release\OCCI_demo.exe.intermediate.manifest
?????文件??????142336??2014-11-15?01:58??test1\x64\Release\vc90.idb
- 上一篇:C與MYSQL連接
- 下一篇:MFC對話框動態接收數據插入List列表并繪曲線
評論
共有 條評論