请教mysql数据库多处连接问题

zhuxianfei

如题：我想在1.cpp文件中打开一个数据库连接“connection1”,将数据写进数据库，然后在2.cpp文件打开一个数据库连接“connection2”将前面我写进去的数据取出来，看代码：

  
  在1.cpp文件中：

1. void DbConn::testDb()
   
2. {
   
3. QSettings sett(QApplication::applicationName() + ".ini", QSettings::IniFormat);
   
4. 
   
5. db = QSqlDatabase::addDatabase(sett.value("MYSQL/databasedriver", "QMYSQL").toString(),"connection1");
   
6. db.setHostName(sett.value("MYSQL/hostname", IPREMOTE).toString());
   
7. db.setDatabaseName(sett.value("MYSQL/databasename", DATABASENAME).toString());
   
8. db.setUserName(sett.value("MYSQL/username", USERNAME).toString());
   
9. db.setPassword(sett.value("MYSQL/password", PASSWORD).toString());
   
10. qDebug() << "opening database...";
    
11. showMessage(tr("opening database"), true);
    
12. if(db.open()){
    
13. qDebug() << "test db open success";
    
14. showMessage(tr("test database success"), false);
    
15. db.close();
    
16. }else{
    
17. qDebug() << "test db open fail" << db.lastError().text();
    
18. showMessage(tr("open database fail"), true);
    
19. }
    
20. }

复制代码

在2.cpp文件中：

1. void viewer::onTestDb()
   
2. {
   
3. QSettings sett(QApplication::applicationName() + ".ini", QSettings::IniFormat);
   
4. QSqlDatabase::addDatabase(sett.value("MYSQ/databasedriver", "QMYSQL").toString(),"connection2");
   
5. db2.setHostName(sett.value("MYSQL/hostname", IPREMOTE).toString());
   
6. db2.setDatabaseName(sett.value("MYSQL/databasename", DATABASENAME).toString());
   
7. db2.setUserName(sett.value("MYSQL/username", USERNAME).toString());
   
8. db2.setPassword(sett.value("MYSQL/password", PASSWORD).toString());
   
9. qDebug() << "opening database...";
   
10. ui->statusBar->showMessage(tr("testing database"));
    
11. ui->statusBar->setStyleSheet("color:red");
    
12. if(db2.open()){
    
13. qDebug() << "test db open success";
    
14. ui->statusBar->showMessage(tr("testing database success"));
    
15. ui->statusBar->setStyleSheet("");
    
16. db2.close();
    
17. }else{
    
18. qDebug() << "test db open fail" << db2.lastError().text();
    
19. ui->statusBar->showMessage(tr("testing database fail"));
    
20. ui->statusBar->setStyleSheet("color:red");
    
21. }
    
22. }
    
23. 
    

复制代码

这样子当我运行1.cpp文件中的代码向数据库中写数据时（不写数据不会），再运行2.cpp文件中的代码就会报错：
QSqlDatabasePrivate::removeDatabase: connection 'connection1' is still in use, all queries will cease to work.

QSqlDatabasePrivate::addDatabase: duplicate connection name 'connection1', old connection removed.

请问如何处理能避开这中问题，欢迎大家讨论！谢谢