pc-system/databasemanager.cpp

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

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

// 创建一个新的数据库连接
DatabaseManager::DatabaseManager() : db(QSqlDatabase::addDatabase("QMYSQL")) {
    db.setHostName("192.168.0.255");
    db.setDatabaseName("pc_system");
    db.setUserName("hxgc");
    db.setPassword("hxgc12345678");

    if (!db.open()) {
        qDebug() << "Failed to open database: " << db.lastError().text();
    }
}

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

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