时间紧任务重,就先不学django了,先使用web.py弄一个简单的连接数据库的前端展示。
1.app.py
from flask import Flask
from flask import render_template
from flask_bootstrap import Bootstrap
import pymysql
app = Flask(__name__)
bootstrap = Bootstrap(app)
@app.route('/')
def index():
conn = pymysql.connect(host='localhost', user='root', password='password', db='flight', charset='utf8')
cur = conn.cursor()
sql = "SELECT * FROM flight"
cur.execute(sql)
u = cur.fetchall()
conn.close()
return render_template('index.html',u=u)
if __name__ == '__main__':
app.run()
2.index.html
{% extends "base.html" %}
{% block title %}首页{% endblock %}
{% block page_co