app.py

运行app

from flask import Flask,render_template,request
from mysqlunit import MySql
import pandas as pd

app=Flask(__name__)
global rows

@app.route("/")
def index():
     global rows
     db=MySql(db="test")
     sql="select * from books"
     rows=db.query(sql)
     print(rows)
     return render_template("index.html",rows=rows)

@app.route("/showAnalyse")
def analyseInfo():
      global rows
      df=pd.DataFrame(rows)
      print(df)
      df1=df.groupby("Press").count()["BookId"].sort_values(ascending=False).head()
      print(df1)
      return render_template("analyseInfo.html",x=list(df1.index),y=list(df1))
if __name__=='__main__':
   app.run(debug=True)

mysqlunit.py

import pymysql

class MySql():
    # 类的构造方法，实例化对象时，获得连接及游标
    def __init__(self,db="test"):