QT 连接多个数据库，必须指定不同的连接名字

/* QT 连接多个数据库，必须指定不同的连接名字 */


#include "q2.h"


#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>


QSqlDatabase *db;
QSqlDatabase *db2;




q2::q2(QWidget *parent, Qt::WFlags flags)
: QMainWindow(parent, flags)
{
ui.setupUi(this);


db = new QSqlDatabase(QSqlDatabase::addDatabase("QMYSQL")); // 没指定连接名字，则为默认库
db->setDatabaseName("sns");
db->setHostName("127.0.0.1");
db->setPort(3306);
db->setUserName("root");
db->setPassword("");
if (! db->open()) {
QSqlError e = db->lastError();
qFatal("ServerDB db1: Failed initialization: %s",qPrintable(e.text()));
}


db2 = new QSqlDatabase(QSqlDatabase::addDatabase("QMYSQL", "db2")); // 如果要连接多个数据库，必须指定不同的连接名字，否则会覆盖上面的默认连接
db2->setDatabaseName("bbs");
db2->setHostName("127.0.0.1");
db2->setPort(3306);
db2->setUserName("root");
db2->setPassword("");
if (! db2->open()) {
QSqlError e = db2->lastError();
qFatal("ServerDB db1 : Failed initialization: %s",qPrintable(e.text()));
}
}


void q2::on_pushButton_clicked()
{
if (db->isValid())
{
QSqlQuery query; // 查默认库，即 db

if (query.prepare("select * from users"))
{
if (query.exec())
{
if (query.next())
ui.pushButton->setText(query.value(2).toString());
else
qWarning("SQL Error [%s]: %s", qPrintable(query.lastQuery()), qPrintable(query.lastError().text()));
}
else
{
qWarning("SQL Error [%s]: %s", qPrintable(query.lastQuery()), qPrintable(query.lastError().text()));
}
}
else
{
qWarning("SQL Error [%s]: %s", qPrintable(query.lastQuery()), qPrintable(query.lastError().text()));
}
}
else
{
qWarning("SQL rejected: Database is gone");
}
}


void q2::on_pushButton_2_clicked()
{
if (db2->isValid())
{
QSqlQuery query(*db2); // 查另一个数据库 db2


if (query.prepare("select * from users"))
{
if (query.exec())
{
if (query.next())
ui.pushButton_2->setText(query.value(2).toString());
else
qWarning("SQL Error [%s]: %s", qPrintable(query.lastQuery()), qPrintable(query.lastError().text()));
}
else
{
qWarning("SQL Error [%s]: %s", qPrintable(query.lastQuery()), qPrintable(query.lastError().text()));
}
}
else
{
qWarning("SQL Error [%s]: %s", qPrintable(query.lastQuery()), qPrintable(query.lastError().text()));
}
}
else
{
qWarning("SQL rejected: Database is gone");
}
}




q2::~q2()
{
db->close();
delete db;
db = NULL;


db2->close();
delete db2;
db2 = NULL;
}