web.py+sqlite写的简单留言本

最新推荐文章于 2023-03-25 17:19:40 发布

xuyf

最新推荐文章于 2023-03-25 17:19:40 发布

阅读量2.7k

点赞数 1

文章标签： sqlite web.py 数据库 insert date integer

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

import os,web,time
import sqlite3 as db

urls = (
        '/', 'hello',
        '/add','add'
        )

class hello:
    def GET(self):
        #实例化sqldb，然后获取内容
        s = ""
        sdb = sqldb()
        rec = sdb.cu.execute("""select * from msgs""")
        dbre = sdb.cu.fetchall()
        for i in dbre:
            s = "<p>"+i[2]+" <span style=/"color: blue/">"+i[1]+' sad: '+r"</span>"+" <span style=/"color: gray/">"+i[3]+r"</span></p>" + s

        sh = """
        <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML>
        <HEAD><meta http-equiv="X-UA-Compatible" content="IE=8" />
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <TITLE> OK!</TITLE> </HEAD> <BODY><h1>Hello World!</h1>
        """
        sb = """
        <h2>add a note</h2>
        <form method="post" action="/add">
        UserName:<INPUT TYPE="text" NAME="uname"><br />
        <textarea name="content" ROWS="20" COLS="60"></textarea><br />
        <button type="submit">save</button></form></BODY></HTML>
        """
        s = sh + s + sb
        return s

class add:
    def POST(self):
        i = web.input('content')
        n = web.input('uname')
        date = time.strftime("%Y-%m-%d %H:%M:%S",time.localtime())
        sdb = sqldb()
        rec = sdb.cu.execute("""select * from msgs""")
        dbre = sdb.cu.fetchall()
        for k in dbre:
            j = k[0]+1
        t = (j,n.uname,date,i.content)
        sdb.cu.execute('insert into msgs values(?,?,?,?)',t)
        sdb.conn.commit()
        return web.seeother('/')

    def GET(self):
        return web.seeother('/')

class sqldb:
    #先验证数据库是否存在
    def __init__(self):
        if os.path.exists("msg.db"):
            #如果数据库存在，就直接连接
            self.conn = db.connect("msg.db")
            self.cu = self.conn.cursor()
        else:
            #如果数据库不存在，连接，并生成表
            self.conn = db.connect("msg.db")
            self.cu = self.conn.cursor()
            self.cu.execute("""create table msgs(
                     id integer primary key,
                     name text,
                     date text,
                     content text) """)
            self.cu.execute("""insert into msgs values(1,'Ahai','2010-05-19 15:11:20','Ahi alaws be ok!')""")
            self.conn.commit()

if __name__=="__main__":

    app = web.application(urls,globals())
    app.run()

运行截图：

xuyf

关注

1
点赞
踩
3

收藏

觉得还不错? 一键收藏
2
评论
web.py+sqlite写的简单留言本

#!/usr/bin/env python#coding=utf-8import os,web,timeimport sqlite3 as dburls = ( '/', 'hello', '/add','add' )class hello: def GET(self): #实例化sqldb，然后获取内容 s = "" sdb = sqldb() rec
复制链接

扫一扫