python - cursor.rowcount 给出 'int' object is not callable 错误

Question

我从 sqlite3 数据库中选择值并打印游标的计数。然后它给出错误“‘int’对象不可调用”

strq="select * from tblsample1"
self.con = sqlite3.connect('mydb.sqlite')
self.cur = self.con.cursor()
self.cur.execute(strq)              
print(self.cur.rowcount())

报错

TypeError: 'int' object is not callable

Answer 1

阅读documentation小心! rowcount 是一个属性，因此请将您的代码更正为:

 print(self.cur.rowcount)

Cursor.rowcount Although the Cursor class of the sqlite3 module implements this attribute, the database engine’s own support for the determination of “rows affected”/”rows selected” is quirky.

---

This includes SELECT statements because we cannot determine the number of rows a query produced until all rows were fetched.

---

所以你可以修改你的代码来使用fetchall :

self.cur.execute(strq) 
data = self.cur.fetchall()
print len(data)