QString sConnectionName = pBasicInfoCfg.value("DataBaseCfg/ConnectionName").toString();
QString sHostName = pBasicInfoCfg.value("DataBaseCfg/HostName").toString();
QString sDatabaseName = pBasicInfoCfg.value("DataBaseCfg/DatabaseName").toString();
QString sUserName = pBasicInfoCfg.value("DataBaseCfg/UserName").toString();
QString sUPassword = pBasicInfoCfg.value("DataBaseCfg/Password").toString();
m_db = QSqlDatabase::addDatabase("QODBC", sConnectionName);
m_db.setDatabaseName(QString("DRIVER={SQL SERVER};"
"SERVER=%1;"
"DATABASE=%2;"
"UID=%3;"
"PWD=%4;"
)
.arg(sHostName)
.arg(sDatabaseName)
.arg(sUserName)
.arg(sUPassword)
);
if(!m_db.open())
{
QHelper::setLog("QCapacity::InitDataBase()" + m_db.lastError().text());
return false;
}
qDebug() << "succeed";
return true;
网上常用的方法连接需要设置ODBC数据源,本方法不用。