我对数据库中表经行修改
以下是我的代码
def _upadte_people(self):
sql = 'UPDATE people SET '#peoname=%s,peotel=%s,kink=%s,place=%s WHERE peono =%s
print(sql)
cs=False
if (self._peono == '' or self._peono.isspace() == True):
pass
else:
if (self._peoname == '' or self._peoname.isspace() == True):
sql = sql
else:
sql = sql + " peoname=%s,"
print(sql)
if (self._peotel == '' or self._peotel.isspace() == True):
sql = sql
else:
sql = sql + " peotel=%s,"
print(sql)
if (self._kink == '' or self._kink.isspace() == True):
sql = sql
else:
sql = sql + " kink=%s,"
print(sql)
if (self._place == '' or self._place.isspace() == True):
sql = sql
else:
sql = sql + " place=%s,"
print(sql)
sql=sql.strip(',');
sql = sql + " WHERE peono =%s;"
print(sql)
data=[self._peoname,self._peotel,self._kink,self._place,self._peono]
cs = sql_severs(sql,data) # cs为布尔型,表示是否插入成功
def sql_severs(sql,date):
conn = pymssql.connect('LAPTOP-SAEUFUK6', 'youke', '123456', 'sy_cxglxt')
cur = conn.cursor()
if(len(date)==5):
cs=cur.execute(sql,(date[0],date[1],date[2],date[3],date[4]))
conn.commit()
conn.close
return cs
我的主要问题是第二个python代码块中 cs=cur.execute(sql,(date[0],date[1],date[2],date[3],date[4]))这个太繁琐了,有没有什么好的方式来替代
cs=cur.execute(sql,date)