import win32com.client
engine = win32com.client.Dispatch("DAO.DBEngine.35")
db = engine.OpenDatabase(r"C:\path\db.mdb")
rs = db.OpenRecordset("SELECT * FROM Customers WHERE City='Taipei'")
while not rs.EOF:
print(rs.Fields("Name").Value)
rs.MoveNext()
統一介面:connect() → cursor() → execute() → fetch*() → close()
import pyodbc # 或 mysql-connector, psycopg2, sqlite3 等
conn = pyodbc.connect('DSN=MyDB;UID=user;PWD=pass')
cur = conn.cursor()
cur.execute("SELECT id, name FROM users WHERE age > ?", (18,))
for row in cur.fetchall():
print(row)
cur.close()
conn.close()
透過 ctypes/calldll 呼叫 odbc32.dll 底層函數。不建議新專案使用,維護困難、易崩潰。
# COM 方式 (Windows)
import win32com.client
conn = win32com.client.Dispatch("ADODB.Connection")
conn.Open("Provider=SQLOLEDB;Data Source=.;Initial Catalog=DB;UID=sa;PWD=pass")
rs = conn.Execute("SELECT * FROM Products")
while not rs.EOF:
print(rs.Fields("Name").Value)
rs.MoveNext()
from sqlalchemy import create_engine, MetaData, Table, select
engine = create_engine("postgresql://user:pass@localhost/db")
meta = MetaData()
users = Table('users', meta, autoload_with=engine)
stmt = select(users.c.name, users.c.email).where(users.c.age > 18)
with engine.connect() as conn:
for row in conn.execute(stmt):
print(row)
# SQLAlchemy ORM 範例
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, Session
class Base(DeclarativeBase): pass
class User(Base):
__tablename__ = 'users'
id: Mapped[int] = mapped_column(primary_key=True)
name: Mapped[str]
email: Mapped[str]
age: Mapped[int]
engine = create_engine("sqlite:///demo.db")
Base.metadata.create_all(engine)
with Session(engine) as session:
session.add(User(name="Alice", email="a@b.c", age=25))
session.commit()
young = session.query(User).filter(User.age < 30).all()