连接MSSQL的代码 - QTCN开发网

连接MSSQL的代码

#include <QtCore>
#include <QtSql>

QString getMSSQLDriver()
{
    static bool bInit = false;
    static QString strSQLDriverName;
    if (!bInit)
    {
#ifdef Q_OS_WIN
        QSettings  sts("HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\ODBCINST.INI"
                "\\ODBC Drivers", QSettings::NativeFormat);
        if (sts.contains("SQL Server Native Client 10.0")
                && sts.value("SQL Server Native Client 10.0").toString()
                == "Installed")
        {
            strSQLDriverName = "SQL Server Native Client 10.0";
        }
        else if (sts.contains("SQL Native Client")
                && sts.value("SQL Native Client").toString() == "Installed")
        {
            strSQLDriverName = "SQL Native Client";
        }
        else if (sts.contains("SQL Server")
                && sts.value("SQL Server").toString() == "Installed")
        {
            strSQLDriverName = "SQL Server";
        }
#endif
        bInit = true;
    }
    qDebug() << strSQLDriverName;
    return strSQLDriverName;
}

QString  getMSSQLDSN(const QString &strUser, const QString &strPass,
        const QString &strServer, const QString &strDbName)
{
    return QString(QString("DRIVER={%5};SERVER=%1;"
                    "DATABASE=%2;UID=%3;PWD=%4")
                .arg(strServer)
                .arg(strDbName)
                .arg(strUser)
                .arg(strPass)
                .arg(getMSSQLDriver()));
}

int main(int argc, char **argv)
{
    QCoreApplication app(argc, argv);

    if (!QSqlDatabase::isDriverAvailable("QODBC"))
    {
        qDebug() << "driver not available";
        app.quit();
        return 0;
    }

    QSqlDatabase *db = new QSqlDatabase(QSqlDatabase::addDatabase("QODBC"));
    db->setDatabaseName(getMSSQLDSN("sa", "123456",
                    "BJP-X200\\SQLEXPRESS", "master"));
    if (!db->open())
    {
        qDebug() << db->lastError();
    }
    else
    {
        qDebug() << "mssql connect success";
    }
    //......


    QString strConn = db->connectionName();
    if (db->isOpen())
    {
        db->close();
    }
    delete db;
    QSqlDatabase::removeDatabase(strConn);
    app.quit();
    return 0;
}