Qt技巧：sqlite数据库 判断表是否存在

    m_dbTest = QSqlDatabase::addDatabase("QSQLITE");
    m_dbTest.setDatabaseName("sqlite.db");
    if(m_dbTest.open())
    {
        qDebug() << "database succeeded to open";
    }
    else
    {
        qDebug() << "database failed to open";
    }

    QSqlQuery query(m_dbTest);
    bool isTableExist = 
        query.exec(QString("select count(*) from sqlite_master where type='table' and name='%1'").arg(strTableName)));    //关键的判断
    if(!isTableExist)
    {
        qDebug() << "table does not exist";
    }
    else
    {
        qDebug() << "table exists";
    }

FROM: http://blog.chinaunix.net/xmlrpc.php?r=blog/article&uid=29650836&id=4457672

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!