首页 > 代码库 > Tornado 网站demo 三

Tornado 网站demo 三

模板

修改index.py

#!/usr/bin/env Python
# coding=utf-8

import tornado.web
import methods.readdb as mrd

class IndexHandler(tornado.web.RequestHandler):
    def get(self):
        usernames = mrd.select_columns(table="users",column="username")
        one_user = usernames[0][0]
        self.render("index.html", user=one_user)

    def post(self):
        username = self.get_argument("username")
        password = self.get_argument("password")
        user_infos = mrd.select_table(table="users",column="*",condition="username",value=http://www.mamicode.com/username)
        if user_infos:
            db_pwd = user_infos[0][2]
            if db_pwd == password:
                self.write("welcome you: " + username)
            else:
                self.write("your password was not right.")
        else:
            self.write("There is no thi user.")

readdb.py 添加select_columns 方法

def select_columns(table, column ):
    sql = "select " + column + " from " + table
    cur.execute(sql)
    lines = cur.fetchall()
    return lines

修改index.html文件

<!DOCTYPE html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <title>Learning Python</title>
</head>

<body>
    <h2> 登录页面</h2>
    <p>用用户名为:{{user}}登录</p>
    <form method="POST">
        <p><span>UserName:</span><input type="text" id="username"/></p>
        <p><span>Password:</span><input type="password" id="password" /></p>
        <p><input type="BUTTON" value="登录" id="login" /></p>
    </form>
<script src="{{static_url(‘js/jquery-3.2.1.min.js‘)}}"></script>
<script src="{{static_url(‘js/script.js‘)}}"></script>
</body>

要求用户正确登录之后,跳转到另外一个页面,并且在那个页面中显示出用户的完整信息。

 先修改 url.py 文件,在其中增加一些内容

#!/usr/bin/env Python
# coding=utf-8
"""
the url structure of website
"""

#!/usr/bin/env Python
# coding=utf-8
"""
the url structure of website
"""

from handlers.index import IndexHandler
from handlers.user import UserHandler

url = [
    (r/, IndexHandler),
    (r/user, UserHandler),
]

然后就建立 handlers/user.py 文件

#!/usr/bin/env Python
# coding=utf-8

import tornado.web
import methods.readdb as mrd

class UserHandler(tornado.web.RequestHandler):
    def get(self):
        username = self.get_argument("user")
        user_infos = mrd.select_table(table="users",column="*",condition="username",value=http://www.mamicode.com/username)
        self.render("user.html", users = user_infos)

 

Tornado 网站demo 三