Qt QSqlDatabase::removeDatabase()遇到的问题

在Qt中想要关闭数据库，并删除连接时发现出错，代码如下：

if（db.isOpen())
{
    QString connection;
    connection = db.connectionName();
    db.close();
    db = QSqlDatabase();
    db.removeDatabase(connection);
}

运行时会出现如下警告：

QSqlDatabasePrivate::removeDatabase: connection ‘in_mem_db’ is still in use, all queries will cease to work.

按照Qt官方教程的说法，内容如下：

Warning: There should be no open queries on the database connection when this function is called, otherwise a resource leak will occur.

Example:

 // WRONG
 QSqlDatabase db = QSqlDatabase::database("sales");
 QSqlQuery query("SELECT NAME, DOB FROM EMPLOYEES", db);
 QSqlDatabase::removeDatabase("sales"); // will output a warning
 // "db" is now a dangling invalid database connection,
 // "query" contains an invalid result set
The correct way to do it:
 {
     QSqlDatabase db = QSqlDatabase::database("sales");
     QSqlQuery query("SELECT NAME, DOB FROM EMPLOYEES", db);
 }
 // Both "db" and "query" are destroyed because they are out of scope
 QSqlDatabase::removeDatabase("sales"); // correct

故将代码修改成如下：

if(db.isOpen()){db.close();}
QString connection;
{
   connection = QSqlDatabase::database().connectionName();    
}
QSqlDatabase::removeDatabase(connection);
db = QSqlDatabase();

问题得以解决！