在Ubuntu上使用Python连接数据库,通常需要使用数据库的官方驱动或第三方库。以下是一些常见数据库的连接方法:
mysql-connector-python
pip install mysql-connector-python
import mysql.connector
# 连接数据库
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
# 创建游标
mycursor = mydb.cursor()
# 执行SQL查询
mycursor.execute("SELECT * FROM yourtable")
# 获取查询结果
myresult = mycursor.fetchall()
for x in myresult:
print(x)
# 关闭游标和连接
mycursor.close()
mydb.close()
psycopg2
pip install psycopg2-binary
import psycopg2
# 连接数据库
conn = psycopg2.connect(
dbname="yourdatabase",
user="yourusername",
password="yourpassword",
host="localhost",
port="5432"
)
# 创建游标
cur = conn.cursor()
# 执行SQL查询
cur.execute("SELECT * FROM yourtable")
# 获取查询结果
rows = cur.fetchall()
for row in rows:
print(row)
# 关闭游标和连接
cur.close()
conn.close()
sqlite3
pip install pysqlite3
import sqlite3
# 连接数据库
conn = sqlite3.connect('yourdatabase.db')
# 创建游标
cursor = conn.cursor()
# 执行SQL查询
cursor.execute("SELECT * FROM yourtable")
# 获取查询结果
rows = cursor.fetchall()
for row in rows:
print(row)
# 关闭游标和连接
cursor.close()
conn.close()
pymongo
pip install pymongo
from pymongo import MongoClient
# 连接数据库
client = MongoClient('mongodb://localhost:27017/')
# 选择数据库
db = client['yourdatabase']
# 选择集合
collection = db['yourcollection']
# 查询文档
documents = collection.find()
for doc in documents:
print(doc)
# 关闭连接
client.close()
redis-py
pip install redis
import redis
# 连接数据库
r = redis.Redis(host='localhost', port=6379, db=0)
# 设置键值对
r.set('yourkey', 'yourvalue')
# 获取键值对
value = r.get('yourkey')
print(value)
# 关闭连接
r.close()
通过以上方法,你可以在Ubuntu上使用Python连接到各种数据库。