python mysql.connector DictCursor

使用Python与MySQL数据库进行交互是一个常见的任务，我们可以使用mysql.connector库来实现这个目标。在这篇文章中，我们将介绍如何使用mysql.connector的DictCursor来执行数据库操作，并提供一些案例代码来进一步说明。

python
pip install mysql-connector-python

python
import mysql.connector
# 建立与MySQL数据库的连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)
# 打印连接信息
print(mydb)

python
import mysql.connector
# 建立与MySQL数据库的连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)
# 创建游标
mycursor = mydb.cursor(dictionary=True)
# 执行查询语句
mycursor.execute("SELECT * FROM yourtable")
# 获取结果
results = mycursor.fetchall()
# 打印结果
for row in results:
  print(row)

python
import mysql.connector
# 建立与MySQL数据库的连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)
# 创建游标
mycursor = mydb.cursor(dictionary=True)
# 执行插入语句
sql = "INSERT INTO yourtable (column1, column2, column3) VALUES (%s, %s, %s)"
val = ("value1", "value2", "value3")
mycursor.execute(sql, val)
# 提交更改
mydb.commit()
# 打印插入的行数
print(mycursor.rowcount, "记录插入成功。")

python
import mysql.connector
# 建立与MySQL数据库的连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)
# 创建游标
mycursor = mydb.cursor(dictionary=True)
# 执行更新语句
sql = "UPDATE yourtable SET column1 = %s WHERE column2 = %s"
val = ("newvalue", "oldvalue")
mycursor.execute(sql, val)
# 提交更改
mydb.commit()
# 打印更新的行数
print(mycursor.rowcount, "记录更新成功。")

python
import mysql.connector
# 建立与MySQL数据库的连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)
# 执行数据库操作...
# 关闭数据库连接
mydb.close()