This project was awarded to PRAP for $50 USD.Get free quotes for a project like this
Project Budget$30 - $35 USD
You are to create an online ordering and stock display system for a retail company, with the main stock being held at a central depot from which branches order stock to replenish their local stock. The system is to be operated by employees of the company, who are situated in the various branches. It is to be implemented entirely in Java and is to comprise a server program and a client program. The client program should first accept the branch's number (from the employee running the program) and should then make connection to the server, passing the branch number to the server. For simplicity's sake, assume that no passwords are required.
Once the server has accepted the branch number, it should display some appropriate message that includes that branch number, such as 'Branch 12 connected'. The server will then provide the functionality listed below.
(i) Retrieval of an individual stock item's current level.
(ii) Display of the full stock list.
(iii) Calculation of the value of an order for one or more of a particular stock item.
(iv) Entry of a new order.
(v) Display of all orders placed by a branch.
The implementation of items (i) and (ii) above (apart from the display itself) is to be provided by a JavaBean called StockAccess, whilst that for the other three items (again, apart from any actual display) is to be provided by a second JavaBean called OrderHandling. Both of the beans are to be contained within package stockBeans.
The implementation of items (iii) and (v) has been supplied by me (within the OrderHandling bean) and should be downloaded from the Assignments folder of the Web & Network Programming section of Blackboard. You are to write the whole of the StockAccess bean and also the one remaining method in the OrderHandling bean that is required to provide the functionality for item (iv). In both of these beans, you should make use of my private methods connectAndCreateStatement and disconnectFromDb that are defined within the OrderHandling bean. (This will mean duplicating the code for these methods within the StockAccess bean.)
In addition to the Java program, you will need to set up a small MS Access database holding two simple tables (details of which are provided below). Note that the ODBC data source name that I have used for the database in the OrderHandling bean is Stock. (You may change this if you wish.)
1. Create an MS Access database called StockData, containing tables called StockItems and StockOrders
Table StockItems is to hold at least eight items of stock with the following field names and associated types:
• stockCode (Text:1 letter + 3 digits);
[Primary key. Note that no validation is required!]
• stockDescription (Text);
• currentLevel (Number);
• reorderLevel (Number);
• price (Currency).
Table StockOrders is to hold at least eight orders with the following field names and associated types:
• orderNumber (Text: 1 letter + 5 digits);
• branchCode (Number);
• orderDate (Date/Time??????);
• stockCode (Text:1 letter + 3 digits);
• quantity (Number).
*** Note ***
Three of the above orders should come from one single branch and another three should come from one other single branch.
2. Create a simple 'skeleton' program
This program should be a menu-driven one with the following 5 options:
1. Retrieve a stock level.
2. Display the full stock list.
3. Calculate order value.
4. Place a new order.
5. Display this branch's orders.
Each of options 1-5 should call an appropriate method. For this initial 'skeleton' program, have each of the five option methods simply display a message when its option is selected. For example, "Option 2 selected".
Before going any further, it is important to stress a few points about JavaBeans...
• They do not display values.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online