python连接mysql数据库
python连接mysql数据库如下
import pymysql use = input("请输入用户名:") pwd = input("请输入密码:") # *******方法一******** conn = pymysql.connect(host="localhost", user="root", password="123456", database="pys9db") cursor = conn.cursor() sql = "select * from userinfo where username='%s' and password='%s'" %(use,pwd) cursor.execute(sql) # 返回受影响的函数 result = cursor.fetchone() # 获取第一条 cursor.close() conn.close() print(result) if result: print("登录成功") else: print("登录失败")
# **********方法二**********
conn = pymysql.connect(host="localhost", user="root", password="123456", database="pys9db")
cursor = conn.cursor() # 创建游标对象
sql = "select * from user1 where username=%s and password=%s"
# sql = "select * from user1 where username=%(u)s and password=%(p)s"
cursor.execute(sql, (use, pwd)) # 防sql注入
# cursor.execute(sql, [use, pwd]) # execute 传参拼接参数(占位符)
# cursor.execute(sql, {"u": use, "p": pwd})
# result = cursor.fetchone() # 获取第一条
result = cursor.fetchall() # 所有的都可获取
cursor.close()
conn.close()
print(result)
if result:
print("登录成功")
else:
print("登录失败")
浙公网安备 33010602011771号