pymysql模块的简单操作

pymysql验证用户名密码

import pymysql

建立mysql链接

conn = pymysql.connect(
user=“root”,
password=“123”,
host=“localhost”,
database=“db12”,
port=3306,
charset=“utf8”,
)

name = input(“用户名”)
pwd = input(“密码”)

游标

cur = conn.cursor(cursor=pymysql.cursors.DictCursor) # 参数表示传参为字典类型 默认为元组或列表
sql = ‘select * from userinfo’
cur.execute(sql, {“name”: name, “pwd”: pwd})

if cur:
print(“登录成功”)
else:
print(“登录失败”)

cur.close()
conn.close()

---

pymysql 表内写数据

import pymysql

conn = pymysql.connect(
user=“root”,
password=“123”,
port=3306,
host=“localhost”,
charset=“utf8”,
database=“db12”
)

cur = conn.cursor()
sql = “insert into userinfo(name,pwd) values(%s,%s)”

cur.execute(sql, (input(“name”), input(“pwd”)))
conn.commit() # 想把数据写入数据库一定要conn.commit()
cur.close()
conn.close()

---

pymysql 表中获取数据

import pymysql
conn = pymysql.connect(
user=“root”,
password=“123”,
port=3306,
database=“db12”,
charset=“utf8”,
host=“localhost”
)

cur = conn.cursor()
sql = ‘select * from userinfo’
cur.execute(sql)
res = cur.fetchall()
print(res)
cur.close()
conn.close()

---

游标滚动 scroll

import pymysql

conn = pymysql.connect(
user=“root”,
password=“123”,
port=3306,
charset=“utf8”,
host=“localhost”,
database=“db12”
)

cur = conn.cursor()
sql = “select * from userinfo”
cur.execute(sql)
res = cur.fetchone()
print(res)
res = cur.fetchone()
print(res)

相对移动游标 向下1行

cur.scroll(1, “relative”)

绝对移动游标 到最初位置

cur.scroll(0,“absolute”)
res = cur.fetchone()
print(res)
cur.close()
conn.close()