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