### Python实现汽车租赁管理系统 以下是一个使用Python开发的汽车租赁管理系统的代码示例。该系统包括用户注册、登录、汽车展示、租赁下单、归还提醒、管理员注册及后台管理等功能模块。 #### 1. 系统设计 系统分为用户端和管理员端。用户可以注册、登录、浏览汽车信息、下单租赁以及接收归还提醒。管理员可以管理用户数据、汽车信息、订单状态等。 #### 2. 数据库模型 使用SQLite作为数据库，存储用户、汽车和订单信息。 ```python import sqlite3 from datetime import datetime, timedelta # 初始化数据库 def init_db(): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() cursor.execute(''' CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, password TEXT NOT NULL, is_admin INTEGER DEFAULT 0 ) ''') cursor.execute(''' CREATE TABLE IF NOT EXISTS cars ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, model TEXT NOT NULL, price REAL NOT NULL, available INTEGER DEFAULT 1 ) ''') cursor.execute(''' CREATE TABLE IF NOT EXISTS orders ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, car_id INTEGER NOT NULL, start_date TEXT NOT NULL, end_date TEXT NOT NULL, returned INTEGER DEFAULT 0, FOREIGN KEY(user_id) REFERENCES users(id), FOREIGN KEY(car_id) REFERENCES cars(id) ) ''') conn.commit() conn.close() ``` #### 3. 用户注册与登录 ```python # 用户注册 def register_user(username, password, is_admin=0): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() try: cursor.execute('INSERT INTO users (username, password, is_admin) VALUES (?, ?, ?)', (username, password, is_admin)) conn.commit() return True except sqlite3.IntegrityError: return False finally: conn.close() # 用户登录 def login_user(username, password): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() cursor.execute('SELECT id FROM users WHERE username = ? AND password = ?', (username, password)) result = cursor.fetchone() conn.close() return result is not None ``` #### 4. 汽车展示 ```python # 展示所有可用汽车 def display_cars(): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() cursor.execute('SELECT * FROM cars WHERE available = 1') cars = cursor.fetchall() conn.close() return cars ``` #### 5. 租赁下单 ```python # 下单租赁汽车 def rent_car(user_id, car_id, days): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() start_date = datetime.now().strftime('%Y-%m-%d') end_date = (datetime.now() + timedelta(days=days)).strftime('%Y-%m-%d') cursor.execute('INSERT INTO orders (user_id, car_id, start_date, end_date) VALUES (?, ?, ?, ?)', (user_id, car_id, start_date, end_date)) cursor.execute('UPDATE cars SET available = 0 WHERE id = ?', (car_id,)) conn.commit() conn.close() ``` #### 6. 归还提醒 ```python # 检查即将到期的订单并发送提醒 def check_return_reminders(): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() today = datetime.now().strftime('%Y-%m-%d') cursor.execute('SELECT * FROM orders WHERE returned = 0 AND end_date = ?', (today,)) reminders = cursor.fetchall() conn.close() return reminders ``` #### 7. 管理员界面与后台管理 ```python # 添加新汽车 def add_car(name, model, price): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() cursor.execute('INSERT INTO cars (name, model, price) VALUES (?, ?, ?)', (name, model, price)) conn.commit() conn.close() # 查看所有订单 def view_orders(): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() cursor.execute('SELECT * FROM orders') orders = cursor.fetchall() conn.close() return orders # 标记汽车已归还 def mark_car_returned(order_id): conn = sqlite3.connect('car_rental.db') cursor = conn.cursor() cursor.execute('UPDATE orders SET returned = 1 WHERE id = ?', (order_id,)) cursor.execute('UPDATE cars SET available = 1 WHERE id = (SELECT car_id FROM orders WHERE id = ?)', (order_id,)) conn.commit() conn.close() ``` #### 8. 示例运行 ```python if __name__ == '__main__': init_db() # 注册用户 if register_user('user1', 'password1'): print("User registered successfully.") else: print("Username already exists.") # 登录用户 if login_user('user1', 'password1'): print("Login successful.") else: print("Invalid credentials.") # 添加汽车 add_car('Toyota Camry', 'Sedan', 50.0) # 展示汽车 cars = display_cars() for car in cars: print(car) # 租赁汽车 rent_car(1, 1, 5) # 查看订单 orders = view_orders() for order in orders: print(order) # 检查归还提醒 reminders = check_return_reminders() for reminder in reminders: print(f"Reminder: Order {reminder[0]} needs to be returned today.") # 标记汽车已归还 mark_car_returned(1) ```