2021.12.05（echarts生成mysql表词云）
访问数据库的数据绘制词云
数据可视化echarts+mysql+python+flask
下面是后端代码：
from flask import Flask,render_template
import json
import pymysql
app = Flask(__name__)
@app.route('/')
def hello_world():
return render_template('index1.html')
@app.route('/test', methods=['POST'])
def mytest():
con = pymysql.connect(host='localhost',user='root',passwd='cbj123',db='bigdata',port=3306,charset='utf8')
cur = con.cursor()
sql = 'select * from hero'
cur.execute(sql)
see = cur.fetchall()
word = []
count = []
jsonData = {}
for data in see:
word.append(data[0])
count.append(data[1])
jsonData['word'] = word
jsonData['count'] = count
j = json.dumps(jsonData)
cur.close()
con.close()
return (j)
if __name__ == '__main__':
app.run(debug=True)
下面是前端代码：
Title
效果如下：
转载于：https://blog.csdn.net/No1Brother_Jian/article/details/90754499