Friday, July 16, 2010

Online Shopping Cart: JSP

Hey Ppl!! I am glad to finally get the time to post on my blog again..... As a part of my curriculum I had to create an online shopping cart. Since I thought of doing it in JSP where in I could some AJAX to make it fancier :).  Well the choice of  IDE for me was to go for RAD (Rational Application Developer) 7.5 with WAS (Websphere Application Server)  CE and DB2 as the back end.This is a basic project but is a good learner for those who are new to JSP, servlets or AJAX. This is also be useful if you are looking to get familiarized with the IDE.

Overview :

Lets draw an outline of the project. We have 2 use cases to the project viz Administrator and Customer. We take them one by one. ADMIN end:
  • Ability to add products
  • Managing the categories that these products belong to
  • Search Transaction
  • Search Customer
  • Search for product and ability to edit product inf
Next, On the Customer End:
  • View product and its details
  • Register
  • Login
  • Add product to cart and checkout
  • Viewing transaction records
Lets take up the database for such a system. I have taken the snapshot right out of DB2 listing the tables there in (click to expand).

Snapshots :

Lets look at the snapshots of the project first and then we will discuss the problems faced and their solutions.

Hurdles :

Creating & calling stored procedures on DB2.
With RAD thats very easy!! Follow the steps:
  1. Switch to Data Perspective.
  2. If haven't already create a new project data development proj say 'ShopDev'. While doing so you will be asked to connect to the DB2 database please make sure you enter the DB2 credentials correctly and dont forget to test the connection.
  3. Right click on the ShopDev in the project navigator and select new stored procedure. 
  4. Make sure you choose java as the language (unless you want to use sqlj) and create the query, set up I/O parameters and you will have a stored procedure created for you. This might not be exactly you want so you can edit it now. (for eg look in folder /workspace/ShoppingDev/JavaSource/com/db2admin/db2admin/*.java)
  5. Once done, you can right click on the procedure and select the option generate JavaBean class to get the .java file in your dynamic web project. (these can be found in  /workspace/ShoppingCart/src/genbeans/ )
  6. Now you can use this class to instantiate it in JSP or as Beans..
Image/File Uploads for products
I have seen a lot of posts over the internet for this. But it was difficult to find one good solution. Our objective was to upload the file to database so the approach that we follow is to first upload the file to a temporary folder on the server then onto the database. Uploading To FileSystem On Server: To do so the Apache Commons FileUpload package will do the work for us. Just include the library in your path or add it as a reference. First lets see the jsp page with form that is going to submit both variables and upload data. (important to note enctype)
<form id="addProduct" enctype="multipart/form-data" action="AddProduct" method="post">
The code snippet shows the use we make of it in a servlet. Here the form sends some variables and 3 image files:
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

 * Servlet implementation class AddProduct
public class AddProduct extends HttpServlet {
    private static final long serialVersionUID = 1L;
     * @see HttpServlet#HttpServlet()
    public AddProduct() {
        // TODO Auto-generated constructor stub

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // Create a factory for disk-based file items
        DiskFileItemFactory factory = new DiskFileItemFactory();
        String SUBCAT = null,Name = null,BRAND = null,Description = null;
        int Price = 0,Qty = 0;
        byte[][] Image=new byte[3][5*1024*1024];
        // Set factory constraints
        factory.setRepository(new File("/tmp"));
        // Create a new file upload handler
        ServletFileUpload upload = new ServletFileUpload(factory);
        int cnt=0;
        // Parse the request
        List items;
        try {
            items = upload.parseRequest(request);
        Iterator iter = items.iterator();
        while (iter.hasNext()) 
            FileItem item = (FileItem);
            // Process a file upload
            if (item.isFormField()) {
                String name = item.getFieldName();
                    SUBCAT = item.getString();
                else if(name.equals("PName"))
                    Name= item.getString();
                else if(name.equals("Brand"))
                    BRAND = item.getString();
                else if(name.equals("Quantity"))
                    Qty = Integer.parseInt(item.getString());      
                else if(name.equals("Price"))
                    Price= Integer.parseInt(item.getString());        
                else if(name.equals("Description"))
                    Description = item.getString();
            if (!item.isFormField()) 
                String fieldName = item.getFieldName();
                String fileName = item.getName();
                String contentType = item.getContentType();
                boolean isInMemory = item.isInMemory();
                long sizeInBytes = item.getSize();
                if (sizeInBytes<=10)
                File uploadedFile = new File("/tmp/up" + ++cnt +".jpg");
                try {
                } catch (Exception e) {
                    // TODO Auto-generated catch block
        } catch (FileUploadException e1) {
            // TODO Auto-generated catch block
        AddProductBean apb=new AddProductBean();
        System.out.println("CNT= " + cnt);

        FileInputStream[] fis=new FileInputStream[3];
        for(int i=1;i<=cnt;i++)
            File f=new File("/tmp/up" + i +".jpg");
            fis[i-1]=new FileInputStream("/tmp/up" + i +".jpg");
            Image[i-1]=new byte[(int) f.length()];
            System.out.println(fis[i-1].read(Image[i-1], 0, (int)f.length()));
        String str="khali";
        byte[] n=str.getBytes();
        System.out.println("Len= " + Image[0].length + " "+ Image[1].length + " "+ Image[2].length + " ");
        try {
                apb.execute(SUBCAT, Name, BRAND, Price, Qty, Description, Image[0], Image[1], Image[2]);
            else if(cnt==2)
                apb.execute(SUBCAT, Name, BRAND, Price, Qty, Description, Image[0], Image[1], n);
            else if(cnt==1)
                apb.execute(SUBCAT, Name, BRAND, Price, Qty, Description, Image[0], n, n);
                apb.execute(SUBCAT, Name, BRAND, Price, Qty, Description, n, n, n);
            for(int i=0;i<3;i++)
        } catch (SQLException e) {
            // TODO Auto-generated catch block
A very common question was getting servlets to work. The error is that httpservlet is not found.
To correct that you need to add reference to j2ee.jar that can be found here

Extensions :

  1. Add provision for product offers or discount offers.
  2. Support for preview of multimedia products and downloadable products like games/softwares.
  3. Recommended products can be evaluated via Apriori algorithm.

Download :

Finally, here you can download the complete workspace for the project.
Download Workspace


Apurv said...

Nice post!.... although i have not read it -- as claimed by the author!


Good post honestly!


u again rocks bhaiyaa.......

but why all d t-shirts were bought by u only..

Milind Mathur said...

:) I like to wear T-Shirts :)...

Well this was in my dev environment and i was the lone tester/developer.... so i had to buy em all....:P

Anonymous said...

I wished to thanks for this nice learn!! I positively enjoying every little bit of it I've you bookmarked to check out new stuff you publish

Anonymous said...

plz attach the DBdump file..........

web email hosting said...

Thanks for sharing your ideas and thoughts, i like your blog and bookmark this blog for further use thanks again…

Piyush Sethi said...

i want the coding part for search box and product category !!
help me