爬虫+sqlite数据库+echart图表运行出现问题

from flask import Flask, render_template
import sqlite3

app = Flask(__name__)
app = Flask(__name__, static_folder='F:/flaskProject/static')

@app.route('/')
def index():
return render_template("index.html")


@app.route('/index')
def home():
return render_template("index.html")


@app.route('/movie')
def movie():
datalist = []
con = sqlite3.connect("aaa.db")
cur = con.cursor()
sql = "select * from books1"
data = cur.execute(sql)
result = cur.fetchall()
for item in result:
datalist.append(item)
cur.close()
con.close()
print(datalist)
return render_template("movies.html", movies=datalist)


@app.route('/score')
def score():
scores = [] # 评分
nums = [] # 每个评分所统计出的电影数量
con = sqlite3.connect("aaa.db")
cur = con.cursor()
sql = "select * from book_score_num"
data = cur.execute(sql)
result = cur.fetchall()
for item in result:
scores.append(str(item[0]))
nums.append(item[1])

cur.close()
con.close()
return render_template("score.html", scores=scores, nums=nums)


@app.route('/country')
def country():
country = [] # 评分
num = [] # 每个评分所统计出的电影数量
con = sqlite3.connect("aaa.db")
cur = con.cursor()
sql = "select * from book_country_num"
data = cur.execute(sql)
result = cur.fetchall()
for item in result:
country.append(str(item[0]))
num.append(item[1])

cur.close()
con.close()
return render_template("country.html", country=country, num=num)


@app.route('/peopletop10')
def peopletop10():
people = [] # 评论人数
title = [] # 书名
s = []
con = sqlite3.connect("database.db")
cur = con.cursor()
sql = "select * from book_people_title"
cur.execute(sql)
result = cur.fetchall()
for item in result:
s.append(item)
people.append(str(item[0]))
title.append(item[1])

cur.close()
con.close()
return render_template("peopletop10.html", people=people, title=title)


@app.route('/presstime')
def presstime():
year = []
num = []
s = []
con = sqlite3.connect("aaa.db")
cur = con.cursor()
sql = "select * from book_presstime_num"
data = cur.execute(sql)
result = cur.fetchall()
for item in result:
s.append(item)
year.append(str(item[0]))
num.append(item[1])

cur.close()
con.close()
return render_template("presstime.html", year=year, num=num)


@app.route('/publisher')
def publisher():
year = []
num = []
s = []
con = sqlite3.connect("aaa.db")
cur = con.cursor()
sql = "select * from book_publisher_num"
data = cur.execute(sql)
result = cur.fetchall()
for item in result:
s.append(item)
year.append(str(item[0]))
num.append(item[1])

cur.close()
con.close()
return render_template("publisher.html", year=year, num=num)


@app.route('/word')
def word():
return render_template("word.html")


@app.route('/team')
def team():
return render_template("team.html")


if __name__ == '__main__':
app.run()

进入生成的网址里

点击进入其他的界面

 

出现这种问题,有大佬知道怎么解决吗

源码地址链接:https://pan.baidu.com/s/1szqLumBJWNL3UYEqziTa6A?pwd=1234 
提取码:1234 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值