Python Execute()恰好接受2个参数(给定3个) [英] Python Execute() takes exactly 2 arguments (3 given)
问题描述
我正在尝试使用以下代码插入SQLite数据库值:
I am trying to insert into the SQLite DataBase values with this code:
con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ? ''', (PlayerLevel,PlayerUsername))
这是Execute函数:
this is the Execute function:
def Execute(self,SQL):
self.__connection.execute(SQL)
self.__connection.comit()
我收到此错误:
con.Execute('''UPDATE tblPlayers SET p_Level =?WHERE p_Username =? ''',(PlayerLevel,PlayerUsername))TypeError:Execute()正好采用 2个参数(给定3个参数)
con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ? ''', (PlayerLevel,PlayerUsername)) TypeError: Execute() takes exactly 2 arguments (3 given)
推荐答案
您的Execute()
方法仅接受两个参数,即self
和SQL
. Python将self
参数提供给绑定方法,因此SQL
参数只有空间:
Your Execute()
method takes only two arguments, self
and SQL
. The self
argument is supplied by Python to bound methods, so there is only room for the SQL
argument:
def Execute(self,SQL):
,但是您使用一个附加参数调用了绑定方法,而不仅仅是一个SQL
参数:
but you called the bound method with an additional argument, not just the one SQL
argument:
con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ? ''',
(PlayerLevel,PlayerUsername))
传入的元组值以及自动插入的self
自变量和SQL
自变量使 3 .
The tuple value passed in, together with the auto-inserted self
argument and the SQL
argument makes three.
如果要支持SQL参数,则需要接受这些参数:
If you want to support SQL parameters, you'll need to accept those parameters:
def Execute(self, SQL, params=()):
self.__connection.execute(SQL, params)
self.__connection.commit()
这篇关于Python Execute()恰好接受2个参数(给定3个)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!