Python 操作 sqlite

代码示例

#导入sqlite3库
import sqlite3  

#连接数据库  
conn = sqlite3.connect("customers.db")  

#创建表，主键id自增
conn.execute('''CREATE TABLE IF NOT EXISTS tb_user
      (ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
      NAME           TEXT    NOT NULL, 
      AGE            INT     NOT NULL);''')  

#向表中插入记录  
name = 'Jay'
age = 28
sql = "insert into tb_user(name,age)values('%s',%d)" % (name, age)  
conn.execute(sql)  
conn.commit() 

# 查询记录
cursor = conn.execute("select id,name,age  from tb_user")
values = cursor.fetchall()
print(values)

#关闭数据库连接  
cusor.close()
conn.close()