try
    {
        Connection conn=Create_Connection.conOpen();
        System.out.println(conn);
        String submit=request.getParameter("submit");
        System.out.println(submit);

        if(submit.equals("View"))
        {
            try {


                ArrayList<RetailerBean> l=new ArrayList<RetailerBean>();

                l=RetDAO.view(conn);

                request.setAttribute("list1", l);
                RequestDispatcher disp=request.getRequestDispatcher("ViewRetailer.jsp");
                disp.forward(request, response);

            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

        if(submit.equals("Register"))
        {  


                System.out.println("hii");
                String n=request.getParameter("name");
                System.out.println(n);
                String n1=request.getParameter("licence_no");
                String n2=request.getParameter("contact_addr");
                int n3=Integer.parseInt(request.getParameter("contact_no"));
                String n4=request.getParameter("email");
                String n5=request.getParameter("d");
                String n6=request.getParameter("m");
                String n7=request.getParameter("y");
                String date=n5+"-"+n6+"-"+n7;
                String n8=request.getParameter("uname");
                System.out.println(n8); 
                System.out.println(n7);
                String n9=request.getParameter("pass");
                String handset1[]=request.getParameterValues("prod");
                int handset[]=new int [handset1.length];
                for(int i=0;i<handset1.length;i++)
                {
                    handset[i]=Integer.parseInt(handset1[i]);
                    System.out.println(handset[i]);

                }
                RetailerBean ret=new RetailerBean();
                ret.setName(n);
                System.out.println(ret.getName());
                System.out.println(n9);
                ret.setLicence(n1);
                ret.setContactno(n3);
                ret.setAddress(n2);
                ret.setEmailid(n4);
                ret.setDob(date);
                ret.setUsername(n8);
                ret.setPassword(n9);

                int b=(int)Math.floor((Math.random()*100)+1);
                String nm="ret"+b;
                System.out.println("check id="+nm);
                ret.setId(nm);
                ret.setHandset(handset);


                RetDAO rd=new RetDAO();
                rd.insert(conn,ret);







        }


        if(submit.equals("ret_id"))
        {   

                String ret_id=request.getParameter("id");
                System.out.println(ret_id);
                System.out.println("hii");

                System.out.println("What");
                int a=RetDAO.searchDelete(conn,ret_id);
                System.out.println("hello");
                System.out.println(a);

                if(a==1)
                {  
                    int b=RetDAO.chk_order(conn,ret_id);
                    System.out.println("b="+b);

                    if(b==2)
                    {
                        System.out.println("FSdSdSD");
                        int c=RetDAO.untag(conn, ret_id);
                        System.out.println("c="+c);
                        int d=RetDAO.deleteRet(conn, ret_id);
                        System.out.println("d="+d);
                        System.out.println("Retailer only present in retailer table");
                    }
                    else if(b==1)
                    {
                        System.out.println("Row will be deleted");
                        int c=RetDAO.untag(conn, ret_id);
                        int d=RetDAO.delete(conn, ret_id);
                        System.out.println(c);
                        System.out.println(d);
                        //System.out.println("Row can be deleted");
                    }
                    else 
                    {   
                        System.out.println("Row cannot be deleted");
                    }
                }
                else response.sendRedirect("Ret_error.jsp");
        }


        if (submit.equals("request"))
        {

            ArrayList<RetailerBean> l=new ArrayList<RetailerBean>();

            l=RetDAO.viewRequest(conn);
            //RetailerBean c=l.get(0);
        //  String f= c.getId();

            System.out.println("hello");
            //request.setAttribute("list2", l);
        //  RequestDispatcher disp=request.getRequestDispatcher("ViewRequest.jsp");
        //  disp.forward(request, response)

            if(l.isEmpty())
            {System.out.println("he");
                response.sendRedirect("Ret_error.jsp");
            }
            System.out.println("mngh");
                HttpSession s=request.getSession();

            s.setAttribute("view1",l);

            response.sendRedirect("ViewRequest.jsp");

            }


        if(submit.equals("tag"))
        {
            System.out.println();
            String approve=request.getParameter("Approve");
            System.out.println(approve);

            /*String n=request.getParameter("hidden");
            System.out.println(n);*/
        }



        if(submit.equals("requestret"))
        {
            ArrayList<RetailerBean> l=new ArrayList<RetailerBean>();

            l=RetDAO.viewRequestRetailer(conn);
            //RetailerBean c=l.get(0);
        //  String f= c.getId();


            //request.setAttribute("list2", l);
        //  RequestDispatcher disp=request.getRequestDispatcher("ViewRequest.jsp");
        //  disp.forward(request, response)

            if(l.isEmpty())
            {
                response.sendRedirect("Ret_error.jsp");
            }

                HttpSession s=request.getSession();

            s.setAttribute("view2",l);

            response.sendRedirect("ViewRequestRetailer.jsp");
        }


        }
        catch(Exception e)
        {

        }

}