GitHub - chanjianliu/sa51_inventory_management_system: This is a simple inventory management system created by me and my teammates for a school project. It is created with Java Spring MVC, Spring Security and Thymeleaf using Mysql as database. I designed the database/entity relationship diagram (ERD), worked on and supported in most of the CRUD logic from database to repository to service to controller and finally to view.

chanjianliu / sa51_inventory_management_system Public

Notifications You must be signed in to change notification settings
Fork 1
Star 2

This is a simple inventory management system created by me and my teammates for a school project. It is created with Java Spring MVC, Spring Security and Thymeleaf using Mysql as database. I designed the database/entity relationship diagram (ERD), worked on and supported in most of the CRUD logic from database to repository to service to control…

MIT license

2 stars 1 fork Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
team9_final_javawebapp		team9_final_javawebapp
LICENSE		LICENSE
README.txt		README.txt
Team 9 Presentation.pdf		Team 9 Presentation.pdf

Repository files navigation

TEAM 9 Java CA


1. Configure file [application.properties]
   - replaced in your password for Mysql database [spring.datasource.password=password]
   - the database/schema name is "team9"


//Only needed if your computer does not have a (D:) drive
2. Configure the pathway to download RerorderReport and UsageReport
   - Access the "com.team9.motors.service" folder
     => Open [CatalogueImplementation.java] and edit line #193
     => Open [ProductImplementation.java] and edit line #130
   - replace "D:\\reorderreport.dat" with "C:\\Users\\{your username}\\Team9Report.dat"


3. Run the project as Spring Boot App.


4. Open the [CreateUser.sql] located in "src\main\resources" 
   (you should be able to see it when you alongside the [application.properties] file)
   - copy and run the sql statements in your Mysql Workbench or HeidiSQL
   - note all the users passwords: password123

5. Run JUnit test on [createSupplierProductInventory.java] to generate supplier,
   product and inventory data



Delivered By:
AFRIN Rukaya
CHAN Jian Liu
LIU Lei
RAMAKRISHNAN Niveditha
XIAO Changwei
ZHANG Hongduo
ZHOU Yanjun
ZHU Haokun