准备工作
安装python准备工作链接
app.js(入口文件)
from gevent import pywsgi
from flask import Flask
from mysql.DB import DB
from router.index import setRoute
db = DB()
app = Flask(__name__)
initRoute = setRoute(app, db)
if __name__ == '__main__':
server = pywsgi.WSGIServer(('192.168.155.26', 8899), app)
print('Running on http://192.168.155.26:8899/')
server.serve_forever()
连接数据库
import pymysql
class DB():
def __init__(self):
self.__connectDb()
def __connectDb(self):
db = pymysql.connect(host='127.0.0.1',
user='root',
password='root',
database='my-build-party')
return db
def query(self, sql):
cursor = self.__connectDb().cursor()
sql_select = sql
cursor.execute(sql_select)
results = cursor.fetchall()
self.__connectDb().close()
return results
路由
from mysql.jsonData import get_data
import json
class setRoute():
def __init__(self, app, db):
self.app = app
self.db = db
self.initRoute()
def initRoute(self):
self.__setHomeRoute()
self.setHomeUserList()
def __setHomeRoute(self):
@self.app.route('/')
def hello_world():
return 'hello world!'
def setHomeUserList(self):
@self.app.route("/user/<int:id>")
def api(id):
request_id = int(id)
global real_json
try:
file = get_data(self.db.query('select * from sys_user'))
print(file)
j1 = json.loads(file)
real_json = "未找到该数据"
for i in j1:
id = i['userId']
if request_id == id:
print(i)
real_json = json.dumps(i, ensure_ascii=False)
except file.DoesNotExist:
print("连接数据库失败")
body = real_json
response = body
print("\nresponse data:", response)
return response
转换data为JSON格式
import json
def get_data(results):
json_data = []
for i in results:
result = {"userId": i[0], "userName": i[2], "deptId": i[1]}
json_data.append(result)
jsondatar = json.dumps(json_data, ensure_ascii=False)
return jsondatar