## 示例：用户登录 * 业务过程如下： * 输入用户名、密码 * 密码加密 * 判断redis中是否记录了用户名，如果有则成功 * 如果redis中没有用户名，则到mysql中查询 * 从mysql中查询成功后，将用户名记录到redis中 ~~~ #encoding=utf-8 from t2 import RedisHelper from t3 import MysqlHelper import hashlib name=raw_input("请输入用户名：") pwd=raw_input("请输入密码：") sha1=hashlib.sha1() sha1.update(pwd) pwd1=sha1.hexdigest() try: redis=RedisHelper() if redis.get('uname')==name: print 'ok' else: mysql=MysqlHelper('localhost',3306,'test1','root','mysql') upwd=mysql.get_one('select upwd from userinfos where uname=%s',[name]) if upwd==None: print '用户名错误' elif upwd[0]==pwd1: redis.set('uname', name) print '登录成功' else: print "密码错误" except Exception,e: print e.message ~~~ ## python3代码 ~~~ #!/usr/bin/env python # -*- coding: utf-8 -*- ''' @Time : 5/19/18 3:42 AM @Author : haibo @File : Login.py ''' # 用户登录完善 from MyRedis import redisHelper from MysqlHelper import MysqlHelper from hashlib import sha1 # 接收输入 name = input("请输入用户用户名") pwd1 = input('请输入密码') # 加密 s1 = sha1() s1.update(pwd1.encode('utf-8')) pwd2 = s1.hexdigest() # 查询redis中是否存在用户 r = redisHelper('localhost', 6379) m = MysqlHelper('localhost', 3306, 'python3', 'root', 'haibo') # print(r.get('name')) # 判断redis中是否存储了此用户和密码 if r.get(name) is None: sql = 'select upwd from userinfos where uname=%s' result = m.one(sql, [name]) if result is None: print('用户名错误') else: # 把sql查出来的数据存储到redis # 从mysql中查询出来数据,则存储到redis中 r.set(name, result[0]) # 判断密码是否正确 if result[0] == pwd2: print('成功--mysql') else: print('密码错误--mysql') else: if r.get(name) == pwd2.encode(encoding="utf-8"): print('登录成功--redis') else: print('密码错误!--redis') ~~~