python自动化怎么连接数据库

数据库类型 库 连接方法 示例 MySQL mysql-connector-python
python
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)


python
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT FROM customers")
myresult = mycursor.fetchall()
for x in myresult:
print(x)
mydb.close()

PostgreSQL psycopg2
python
import psycopg2
conn = psycopg2.connect(
host="yourhost",
database="yourdatabase",
user="yourusername",
password="yourpassword"
)


python
import psycopg2
conn = psycopg2.connect(
host="yourhost",
database="yourdatabase",
user="yourusername",
password="yourpassword"
)
cur = conn.cursor()
cur.execute("SELECT FROM customers")
rows = cur.fetchall()
for row in rows:
print(row)
cur.close()
conn.close()

SQLite sqlite3
python
import sqlite3
conn = sqlite3.connect('mydatabase.db')


python
import sqlite3
conn = sqlite3.connect('mydatabase.db')
cursor = conn.cursor()
cursor.execute("SELECT FROM customers")
rows = cursor.fetchall()
for row in rows:
print(row)
cursor.close()
conn.close()

MongoDB pymongo
python
import pymongo
client = pymongo.MongoClient("mongodb://localhost:27017/")
db = client["yourdatabase"]
collection = db["yourcollection"]


python
import pymongo
client = pymongo.MongoClient("mongodb://localhost:27017/")
db = client["yourdatabase"]
collection = db["yourcollection"]
for document in collection.find():
print(document)

Oracle cx_Oracle
python
import cx_Oracle
conn = cx_Oracle.connect(
"username/password@host:port/service_name"
)


python
import cx_Oracle
conn = cx_Oracle.connect(
"username/password@host:port/service_name"
)
cursor = conn.cursor()
cursor.execute("SELECT FROM customers")
rows = cursor.fetchall()
for row in rows:
print(row)
cursor.close()
conn.close()