以下是我的代码,我的希望是修改随便修改某一项数据,到为什么更新数据时出现了错误,而且错误是无限的列名None
相关类
class Tea:
# 编号
TID = None
# 姓名
Tname = None
# 年龄
Tage = None
# 性别
Tsex = None
# 联系电话
Tphone = None
# 住址
Taddress = None
# 用户名
Tuser = None
# 密码
Tpassword = None
def __init__(self, Tname,Tuser,Tpassword):
self.Tname = Tname
self.Tuser = Tuser
self.Tpassword=Tpassword
@staticmethod
def my_construtor(Tname,Tage, Tsex, Tphone, Taddress, Tuser, Tpassword):
obj = Tea(Tname,Tuser,Tpassword)
obj.Tage = Tage
obj.Tsex = Tsex
obj.Tphone = Tphone
obj.Taddress = Taddress
obj.Tpassword = Tpassword
return obj
数据库更新代码
def update(tea: Tea) -> int:
con = None
try:
con = dbUtil.getCon()
cursor = con.cursor()
# 更新数据
sql = f"update Teacher set Tname='{tea.Tname}',Tage='{tea.Tage}',Tsex='{tea.Tsex}',Tphone='{tea.Tphone}'," \
f"Taddress='{tea.Taddress}' where TID={tea.TID}"
cursor.execute(sql)
con.commit()
return cursor.rowcount
except Exception as e:
print(f"更新数据时发生错误: {e}")
if con is not None:
con.rollback()
return 0
finally:
dbUtil.closeCon(con)
返回的错误
更新数据时发生错误: (207, b"Invalid column name 'None'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")