如何在flask_sqlalchemy中显示列内容

pip install Flask-SQLAlchemy

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_database_url'
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True)
    email = db.Column(db.String(120), unique=True)

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

from flask import render_template

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

{% for user in users %}
    <p>{{ user.username }}</p>
    <p>{{ user.email }}</p>
{% endfor %}