读书人

Oracle安装文件夹中相关OCI的Demo在哪

发布时间: 2012-12-31 11:57:52 作者: rapoo

Oracle安装文件夹中有关OCI的Demo在哪里?
看OCI的官方文档中说:

Oracle provides code examples illustrating the use of OCI calls. These programs are provided for demonstration purposes, and are not guaranteed to run on all operating systems.

The demonstration programs are available with your Oracle installation. The location, names, and availability of the programs may vary on different operating systems. On a Linux or UNIX workstation, the programs are installed in the $ORACLE_HOME/rdbms/demo directory.

上述文档出处:http://docs.oracle.com/cd/B28359_01/appdev.111/b28395/ociabdem.htm#i459676

为什么我在Oracle安装的机器上找不到这个Demo?也没有发现与此有关的安装选项(Oracle 11.2)?
[解决办法]
看看这里有没有:oracle目录\oci\samples
[解决办法]
我这边也没有Samples,有include就够了,把这个include和lib路径加到vc options就可以用了吧。
可以到百度搜"oci 访问Oracle“就可以了。


Environment *env = Environment::createEnvironment( " ZHS16GBK " , " UTF8 " );
// // Environment *env=Environment::createEnvironment(Environment::DEFAULT);

string mc;
{
Connection *conn = env->createConnection( "uid" , "pwd" , "//***.***.***.***:port/servername" );////localhost:1521/servername
try
{
Statement *stmt = conn->createStatement( " select * from table" );

ResultSet *rs = stmt->executeQuery();
// int i = 1;
while (rs->next())
{
CString str;
mc = rs->getString( 1 );
str.Format("%s", mc.c_str());
//mc = rs->getString( 1 );
::AfxMessageBox(str);
}
stmt->closeResultSet(rs);
stmt = conn->createStatement( " insert into table(ziduan) values('11002') " );
rs = stmt->executeQuery();
stmt->closeResultSet(rs);
conn->terminateStatement(stmt);
}
catch (SQLException e)
{
cout << e.what();
}
env->terminateConnection(conn);
}
Environment::terminateEnvironment(env);

读书人网 >VC/MFC

热点推荐