qt - 检查表是否存在

Question

我正在使用这个 SELECT name FROM sqlite_master WHERE type = "table"AND name = 'create_organization'; 来检查名为 create_organization 的表是否存在并且它有效。但是我想使用 qt找出答案。我正在尝试

 QSqlQuery query;
    QString tableName = "employee_datastores";
    QString sqlQuery = QString("SELECT name FROM sqlite_master WHERE type =:table AND name = %1 ").arg(tableName);
    query.prepare(sqlQuery);
    query.bindValue(":table", "table");
    query.exec();
    int fieldNo = query.record().indexOf("employee_datastore_name");
    while (query.next()) {
        QString employee_ds_name = query.value(fieldNo).toString();
        qDebug() << "Table Name" << employee_ds_name ;
    }

但它不起作用。

Answer 1

QSqlDatabase::tables() 是否给了你想要的？例如你可以尝试:

if ( database.tables().contains( QLatin1String("employee_datastores") ) {
    ...
}