def getvaluelist(tel):
with open(selectsqlpath, 'r', encoding='utf-8') as file:
lines = file.readlines()
file.close()
valuelist = []
for line in lines:
sql = str(line).replace('19900000000', tel)
value = Mysql.selectwithoutparams(business, sql)[0]
# 生成结果列表
valuelist.append(value)
return valuelist
def saveauthenticationmock(name, card, tel):
sql = 'update mag_customer set PERSON_NAME = "' + name + '", card = "' + card + '" where tel = "' + tel + '"'
Mysql.selectwithoutparams(business, sql)