本文实例讲述了python操作sqlite的crud实现方法。分享给大家供大家参考。具体如下：
import sqlite3 as dbconn = db.connect('mytest.db')cursor = conn.cursor()cursor.execute(drop table if exists datecounts)cursor.execute(create table datecounts(date text, count int))cursor.execute('insert into datecounts values(12/1/2011,35)')cursor.execute('insert into datecounts values(12/2/2011,42)')cursor.execute('insert into datecounts values(12/3/2011,38)')cursor.execute('insert into datecounts values(12/4/2011,41)')cursor.execute('insert into datecounts values(12/5/2011,40)')cursor.execute('insert into datecounts values(12/6/2011,28)')cursor.execute('insert into datecounts values(12/7/2011,45)')conn.row_factory = db.rowcursor.execute(select * from datecounts)rows = cursor.fetchall()for row in rows: print(%s %s % (row[0], row[1]))cursor.execute(select avg(count) from datecounts)row = cursor.fetchone()print(the average count for the week was %s % row[0])cursor.execute(delete from datecounts where count = 40)cursor.execute(select * from datecounts)rows = cursor.fetchall()for row in rows: print(%s %s % (row[0], row[1]))
希望本文所述对大家的python程序设计有所帮助。