python - 内置.AttributeError : 'str' object has no attribute 'toString'

Question

我有点菜鸟，我一直在按照教程使用 PyQt/Python 创建一个基本应用程序来查询 MySql 数据库。这是代码:

import sys

from PyQt4 import QtCore, QtGui, QtSql

from PyQt4.QtCore import *
from PyQt4.QtGui import *
from PyQt4.QtSql import *


app = QApplication(sys.argv)
w = QTextBrowser()

# DB type, host, user, password...
db = QSqlDatabase.addDatabase("QMYSQL");
db.setHostName("localhost")
db.setDatabaseName("microphones")
db.setUserName("root")
db.setPassword("")
ok = db.open()

# True if connected
if ok:
    w.insertHtml('Connected to MySQL<br />')
else:
    w.insertHtml('ERROR connecting to MySQL<br />')

# do a query "on" a DB connection
query = QSqlQuery(db)
if query.exec_("SHOW TABLES"):
    w.insertHtml('<br />')
    while query.next():
        table = query.value(0).toString()
        w.insertHtml('%s<br />' % table)

    w.insertHtml('<br />')
    w.insertHtml('TOTAL %s TABLES' % query.size())

w.show()
sys.exit(app.exec_())

这是数据库“microphones”中的表“ebay_microphones”:

ID,product_name,item_number,price
1,"AKG C14",564564564,32
2,"Samsung ",454564545,99
3,"Shure ",564687784,80

据我所知，代码应该显示数据库中的表，但我收到错误 builtins.AttributeError: 'str' object has no attribute 'toString'

谁能给我指出正确的方向，为什么我会收到这个错误？谢谢

Answer 1

只需将这一行 - table = query.value(0).toString() 更改为 - table = query.value(0)