如何在Python中处理数据库操作的问题

pip install psycopg2    # 连接 Postgresql
pip install mysql-connector-python    # 连接 MySQL
pip install pymongo    # 连接 MongoDB

import psycopg2    # PostgreSQL
conn1 = psycopg2.connect(database="mydb", user="myuser", passWord="mypassword", host="localhost", port="5432")

import mysql.connector    # MySQL
conn2 = mysql.connector.connect(user='myuser', password='mypassword', host='localhost', database='mydb')

import pymongo    # MongoDB
client = pymongo.MongoClient("mongodb://localhost:27017/")
db = client["mydb"]

# PostgreSQL
cur1 = conn1.cursor()
cur1.execute("SELECT * from mytable")
rows1 = cur1.fetchall()
for row in rows1:
    print(row)

# MySQL
cur2 = conn2.cursor()
cur2.execute("SELECT * from mytable")
rows2 = cur2.fetchall()
for row in rows2:
    print(row)

# MongoDB
col = db["mycollection"]
docs = col.find()
for doc in docs:
    print(doc)

# PostgreSQL
cur1 = conn1.cursor()
cur1.execute("INSERT INTO mytable (column1, column2) VALUES (%s, %s)", ("value1", "value2"))
conn1.commit()

# MySQL
cur2 = conn2.cursor()
cur2.execute("INSERT INTO mytable (column1, column2) VALUES (%s, %s)", ("value1", "value2"))
conn2.commit()

# MongoDB
col = db["mycollection"]
doc = { "column1": "value1", "column2": "value2" }
col.insert_one(doc)

# PostgreSQL
cur1 = conn1.cursor()
cur1.execute("UPDATE mytable SET column1 = %s WHERE column2 = %s", ("newvalue1", "value2"))
conn1.commit()

# MySQL
cur2 = conn2.cursor()
cur2.execute("UPDATE mytable SET column1 = %s WHERE column2 = %s", ("newvalue1", "value2"))
conn2.commit()

# MongoDB
col = db["mycollection"]
col.update_one({ "column2": "value2" }, { "$set": { "column1": "newvalue1" } })

# 删除数据
# PostgreSQL
cur1 = conn1.cursor()
cur1.execute("DELETE FROM mytable WHERE column2 = %s", ("value2",))
conn1.commit()

# MySQL
cur2 = conn2.cursor()
cur2.execute("DELETE FROM mytable WHERE column2 = %s", ("value2",))
conn2.commit()

# MongoDB
col = db["mycollection"]
col.delete_one({ "column2": "value2" })