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";
}