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

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

1. m_dbTest = QSqlDatabase::addDatabase("QSQLITE");
   
2. m_dbTest.setDatabaseName("sqlite.db");
   
3. if(m_dbTest.open())
   
4. {
   
5.     qDebug() << "database succeeded to open";
   
6. }
   
7. else
   
8. {
   
9.     qDebug() << "database failed to open";
   
10. }
    
11. 
    
12. QSqlQuery query(m_dbTest);
    
13. bool isTableExist = \
    
14.     query.exec(QString("select count(*) from sqlite_master where type='table' and name='%1'").arg(strTableName)));    //关键的判断
    
15. if(!isTableExist)
    
16. {
    
17.     qDebug() << "table does not exist";
    
18. }
    
19. else
    
20. {
    
21.     qDebug() << "table exists";
    
22. }