6：基于Excel的数据展示（生成报表）_数据库链接excel 生成报表-CSDN博客

本文链接：https://blog.csdn.net/lianghecai52171314/article/details/121107601

简介

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

添加依赖

    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>easyexcel</artifactId>
      <version>3.0.2</version>
    </dependency>

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<Goods> arrayList = goodsService.listAllGoods();

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

}

前端页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>生成报表</title>
</head>
<body>
<a href="goods?op=genExcel">生成Excel报表</a>
</body>
</html>