def bank_tran(account1, account2, password, money):
sql = "select count(*) from users where users.account= %s or users.account =%s"
param = [account1, account2]
data = select(sql, param)
if data[0][0] == 2:
sql = "select count(*) from users where users.account= %s and users.password=%s"
param = [account1, password]
data = select(sql, param)
if data[0][0] == 1:
sql = "select * from users where users.account= %s"
param = [account1]
data = select(sql, param)
num = data[0][7]
if num >= money:
sql = "update users set users.money =users.money - %s where users.account=%s"
param1 = [money, account1]
update(sql, param1)
sql1 = "update users set users.money =users.money + %s where users.account=%s"
param2 = [money, account2]
update(sql1, param2)
else:
return 3
if data[0][0] == 0:
return 2
else:
return 1
def bank_zhuanzhang(send_user, send_userPw, send_to, send_money):
sql = "select account from bank where account = %s or account = %s"
parame = [send_user, send_to]
users = select(sql, parame)
if len(users) == 2:
users = ()
sql = "select account from bank where account = %s and password = %s"
parame = [send_user, send_userPw]
users = select(sql, parame)
if len(users) == 1:
users = ()
sql = "select account from bank where account = %s and password = %s and money >= %s"
parame = [send_user, send_userPw, send_money]
users = select(sql, parame)
if len(users) == 1:
sql = "update bank set money = (money - %s) where account = %s ;"
parame = [send_money, send_user]
update(sql, parame)
sql = "update bank set money = (money + %s) where account = %s ;"
parame = [send_money, send_to]
update(sql, parame)
return 0
else:
return 3
else:
return 2
else:
return 1
def withdraw_money():
account = input("请输入用户账号：")
sql = "SELECT account FROM user_data where account = %s"
param = [account]
data01 = select(sql, param)
if len(data01) != 0:
print("用户存在")
password = input("请输入密码：")
sql1 = "SELECT passwords FROM user_data where account = %s"
param1 = [account]
data02 = select(sql1, param1)
if data02[0][0] == password:
print("密码正确！")
money = int(input("请输入取钱金额："))
sql2 = "SELECT money FROM user_data where account = %s"
param2 = [account]
data03 = select(sql2, param2)
if money <= data03[0][0]:
sql2 = "UPDATE user_data set money = money -%s where account = %s"
param3 = [money, account]
update(sql2, param3)
print("取钱成功！！")
else:
print("余额不足！！")
else:
print("密码错误！！")
else:
print("账户不存在！！")
def bankadd(account, username, password, country, province, street, door):
sql1 = "select * from user where account = %s"
param1 = [account]
data1 = select(sql1, param1)
if len(data1) > 0:
return "2"
sql = "select count(*) from user" # (5)
param = []
data = select(sql, param)
if data[0][0] >= 100:
return "3"
sql2 = " insert into user values(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
param2 = [
account, username, password, country, province, street, door, 0,
bank_name
]
update(sql2, param2)
# bank[account] = {
# "username": username, # 从useradd的account获取的随机数
# "password": password,
# "country": country,
# "province": province,
# "street": street,
# "door": door,
# "bank_name": bank_name,
# "money": 0
# }
return "1"
def transfer_accounts(za, zb, zc, zd): # 转账
sql1 = "select * from user where account = %s"
param1 = [za]
data1 = select(sql1, param1)
if za != zb:
if len(data1[0]) > 0:
sql2 = "select * from user where account = %s"
param2 = [zb]
data2 = select(sql2, param2)
if len(data2[0]) > 0:
if zc == data1[0][2]:
if data1[0][7] >= zd:
sql2 = "update user set money = money - %s where account=%s"
param = [int(zd), za]
update(sql2, param)
sql2 = "update user set money = money + %s where account=%s"
param = [int(zd), zb]
update(sql2, param)
else:
return "3"
else:
return "2"
else:
return "1"
else:
return "1"
elif za == zb:
print("转出账号不能和转入账号相同")
def bank_takeMoney(account,password,money):
sql1 = "select * from bank where username=%s"
user = select(sql1, account)
if len(user) != 0:
sql2 = "select password from bank where username=%s"
password1= select(sql2, account)
if password1[0][0]==password:
sql3="select money from bank where username=%s"
money1=select(sql3,account)
if money1[0][0]>=money:
sql4="update bank set money=money-%s where username =%s"
parm=[money,account]
update(sql4,parm)
print("取了",money,"元")
else:
print("取钱失败请充钱")
return 3
else:
print("密码错误")
return 1
else:
print("用户名不存在")
return 2
def transfer(self, u, inu):
sql = "select * from 开户 where account=%s "
data = select(sql, u.getAccount())
if len(data) != 0:
sq2 = "select * from 开户 where account=%s "
data1 = select(sq2, inu)
if len(data1) != 0:
sql3 = "select account from 开户 where account=%s and mima=%s"
data = select(sql3, [u.getAccount(), u.getPassword()])
if len(data) != 0:
sql4 = "select * from 开户 where account = %s and money>=%s"
data = select(sql4, [u.getAccount(), u.getMoney()])
if len(data) != 0:
sql5 = "update 开户 set money=money-%s where account = %s "
update(sql5, [u.getMoney(), u.getAccount()])
sql6 = "update 开户 set money=money+%s where account = %s "
update(sql6, [u.getMoney(), inu])
return 0
else:
return 3
else:
return 2
else:
return 1
else:
return 1
def qu():
zh = input("请输入您的账号：")
sql = "select * from blank where account = %s"
param = [zh]
data = select(sql, param)
if len(data) != 0:
print("账户存在！")
password = input("请输入您的密码：")
sql1 = "SELECT passwords FROM blank WHERE account = %s"
data1 = select(sql1, param)
print(data1[0][0])
if data1[0][0] == password:
quqian = int(input("请输入取钱金额："))
sql3 = "SELECT money FROM blank WHERE account = %s"
data3 = select(sql3, param)
print(data3)
if quqian <= data3[0][0]:
sql2 = "update blank set money = money - %s where account = %s"
param1 = [quqian, zh]
update(sql2, param1)
print("取钱成功！！")
else:
print("取钱失败，金额不足！")
else:
print("请输入正确的密码！！！")
return 2
else:
print("请输入用户账号不存在！！！")
return 1
def bank_transfer_accounts(account, accounts, password, money):
sql = "select account from user where account=%s"
sq = "select account from user where account=%s"
param = [account]
par = [accounts]
data = select(sql, param)
d = select(sq, par)
if len(data) == 0 and len(d) == 0:
return 1
sql1 = "select password from user where account = %s"
param1 = [account]
data = select(sql1, param1)
if data[0][0] != password:
return 2
sql2 = "select money from user where account = %s"
data = select(sql2, param1)
if data[0][0] < money:
return 3
# 正常转账
sql3 = "update user set money=money-%s where account = %s"
parma3 = [money, account]
update(sql3, parma3)
sql4 = "update user set money=money+%s where account = %s"
parma4 = [money, accounts]
update(sql4, parma4)
return 0
def bank_moneytransfer (account1,account2,password,moneytransfer):
sql = "select * from 开户 where account = %s"
date = select(sql,account1)
if len(date) != 0:
sql2 = "select * from 开户 where account = %s"
date1 = select(sql2,account2)
if len(date1) !=0:
sql3 = "select * from 开户 where account = %s and mima = %s"
date2 = select(sql3,[account1,password])
if len(date2) !=0:
sql4 = "select * from 开户 where account= %s and money >=%s"
date3 = select(sql4,[account1,moneytransfer])
if len(date3)!=0:
sql5 = "update 开户 set money = money - %s where account = %s"
update(sql5,[moneytransfer,account1])
sql6 = "update 开户 set money = money +%s where account = %s"
update(sql6,[moneytransfer,account2])
return 0
else:
return 3
else:
return 2
else:
return 1
def bank_getmoney (slef,account,password,gmoney):
# 账号是否存在
sql="select 账号 from users where 账号 =%s"
param=[account]
user=select(sql,param)
if len(user)>0:
# 密码是否正确
sql="select 账号 from users where 账号 =%s and 密码 = %s"
param=[account,password]
user=select(sql,param)
if len(user)>0:
#正常取钱
sql="select 账号 from users where 余额>=%s and 账号 =%s"
param = [gmoney, account]
user=select(sql,param)
if len(user) >0:
sql="update users set 余额=余额-%s where 账号 =%s"
param=[gmoney,account]
update(sql,param)
return 0
else:
return 3
else:
return 2
else:
return 1
def bank_transfer(self,account1, account2, password, money):
# 两个账号是不是存在
sql = "select 账号 from users where 账号=%s or 账号=%s"
param = [account1, account2]
user = select(sql, param)
if len(user) == 2:
# 转出账号密码是不是存在
sql = "select * from users where 密码=%s and 账号=%s"
param = [password, account1]
user = select(sql, param)
if len(user) > 0:
# 转出金额是不是足够
sql = "select 账号 from users where 余额>=%s and 账号=%s"
param = [money, account1]
user = select(sql, param)
if len(user) > 0:
# 正常转出
sql = "update users set 余额=余额- %s where 账号= %s "
param = [money, account1]
update(sql, param)
# 调用update方法
sql = "update users set 余额=余额+ %s where 账号= %s "
param = [money, account2]
update(sql, param)
return 0
else:
return 3
else:
return 2
else:
return 1
def bank_ransferA(chu_account, ru_account, password, chu_money):
sql8 = "select count(account) from bank where bank.account = %s or bank.account = %s"
param8 = [chu_account, ru_account]
data8 = select(sql8, param8)
if data8[0][0] == 2:
sql9 = "select count(account) from bank where bank.account = %s and bank.password = %s"
param9 = [chu_account, password]
data9 = select(sql9, param9)
if data9[0][0] == 1:
sqldx1 = "select * from bank where bank.account = %s"
paramdx1 = [chu_account]
datadx = select(sqldx1, paramdx1)
num1 = datadx[0][7]
if num1 >= chu_money:
sql10 = "update bank set bank.money = bank.money - %s where bank.account = %s"
param10 = [chu_money, chu_account]
update(sql10, param10)
sql11 = "update bank set bank.money = bank.money + %s where bank.account = %s"
param11 = [chu_money, ru_account]
update(sql11, param11)
return 0
else:
return 3
else:
return 2
else:
return 1
def bank_wda(account, password, wdamoney):
sql = "select count(*) from users where users.account = %s"
data = select(sql, account)
if data[0][0] == 0:
return 1
if data[0][0] == 1:
sql = "select count(*) from users where users.account= %s and users.password=%s"
param = [account, password]
data = select(sql, param)
if data[0][0] == 1:
sql2 = "select * from users where users.account= %s"
param2 = [account]
data2 = select(sql2, param2)
datanum = data2[0][7]
if datanum >= wdamoney:
sql = "update users set users.money =users.money -%s where users.money>=%s"
param = (wdamoney, wdamoney)
update(sql, param)
return 0
else:
return 3
else:
return 2
def bank_addUser(account, username, password, country, province, street, door):
#查询数据库中是否存在账号
sql = "select count(*) from bank"
data = select(sql, []) # ((72),(),())
print(data)
# 判断是否已满
if data[0][0] >= 100:
return 3
sql1 = "select * from bank where account = %s"
data1 = select(sql1, account)
# 判断是否存在
if len(data1) != 0:
return 2
# 准备一条sql语句
sql2 = "insert into bank values(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
param2 = [
account, username, password, country, province, street, door, 0,
bank_name
]
# 让控制台执行sql
update(sql2, param2)
return 1
def bank_quqian(take_user, take_password, take_money):
#判断 用户存在
sql = "select account from bank where account = %s;"
parame = [take_user]
users = select(sql, parame)
if len(users) != 0:
# 判断 密码正确
users = ()
sql = "select account from bank where account = %s and password = %s;"
parame = [take_user, take_password]
users = select(sql, parame)
if len(users) != 0:
#判断 余额足够
users = ()
sql = "select account from bank where account = %s and password = %s and (money-'%s') >= 0;"
parame = [take_user, take_password, take_money]
users = select(sql, parame)
if len(users) != 0:
#满足 扣钱
users = ()
sql = "update bank set money = money - %s where account = %s "
parame = [take_money, take_user]
update(sql, parame)
return 0 #成功 返回值0
else:
return 3 #钱不够返回3
else:
return 2 #用户密码不正确返回2
else:
return 1 #返回1
def bank_addUser(account, username, password, country, province, street, door):
# 判断是否已满
sql = "select * from users"
data = select(sql, [])
print(data)
if len(data) >= 100:
return 3
# 判断是否存在
sql = "select * from users where id = %s"
data = select(sql, account)
if len(data) != 0:
return 2
#正常开户
sql = "insert into users value(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
param = [
account, username, password, country, province, street, door, 0,
bank_name
]
update(sql, param)
return 1
def money_transfer(outuser, takeinuser, password, outmoney):
sql = "select * from users where id=%s "
data = select(sql, outuser)
sql5 = "select * from users where id=%s"
data1 = select(sql5, takeinuser)
if len(data) != 0 and len(data1) != 0:
sql1 = "select * from users where id=%s and upassword=%s"
data = select(sql1, [outuser, password])
if len(data) != 0:
sql2 = "select * from users where id=%s and money>=%s"
data = select(sql2, [outuser, outmoney])
if len(data) != 0:
sql3 = "update users set money=money-%s where id=%s"
update(sql3, [outmoney, outuser])
sql4 = "update users set money=money+%s where id=%s"
update(sql4, [outmoney, takeinuser])
return 0
else:
return 3
else:
return 2
else:
return 1
def savemoney(self, u):
sql = "select * from 开户 where account=%s "
data = select(sql, u.getAccount())
if len(data) != 0:
sql1 = "update 开户 set money = money + %s where account = %s;"
update(sql1, [u.getMoney(), u.getAccount()])
return 1
else:
return False
def bank_moneyin(account,money):
sql = "select * from 开户 where account =%s"
date = select(sql,account)
if len(date)!=0:
sql1 = "update 开户 set money =money + %s where account = %s"
update(sql1,[money,account])
return True
else:
return False
def storage(ca, cb): # 存钱
sql1 = "select * from user where account = %s"
param1 = [ca]
data1 = select(sql1, param1)
if len(data1) > 0:
sql2 = "update user set money = money + %s where account=%s"
param = [int(cb), ca]
update(sql2, param)
elif len(data1) == 0:
return False
def cun_money(user, savemoney):
sql = "select * from users where id = %s"
data = select(sql, user)
if len(data) != 0:
sql2 = "update users set money = money + %s where id = %s"
update(sql2, [savemoney, user])
return 1
else:
return 0
def bank_deposit(account, money):
sql = "select * from user where account = %s"
param = [account]
data = select(sql, param)
if len(data) != 0:
sql1 = "update user set money=money+%s where account = %s"
param1 = [money, account]
update(sql1, param1)
return True
else:
return False
def bank_saveMoney(ac,money):
sql1 = "select * from bank where username=%s"
user = select(sql1, ac)
print(len(user))
if len(user) != 0:
sql="update bank set money=money+%s where username=%s"
parm=[money,ac]
update(sql,parm)
print("存钱成功")
else:
print("没有该用户")
return False;
def bank_save(account, money):
sql = "select * from users where users.account = %s"
data = select(sql, account)
if len(data) != 0:
sql = "update users set money = money + %s where account= %s"
param = [money, account]
update(sql, param)
return 1
if len(data) == 0:
return False
def bank_cunqian(user, money):
sql = "select account from bank where account = %s ;"
parame = [user]
users = select(sql, parame)
if len(users) != 0:
sql = "UPDATE bank SET money = money + %s WHERE account = %s ;"
parame = [money, user]
update(sql, parame)
return True
else:
return False
def headerupload():
if request.method == 'POST':
f = request.files['headerpic']
base_path = path.abspath(path.dirname(__file__))
upload_path = path.join(base_path, 'static/uh_img/')
head_name = session.get('uid') + '.jpg'
file_name = upload_path + secure_filename(head_name)
f.save(file_name)
sql = "UPDATE t_user SET head_path='%s' WHERE uid='%s'" % (
head_name, session.get('uid'))
update(sql)
return userinfopage()
def bank_addMoney(account, money):
sql1 = "select account from user where user.account = %s"
param1 = [account]
data = select(sql1, param1)
num = len(data)
if num == 1:
sql2 = "update user set money = money + %s where account = %s"
param2 = [money, account]
update(sql2, param2)
return 1
if num == 0:
return False
def bank_savemoney(self,account,money):
sql = "select 账号 from users where 账号= %s;"
param = [account]
# 调用select方法
user = select(sql, param)
if len(user) > 0:
sql = "update users set 余额=余额+ %s where 账号= %s"
param = [money,account]
##调用方法update
update(sql, param) # (sql模板，param实际的填充参数)
return 1
else:
return False
def cun():
zh = input("请输入您的账号：")
sql = "select * from blank where account = %s"
param = [zh]
data = select(sql, param)
if len(data) != 0:
jine = int(input("请输入存钱金额："))
sql1 = "update blank set money = money + %s where account = %s"
param1 = [jine, zh]
update(sql1, param1)
print("存钱成功!!")
else:
print("不存在该用户，请重新输入！！")
