登陆redis , 登录mysql
import sys
import pymysql
import redis
def con_mysql(sql):
db = pymysql.connect(
host = '47.98.173.x',
user = 'root',
passwd = '123456',
port = 3306,
db = 'passwd',
charset = 'utf8')
cursor = db.cursor()
cursor.execute(sql)
data = cursor.fetchall()
db.close()
return data
def con_redis(name, passwd):
r = redis.Redis(host = '47.98.173.x', port = 6379, password = '123456')
r_name = r.hget('user', 'nam')
r_passwd = r.hget('user', 'passwd')
r_name = r_name.decode('utf8')
r_passwd = r_passwd.decode('utf8')
if name == r_name and passwd == r_passwd:
return True, '欢迎回来, %s!' % name
else:
return False, '用户名或密码错误!'
def main():
name = sys.argv[1]
passwd = sys.argv[2]
result = con_redis(name, passwd)
if not result[0]:
sql = '''select * from stu where nam = '%s'
and passwd = '%s' ''' % (name, passwd)
data = con_mysql(sql)
if data:
r = redis.Redis(host = '47.106.145.176', port = 6379, password = '123456')
r.hset('user', 'nam', name)
r.hset('user', 'passwd', passwd)
print('刷新redis, 登陆成功!')
else:
print('用户名和密码错误!')
else:
print('redis中数据正确,登陆成功!')
if __name__ == '__main__':
main()