以下是我的代码,为什么会出现查询错误的问题,该怎么解决
def list(cea: Cea):
"""
根据条件查询图书信息
:param Hbook: 查询参数
:return:
"""
con = None
try:
con = dbUtil.getCon()
cursor = con.cursor()
# 查询数据
sql = "SELECT c.Cuser,c.Cname,c.Cage,c.Csex,c.Cphone,c.Caddress,c.Caddtime,g.Gname FROM Crew AS c,Groups AS g WHERE c.GID=g.GID AND CID=CID"
if cea != None:
if cea.Cuser.strip() != '':
sql += " and c.Cuser like '%" + cea.Cuser + "%' "
if cea.Cname.strip() != '':
sql += " and c.Cname like '%" + cea.Cname + "%' "
if cea.GID != -1:
sql += " and g.GID = " + str(cea.GID)
cursor.execute(sql)
con.commit()
return cursor.fetchall()
except Exception as e:
print(f"123查询数据时发生错误: {e}")
if con is not None:
con.rollback()
return None
finally:
dbUtil.closeCon(con)
123查询数据时发生错误: (207, b"Invalid column name 'None'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")