myBean.setSql(sql);
int totalpage = DButil.getTotalPage(sqlpage);
myBean.setTotalPage(totalpage);
session.setAttribute("myBean", myBean);
Vector<String[]> vgoods = DButil.getPageContent(1,sql);
if(vgoods.size()==0){
String msg = "对不起，没有搜到您要的商品！！";
pageForward(msg,request,response);
}
else{
request.setAttribute("vgoods",vgoods);
String url = "/index.jsp";
ServletContext sc = getServletContext();
RequestDispatcher rd = sc.getRequestDispatcher(url);
rd.forward(request,response);
}
}
else if(action.equals("pageChange")){
ShoppingBean myBean = (ShoppingBean) session.getAttribute("myBean");
if(myBean==null){
myBean = new ShoppingBean();
}
String curPage = request.getParameter("curPage");
String selPage = request.getParameter("selPage");
if(curPage==null){
int page = Integer.parseInt(selPage);
myBean.setCurPage(page);
}else{
int page = Integer.parseInt(curPage);
myBean.setCurPage(page);
}
String sql = myBean.getSql();
Vector<String[]> vgoods = DButil.getPageContent(myBean.getCurPage(),sql);
request.setAttribute("vgoods",vgoods );
session.setAttribute("myBean", myBean);
String url = "/index.jsp";
ServletContext sc = getServletContext();
RequestDispatcher rd = sc.getRequestDispatcher(url);
rd.forward(request, response);
}
else if(action.equals("getDetail")){
String gid = request.getParameter("gid").trim();
String sql = "select Gimgurl,Gname,Gintro,Gclass,Gprice,"+
"Glook,Gid,Gbrief from GoodsInfo where Gid="+gid;
//更新表中的浏览量
String updatesql = "update GoodsInfo set Glook=Glook+1 where Gid="+gid;
DButil.updateTable(updatesql);