Qt5.12.3+VS2017编译的Oracle32+64位驱动
解压后,32,64位最终文件分别复制至:
D:\Install\Qt5.12.3\5.12.3\msvc2017\plugins\sqldrivers
D:\Install\Qt5.12.3\5.12.3\msvc2017_64\plugins\sqldrivers
下载地址:
https://download.csdn.net/download/yulinxx/11261390
Qt5.12.3+VS2017
测试均通过
#include <QtCore/QCoreApplication>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QVariant>
#include <QDebug>
#include <QLibrary>
#include <QSqlRecord>
#include <QSqlField>
#include <QTime>
#include <QSqlError>
int main(int argc, char *argv[])
{
QLibrary *hello_lib = nullptr;
#if 1 // 32
hello_lib = new QLibrary("D:\\Install\\OracleInstantClient_12_2_32\\oci.dll");
#else // 64
hello_lib = new QLibrary("D:\\Install\\OracleInstantClient_19_3_64\\oci.dll");
#endif
//加载动态库
hello_lib->load();
if (!hello_lib->isLoaded())
{
printf("load Oracle failed!\n");
//return 0;
}
QStringList drivers1 = QSqlDatabase::drivers();
for(auto str : drivers1)
qDebug()<<str;
bool isAvailable = QSqlDatabase::isDriverAvailable("QOCI");
if(!isAvailable)
{
qDebug() << "QOCI driver is not available!";
}
// 加载数据库驱动
QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
qDebug() << "QT DB driver?" << db.isValid();
db.setPort(1521);
db.setHostName("192.168.1.53");
db.setDatabaseName("ORCL");
db.setUserName("C##test");
db.setPassword("test");
bool ok = db.open();
if(ok)
{
qDebug() << "connect sucess!";
}
else
{
qDebug() << "connect failed!";
}
QSqlQuery query;
QString strSql = "create table xxx.t_stu(stuid number(10) primary key, stuname varchar2(20) not null, stusex varchar2(2))";
bool bSuccess = query.exec(strSql);
if(!bSuccess)
{
qDebug()<<QString::fromLocal8Bit("create error");
return 0;
}
else
{
bSuccess = query.exec("SELECT * FROM xxx.t_stu");
if(bSuccess)
{
QSqlRecord rec = query.record();
qDebug()<<QString::fromLocal8Bit(" 字段个数:")<<rec.count();
QSqlField filed = rec.field(0);
qDebug()<<QString::fromLocal8Bit("字段名称:")<<rec.field(0).name()<<QString::fromLocal8Bit("字段类型:")<<rec.field(0).type()<<QString::fromLocal8Bit("字段值:")<<rec.field(0).value();
qDebug()<<QString::fromLocal8Bit("字段名称:")<<rec.field(1).name()<<QString::fromLocal8Bit("字段类型:")<<rec.field(1).type()<<QString::fromLocal8Bit("字段值:")<<rec.field(1).value();
qDebug()<<QString::fromLocal8Bit("字段名称:")<<rec.field(2).name()<<QString::fromLocal8Bit("字段类型:")<<rec.field(2).type()<<QString::fromLocal8Bit("字段值:")<<rec.field(2).value();
qDebug()<<QString::fromLocal8Bit("字段名称:")<<rec.field(3).name()<<QString::fromLocal8Bit("字段类型:")<<rec.field(3).type()<<QString::fromLocal8Bit("字段值:")<<rec.field(3).value();
}
else
{
qDebug()<<QString::fromLocal8Bit("SELECT error");
}
}
return 0;
}