cs.calstatela.edu/abet/cs491/S06/Chao.Li/CS491%20F...

farrightΛογισμικό & κατασκευή λογ/κού

15 Αυγ 2012 (πριν από 5 χρόνια και 3 μήνες)

269 εμφανίσεις

AIM

1


Automated Inventory Management


Chao Li

CS491 Spring 2006





AIM

2

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

3

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

4

Users


Regular users: waiter/waitress


Place orders


Check inventory levels


View past order information

AIM

5

Users


Managers


Order inventory from liquor vendors


Delete certain orders


Check sales in the past


Re
-
stock inventory


All functions as regular users


AIM

6

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

7

Technology


Some useful JTable class


setValueAt(row, col)


getValueAt(row, col)


Print()


setRowSelectionInterval(index0, index1), inclusive


AIM

8

Architecture


Client Tier


User Interface


Displaying menu, sales summary,
inventory, orders information, ect.



AIM

9

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

10

Architecture


Business Tier


Methods to retrieve or store data from or to
database


Methods to support all the functionality,
verify user’s input






AIM

11

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

12

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

13

Thank You


Any Questions?


Demo