@app.route('/') #装饰器定义路由函数defshow_entries():
cur = g.db.execute('select title, text from entries order by id desc')
#查询数据库是否有数据 将数据以数组的形式存储在字典中 将数组传入网页
entries = [dict(title=row[0], text=row[1]) for row in cur.fetchall()]
return render_template('show_entries.html', entries=entries)
{% extends "layout.html" %}{% block body %}{% if session.logged_in %}<formaction="{
{ url_for('add_entry') }}"method=postclass=add-entry><dl><dt>Title:
<dd><inputtype=textsize=30name=title><dt>Text:
<dd><textareaname=textrows=5cols=40></textarea><dd><inputtype=submitvalue=Share></dl></form>{%