def bank_inquriy(account, password): sql = "select * from 用户信息 where account=%s " data = select(sql, account) if len(data) != 0: sql2 = "select account from 用户信息 where mima=%s" data = select(sql2, password) if len(data) != 0: return 0 else: return 2 else: return 1
def bank_savemoney(account, money): sql = "select * from 用户信息 where account=%s " data = select(sql, account) if len(data) != 0: sql1 = "update 用户信息 set money = money + %s where account = %s;" update(sql1, [money, account]) return 1 else: return False
def bank_addUser(account, username, password, country, province, street, door): # 判断是否已满 sql = "select count(*)from 用户信息" data = select(sql, []) if data[0][0] >= 100: return 3 # 判断是否存在 sql1 = "select * from 用户信息 where account=%s" data = select(sql1, account) if len(data) != 0: return 2 # 正常开户 sql2 = "insert into 用户信息 values(%s,%s,%s,%s,%s,%s,%s,%s,%s)" param = [ account, username, password, country, province, street, door, 0, bank_name ] update(sql2, param) return 1
def bank_getmoney(account, password, getmoney): sql = "select * from 用户信息 where account=%s " date = select(sql, account) if len(date) != 0: sql2 = "select account from 用户信息 where mima=%s" date = select(sql2, password) if len(date) != 0: sql4 = "select money from 用户信息 where money>%s" date = select(sql4, getmoney) if len(date) != 0: sql3 = "update 用户信息 set money = money - %s where account = %s" update(sql3, [getmoney, account]) return 0 else: return 3 else: return 2 else: return 1
def inquiry(): account = input("请输入账户:") password = input("请输入密码:") account1 = bank_inquriy(account, password) if account1 == 0: sql = "select * from 用户信息 where account=%s " date = select(sql, account) if len(date) != 0: print("账号:", date[0][0], "账户名", date[0][1], "密码:", date[0][2], "居住地址:", date[0][3], date[0][4], date[0][5], date[0][6], "余额:", date[0][7], "当前账户开户行:", date[0][8]) elif account1 == 1: print("账户不存在!") elif account1 == 2: print("密码错误!")
def bank_transfer(outaccount, inaccount, password, outmoney): sql = "select * from 用户信息 where account=%s " data = select(sql, outaccount) if len(data) != 0: sq2 = "select * from 用户信息 where account=%s " data = select(sq2, inaccount) if len(data) != 0: sql3 = "select account from 用户信息 where account=%s and mima=%s" data = select(sql3, [outaccount, password]) if len(data) != 0: sql4 = "select money from 用户信息 where money>%s" data = select(sql4, outmoney) if len(data) != 0: sql5 = "update 用户信息 set money=money-%s where account = %s " update(sql5, [outmoney, outaccount]) sql6 = "update 用户信息 set money=money+%s where account = %s " update(sql6, [outmoney, inaccount]) return 0 else: return 3 else: return 2 else: return 1