def Member_id():
connect = pymysql.connect(CONFIG.Data_base_config()['address'], CONFIG.Data_base_config()['user'],CONFIG.Data_base_config()['pwd'],CONFIG.Data_base_config()['base_name'])
try:
cursor = connect.cursor() # 游标
cursor.execute('select id, mobile \
from xx_member \
where mobile = \'%s\'' % CONFIG.Mobile()) #执行sql
member_id = cursor.fetchall()[0] # 返回执行结果
connect.close() # 断开数据库连接
return member_id
except Exception as error:
connect.close()
return '数据库操作失败-->%s' % error
def OrderCode(id):
connect = pymysql.connect(CONFIG.Data_base_config()['address'], CONFIG.Data_base_config()['user'],CONFIG.Data_base_config()['pwd'],CONFIG.Data_base_config()['base_name'])
try:
cursor = connect.cursor() # 游标
cursor.execute('select id, sn \
from xx_order \
where id = \'%s\'' % id) # 执行sql
sn = cursor.fetchall()[0] # 返回执行结果
connect.close() # 断开数据库连接
return sn[1]
except Exception as error:
connect.close()
return '数据库操作失败, 订单id: %s没找到-->异常记录: %s' % (id,error)
