python操作sqlite的CRUD实例分析
本文实例讲述了python操作sqlite的CRUD实现方法。分享给大家供大家参考。具体如下:
importsqlite3asdb conn=db.connect('mytest.db') cursor=conn.cursor() cursor.execute("droptableifexistsdatecounts") cursor.execute("createtabledatecounts(datetext,countint)") cursor.execute('insertintodatecountsvalues("12/1/2011",35)') cursor.execute('insertintodatecountsvalues("12/2/2011",42)') cursor.execute('insertintodatecountsvalues("12/3/2011",38)') cursor.execute('insertintodatecountsvalues("12/4/2011",41)') cursor.execute('insertintodatecountsvalues("12/5/2011",40)') cursor.execute('insertintodatecountsvalues("12/6/2011",28)') cursor.execute('insertintodatecountsvalues("12/7/2011",45)') conn.row_factory=db.Row cursor.execute("select*fromdatecounts") rows=cursor.fetchall() forrowinrows: print("%s%s"%(row[0],row[1])) cursor.execute("selectavg(count)fromdatecounts") row=cursor.fetchone() print("Theaveragecountfortheweekwas%s"%row[0]) cursor.execute("deletefromdatecountswherecount=40") cursor.execute("select*fromdatecounts") rows=cursor.fetchall() forrowinrows: print("%s%s"%(row[0],row[1]))
希望本文所述对大家的Python程序设计有所帮助。