itemservlet.java

一套购物车项目。电子商务系统。实现了前台和后台的业务逻辑。

package com.softfz.jn0708.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;


import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.softfz.jn0708.bean.ItemBean;
import com.softfz.jn0708.dao.ClassDAO;
import com.softfz.jn0708.dao.ItemDAO;
import com.softfz.jn0708.util.StrUtil;
import com.softfz.jn0708.util.XPage;


/**
 * 商品信息处理Servlet
 * @author student
 *
 */
public class ItemServlet extends HttpServlet {

	
	/**
	 * 
	 */
	private static final long serialVersionUID = -7633077744996936149L;



	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request,response);
		
	}

	
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
		String task = request.getParameter("task");
		String id = request.getParameter("id");
		if(task==null){//默认是查询
			doquery(request,response);
		}else if(task.equals("add")){//添加商品
//			doadd(request,response);
		}else if(task.equals("edit")){//得到商品编辑页面显示的数据
			String itemid= request.getParameter("itemid");
			ItemDAO dao = new ItemDAO();
			ItemBean item = dao.getItemById(itemid);
			request.setAttribute("item",item);
			request.getRequestDispatcher("/main.jsp").forward(request,response);
		}else if(task.equals("doedit")){
			//封装Bean对象
			ItemBean bean = new ItemBean();
			bean.parseRequest(request);
			ItemDAO dao = new ItemDAO();
			boolean flag = dao.update(bean);
			String contextPath = request.getContextPath();
			PrintWriter out =response.getWriter();
			//根据dao的返回值进行处理
			if(flag){
				
				out.print("<SCRIPT>");
				out.print("alert('修改商品成功');");
				out.print("location.href='"+contextPath+"/itemServlet';");
				out.print("</script>");
			}else{
				out.print("<script>");
				out.print("alert('修改商品失败');");
				out.print("history.back();");
				out.print("</script>");
			}
		}else if(task.equals("del")){
			String itemid = request.getParameter("itemid");
			ItemDAO dao = new ItemDAO();
			boolean flag=dao.delete(itemid);
			String contextPath = request.getContextPath();
			PrintWriter out =response.getWriter();
			//根据dao的返回值进行处理
			if(flag){
				
				out.print("<SCRIPT>");
				out.print("alert('删除商品成功');");
				out.print("location.href='"+contextPath+"/itemServlet';");
				out.print("</script>");
			}else{
				out.print("<script>");
				out.print("alert('删除商品失败');");
				out.print("history.back();");
				out.print("</script>");
			}
		}else if(task.equals("btype")){//按大类别查询
			
			String pagenum = request.getParameter("currentPage");
			ItemDAO dao = new ItemDAO();
			int currentPage = 1;
			try {
				currentPage = Integer.parseInt(pagenum);
			} catch (Exception e) {
				currentPage=1;
			}		
			int count = 10;		
			ItemBean bean = new ItemBean();
			bean.setClassid(StrUtil.parseInt(id));
			List list = dao.getItemListbyClassid(currentPage,count,bean);
			String path = request.getContextPath()+"/itemServlet?";
			String sql = "select count(itemid) from t_iteminfo where 1=1";
			if(id!=null&&!id.trim().equals("")){
				sql=sql+" and classid ="+id;
				path = path+"classid="+id+"&";
			}
			XPage page = new XPage(currentPage,count,sql);
			page.setPath(path);

			request.setAttribute("result",list);
			request.setAttribute("mpage",page);
			if(list.size()==0){
				request.setAttribute("result",null);
			}
			request.getRequestDispatcher("/shop/list.jsp").forward(request,response);
			
		}else if(task.equals("stype")){//按小类别查询
			
			String pagenum = request.getParameter("currentPage");
			ItemDAO dao = new ItemDAO();
			int currentPage = 1;
			try {
				currentPage = Integer.parseInt(pagenum);
			} catch (Exception e) {
				currentPage=1;
			}		
			int count = 10;		
			ItemBean bean = new ItemBean();
			bean.setNclassid(StrUtil.parseInt(id));
			List list = dao.getItemListbyNclassid(currentPage,count,bean);
			String path = request.getContextPath()+"/itemServlet?";
			String sql = "select count(itemid) from t_iteminfo where 1=1";
			if(id!=null&&!id.trim().equals("")){
				sql=sql+" and nclassid ="+id;
				path = path+"nclassid="+id+"&";
			}
			XPage page = new XPage(currentPage,count,sql);
			page.setPath(path);

			request.setAttribute("result",list);
			request.setAttribute("mpage",page);
			if(list.size()==0){
				request.setAttribute("result",null);
			}
			request.getRequestDispatcher("/shop/list.jsp").forward(request,response);
		}else if(task.equals("itemshow")){//显示商品详细信息
			String itemid= request.getParameter("itemid");
			ItemDAO dao = new ItemDAO();
			ItemBean item = dao.getItemById(itemid);
			request.setAttribute("item",item);
			request.getRequestDispatcher("/shop/itemshow.jsp").forward(request,response);
		}
		
	}


	private void doquery(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
	
		//获取页面参数
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
		
		String pagenum = request.getParameter("currentPage");
		String title = request.getParameter("title");
		ItemDAO dao = new ItemDAO();
		ClassDAO classdao = new ClassDAO();
		int currentPage = 1;
		try {
			currentPage = Integer.parseInt(pagenum);
		} catch (Exception e) {
			currentPage=1;
		}		
		int count = 10;		
		ItemBean bean = new ItemBean();
		bean.setTitle(title);
		List list = dao.getItemList(currentPage,count,bean);
		List bClasslist = classdao.getBclass();
		List nClasslist = classdao.getNclass();
		String path = request.getContextPath()+"/itemServlet?";
		String sql = "select count(itemid) from t_iteminfo where 1=1";
		if(title!=null&&!title.trim().equals("")){
			sql=sql+" and title like '%"+title+"%'";
			path = path+"title="+title+"&";
		}
		XPage page = new XPage(currentPage,count,sql);
		page.setPath(path);
		request.setAttribute("bclasslist",bClasslist);
		request.setAttribute("nclasslist",nClasslist);
		request.setAttribute("result",list);
		request.setAttribute("mpage",page);
		if(list.size()==0){
			request.setAttribute("result",null);
		}
		request.getRequestDispatcher("/shop/list.jsp").forward(request,response);
	}

}