Python flask框架实现查询数据库并显示数据

砸漏

发布于 2020-11-02 10:04:58

1.8K0

发布于 2020-11-02 10:04:58

文章被收录于专栏：恩蓝脚本

首先数据库长这样

我们想将name和age列显示到web页面

上代码sqlshowweb.py

from flask import Flask
from flask import render_template
import pymysql

app = Flask(__name__)


@app.route('/')
def index():
  conn = pymysql.connect(host='39.106.168.84', user='flask_topvj_net', password='xxxxxxxx', port=3306,
            db='flask_topvj_net')
  cur = conn.cursor()
  sql = "SELECT `name`, `age` FROM `student` WHERE 1"
  cur.execute(sql)
  u = cur.fetchall()
  conn.close()
  return render_template('index.html',u=u)
if __name__ == '__main__':
  app.debug = True
  app.run(port=8003)

index.html

<!DOCTYPE html 
<html lang="en" 
<head 
  <meta charset="UTF-8" 
  <title Title</title 
</head 
<body 

  <table class="table table-bordered" 
  <tr 
    <th name</th 
    <th age</th 

  </tr 
    {% for i in u %}
      <tr 
        <td {{ i[0] }}</td 
        <td {{ i[1] }}</td 

      </tr 
    {% endfor %}
  </table 

</body 
</html

运行结果