Java实现数据导出Excel：自定义存储服务示例

public class StorageService  {
    public XSSFWorkbook doExport(Model model,HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException {
        //从数据库拿数据
        //根据request获取前台传过来的数据
        String cid = request.getParameter("cid");
        String cplace = request.getParameter("cplace");
        String deccount = request.getParameter("deccount");
        String cname = request.getParameter("cname");
        String ph = request.getParameter("ph");
        String batchnumber = request.getParameter("batchnumber");
        //根据前台的数据去数据库查出来自己要的数据
        Map<String, Object> paramMap = new HashMap<>();
        paramMap.put("EQ_deleteState", 0);
        paramMap.put("EQ_cid", cid);
        paramMap.put("EQ_cplace", cplace);
        paramMap.put("EQ_deccount", deccount);
        paramMap.put("EQ_cname", cname);
        paramMap.put("EQ_ph", ph);
        paramMap.put("EQ_batchnumber", batchnumber);
        List<Out> list = search(paramMap);
        //数据转成excel
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("application/x-download");
        //定义excel的文件的名字
        String fileName = "日志表.xlsx";
        fileName = URLEncoder.encode(fileName, "UTF-8");
        response.addHeader("Content-Disposition", "attachment;filename=" + fileName);
        // 定义一个新的工作簿
        XSSFWorkbook wb = new XSSFWorkbook();