Skip to content
/ Pizzeria Public template

Pizzeria is a backend application developed in Java, integrated with a SQL database, designed to simulate and manage the operations of a pizza store. This project is a fusion of complex system architecture and practical business applications, aimed at demonstrating robust backend development and database management skills.

Notifications You must be signed in to change notification settings

swapnilmukherjee/Pizzeria

Repository files navigation

Pizzeria: Advanced Java/SQL Backend System for Pizza Store Operations

Overview

Welcome to 'Pizzeria' - a sophisticated Java-based backend system, perfectly integrated with a SQL database, meticulously crafted to streamline the management and operations of a pizza store. This project is a testament to innovative system architecture, focusing on backend development and effective database management.

Key Features

  • Java Backend Architecture: Incorporates a series of Java classes such as Customer, Order, Pizza, etc., showcasing object-oriented design, modularity, and scalability.
  • Structured SQL Database Schema: A well-designed SQL database featuring scripts for table creation, data view management, and efficient data handling.
  • Versatile Order Processing: Capably manages diverse order scenarios including delivery, dine-in, and pickup.
  • Intuitive Menu and Inventory Control: Facilitates comprehensive menu management and real-time inventory oversight.
  • Enhanced Data Operations: Utilizes advanced SQL for effective data manipulation, retrieval, and insightful reporting.

Technical Stack

  • Backend Development: Java
  • Database Management: SQL
  • Preferred SQL IDE: MySQL Workbench or DataGrip

Setup Guide

Prerequisites

  • Java JDK 8 or above
  • SQL Server (local or cloud-based)
  • An SQL IDE like MySQL Workbench or DataGrip

Installation Steps

  1. Database Initialization:

    • Set up your SQL database either locally or on a cloud platform.
    • Use your preferred SQL IDE to connect to the database.
    • Execute the CreateTables.sql script to structure your database.
  2. Project Configuration:

    • Clone the repository:
      git clone https://github.com/[your-username]/pizzeria.git
    • Open the cloned project in your favorite Java IDE.
    • Configure your database connection in DBConnector.java.
    • Verify the connection with DBConnectionTest.java.
  3. Running the Application:

    • Launch the application by running Menu.java.

Utilization

This project is a prime example for those interested in the intricacies of Java-based backend systems and SQL database integration, focusing on real-world business logic and database interactivity.

Contributions

Your contributions are what drive the open-source community forward. Whether you're adding new features, fixing bugs, or improving documentation, your input is immensely valued.

  1. Fork the Project
  2. Create Your Feature Branch (git checkout -b feature/YourAmazingFeature)
  3. Commit Your Changes (git commit -m 'Add YourAmazingFeature')
  4. Push to the Branch (git push origin feature/YourAmazingFeature)
  5. Submit a Pull Request

License

This project is licensed under the MIT License - see the LICENSE file for details.

About

Pizzeria is a backend application developed in Java, integrated with a SQL database, designed to simulate and manage the operations of a pizza store. This project is a fusion of complex system architecture and practical business applications, aimed at demonstrating robust backend development and database management skills.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages