<pre><code>
# 导入Flask模块
from flask import Flask, render_template, request
# 创建Flask应用实例
app = Flask(__name__)
# 定义数据库配置信息
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/dormitory'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
# 引入SQLAlchemy模块
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy(app)
# 定义宿舍模型
class Dormitory(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), unique=True, nullable=False)
capacity = db.Column(db.Integer, nullable=False)
# 定义路由，用于显示宿舍列表
@app.route('/')
def index():
dormitories = Dormitory.query.all()
return render_template('index.html', dormitories=dormitories)
# 定义添加宿舍的路由
@app.route('/add', methods=['POST'])
def add_dormitory():
name = request.form.get('name')
capacity = request.form.get('capacity')
new_dormitory = Dormitory(name=name, capacity=capacity)
db.session.add(new_dormitory)
db.session.commit()
return '宿舍添加成功！'
if __name__ == '__main__':
app.run(debug=True)
</code></pre>