QtÁ¬½ÓSQLiteÊý¾Ý¿â²¢²éѯ

ÏÂÃæµÄ·½·¨¿ÉÒÔ±ÜÃâÕâÖÖ´íÎó：
QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.

1. //ΪÁËÖ§³ÖÖÐÎÄ
2. QTextCodec::setCodecForTr(QTextCodec::codecForLocale());
4. QSqlDatabase sqlDatabase;
5. //ÓëÊý¾Ý¿â½¨Á¢Á¬½Ó
6. if (QSqlDatabase::contains("my_conn"))
7. {
8. sqlDatabase = QSqlDatabase::database("my_conn");
9. }
10. else
11. {
12. sqlDatabase = QSqlDatabase::addDatabase("QSQLITE", "my_conn");
13. }
14. //ÉèÖÃÊý¾Ý¿âÃû
15. sqlDatabase.setDatabaseName("my_database.db");
16. //´ò¿ªÊý¾Ý¿â
17. if (!sqlDatabase.open())
18. {
19. qDebug() << "Open database failed!";
20. return;
21. }
22. QString query_str = "select * from my_table";
23. //²éѯÊý¾Ý¿â
24. QSqlQuery sqlQuery(query_str, sqlDatabase);
25. sqlQuery.exec();
26. while (sqlQuery.next())
27. {
28. for (int i = 0; i < cnt; ++i)
29. {
30. qDebug() << sqlQuery.value(i).toString();
31. }
32. }
33. // ¹Ø±ÕÊý¾Ý¿â
34. sqlDatabase.close();

±¾ÎÄת×Ôwalker snapshot²©¿Í51CTO²©¿Í，Ô­ÎÄÁ´½Óhttp://blog.51cto.com/walkerqt/990874ÈçÐèתÔØÇë×ÔÐÐÁªÏµÔ­×÷Õß

RQSLT