6：基于Excel的数据展示（生成报表）

简介

采用阿里的Easy-Excel生成报表

添加依赖

    
      com.alibaba
      easyexcel
      3.0.2
    

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 "genExcel":
                try {
                    genExcel();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                break;
            default:
                break;
        }
    }


    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);
    }

}

前端页面

    
    生成报表


生成Excel报表

当用户单击页面中的超连接时，会在D盘生成Excel文件：