En cours

eclipse project

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);

[Primary key.]

• 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.

6. Quit.

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.

Compétences : Conception graphique , HTML, PHP, Design de site internet

Voir plus : write java code online, website package price list, web design programming java, web design names list, web design company names, quit letter, project details example, price letter design, php eclipse, package design online order, online data entry methods, network programming java, names web design company, list methods package design, java network programming, entry level programming, employee network, eclipse java programming online, eclipse java programming, eclipse php, eclipse programming, design name folder online, design depot, data entry validation access, data driven programming

Concernant l'employeur :
( 3 commentaires ) sheffield, United Kingdom

N° du projet : #1622714

Décerné à :

PRAP

hi, i am intersted in your project.please let me knoww?

50 $ USD en 5 jours
(0 Commentaires)
1.4

2 freelance ont fait une offre moyenne de 200 $ pour ce travail

eperfections

EXPERT JAVA DEVELOPER ! Details in PMB

350 $ USD en 5 jours
(163 Commentaires)
6.9