databasemanager.cpp 760 B

123456789101112131415161718192021222324252627282930313233
  1. #include "databasemanager.h"
  2. #include <QSqlError>
  3. #include <QDebug>
  4. #include "logger.h"
  5. DatabaseManager& DatabaseManager::getInstance() {
  6. static DatabaseManager instance;
  7. return instance;
  8. }
  9. // 创建一个新的数据库连接
  10. DatabaseManager::DatabaseManager() : db(QSqlDatabase::addDatabase("QMYSQL")) {
  11. db.setHostName("192.168.1.234");
  12. db.setDatabaseName("pc_system");
  13. db.setUserName("root");
  14. db.setPassword("123456");
  15. if (!db.open()) {
  16. qDebug() << "Failed to open database: " << db.lastError().text();
  17. }
  18. Logger::getInstance().info("Mysql Connected");
  19. }
  20. DatabaseManager::~DatabaseManager() {
  21. if (db.isOpen()) {
  22. db.close();
  23. }
  24. }
  25. QSqlDatabase& DatabaseManager::getDatabase() {
  26. return db;
  27. }