python输出sqlite表到网页浏览

发表于： 2021年1月14日 2021年1月14日
分类： Python
from http.server import BaseHTTPRequestHandler, HTTPServer
import sqlite3
import time,datetime

class RequestHandler(BaseHTTPRequestHandler):
    '''处理请求并返回页面'''
    conn = sqlite3.connect('./database.db')
    c = conn.cursor()

    # 处理一个GET请求
    def do_GET(self):
        time_stamp = datetime.datetime.now()
        time_stamp = time_stamp.strftime('%Y-%m-%d %H:%M:%S')

        self.c.execute("select * from COINS")
        script_list = self.c.fetchall()

        zd = self.c.execute("PRAGMA table_info('COINS')")
        zd = self.c.fetchall()


        html = '<table border="1"><tr>'
        for zdv in zd:
            html += '<th>'+zdv[1]+'</th>'
        html += '</tr>'

        for row in script_list:
            # html += "<tr><td>%s</td><td>%s</td><td>%s</td></tr>" % (row[0], row[1], row[2])
            html += '<tr>'
            for i in row:
                if 'e' in str(i):
                    html += '<td>%.8f</td>' % i
                else:
                    html +='<td>'+str(i)+'</td>'
            html += '</tr>'

        html += '</table>'
        # 页面模板
        Page = '''\
                <html>
                <head>
                <link rel="stylesheet" type="text/css" href="http://8.210.159.105/table.css" />
                <style type="text/css">
                body {padding:30px;}
                
                </style>
                </head>
                <body>
                <p>Hello, World! ZD VALUE IS %s,TIME IS %s</p>
                %s
                </body>
                </html>
            ''' % (len(zd),time_stamp,html)

        self.send_response(200)
        self.send_header("Content-Type", "text/html")
        self.send_header("Content-Length", str(len(Page)))
        self.end_headers()
        self.wfile.write(Page.encode('utf-8'))

if __name__ == '__main__':
    serverAddress = ('', 8080)

    server = HTTPServer(serverAddress, RequestHandler)
    server.serve_forever()
admin

1009