QSql遇到的问题

ontheway-xx

已于 2024-06-11 17:43:12 修改

阅读量533

点赞数 2

CC 4.0 BY-SA版权

分类专栏： Qt学习笔记文章标签： sql 数据库服务器

于 2024-06-11 16:00:09 首次发布

本文链接：https://blog.csdn.net/ZaiLuShang2121/article/details/139601161

Qt学习笔记专栏收录该内容

22 篇文章

订阅专栏

问题1：QSqlDatabasePrivate::removeDatabase: connection 'qt_sql_connection_hvsdb' is still in use, all queries will cease to work.

 // 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


 //RIGHT
 {
     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

QSqlDatabase::removeDatabase("sales") 之前要释放“sales”数据库：db = QSqlDatabase();