## 示例：用戶登錄 * 業務過程如下： * 輸入用戶名、密碼 * 密碼加密 * 判斷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') ~~~