基于Flask框架，编写一段代码访问数据库，然后把数据展示在页面上。

from flask import Flask, render_templatefrom flask_sqlalchemy import SQLAlchemyapp = Flask(__name__)app.config['SQLALCHEMY_DATABASE_URI'] = '你的数据库连接地址'db = SQLAlchemy(app)class User(db.Model):...

BE东欲

299人浏览 · 2023-01-12 21:09:37

BE东欲 · 2023-01-12 21:09:37 发布

from flask import Flask, render_template
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = '你的数据库连接地址'
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(20))
    age = db.Column(db.Integer)

@app.route('/')
def index():
    users = User.query.all()
    return render_template('index.html', users=users)

if __name__ == '__main__':
    app.run()