Code:
if (dbType == "QSQLITE") {
currentConnection
= QSqlDatabase::addDatabase("QSQLITE",
"CN");
currentConnection.
setDatabaseName(QString(dataDir
+ "/%1-%2.db").
arg(date.
year()).
arg(basename
));
} else if (dbType == "QMYSQL") {
QString userName
= settings.
value("DB_userName",
"QRK").
toString();
QString password
= settings.
value("DB_password",
"").
toString();
QString hostName
= settings.
value("DB_hostName",
"localhost").
toString();
currentConnection
= QSqlDatabase::addDatabase("QMYSQL",
"CN");
currentConnection.setHostName(hostName);
currentConnection.setUserName(userName);
currentConnection.setPassword(password);
currentConnection.setConnectOptions("MYSQL_OPT_RECONNECT=1;MYSQL_OPT_CONNECT_TIMEOUT=86400;MYSQL_OPT_READ_TIMEOUT=60");
}
bool ok = currentConnection.open();