builtins.AttributeError：'str‘对象没有属性'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_())

这是数据库“麦克风”中的“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)