Skip to content
A Spring MVC web application for inventory management at a home improvement store.
Java HTML CSS JavaScript
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.settings
gradle/wrapper
src
.classpath
.gitignore
.project
.springBeans
README.md
build.gradle
gradlew
gradlew.bat
homeImprovementSchema.mwb
homeImprovementSchema.mwb.bak
homeImprovementSchema.sql
model.png
pom.xml
settings.gradle
website.png

README.md

home-improvement-store

A Spring MVC web application for inventory management at a home improvement store. An inventory manager can use the system to list current inventory, search the inventory by product id, add new products, update stock, and delete products from the database. alt text

In This Document:

  1. Application URL
  2. How to Use the Application
  3. Technologies Used
  4. Data Model
  5. Future Feature Sets
  6. Stumbling and Learning Points

Application URL

http://www.shaundashjian.com:8080/HomeImprovementStore/

How to Use the Application

  • The Inventory Manager opens the application and will see the inventory list
  • Manager could select an item from the list to display more details about the product
  • Manager could search the stock for a specific product by ID in the sidebar
  • Manager could click on Add Product in the sidebar to be able to add a new product to the database
  • After displaying product details, they could update product details and quantity in stock
    • Manager could also delete the product permanently from the database by clicking Delete

Technologies Used

Data Model

alt text

Future Feature Sets:

  • The ability to add new product categories to the system
  • Alerts when quantity in stock is low or reaches a certain level
  • Information about the date an item was added or updated
  • Search by product name functionality
  • Add pictures to product details
  • Add warehouse database and connect store inventory system to it

Stumbling and Learning Points:

  • Ensuring that the database server is active
  • Getting better using SQL

Up

You can’t perform that action at this time.