qoci连接oracle代码,Qt联接Oracle数据库详细介绍(QOCI)

#include

#include

//连接数据库

QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");

db.setPort(DB_PORT);

db.setHostName(DB_HOSTNAME);

db.setDatabaseName(DB_DBNAME);

db.setUserName(DB_USERNAME);

db.setPassword(DB_PASSWORD);

if (db.open()) {

qDebug()<< "链接远程数据库成功";

}else{

qDebug()<< "链接远程数据库失败";

return;

}

//查询语句

QSqlQuery query("SELECT * FROM TB_PRO");

while (query.next())

{

int iProNo = query.value(0).toInt();

QString sProName = query.value(1).toString();

}

//删除语句

QString sProName = "csdn"

QSqlQuery query("delete from TB_PRO where task_name = '"+sProName+"'");