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屋！