标签:
import pymysql
db = pymysql.connect("localhost","root","subaobao666","newdatabase" ) #直接连入newdatabase库
cur = db.cursor() #获取游标
print('**************开始注册')
user1 = str(input('请输入账号:'))
password1 = str(input('请输入密码:'))
key1 = str(input('请输入注册码:'))
sql = """select * from key_1 where key_num = %s"""
aa = cur.execute(sql,[key1])
db.commit()
if aa==1:
sql = """select * from key_1 where (key_num = %s) and (syzt = 1)"""
aa = cur.execute(sql, [key1])
db.commit()
if aa == 1:
#判断用户名是否已被注册
sql = """select * from user_1 where username = %s"""
aa = cur.execute(sql, [user1])
db.commit()
if aa == 1:
print("用户名已存在,请重新注册")
else:
# 开始执行注册,加入用户数据到表中,且将该注册码标记为已使用状态:0
sql = """insert into user_1(username,userpassword,zhucekey) values (%s,%s,%s)"""
cur.execute(sql, [user1, password1, key1])
db.commit()
sql = """update key_1 set syzt = 0 where key_num = %s"""
cur.execute(sql, [key1])
db.commit()
print("注册成功")
else:
print("注册码已使用\n注册失败")
else:
print("注册码不存在");
db.close()
标签: