Method OpenODBCDatabase

Src/Database/Database.cpp:232–286

}

bool CDatabase::OpenODBCDatabase(const CParameterDatabase *pPara,
                                 const QString &szConnectName)
{
    if(!pPara) return false;

    if(!szConnectName.isEmpty())
        m_szConnectName = szConnectName;

    // 打开或创建数据库
    m_database = QSqlDatabase::addDatabase("QODBC", m_szConnectName);
    QString szDbName = pPara->GetDatabaseName();
    if(szDbName.isEmpty()) {
#if DEBUG
        szDbName = "remote_control_dev";
#else
        szDbName = "remote_control";
#endif
    }
    m_database.setDatabaseName(szDbName);

    if (!m_database.open()) {
        SetError("Failed to open odbc database: " + m_database.databaseName()
                 + "; Connect name: " + m_database.connectionName()
                 + "; Error: " + m_database.lastError().text()
                 );
        qCritical(log) << GetError();
        return false;
    }

    m_bOwner = true;

    QSqlQuery query(GetDatabase());
    bool success = query.exec("CREATE DATABASE IF NOT EXISTS " + szDbName);
    if (!success) {
        SetError("Failed to create database: " + szDbName
                 + "; Error: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
        return false;
    }

    success = query.exec("use " + szDbName);
    if (!success) {
        SetError("Failed to use " + szDbName
                 + "; Error: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
        return false;
    }

    qInfo(log) << "Open odbc database:" << m_database.databaseName()
               << "Connect name:" << m_database.connectionName();

    return OnInitializeDatabase();
}

bool CDatabase::OnInitializeDatabase()
{