python一个通用mysql增删改查模板
时间: 2024-03-07 17:23:14 浏览: 19
下面是一个通用的 MySQL 增删改查模板,你可以根据自的实际需求进行修改:
```python
import mysql.connector
# 连接数据库
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
# 插入数据
def insert(table, data):
mycursor = mydb.cursor()
sql = f"INSERT INTO {table} (column1, column2, column3) VALUES (%s, %s, %s)"
val = (data["column1"], data["column2"], data["column3"])
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record inserted.")
# 更新数据
def update(table, id, data):
mycursor = mydb.cursor()
sql = f"UPDATE {table} SET column1 = %s, column2 = %s, column3 = %s WHERE id = %s"
val = (data["column1"], data["column2"], data["column3"], id)
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record(s) updated.")
# 删除数据
def delete(table, id):
mycursor = mydb.cursor()
sql = f"DELETE FROM {table} WHERE id = %s"
val = (id,)
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record(s) deleted.")
# 查询数据
def select(table):
mycursor = mydb.cursor()
sql = f"SELECT * FROM {table}"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
print(x)
```
使用时,你需要先连接到你的 MySQL 数据库,然后调用相应的函数进行增删改查操作,示例代码如下:
```python
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase