Travel Booking System

A comprehensive Java desktop application for managing travel bookings, packages, and user accounts with an intuitive interface and robust backend functionality.

Features

• User authentication and registration
• Browse and search travel packages
• Book travel packages
• View and cancel bookings
• Secure password handling
• Interactive user dashboard
• Detailed travel package information with images

Technologies Used

• Java
• Swing for GUI
• MySQL for database storage
• JDBC for database connectivity
• MVC (Model-View-Controller) architecture
• Properties files for configuration management
• Custom exception handling

Prerequisites

• JDK 8 or higher
• MySQL Server 5.7 or higher
• MySQL Connector/J (JDBC driver)

Setup Instructions

1. Database Setup

1. Install MySQL Server if not already installed
2. Create a new database named tbs
3. Import the provided SQL schema from database/tbs_schema.sql

<Enter your password>
SOURCE database/tbs_schema.sql;

2. Configure Database Connection

1. Navigate to the config directory
2. Rename db.properties.example to db.properties
3. Edit db.properties and update with your MySQL credentials:

db.url=jdbc:mysql://localhost:3306/tbs
db.user=your_username
db.password=your_password

3. Set up JDBC Driver

1. Create a "lib" folder in src directory
2. Download the MySQL JDBC driver
3. Unzip the downloaded folder and copy the JAR file of the driver
4. Paste the JAR file into the lib directory you created

4. Compile and Run the Application

Using an IDE (Eclipse, IntelliJ IDEA, etc.)

1. Import the project into your IDE
2. Download and the MySQL JDBC connector to your project's classpath or 'lib' directory
3. Run the App.java file as the main class

Using Command Line

1. Navigate to the project root directory
2. Compile the Java files:

javac -d bin -cp lib/mysql-connector-java.jar src/*.java src/**/*.java

3. Run the application:

java -cp bin:lib/mysql-connector-java.jar App

For Windows, use ; instead of : in the classpath:

java -cp bin;lib/mysql-connector-java.jar App

Project Structure

TBS/
├── src/                  # Source code
│   ├── db/               # Database connection code
│   ├── exception/        # Custom exceptions
│   ├── model/            # Data models
│   ├── service/          # Business logic
│   ├── ui/               # User interface
│   ├── utils/            # Utility classes
│   └── App.java          # Main application entry
├── config/               # Configuration files
│   └── db.properties     # Database configuration (not in git)
├── database/             # SQL scripts
│   └── tbs_schema.sql    # Database schema
├── lib/                  # External libraries/dependencies
└── README.md             # This file

Usage

1. Login Screen: Enter credentials or register a new account
   • New users can register from the login screen
2. Home Page: Browse available travel packages
3. Package Details: View detailed information and book packages
   • Package descriptions, itineraries, and included amenities
4. My Bookings: View and manage your bookings
   • See booking status (Confirmed, Cancelled)
   • Cancel bookings with applicable refund policy

Architecture Overview

The application follows the MVC (Model-View-Controller) pattern:

• Models: Represent data structures (User, Package, Booking)
• Views: Swing GUI components for user interaction
• Controllers: Handle user input and update models/views

License

This project is for educational purposes only. Not for commercial use.