occi 标准连接数据库代码

来源：互联网发布：最新免费读书软件编辑：程序博客网时间：2024/04/30 15:39

#include <iostream>
#include <occi.h>
using namespace oracle: occi;
using namespace std;

class testOcci{
private:
Environment *env;
Connection *conn;
Statement *stmt;

public:
testOcci (string user, string passwd, string db)
{
env = Environment::createEnvironment (Environment: DEFAULT);
conn = env->createConnection( user, passwd, db);
}
~testOcci ()
{
env->terminateConnection(conn);
Environment::terminateEnvironment (env);
}
};
int main(void)
{
string user="test";
string passwd="test";
string db="spdc";

testOcci *demo = new testOcci (user, passwd, db);
cout << "Creation Successful" << endl;
delete (demo);
cout << "Deletion Successful" << endl;

return 0;
}

A Simple Useful OCCI Program

//create environment and connection

Environment* env = Environment::createEnvironment();

Connection* conn = env->createConnection( "scott", "tiger" );

cout << "Environment and Connection created" << endl;

//execute a SQL statement

Statement* stmt = conn->createStatement();

stmt->setSQL("INSERT into FRUITS (fruit, amt) VALUES ('apple', 10)");

stmt->executeUpdate();

conn->terminateStatement(stmt);

//terminate environment and connection

env->terminateConnection(conn);

Environment::terminateEnvironment(env);

cout << "Environment and Connection terminated" << endl;