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