连接数据库user表,进行登录
时间:2021-07-01 10:21:17
帮助过:6人阅读
pymysql,hashlib,datetime
today =
datetime.datetime.today()
def op_mysql(sql):
db_info = {
‘user‘:
‘xxx‘,
‘password‘:
‘xxxxxx‘,
‘host‘:
‘127.0.0.1‘,
‘db‘:
‘xxx‘,
‘port‘: 3306,
‘charset‘:
‘utf8‘,
‘autocommit‘: True}
conn = pymysql.connect(**db_info)
# 建立连接
cur = conn.cursor(pymysql.cursors.DictCursor)
# 游标
cur.execute(sql)
# 执行sql语句,insert 、update 、delete
result =
cur.fetchall()
cur.close()
conn.close()
return result
for i
in range(3
):
username = input(
‘请输入用户名:‘).strip()
password = input(
‘请输入密码:‘).strip()
ha_pwd =
hashlib.md5(password.encode())
md5_pwd =
ha_pwd.hexdigest()
sql1 =
‘select * from user where username="%s";‘ %
(username)
if username ==
‘‘ or password ==
‘‘:
print(
‘用户名或密码不能为空‘)
elif not op_mysql(sql1):
print(
‘账号不存在‘)
elif op_mysql(sql1):
if op_mysql(sql1)[0].get(
‘error_count‘)<5
:
if md5_pwd==op_mysql(sql1)[0].get(
‘password‘):
print(
‘欢迎 %s登录,今天的日期是 %s‘ %
(username, today))
break
else:
new_count = op_mysql(sql1)[0].get(
‘error_count‘)+1
sql3 =
‘update user set error_count= "%s" where username="%s";‘%
(new_count,username)
op_mysql(sql3)
print(
‘密码不正确‘)
else:
print(
‘用户被冻结‘)
else:
print(
‘登录失败次数超过3次,不允许登录‘)
连接数据库user表,进行登录
标签:connect 获取 Oday pwd insert inf auto xxxxx ges