SQLite 查询示例

import sqlite3
conn = sqlite3.connect("app.db")
cur = conn.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS notes(id INTEGER PRIMARY KEY, body TEXT)")
cur.execute("INSERT INTO notes(body) VALUES (?)", ("hello",))
conn.commit()
rows = cur.execute("SELECT id, body FROM notes").fetchall()
print(rows)
conn.close()