目录
1、pymysql模块使用说明
1.1 操作流程
import pymysql
conn = pymysql.connect(参数列表)
连接对象操作说明:
conn.close()
conn.commit()
conn.rollback()
1.2 获取游标对象
cur = conn.cursor()
游标操作说明:
execute(operation [parameters]):使用游标执行SQL语句,返回受影响的行数,主要用于执行insert,update,delete,select等语句。也可以执行creater,alter,drop等语句。
cur.fetchone():获取查询结果集中的一条数据,返回一个元组
curfetchall():获取查询结果集中的所有数据,返回一个元组
cur.close():关闭游标,表示和数据库操作完成
2、实例
获取一条数据
import pymysql
conn = pymysql.connect(host="localhost",
port=3306,
user="root",
password="123456",
database="gctzsc_db",
charset="utf8"
)
cursor = conn.cursor()
sql = "select * from type_tb;"
cursor.execute(sql)
row = cursor.fetchone()
print(row)
cursor.close()
conn.close()
获取多条数据
import pymysql
conn = pymysql.connect(host="localhost",
port=3306,
user="root",
password="123456",
database="gctzsc_db",
charset="utf8"
)
cursor = conn.cursor()
sql = "select * from type_tb;"
cursor.execute(sql)
row = cursor.fetchall()
print(row)
cursor.close()
conn.close()
对数据进行增删改查
import pymysql
conn = pymysql.connect(host="localhost",
port=3306,
user="root",
password="123456",
database="gctzsc_db",
charset="utf8"
)
cursor = conn.cursor()
sql = "update type_tb set t_name = '其它' where t_id = '11';"
try:
cursor.execute(sql)
conn.commit()
except:
conn.rollback()
sql = "select * from type_tb where t_id = '11';"
cursor.execute(sql)
row = cursor.fetchone()
print(row)
cursor.close()
conn.close()