显示注册用户的前台主要代码如下:
{%block content%} <ul> {%for i in users%} <li><a href=‘/user/{{i[1]}}‘ class=‘text-success h4‘>{{i[1]}}<small>({{i[3]}}星级)</small></a></li> {%end%} <br/> </ul> {%end%}
class memberHandler(tornado.web.RequestHandler): def get(self): name=self.get_cookie(‘hackerName‘) users=show() users.sort(key=lambda x:x[3],reverse=True) self.render(‘member.html‘,cookieName=name,users=users)
def show(): c.execute(‘select * from user‘) return c.fetchall()
user表定義如下:
CREATE TABLE user(id integer primary key,name text,pw text,level integer);
轉載請注明:轉自http://blog.csdn.net/littlethunder/article/details/25559749
【從0開始Tornado建站】顯示所有注冊用戶,布布扣,bubuko.com
原文地址:http://blog.csdn.net/littlethunder/article/details/25559749