Simple Web Application using Cherrypy in Python 3.3 with MySQL

最新推荐文章于 2022-07-02 23:31:40 发布

solaris_navi

最新推荐文章于 2022-07-02 23:31:40 发布

阅读量1.3k

点赞数 1

分类专栏： Python

本文链接：https://blog.csdn.net/solaris_navi/article/details/37937075

版权

Python 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

import cherrypy
import mysql.connector as mconnector
import sys

# Global
global conn
global cur

try:
    conn = mconnector.connect(user='test',
                              password='test1234',
                              host='localhost',
                              database='test')

    cur = conn.cursor()

except:
    print(sys.exc_info()[1])


class HelloWorld(object):

    @cherrypy.expose
    def index(self):
        cherrypy.session["abc"] = "abc"
        return "Hello World!"

    @cherrypy.expose
    def test(self):
        return "Hello world2!"

    @cherrypy.expose
    def say(self, name):
        return "Hello, %s" % name

    @cherrypy.expose
    def getsession(self):
        return cherrypy.session["abc"]

    @cherrypy.expose
    def loaddata(self):
        try:
                cur.execute('select * from testtable1')
                rows = cur.fetchall()

                str = "<br/>".join("%d %s" %(row[0], row[1].decode("utf-8")) for row in rows )

                return str;
        except:
            return "Error while processing data<br/>" + sys.exc_info()[1];


conf = {
         '/': {
             'tools.sessions.on': True
         }
     }

cherrypy.quickstart(HelloWorld(),'/', conf)