comparison: src/database/database.cpp
src/database/database.cpp
- changeset 3
- 4b95e33ee476
- child 4
- fe106c497b75
equal
deleted
inserted
replaced
| 2:a1e435907f3a | 3:4b95e33ee476 |
|---|---|
| 1 | |
| 2 // from: https://evileg.com/en/post/93/ | |
| 3 | |
| 4 #include "database.h" | |
| 5 | |
| 6 DataBase::DataBase(QObject *parent) : QObject(parent) | |
| 7 { | |
| 8 | |
| 9 } | |
| 10 | |
| 11 DataBase::~DataBase() | |
| 12 { | |
| 13 | |
| 14 } | |
| 15 | |
| 16 void DataBase::connectToDataBase() | |
| 17 { | |
| 18 this->openDataBase(); | |
| 19 } | |
| 20 | |
| 21 bool DataBase::openDataBase() | |
| 22 { | |
| 23 QSettings settings(QSettings::IniFormat, QSettings::UserScope, "mbse", "bmsapp"); | |
| 24 | |
| 25 settings.beginGroup("dbdev"); | |
| 26 qDebug() << settings.value("host").toString() << settings.value("port").toString() << settings.value("name").toString() << settings.value("user").toString() << settings.value("pass").toString(); | |
| 27 db = QSqlDatabase::addDatabase("QMYSQL"); | |
| 28 db.setHostName(settings.value("host").toString()); | |
| 29 db.setPort(settings.value("port").toInt()); | |
| 30 db.setDatabaseName(settings.value("name").toString()); | |
| 31 db.setUserName(settings.value("user").toString()); | |
| 32 db.setPassword(settings.value("pass").toString()); | |
| 33 settings.endGroup(); | |
| 34 | |
| 35 if (db.open()) { | |
| 36 qDebug() << "Database open success"; | |
| 37 return true; | |
| 38 } else { | |
| 39 qDebug() << "Database open failed"; | |
| 40 return false; | |
| 41 } | |
| 42 } | |
| 43 | |
| 44 void DataBase::closeDataBase() | |
| 45 { | |
| 46 qDebug() << "Database close called"; | |
| 47 db.close(); | |
| 48 } | |
| 49 |
