Qt连接Oracle数据库测试Demo
#include <QCoreApplication>
#include "cplusplus/database/oracleuserdb.h"
#include <QSqlDatabase>
#include <QtGlobal>
#include <QtDebug>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QSqlField>
#include <QLibrary>
#include <memory>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
std::shared_ptr<QLibrary> ocilib(new QLibrary("./oracle/oci.dll"));
qDebug()<<"Available drivers:"<< ocilib->load();;
QStringList drivers=QSqlDatabase::drivers();
foreach(QString driver,drivers)
qDebug()<<driver;
QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
qDebug() << "QT DB driver?" << db.isValid();
bool m_bIsConn;
db.setHostName("192.168.0.156");
db.setPort(1521);
db.setDatabaseName("xe");
db.setUserName("user");
db.setPassword("passwd");
if(db.open())
{
qDebug()<<QString("连接成功");
m_bIsConn = true;
}
else
{
qDebug()<<"连接失败";
m_bIsConn = false;
qDebug()<<db.lastError();
}
return a.exec();
}