Vehicle Service Booking System

A Java console-based application that manages vehicle service bookings using JDBC, MySQL, and a menu-driven structure. Includes full CRUD operations, ENUM-based service types, date validation, and clean architecture (DAO + Model + DBUtil).

Features

• Add service bookings
• View all bookings
• Search bookings by vehicle number
• Update service type and date
• Delete booking
• Input validation (date, service type)
• Database connectivity using JDBC

Technologies Used

• Java
• JDBC
• MySQL
• IntelliJ IDEA

Project Structure

• DBUtil.java — handles database connection
• Booking.java — model class
• BookingDAO.java — CRUD operations
• BookingApp.java — console menu

How to Run

1. Import project into IntelliJ
2. Add MySQL Connector/J to dependencies
3. Create the database using provided SQL
4. Run BookingApp.java