databasemanager.cpp

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


DataBaseManager &DataBaseManager::instance()
{
    static DataBaseManager instance;
    return instance;
}

bool DataBaseManager::openDatabase(const QString &path)
{
    db.setDatabaseName(path);
    if(!db.open()){
        qDebug() << "Failed to open the database：" << db.lastError().text();
        return false;
    }
    return true;
}

void DataBaseManager::closeDatabase()
{
    if(db.isOpen()){
        db.close();
    }
}

QString DataBaseManager::getDatabasePath() const
{
    return dbPath;
}

void DataBaseManager::setDatabasePath(const QString &path)
{
    if(path != dbPath){
        dbPath = path;
        closeDatabase();
        openDatabase(path);
    }
}

DataBaseManager::~DataBaseManager()
{
    closeDatabase();
}

//构造
DataBaseManager::DataBaseManager(QObject *parent)
    : QObject{parent}
{
    db = QSqlDatabase::addDatabase("QSQLITE");//使用的数据库类型
    openDatabase(dbPath);
}