qt access 数据库
2024-08-26 13:14:10
#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QtDebug>
#include <QSqlError>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
// QSqlDatabase db;
// db = QSqlDatabase::addDatabase("QODBC","test");
// db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};FIL={MS Access};DBQ=E:/test.mdb");
// if (db.open()) {
// qDebug() << "xxxxxxxxxxxxxxxx";
// }
// else {
// qDebug() << db.lastError();
// }
// return a.exec();\ QCoreApplication a(argc, argv);
QSqlDatabase db;
db = QSqlDatabase::addDatabase("QODBC","test");
db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};FIL={MS Access};DBQ=testacc64");
if (db.open()) {
qDebug() << "xxxxxxxxxxxxxxxx";
}
else {
qDebug() << db.lastError();
}
return a.exec();
}
int createSQLServerConnection()
{
loadPlugin();
QString strHost = "10.211.55.4";
int port = 3306;
QString strDbName = "SQLData";
QString strUserName = "test";
QString strUserPwd = "123321";
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
QString strconn = QString("Driver={sql server};SERVER=%1;PORT=%2;DATABASE=%3;UID=%4;PWD=%5;")
.arg(strHost)
.arg(port)
.arg(strDbName)
.arg(strUserName)
.arg(strUserPwd);
db.setDatabaseName(strconn);
if (!db.open())
{
qDebug() <<"error_SqlServer:" << db.lastError().text();
return 1201;
}
return 0;
}
access
"Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;"
dBase
"Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=***;"
oracle
"Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;"
MSSQL server
"Driver={sql server};server=servername;database=dbname;uid=sa;pwd=pass;"
MS text
"Driver={microsoft text driver(*.txt; *.csv)};dbq=**;extensions=asc,csv,tab,txt;Persist SecurityInfo=false;"
Visual Foxpro
"Driver={microsoft Visual Foxpro driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;"
MySQL
"Driver={mysql};database=yourdatabase;uid=username;pwd=yourpassword;option=16386;"
SQLite
"Driver={SQLite3 ODBC Driver};Database=D:\SQLite\*.db"
PostgreSQL
"Driver={PostgreSQL ANSI};server=127.0.0.1;uid=admin;pwd=pass;database=databaseName"
最新文章
- Spark会把数据都载入到内存么
- windows重新获取IP
- 把C编译成javascript的方法
- python字符串常用操作方法
- 【阿里云产品公测】以开发者角度看ACE服务『ACE应用构建指南』
- 新浪使用Redis
- python的random函数
- [工作] 使在家办公(Work From Home)更有效率的建议
- linux环境之监听端口配置
- javascript how sort() work
- Linux下Tomcat catalina.out自动归档,以及logrotate 配置详解
- 按某个字段来分组、编号的row_number()函数
- ESP8266 RTOS SDK(IDF)编译环境搭建
- angular使用sass的scss语法
- leetcode — unique-paths
- guxh的python笔记五:面向对象
- EasyUI - DataGrid 去右边空白滚动条列
- Linux - Port 端口检测方式
- 转:TensorFlow入门(六) 双端 LSTM 实现序列标注(分词)
- C语言高精度乘法