python execute传参,Python Execute（）恰好接受2个参数（给定3个）

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))

this is the Execute function:

def Execute(self,SQL):

self.__connection.execute(SQL)

self.__connection.comit()

and i am getting this error:

con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ?

''', (PlayerLevel,PlayerUsername)) TypeError: Execute() takes exactly

2 arguments (3 given)

解决方案

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):

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))

The tuple value passed in, together with the auto-inserted self argument and the SQL argument makes three.

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()