python中,从mysql读取数据,并存入redis里面(3)
from Redis_Helper import RedisHelper
from MysqlHelper import TestHelper
from hashlib import sha1
name=input("请输入用户名:")
pwd1=input("请输入密码:")
s1=sha1()
s1.update(pwd1.encode("utf8"))
pwd2=s1.hexdigest()
r=RedisHelper('localhost',6379)
m=TestHelper('localhost',3306,'test','root','root')
temp1=r.get(name)
if temp1 == None:
sql ='select passwd from user1 where name=%s'
pwd3 = m.one(sql, [name])
if pwd3 == None:
print("用户名错误!")
else :
r.set(name,pwd3[0])
if pwd3[0]==pwd2:
print("成功!")
else:
print("密码错误!----")
else:
if r.get(name).decode()==pwd2:
print("成功!")
else:
print("密码错误!!!")