Linux下OCCI操作Oracle数据库

开启数据库：

bool DBBase::startUp()
{
bool flag = true;
try
{
env = Environment::createEnvironment(Environment::OBJECT);
conn = env->createConnection(username, userpwd, connstr);//创建环境变量
}
catch (SQLException e) 
{
flag = false;
cout<<"连接失败..."<<endl;
cout<<"错误号:"<<e.getErrorCode()<<endl;
cout<<"错误信息:"<<e.getMessage()<<endl;
}
return flag;
} 

插入一条记录：

string sqlstr = "insert into tb_person values(:1, :2, :3, :4, :5, :6, :7)";
stmt = conn->createStatement();
stmt->setSQL(sqlstr);//设置sql语句
stmt->setInt(1, 136147726);//设置第一个参数
stmt->setString(2, "15039707134Hywei");//设置第二个参数
stmt->setString(3, "juve");//设置第三个参数
stmt->setInt(4, 22);//设置第四个参数
stmt->setString(5, "男");//设置第五个参数
stmt->setString(6, "荆州沙市");//设置第六个参数
stmt->setString(7, "把握机遇。");//设置第七个参数
stmt->executeUpdate();//执行更新
conn->terminateStatement(stmt);//释放statement对象

查找所有记录：

sqlstr = "select * from tb_person";
stmt = conn->createStatement();
stmt->setSQL(sqlstr);
ResultSet *rs;
rs = stmt->executeQuery();
while(rs->next())
{
cout<<"*****************************"<<endl;
cout<<"id:"<<rs->getInt(1)
<<"pwd:"<<rs->getString(2)
<<"nickname:"<<rs->getString(3)
<<"age:"<<rs->getInt(4)
<<"sex:"<<rs->getString(5)
<<"comfrm:"<<rs->getString(6)
<<"note:"<<rs->getString(7)
<<endl;
}

关闭数据库：

void DBBase::finishedFunc()
{
//关闭连接
env->terminateConnection(conn);
//销毁环境变量
Environment::terminateEnvironment(env);
}