#1.pymysql连接mysql校验用户名和密码:
importpymysql
usn= input('请输入用户名:')
psd= input('请输入密码:')#pymysql连接MySQL,得到一个连接
conn =pymysql.connect(
host='localhost',
port=3306, #数字类型
user='root',
password='123',
database='db1',
charset='utf8' #注意是utf8不是utf-8
)
cursor= conn.cursor() #光标对象#不推荐此写法#sql = "select * from userinfo where username='%s'and password='%s'"%(usn,psd) #sql语句#ret = cursor.execute(sql) #光标执行sql语句,拿到行数#推荐下面传参的写法
sql = "select * from userinfo where username=%s and password=%s" #sql语句
ret = cursor.execute(sql,[usn,psd]) #让pymysql帮忙拼接字符串,避免出错,使用列表和元祖都可以
print(ret)ifret:print('登录成功')else:print('登录失败')
cursor.