26_商品管理

商品管理

1）步骤分析

1. 修改left.jsp的页面的连接：/store/adminProduct/findAll
2. 在AdminProductServlet中查询所有商品，返回list，将list放入request中，请求转发到/admin/product/list.jsp
3. 在页面上展示数据

---

2）代码实现

①修改left.jsp

d.add('010401','0104','商品管理','${pageContext.request.contextPath}/adminProduct/findAll','','mainFrame');

② 完成AdminProductServlet

	@WebServlet("/adminProduct/*")
	public class AdminProductServlet extends HttpServlet{
		
		/**
		 * 
		 */
		private static final long serialVersionUID = 4290115767664068382L;
		
		private ProductService productService=new ProductServiceImpl();
		@Override
		protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
			//得到URI
			String uri=request.getRequestURI();
			//处理各个方法抛出的异常
			try {
				if(uri.endsWith("/findAll")) {
					findAll(request,response);
				}
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				//抛出自定义异常
				throw new MyException();
			} 
		}
		/**
		 * 查询所有
		 * @param request
		 * @param response
		 * @throws Exception 
		 */
		private void findAll(HttpServletRequest request, HttpServletResponse response) throws Exception {
			List<Product> list=productService.findAll();
			request.setAttribute("list", list);
			request.getRequestDispatcher("/admin/product/list.jsp").forward(request, response);
		}
	}

③ 完成dao

	@Override
	public List<Product> findAll() throws Exception {
		String sql="select * from product";
		return qr.query(sql, new BeanListHandler<>(Product.class));
	}

④ 修改页面，展示数据