不以学习为目的的学习，那是耍流氓~所以流氓都成了有钱人。。。。。。
额，不贫了。从某天开始，次博客只谈学习和感情，不谈工作，不扯没用的~
今天整个啥呢？容我思量思量~嗯，昨天不整了数据库吗，那就从这里开始吧，来粘贴个小代码，小爽一下子~
“”“数据库の基本操作”“”
from pymysql import *
from hashlib import *
from pymongo import *
from redis import *
def register():
"""注册"""
try:
# 1. 获取连接对象
conn = mysql_conn()
# 2. 数据库操作对象
cur = conn.cursor()
# 3. 编写sql
select_params = [uname]
select_sql = 'select upwd from momo_users where uname = %s'
# 4.执行sql
cur.execute(select_sql, select_params)
res = cur.fetchone()
print(res)
if res is not None:
print('用户名已经被注册,注册失败')
return
# 注册用户 用户一定不存在 插入数据
insert_params = [uname, sha_pwd]
insert_sql = 'insert into momo_users (uname,upwd) values (%s,%s)'
count = cur.execute(insert_sql, insert_params)
if count == 0:
print('注册失败')
else:
print('注册成功', uname)
# 5. 如果是数据更新操作需要commit
conn.commit()
# 6.关闭cursor对象和连接对象
cur.close()
conn.close()
except Exception as e:
print(e)
def mysql_login():
"""登陆"""
try:
# 1. 获取连接对象
conn = mysql_conn()
# 2. 数据库操作对象
cur = conn.cursor()
# 3. 编写sql
select_params = [uname]
select_sql = 'select upwd from momo_users where uname = %s'
# 4.执行sql
cur.execute(select_sql, select_params)
res = cur.fetchone()
if res is None:
# 根据用户名没有获取到相关信息，此时用户名错误
print('用户名错误，登录失败')
cur.close()
conn.close()
return
# 获取密码信息 判断密码是否相等
print(res)
m_pwd = res[0]
if m_pwd == sha_pwd:
print('密码正确，登录成功',uname)
# 将查询到的结果存储到mongo/redis中
# col.insert_one({'username':uname,'password':sha_pwd})
r_client.set(uname,sha_pwd)
else:
print('密码错误，登录失败')
# 6.关闭cursor对象和连接对象
cur.close()
conn.close()
except Exception as e:
print(e)
def mongo_login():
# 获取mongo的连接对象
m_client = MongoClient(host='localhost',
port=27017)
db = m_client.QQDB
col = db.QQ_users
# 根据用户名获取数据 约定mongo中的数据存储的方式 {'username':uname,'password':sha_pwd}
res = col.find_one({'username': uname})
if res is None:
print('mongo中没有获取到任何数据，在mysql中完成登陆')
mysql_login()
else:
print(res)
m_password = res['password']
if m_password == sha_pwd:
print('密码正确，登录成功，mongodb')
else:
print('密码错误，登录失败，mongodb')
def mysql_conn():
return connect(host='localhost',
user='root',
password='mysql',
database='python_restore',
port=3306,
charset='utf8')
if __name__ == '__main__':
uname = input('请输入用户名：')
upwd = input('请输入密码：')
# sha1
s1 = sha1()
s1.update(upwd.encode())
sha_pwd = s1.hexdigest()
print(sha_pwd)
# register()
# login()
r_client = StrictRedis(host='192.168.85.70')
# 约定好如何存储数据 key value uname sha_pwd
res = r_client.get(uname)
print(res)
if res is None:
print('redis中没有获取到任何数据，在mysql中完成登陆')
mysql_login()
else:
r_pwd = res.decode()
if r_pwd == sha_pwd:
print('密码正确，登录成功，redis')
else:
print('密码错误，登录失败，redis')
好了，就先到这里吧。下一次把Python中相关的服务器这块儿代码搞一搞~可以的。
