4：基于html的数据展示

Servlet层

@WebServlet(urlPatterns = "/goods")
public class GoodsServlet extends HttpServlet {
    private static final long serialVersionUID = 4116681024313896922L;

    private GoodsService goodsService = new GoodsServiceImpl();

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException {
        response.setContentType("application/json");
        response.setCharacterEncoding("UTF-8");

        final String op = request.getParameter("op");
        switch (op) {
            case "findAllGoods":
                try {
                    findAllGoods(request, response);
                } catch (SQLException | IOException e) {
                    e.printStackTrace();
                }
                break;
            case "getGoodsById":
                try {
                    getGoodsById(request, response);
                } catch (SQLException | IOException e) {
                    e.printStackTrace();
                }
                break;
            default:
                break;
        }

    }

    private void getGoodsById(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        final String idStr = request.getParameter("id");
        if (idStr == null) {
            throw new RuntimeException("待查询的商品的id不能为空");
        }
        Integer id = Integer.parseInt(idStr);
        final Goods goods = goodsService.getGoodsById(id);
        request.setAttribute("goods", goods);
        request.getRequestDispatcher("goods.jsp").forward(request, response);
    }

    private void findAllGoods(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        final List goodsList = goodsService.listAllGoods();
        request.setAttribute("goodsList", goodsList);
        request.getRequestDispatcher("index.jsp").forward(request, response);
    }

    private void genExcel() throws SQLException {
        final List arrayList = goodsService.listAllGoods();

        String fileName = "D:/demo" + System.currentTimeMillis() + ".xlsx";
        EasyExcel.write(fileName, Goods.class).sheet("商品信息").doWrite(arrayList);
    }
}

前端代码

• index.jsp

    首页


商品列表

    
        编号
        名称
        市场价格
        会员价格
        库存数量
        操作
    

    
        ${goods.id}
        ${goods.name}
        ${goods.price1}
        ${goods.price2}
        ${goods.amount}
        
            详情
        
    

• goods.jsp

    商品详情


    编号：${goods.id} 
    名称：${goods.name} 
    市场价格：${goods.price1} 
    会员价格：${goods.price2} 
    库存：${goods.amount}

效果