Design-based E-commerce System Implementation

This assignment requires the implementation of an online bidding system using Java or other OO language, with features such as user validation, data storage in a MySQL database, error handling through try-catch blocks, and testing strategies. The system allows admins to add owner details and item listings, while normal users can view their personal details, bid on items, receive notifications of winning bids, and make payments.

Contents
Fit to the design...........................................................................................................................................2
Use of dynamic UML modeling..................................................................................................................2
Correct and efficient use of Java or other OO language..............................................................................2
Good use and appropriate selection of other technologies...........................................................................2
Coding of error handling.............................................................................................................................2
Testing and testing strategy.........................................................................................................................2
Screen Shots................................................................................................................................................2

Fit to the design
The whole code implementation is done which is based on use case diagram which is provided in
part one document. According to use case diagram admin able to add any owner details and their
items for bidding into database admin can also view all item details with link of their images and
their owner details where admin can see which items are for auction and which are not.
According to use case diagram the normal user able to view his/her personal details, he/she can
also view those items for which he fixes the bidding. The normal user can also able to see the
notification which is a message that is send by the admin to every bid winner. Normal user will
login and then he/she able to see whether he wins or losses by checking his/her notifications and
by checking the notification he/she able to make payment for bid item. If he/she losses then user
will not see the payment option otherwise when she/he won, he/she make payment for that
particular won item.

Correct and efficient use of Java or other OO language
I have used JSP page for form design. JSP is also used for user validation when user login using
index.jsp page then user is validate by login.jsp page this page fetch the data from the database
and validate user and determine either he/she is admin or normal user and redirect user
accordingly. I have also used some servlet classes that save the data from the jsp page to
database and after saving the data user is redirected to JSP page directly from this code.
Good use and appropriate selection of other technologies
I have used JSP and SERVLET classes. I have created database in MySql. All tables are created this is
the .sql script where you can see the all create table command.

Coding of error handling
All the errors are handled using try catch block. This technique of error handling is called
exception handling.
Here are some code snippets for error handling:

In sql query through any error during its processing then it all handled by the catch block and this
error details are stored in message variable that is later set to session attribute that is “Message”
and the calling jsp page will use this variable to display the error to user.
Connection.java
If there is any error occur during connecting with database then these all errors also handled by
catch block.

Testing
1. Test the login page
Expected Output: alex will logged in successfully and redirected to her panel.
Result: alex user logged in successfully and able to view normal user panel.
Alex is not admin.

2. Admin ale to add new owner information to the system
Expectation: New owner details are successfully saved to database
Result: owner details are successfully saved to database.
3. Admin can add multiple items for an owner
Expectation: All items details are saved in database for particular owner.
Result: all details are successfully saved to database.

4. Admin able to view all bid items list and there will be option to view their owner
information and the image for those items
Expectation: right information will come up for each item
Result: admin able to view all item information
5. Admin can go back to menu and able to add next owner details to database and his/her
item details also.
Expectation: right page will show to admin and admin able to add new owner information to
the system.
Result: no bug error this functionality is done successfully completed by the admin.

6. New user can register successfully and can login
Expectation: when new user register to system then new user details saved to database
successfully and user got message for succession and then user able to login to system
Result: no bug error

7. New logged in user able to view currently bidding items so that he/she can also bid
for one or more items.
Expected output: user able to bidding items details and bid for one or more item
Result: result is same as expected.

8. Here is new user rose registration and login process is shown through screen shots.

9. Here is the list of all bidders. This list is only show to admin. Now admin will decide the
who is winner and send him/her a message
Expected output: message is successfully sent to winner and winner able to view this
message in her/his notification so that he/she can make payment
Result: no bug occur

10. JOHN WON BIDDING, so now john will get the notification and he/she will get an
option for buy this bid item and then user can make payment
Expected output: The user will get message and option and he/she make payment
successfully
Result: This is done successfully no error occur.

Testing strategy
I have tested my code using unit testing strategy. First I create a message.jsp page. If there is any
occur in my code, these errors were handled by try catch block and then I used message variable,
in this error message will saved and this variable is set to session and by getting this variable
value in message.jsp page.