Online Store Management System

A Java-based inventory and order management application with PostgreSQL, featuring complete CRUD operations and business analytics.

Features

• Customer Management: Handle customer profiles and multiple shipping addresses
• Product Inventory: Manage products with categories, suppliers, pricing, and stock tracking
• Order Processing: Create and process orders with automatic total calculation
• Business Reports: Revenue tracking, average order value, popular products, and customer analytics
• Security: Parameterized SQL queries prevent SQL injection across all operations

Demo

Click the image above to watch the full demo

Tech Stack

• Java 21.0.9
• PostgreSQL with JDBC
• NetBeans IDE

Database

The system manages 9 interconnected tables including customers, products, orders, suppliers, and price history tracking. All relationships use proper foreign key constraints for data integrity.

Getting Started

Prerequisites

• Java 21.0.9+
• PostgreSQL
• NetBeans IDE
• PostgreSQL JDBC Driver

Setup

1. Clone the repository
2. Create a PostgreSQL database
3. Run the SQL scripts:

psql -U your_username -d your_database -f DatabseFinalCreateTables.sql
psql -U your_username -d your_database -f ViewIndexInsert.sql

4. Open in NetBeans and run
5. Enter your database credentials when prompted

Usage

Navigate through the menu-driven interface:

• Customers: Manage profiles and addresses
• Products: Handle inventory and pricing
• Orders: Process customer orders
• Reports: View business analytics

Project Structure

src/ProjectFiles/
├── DatabaseManager.java   # Connection handling
├── Customer.java / Address.java
├── Product.java / Category.java / Supplier.java
├── Order.java / OrderItem.java
├── PriceHistory.java
└── StartingPoint.java    # Main application

Team

Collaborative team project for Database Systems at North Dakota State University.