python操作SQLite数据库的Cursor对象

一 代码

import sqlite3
conn=sqlite3.connect(":memory:")
cur=conn.cursor()
cur.execute("CREATE TABLE people(name_last,age)")
who = "cakin"
age = 35
cur.execute("INSERT INTO people VALUES(?,?)",(who,age))
cur.execute("SELECT * FROM people WHERE name_last=:who1 AND age = :age1",
            {"who1":who,"age1":age})
print(cur.fetchone())

 

二 运行结果

==========

('cakin', 35)