importpymysqlimporthashlib
conn= pymysql.connect(user='root', passwd='123',db='test1')
cur=conn.cursor()
name=input("name:")
passwd=input('passwd:')
m=hashlib.md5() #数据库中的密码是md5值,所以输入的字符串要转换一下。
m.update(passwd.encode('utf-8'))
passwd_md5=m.hexdigest()
count=cur.execute("SELECT * FROM a1 where name='%s' and passwd='%s';" %(name,passwd_md5))
x=cur.fetchone()if count==0:print('没找到')else:print(x)
cur.close()
conn.close()