使用代码进行控制
import pymysql
# 连接数据库在连接之后直接进入day2
conn = pymysql.connect(host='127.0.0.1', user='root', passwd='jhy030116', charset='utf8', db='day2')
首先在数据库中创建对应的表
mysql> create database usersdb default charset utf8 collate utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
mysql> create table users(id int not null primary key auto_increment,
-> name varchar(32),
-> password varchar(64)
-> )default charset=utf8;
Query OK, 0 rows affected (0.45 sec)
mysql> describe users
-> ;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(32) | YES | | NULL | |
| password | varchar(64) | YES | | NULL | |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
import pymysql
def register():
print("用户注册")
user = input("请输入用户名")
passwd = input("请输入密码")
conn = pymysql.connect(host='127.0.0.1', user='root', passwd='jhy030116', charset='utf8', db='usersdb')
cursor = conn.cursor()
sql = 'insert into users(name, password) values("{}", "{}")'.format(user, passwd)
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()
def login():
print("用户登录")
user = input("请输入用户名")
passwd = input("请输入密码")
conn = pymysql.connect(host='127.0.0.1', user='root', passwd='jhy030116', charset='utf8', db='usersdb')
cursor = conn.cursor()
sql = 'select * from users where name="{}" and password="{}"'.format(user, passwd)
cursor.execute(sql)
result = cursor.fetchone() # 检查上一个返回的值
cursor.close()
conn.close()
if result:
print("成了")
else:
print("爬")
def run():
choice = input("1.登录, 2.注册")
if choice == '1':
login()
else:
register()
if __name__ == '__main__':
run()