最近在学习echarts,写一篇文吧,第一篇~~~~
servers.py
from flask import Flask, render_template
import pymysql
app = Flask(__name__)
@app.route("/")
def my_echart():
# 连接数据库
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', db='mysql')
cur = conn.cursor()
sqlmale = ' SELECT count(num) FROM people_flow where sex=1 ' # 男
sqlfemale = ' SELECT count(num) FROM people_flow where sex=0' # 女
sqls = ' SELECT num FROM people_flow '#随意的数据int
cur.execute(sqlmale)
maleresult = cur.fetchall()
cur.execute(sqlfemale)
femaleresult = cur.fetchall()
cur.execute(sqls)
results = cur.fetchall()
male_num = maleresult[0][0]
female_num = femaleresult[0][0]
num1=[]
for result in results:
num1.append(result[0])
cur.close()
conn.close()
#print(male_num)
#print(female_num)
#print(num1)测试一下
return render_template('servers.html', male_num=male_num,
female_num=female_num,num1=num1)
if __name__ == '__main__':
app.run(debug=True)
servers.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>bar</title>