留言簿代码（python 的一个bottle.py写的）

# -*- coding: utf-8 -*- import sqlite3 from bottle import route , run ,debug ,template ,request ,validate, error from bottle import default_app,get,post nick='zhang' topic_id=0 #这个程序检查输入的语言是否是中文，并且以unicode形式输出 def china(s): if isinstance(s, unicode): #s=u"中文" return s else: #s="中文" return s.decode('utf-8') @get('/note') def note_form(): mydb = sqlite3.connect('my.db') c = mydb.cursor() c.execute("select * from main.note_book order by id desc limit 10;") result = c.fetchall() #mydb.commit() c.close() output = template('noteviews',rows=result) return output @post('/note') def note_submit(): notebody=request.forms.get('notebody') if notebody =="": return note_form() else: notebody=china(notebody) mydb = sqlite3.connect('my.db') c = mydb.cursor() c.execute("INSERT INTO note_book (name,content,topic_id) VALUES (?,?,?)", (nick,notebody,topic_id)) c.execute("select * from note_book order by id desc limit 10;") result = c.fetchall() mydb.commit() c.close() output = template('noteviews',rows=result) return output if __name__ == '__main__': run()