执行AddOcci程序之前:
执行AddOcci程序之后:
//ListOcci.cc #include <iostream> #include <string> #include <occi.h> #pragma comment(lib,"oci.lib") #pragma comment(lib,"ociw32.lib") #pragma comment(lib,"oraocci10.lib") using namespace std; using namespace oracle::occi; /******************************* *查询表中数据 *******************************/ int main() { Environment *env = Environment::createEnvironment(Environment::OBJECT); string username = "hahaya"; string userpass = "hahaya"; string connstr = "192.168.0.6:1521/orcl"; Connection *conn = env->createConnection(username, userpass, connstr); Statement *st = conn->createStatement(); st->setSQL("select * from user_info"); ResultSet *rs = st->executeQuery(); while(rs->next()) { cout << "user id:" << rs->getInt(1) << "user name:" << rs->getString(2) << endl;; } st->closeResultSet(rs); env->terminateConnection(conn); Environment::terminateEnvironment(env); return 0; } |
执行ListOcci之前:
执行DelOcci结果: