| | |
please Help web application(jsp, servlet, tomcat, HTML, OracleDB)
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jan 2009
Posts: 1
Reputation:
Solved Threads: 0
Your web based ordering should work as follows:
1. Authorized customer must be able to place his online orders.
2. Authorized customer MUST log in first before making any transaction. If the login is invalid the customer access is denied and a message is displayed to the customer “ACCESS DENIED”
3. New customer is able to register so that he/she will be added to the list of authorized customers. The system display a welcome message to the new client “WELCOME TO OUR ORDERING SYSTEM”
4. Authorized customer places an order for up to 3 products. For each product, the customer enters a name and quantity ordered. The system displays a detailed order page (like a pre_order or pre-invoice) for the customer. This order page contains, for each product, the reference, name, unit price, quantity ordered, and total_price. It also contains the total amount due.
5. Authorized customer should be able to validate the pre-order so that the system should prepare a final order (for this requirement, you need an order processing on the server side: create an order line (up to 3 records) in the order_line database table, and update, for each ordered product, the stock in the product database table.
NB:
• You have a Server side database of 3 tables:
i. Customers (optional)
ii. Order_line (for requirement 5)
iii. Products (mandatory)
• You also have a text file: passwords.txt that represents the lists of log in data for all authorized customers: each line contains a login name and password separated by comma. This file is mandatory.
Implementation Tool:
1. You are required to use JSP technology to support your web application.
1. Authorized customer must be able to place his online orders.
2. Authorized customer MUST log in first before making any transaction. If the login is invalid the customer access is denied and a message is displayed to the customer “ACCESS DENIED”
3. New customer is able to register so that he/she will be added to the list of authorized customers. The system display a welcome message to the new client “WELCOME TO OUR ORDERING SYSTEM”
4. Authorized customer places an order for up to 3 products. For each product, the customer enters a name and quantity ordered. The system displays a detailed order page (like a pre_order or pre-invoice) for the customer. This order page contains, for each product, the reference, name, unit price, quantity ordered, and total_price. It also contains the total amount due.
5. Authorized customer should be able to validate the pre-order so that the system should prepare a final order (for this requirement, you need an order processing on the server side: create an order line (up to 3 records) in the order_line database table, and update, for each ordered product, the stock in the product database table.
NB:
• You have a Server side database of 3 tables:
i. Customers (optional)
ii. Order_line (for requirement 5)
iii. Products (mandatory)
• You also have a text file: passwords.txt that represents the lists of log in data for all authorized customers: each line contains a login name and password separated by comma. This file is mandatory.
Implementation Tool:
1. You are required to use JSP technology to support your web application.
On top of JSP section is sticky post called JSP database connectivity according to Model View Controller (MVC) Model 2, even tough it is MySQL example you should be able easy to adapt to your needs.
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
![]() |
Other Threads in the JSP Forum
- Previous Thread: Problem facing during logout
- Next Thread: How to consume a WSDL using JSP
| Thread Tools | Search this Thread |
apache backbutton combobox connection database development directorystructure dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 network parameters passing ping printinserverinsteadofclient redirect request.getparameter response servlet servletdopost()readxml sessions software ssl state_saving_method stocks sun tomcat tutorial update video web






