//搜索商品
                else if(url.equals("/goods/searchGoods.action")){
                    String keyword=req.getParameter("keyword");
                    String sort=req.getParameter("sort");
                    List<Goods> searchGoods=new ArrayList<Goods>();
                    if(keyword!=null&&!keyword.equals("")){
                        searchGoods=GoodsService.searchGoodsByKeywords(keyword,sort);
                        req.setAttribute("goods", searchGoods);
                    }
                    req.getRequestDispatcher("/goods/goods_list.jsp").forward(req, resp);
                    
    }
        else if(url.equals("/goods/deleteCart.action")){
            resp.setContentType("text/json; charset=utf-8");
            PrintWriter out = resp.getWriter();
            String index=req.getParameter("index");
            List<Goods> goodslist=new ArrayList<Goods>();
            Object ob=req.getSession().getAttribute("goodslist");
            if(ob!=null&&index!=null){
                goodslist=(List<Goods>) ob;
                goodslist.remove(Integer.parseInt(index));
            }
            req.getSession().setAttribute("goodslist", goodslist);
            out.print("{\"success\":true,\"cartnum\":"+goodslist.size()+"}");

        }else if(url.equals("/goods/clearCart.action")){
            resp.setContentType("text/json; charset=utf-8");
            PrintWriter out = resp.getWriter();
            req.getSession().removeAttribute("goodslist");
            out.print("{\"success\":true}");
            
    
        }else if(url.equals("/goods/changeCart.action")){
            List<Goods> goodslist=new ArrayList<Goods>();
            Object ob=req.getSession().getAttribute("goodslist");
            if(ob!=null){
                goodslist=(List<Goods>) ob;             
            }
            resp.setContentType("text/json; charset=utf-8");
            PrintWriter out = resp.getWriter();
            String index=req.getParameter("index");
            String goodsSales=req.getParameter("goodsSales");
            float totalAmount=0;
            float totalPrice=0;
            if(ob!=null){
                for(int i=0;i<goodslist.size();i++){
                    if(i==Integer.parseInt(index))
                        {
                        goodslist.get(i).setGoodsSales(Integer.parseInt(goodsSales));
                        totalPrice=goodslist.get(i).getGoodsSales()*goodslist.get(i).getGoodsDiscount();
                        }
                    totalAmount=totalAmount+goodslist.get(i).getGoodsSales()*goodslist.get(i).getGoodsDiscount();
                }
            }
    
            out.print("{\"success\":true,\"totalAmount\":"+totalAmount+",\"totalPrice\":"+totalPrice+"}");
        
              }else if(url.equals("/goods/buyGoods.action")){ 
              req.setAttribute("catelist", catelist);  
              User logu=(User)req.getSession().getAttribute("_LOGIN_USER_");  
              if(logu!=null){
             //  List<Address> addresses=AddressService.getAllAddress(logu.getUserId()); 
              //req.setAttribute("addrs",addresses);  
              } 
              req.getRequestDispatcher("/order/buyGoods.jsp").forward(req, resp);
             }

//byzmh
    public static List<Goods> searchGoodsByKeywords(String name,String sort) {
        // TODO Auto-generated method stub
        DBUtil1 db=new DBUtil1();// 连接数据库
        String sql="select * from t_goods where goods_name like ? "; 
        if(sort!=null)
          if(sort.equals("1"))
                sql=sql+" order by goods_discount asc";
          else if(sort.equals("2"))
              sql=sql+" order by goods_discount  desc";
          else if(sort.equals("3"))
              sql=sql+" order by goods_sales desc";
          else if(sort.equals("4"))
              sql=sql+" order by goods_sales asc";
            
        String params[]={"%"+name+"%"};
        List<Map<String,String>> goods_map=db.getList(sql,params);
        if(goods_map!=null)
            return maptomodel(goods_map);
        else
            return null;
    }