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("登录失败")

 

posted @ 2018-12-02 22:47  随性岁分享  阅读(14)  评论(0)    收藏  举报