[QT] QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.

Error Message

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

會出現上述問題是因為重複使用了DB Driver,只要在開啟DB時給于名稱


方法一：使用預設名稱

QSqlDatabase datebase;    
if(QSqlDatabase::contains("qt_sql_default_connection"))
    datebase = QSqlDatabase::database("qt_sql_default_connection");
else
    datebase = QSqlDatabase::addDatabase("QSQLITE");

QSqlQuery query; //不指定，則使用defaults

方法二：自訂名稱

QSqlDatabase datebase;    
if(QSqlDatabase::contains("QSQLITE"))
     datebase = QSqlDatabase::database("QSQLITE");
else
     datebase = QSqlDatabase::addDatabase("QSQLITE", "QSQLITE");

QSqlQuery *query = new QSqlQuery(database); //不指定，則使用defaults