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).
- 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
- Java
- JDBC
- MySQL
- IntelliJ IDEA
- DBUtil.java — handles database connection
- Booking.java — model class
- BookingDAO.java — CRUD operations
- BookingApp.java — console menu
- Import project into IntelliJ
- Add MySQL Connector/J to dependencies
- Create the database using provided SQL
- Run BookingApp.java