python - 从用户输入中搜索 SQLite 数据

Question

import sqlite3
conn = sqlite3.connect('ProcessPower.db')

c = conn.cursor()
user_input = (input("Enter a Type: "))

c.execute("SELECT * FROM Instrumentation WHERE Type = ?", user_input)
rows = c.fetchall()
for row in rows:
    print(row)
conn.close()

标签： pythonpython-3.xsqlite