python3.8 flask连接mysql数据库，创建，查询

一.链接查询原有数据库
1.首先我们要安装调试好flask和mysql，使MySQL服务处于启动状态
2.给Python安装数据库框架MySQL_Python
pip install pymysql
安装前端框架bootstrap（为了数据显示美观）
pip install flask_bootstrap
3.在主程序app.py中写入

from flask_bootstrap import Bootstrap
import pymysql

app = Flask(__name__)
bootstrap = Bootstrap(app)

@app.route('/view')
def view():
    conn = pymysql.connect(host='127.0.0.1', user='root', password='', db='usertable', charset='utf8', port=3306)
    cur = conn.cursor()
    sql = "SELECT * FROM user"
    cur.execute(sql) #执行语句
    u = cur.fetchall()
    cur.close()
    conn.close()
    return render_template('view.html', u=u)
    if __name__ == '__main__':
    app.run(debug = True)

4.在templates文件夹中新建base.html

{% extends "bootstrap/base.html"  %}