python操作sqlite的CRUD实例分析_程序人生

python操作sqlite的CRUD实例分析

admin

2023-07-31 02:25:05

0次

本文实例讲述了python操作sqlite的CRUD实现方法。分享给大家供大家参考。具体如下：

import sqlite3 as db
conn = 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.Row
cursor.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程序设计有所帮助。

python sqlite CRUD

上一篇：python基于Tkinter库实现简单文本编辑器实例

下一篇：实例说明Python中比较运算符的使用

python操作sqlite的CRUD实例分析

相关内容

热门资讯