Debian Python数据库连接指南

2月 28th, 2025

在Debian系统上使用Python连接数据库，通常需要安装相应的数据库驱动模块。以下是一些常见数据库的连接指南：

MySQL

安装驱动：使用pip安装mysql-connector-python包。
```
pip install mysql-connector-python
```

连接示例：

import mysql.connector
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
cursor = cnx.cursor()
cursor.execute("SELECT * FROM table_name")
for row in cursor:
    print(row)
cursor.close()
cnx.close()

PostgreSQL

安装驱动：使用pip安装psycopg2包。
```
pip install psycopg2
```

连接示例：

import psycopg2
conn = psycopg2.connect(database="database_name", user="username", password="password", host="localhost", port="5432")
cur = conn.cursor()
cur.execute("SELECT * FROM table_name")
rows = cur.fetchall()
for row in rows:
    print(row)
cur.close()
conn.close()

SQLite

SQLite是Python的标准库之一，无需额外安装。

连接示例：

import sqlite3
conn = sqlite3.connect('example.db')
cur = conn.cursor()
cur.execute("CREATE TABLE students (id INTEGER PRIMARY KEY, name TEXT, grade TEXT)")
conn.commit()
cur.execute("INSERT INTO students (name, grade) VALUES (?, ?)", ('Alice', '10'))
conn.commit()
cur.execute("SELECT * FROM students")
rows = cur.fetchall()
for row in rows:
    print(row)
cur.close()
conn.close()