Category: Web

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
  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
  3. Recommended products can be evaluated via Apriori algorithm.

Download :

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

java Web