ECE 9014 - Racing Car Rental System

Group 14 | Fall 2025 | Western University

A web system for rent luxury racing cars. Use Spring Boot + Vue.js.

---

What is this project

This is a car rental management system. Admin can manage cars and orders. User can rent cars online.

We have 20 luxury cars like Ferrari, Lamborghini, Porsche etc. And 500 sample orders in database.

---

Tech Stack

• Backend: Java, Spring Boot, MyBatis-Plus
• Frontend: Vue.js, Element UI, ECharts
• Database: MySQL 8.0

---

How to run

1. Database

Create database and import data:

CREATE DATABASE vehicle_lease_manager;
USE vehicle_lease_manager;
SOURCE vehicle_lease_manager.sql;
SOURCE insert_mock_data.sql;

2. Backend

1. Open Racing car tental system-idea in IntelliJ IDEA
2. Change database password in src/main/resources/application.yml:

username: root        # your mysql username
password: 12345       # your mysql password

3. Run VehicleLeaseManagerApplication.java
4. Backend run at http://localhost:9341

3. Frontend

cd "Racing car tental system-VUE"
npm install
npm run dev

Frontend run at http://localhost:9342

4. Login

• Admin: username admin, password 123456, select role Admin
• User: username user, password 123456, select role User

---

Main Features

• User management (admin approve user verification)
• Car fleet management (add car, deploy to location)
• Order management (view orders, payment status)
• Dashboard with charts (revenue, car status)
• Car return and review system

---

Performance Optimization

1. Database Indexing - Primary key and unique index for fast query
2. Pagination - Load 10 records per page, not all data at once
3. Token Authentication - Stateless design, easy to scale

---

Project Structure

├── Racing car tental system-idea/    # Backend (Spring Boot)
├── Racing car tental system-VUE/     # Frontend (Vue.js)
├── vehicle_lease_manager.sql         # Database schema
├── insert_mock_data.sql              # 500 sample orders
└── README.md

---

Team Members (Group 14)

Name	Student ID
Gu Yicheng
Li Chenghao
Yin Shi
Hussein Harb

---

ECE 9014 Database Systems - Fall 2025