🎮 GameStore — Database-Driven Web Application

A full-stack game store management system with a relational database backend, Java servlets, and JSP-based frontend. Built as part of CS 157A — Introduction to Database Management Systems at San José State University.

🎯 Overview

GameStore is a web application that allows users to browse products, manage customer orders, and handle store inventory. It features a MySQL relational database with a Java servlet backend and JSP frontend deployed on Apache Tomcat.

✨ Features

• Product Catalog — Browse and search game store inventory
• Customer Management — Customer registration and profile management
• Order System — Place, view, and track customer orders
• Staff Portal — Staff management and role-based access
• Store Management — Multi-store support with address tracking
• Platform Tracking — Manage game platforms and manufacturers
• Reporting — View all orders, customer orders, and store orders

🗄️ Database Schema

The MySQL database includes the following tables:

Table	Description
gamestore	Store locations
address	Store addresses (city, district, postal code, country)
manufacturers	Game manufacturers
platform	Gaming platforms
order	Customer orders with dates
product	Game products
customer	Customer profiles
staff	Store staff

🏗️ Architecture

CS157A-team4/
├── src/
│   ├── Customer.java           # Customer model & operations
│   ├── Product.java            # Product model & operations
│   ├── Main.java               # Application entry point
│   ├── FrontPage.java          # Front page servlet
│   ├── HomePage.java           # Home page servlet
│   ├── Staff.java              # Staff model & operations
│   ├── User.java               # User authentication
│   ├── InventoryManager.java   # Inventory management logic
│   └── SqlConnection.java      # Database connection handler
├── gamestore jsps/
│   ├── login.jsp               # Login page
│   ├── GamestoreFrontPage.jsp  # Main storefront
│   ├── GamestoreSHomePage.jsp  # Staff home page
│   ├── GamestoreCHomePage.jsp  # Customer home page
│   ├── NewOrder.jsp            # Create new order
│   ├── allOrders.jsp           # View all orders
│   ├── CustomerOrders.jsp      # Customer-specific orders
│   └── storeOrders.jsp         # Store-specific orders
├── Gamestore.sql               # Full database schema + seed data
├── apache-tomcat-8.5.100/      # Tomcat server
└── data/                       # Additional data files

🛠️ Tech Stack

Layer	Technology
Backend	Java Servlets
Frontend	JSP (JavaServer Pages), HTML/CSS
Database	MySQL
Server	Apache Tomcat 8.5
Build	IntelliJ IDEA

🚀 Getting Started

Prerequisites

• Java JDK 8+
• MySQL Server
• Apache Tomcat 8.5+
• IntelliJ IDEA (recommended)

Database Setup

mysql -u root -p < Gamestore.sql

Run the Application

1. Open the project in IntelliJ IDEA
2. Configure Tomcat server in Run Configurations
3. Deploy and run on http://localhost:8080

👥 Team

Built by SJSU students for CS 157A:

• Aman Imran — aman.imran@sjsu.edu | Portfolio
• Brandon Moriguchi — Repository owner
• Team collaborators

📄 License

This project is open source and available for educational purposes.