python3链接sqlite3数据库

python3中本就内嵌了sqlite3数据库模块，只要导入代码就能连接

#  -*- coding:gbk -*-
import sqlite3

conn = sqlite3.connect('test.db')  # 打开或创建一个新的sqlite3轻量级数据库
cur = conn.cursor()    # 游标对象，用于执行sql语句

# cur.execute('create table t(id int,v varchar(20));')   #  execute执行sql语句
cur.execute("insert into t values(%d,'%s')" % (1, 'xxx'))
cur.execute("insert into t values(%d,'%s')" % (2, 'yyy'))
cur.execute("update t set v = '%s' where id = %d" % ('zzz', 2))
cur.execute("select * from t;")

results = cur.fetchall()   # 一条一条执行

for row in results:
    print(row)

conn.commit()
cur.close()
conn.close()