Home >Backend Development >Python Tutorial >python从sqlite读取并显示数据的方法
python从sqlite读取并显示数据的方法
- WBOYOriginal
- 2016-06-06 11:15:481454browse
本文实例讲述了python从sqlite读取并显示数据的方法。分享给大家供大家参考。具体实现方法如下：
import cgi, os, sys
import sqlite3 as db
conn = db.connect('test.db')
cursor = conn.cursor()
conn.row_factory = db.Row
cursor.execute("select * from person")
rows = cursor.fetchall()
sys.stdout.write("Content-type: text.html\r\n\r\n")
sys.stdout.write("")
sys.stdout.write("<html><body><p>")
for row in rows:
sys.stdout.write("%s %s %s" % (row[0],row[1],row[2]))
sys.stdout.write("<br />")
sys.stdout.write("</p></body></html>")
希望本文所述对大家的Python程序设计有所帮助。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：python查询sqlite数据表的方法Next article：python实现在sqlite动态创建表的方法