pc-system/databasemanager.cpp

#include "databasemanager.h"
#include <QSqlError>
#include <QDebug>
#include "logger.h"

DatabaseManager& DatabaseManager::getInstance() {
    static DatabaseManager instance;
    return instance;
}

// 创建一个新的数据库连接
DatabaseManager::DatabaseManager() : db(QSqlDatabase::addDatabase("QMYSQL")) {
    QString host("192.168.1.160");
    db.setHostName(host);
    db.setDatabaseName("pc_system");
    db.setUserName("root");
    db.setPassword("123456");

    if (!db.open()) {
        qDebug() << "Failed to open database: " << db.lastError().text();
    }
    Logger::getInstance().info(QString("Mysql Connected. host: %1").arg(host));

}

DatabaseManager::~DatabaseManager() {
    if (db.isOpen()) {
        db.close();
    }
}

QSqlDatabase& DatabaseManager::getDatabase() {
    return db;
}