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)