Automated Inventory Management
Chao Li
CS491 Spring 2006
AIM 1
Background
Traditional method of managing inventory
Inaccuracy and inefficiency
– Wasting time and human efforts to check
inventory weekly.
– Prone to human errors
– Hard to maintain inventory levels.
AIM 2
Introduction
An stand alone program that automatically
manages restaurant’s liquor inventory
– Orders, sales, etc.
Improve efficiency and accuracy
– Up-to-date inventory info
Reduced errors due to human factors
However, still exists inevitable human errors
in using it.
AIM 3
Users
Regular users: waiter/waitress
– Place orders
– Check inventory levels
– View past order information
AIM 4
Users
Managers
– Order inventory from liquor vendors
– Delete certain orders
– Check sales in the past
– Re-stock inventory
– All functions as regular users
AIM 5
Technology and Development
J2SE: Swing and awt
MySQL and JDBC
– CS server
– Auto_increment of mysql and Serial type of
postgreSql.
netBeans 5.0
AIM 6
Technology
Some useful JTable class
– setValueAt(row, col)
– getValueAt(row, col)
– Print()
– setRowSelectionInterval(index0, index1), inclusive
AIM 7
Architecture
Client Tier
– User Interface
– Displaying menu, sales summary,
inventory, orders information, ect.
AIM 8
Architecture
Client Tier
– Summary: sales summary in the past
periods
– Inventory: current inventory levels
– Orders: orders information in time fashion
– Restock: out going orders that send to
vendors
AIM 9
Architecture
Business Tier
– Methods to retrieve or store data from or to
database
– Methods to support all the functionality,
verify user’s input
AIM 10
Architecture
Data Tier
– Actual data stored in database
– Inventory: inventory’s info such as id, name,
vendor’s email, total
– order detail: id, item, total, order time
– outgoing orders: orders that send to vendors
AIM 11
Summary
Automated Inventory System that manages
inventory accurately, provide inventory level
up-to-date, store orders information
Improved efficiency of inventory management
and accuracy
A lot to do in the future
AIM 12
Thank You – Any Questions?
Demo
AIM 13