数据库连接html文件路径,Python+Flash+MySQL+HTML链接数据库查询,pythonflaskmysqlhtml,连库...

py文件：sqlshowweb.py

from flask import Flask

from flask import render_template

import pymysql

app = Flask(__name__)

@app.route('/test1')

def index():

conn = pymysql.connect(host='192.168.1.**', user='root', password='****', port=3306,

db='lxl-test')

cur = conn.cursor()

sql = "SELECT `id`, `userno` FROM `reply` WHERE 1"

cur.execute(sql)

u = cur.fetchall()

conn.close()

return render_template('index.html', u=u)

#return u

if __name__ == '__main__':

app.debug = True

app.run(port=8002)

html文件：(需放在templates文件夹下)

Title

name	age

{% for i in u %}

{{ i[0] }}{{ i[1] }}

{% endfor %}

运行sqlshowweb.py

name

age

1

2222222

2

33333333