webpy-mydemo

最新推荐文章于 2022-02-21 21:57:15 发布

freshfox

最新推荐文章于 2022-02-21 21:57:15 发布

阅读量135

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/freshfox/article/details/109779966

版权

python 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

import web


 # /friend/1
# CREATE TABLE `friend` (
#   `id` int(11) NOT NULL AUTO_INCREMENT,
#   `name` char(255) NOT NULL,
#   `nickname` char(255) DEFAULT NULL,
#   `icon` char(255) DEFAULT NULL,
#   PRIMARY KEY (`id`)
# ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;



urls = (
'/friend/(\d+)','friend',
    '/(.*)', 'hello',

)
app = web.application(urls, globals())
db = web.database(dbn='mysql', user='root', pw='ilovevC6aA!', db='test')
# todos = db.select('todo')
# xxx =0
#
# for item in todos:
#     xx =0
sqlOffset = 3

class friend :
    def GET(self, pageid):
        name =''
        _pageid =  int(pageid) *sqlOffset
        result =[]
        sql = "select * from friend   limit " + str(_pageid) + ',' + str(sqlOffset)
        sqlresults = list(db.query(sql))

        for item in sqlresults:
            res ={}

            res['name'] = item['name']
            result.append(res)
        return result
class hello:
    def GET(self, name):
        if not name:
            name = 'World'
            todos = db.select('todo')
            results = list(db.query("select * from friend "))

            for item in results:
                # name = name + item.title
                xxx =0


            xx=0
            # db.
        return 'Hello, ' + name + '!'

if __name__ == "__main__":
    app.run()

import web

urls = (
    '/login', 'login',
'/friend/(\d+)','friend',
    '/(.*)', 'hello',
)
app = web.application(urls, globals())
db = web.database(dbn='mysql', user='root', pw='ilovevC6aA!', db='test')

sqlOffset = 3

class login:
    def POST (self):
        a = int(web.input().userName)
        pass

class friend :
    def GET(self, pageid):
        name =''
        _pageid =  int(pageid) *sqlOffset
        result =[]
        sql = "select * from friend   limit " + str(_pageid) + ',' + str(sqlOffset)
        sqlresults = list(db.query(sql))

        for item in sqlresults:
            res ={}

            res['name'] = item['name']
            result.append(res)
        return result


if __name__ == "__main__":
    app.run()

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title1111</title>
<script src="jquery.js"></script>
  <script type="text/javascript">
        function login() {
            $.ajax({
            //几个参数需要注意一下
                type: "POST",//方法类型
                dataType: "json",//预期服务器返回的数据类型
                url: "/login" ,//url
                data: $('#form1').serialize(),
                success: function (result) {
                    console.log(result);//打印服务端返回的数据(调试用)
                    if (result.resultCode == 200) {
                        alert("SUCCESS");
                    }
                    ;
                },
                error : function() {
                    alert("异常！");
                }
            });
        }
    </script>



</head>
<body>

<form id="form1" onsubmit="return false" action="##" method="post">
        <p>用户名：<input name="userName" type="text" id="txtUserName" tabindex="1" size="15" value=""/></p>
        <p>密　码：<input name="password" type="password" id="TextBox2" tabindex="2" size="16" value=""/></p>
        <p><input type="button" value="登录" onclick="login()">&nbsp;<input type="reset" value="重置"></p>
    </form>

</body>
</html>

freshfox

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
webpy-mydemo

import weburls = ( '/(.*)', 'hello')app = web.application(urls, globals())db = web.database(dbn='mysql', user='root', pw='ilovevC6aA!', db='test')# todos = db.select('todo')# xxx =0## for item in todos:# xx =0class hello: def GET(se.
复制链接

扫一扫