python 复制代码 运行

from flask import Flask, render_template, request, redirect, url_for from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///car_rental.db' db = SQLAlchemy(app) class Car(db.Model): id = db.Column(db.Integer, primary_key=True) brand = db.Column(db.String(80), nullable=False) model = db.Column(db.String(80), nullable=False) price = db.Column(db.Float, nullable=False) class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) password = db.Column(db.String(80), nullable=False) class Order(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) car_id = db.Column(db.Integer, db.ForeignKey('car.id'), nullable=False) start_date = db.Column(db.Date, nullable=False) end_date = db.Column(db.Date, nullable=False) @app.route('/') def index(): cars = Car.query.all() return render_template('index.html', cars=cars) @app.route('/login', methods=['GET', 'POST']) def login(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] user = User.query.filter_by(username=username, password=password).first() if user: return redirect(url_for('index')) else: return '用户名或密码错误' return render_template('login.html') @app.route('/register', methods=['GET', 'POST']) def register(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] user = User(username=username, password=password) db.session.add(user) db.session.commit() return redirect(url_for('login')) return render_template('register.html') if __name__ == '__main__': app.run(debug=True)