BookMyMoviesApp

🎬 BookMyMoviesApp

A Java-based console movie booking application that lets users explore cities, browse theaters, view show timings, and book seats dynamically — all backed by a powerful MySQL database.

🌟 Key Features

• Select from major Delhi-NCR cities: Delhi, Noida, and Gurgaon
• Dynamically view theaters, movies, and show timings
• Real-time seat availability with booking functionality
• Smart messages like “No theaters available” or “No shows available” when needed

🧰 Tech Stack

• Java (JDK 17)
• JDBC
• MySQL (8.0+)
• MySQL Connector/J (v8.0.28)

🛠️ Database Setup

1. Install MySQL and ensure it’s running.

2. Create the database:

   CREATE DATABASE bookmyshow;
   

3. Import the provided SQL schema and data:

   mysql -u root -p bookmyshow < bookmyshow.sql
   

▶️ How to Run

1. Make sure you’ve compiled the .jar file and downloaded the MySQL connector .jar.

2. Then run the following command in your terminal:

   java -cp "BookMyMoviesApp.jar:mysql-connector-java-8.0.28.jar" app.BookMyMoviesApp
   

   ✅ Replace the file paths with absolute paths if required (especially on macOS/Linux).

📂 Project Structure

📦 BookMyMoviesApp
├── app/
│   └── BookMyMoviesApp.java
├── db/
│   └── DBConnection.java
├── model/
│   ├── City.java
│   ├── Movie.java
│   ├── Theater.java
│   └── ...
└── bookmyshow.sql

👨‍💻 Author

Kartik Jindal Final Year B.Tech CSE Student @ MIET, Meerut

This site is open source. Improve this page.