#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?<
??????Statement?*stmt?=?conn->createStatement（“select?*?from?TEST_TABLE“）;
??????ResultSet?*rs?=?stmt->executeQuery（）;

??????while（rs->next（））{
?????????cout?<<“Name:?“<getString（1）?<getInt（2）?<getInt（3）?<??????}
??????stmt->closeResultSet（rs）;
??????conn->terminateStatement（stmt）;
??????env->terminateConnection（conn）;?
???}?
???catch（SQLException?&e）?
???{
??????cout?<???}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????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.embed.manifest
?????文件????????2112??2014-11-15?00:14??test1\Debug\OCCI_demo.exe.embed.manifest.res
?????文件?????????663??2014-11-14?23:16??test1\Debug\test1.exe.embed.manifest
?????文件?????????728??2014-11-14?23:16??test1\Debug\test1.exe.embed.manifest.res
?????文件?????????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