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()