数据库实例：mysql与redis结合用户登录

加入redis后登录逻辑如下图&＃xff0c;将图中nosql的位置换为redis即可

• 用户数据存的键为用户名&＃xff0c;值为密码
• 将原来MySQL操作的代码封装到一个方法中&＃xff0c;代码如下

defmysql_login():
    #redis中没有则到mysql中查询
    sql&＃61;&＃39;select upwd from py_users whereuname&＃61;%s&＃39;
    params&＃61;[uname]
    try:
        conn&＃61; connect(host&＃61;&＃39;localhost&＃39;,port&＃61;3306,database&＃61;&＃39;python&＃39;,user&＃61;&＃39;root&＃39;,password&＃61;&＃39;mysql&＃39;,charset&＃61;&＃39;utf8&＃39;)
        cur&＃61;conn.cursor()
       cur.execute(sql,params)
        result&＃61;cur.fetchone()
        cur.close()
        if result&＃61;&＃61;None:
            print &＃39;用户名错误&＃xff0c;登录失败&＃xff0c;数据来源于mysql&＃39;
        else:
            #当查询到用户及对应的密码时&＃xff0c;将数据加入到redis中&＃xff0c;以供后续登录使用
           r.set(uname,upwd_sha1)
            #判断密码是否正确
            if result[0]&＃61;&＃61;upwd_sha1:
                print &＃39;登录成功&＃xff0c;数据来源于mysql&＃39;
            else:
                print &＃39;密码错误&＃xff0c;登录失败&＃xff0c;数据来源于mysql&＃39;
    except Exception,e:
        print &＃39;登录失败&＃xff0c;错误原因&＃xff1a;%s&＃39; % e
    finally:
        conn.close()

• 创建user_redis.py文件&＃xff0c;代码如下

#coding&＃61;utf-8
from MySQLdb import*
from hashlib importsha1
from redis import*

if __name__&＃61;&＃61;&＃39;__main__&＃39;:
    try:
        #接收输入用户名、密码
        uname&＃61;raw_input(&＃39;请输入用户名&＃xff1a;&＃39;)
        upwd&＃61;raw_input(&＃39;请输入密码&＃xff1a;&＃39;)

#对密码加密
        s1&＃61;sha1()
        s1.update(upwd)
        upwd_sha1&＃61;s1.hexdigest()

#根据用户名查询密码
        #先到redis上查&＃xff0c;没有再到mysql上查
        r&＃61;StrictRedis()
        result&＃61;r.get(uname)
        if result&＃61;&＃61;None:
            mysql_login()
        else:
            #redis中找到了这个用户名的数据
            if result&＃61;&＃61;upwd_sha1:
                print &＃39;登录成功&＃xff0c;数据来源于redis&＃39;
            else:
                print &＃39;密码错误&＃xff0c;登录失败&＃xff0c;数据来源于redis&＃39;
    exceptException,e:
        print &＃39;登录失败&＃xff0c;错误原因&＃xff1a;%s&＃39;%e