17,134
社区成员
发帖
与我相关
我的任务
分享#include "Stdafx.h"
#include <iostream>
#include <occi.h>
using namespace std;
using namespace oracle::occi;
Environment *env;
Connection *conn;
Statement *stmt;
ResultSet *rset;
string tableName;
string typeName;
void main()
{
Environment * env=Environment::createEnvironment(Environment::DEFAULT);
cout << "Ready, let's go!" << endl;
cout << "Trying" << endl;
Connection *conn=env->createConnection("broadsky","111111","");
cout << "Done!" << endl;
if (conn)
cout << "SUCCESS - createConnection" <<"\tconn="<<conn<< endl;
else
cout << "FAILURE - createConnection" <<"\tconn="<<conn<<endl;
stmt = conn->createStatement("SELECT * FROM t1");
rset=stmt->executeQuery();
while (rset->next())
{
cout<<"the empno is:"<<rset->getString(1)<<"\t"<<rset->getString(2)<<"\t";
cout<<rset->getString(3)<<"\t"<<rset->getString(4)<<"\t"<<rset->getString(5)<<"\t"<<endl;
}
stmt->closeResultSet (rset);
conn->terminateStatement (stmt);
env->terminateConnection (conn);
Environment::terminateEnvironment(env);
system("PAUSE");
}