2022年1月21号遇到的问题与学习

1.easyExcel的导出。
（导出会报知名的错误，但是数据是对的，待解决）

//导出
        InputStream inputStream = this.getClass().getResourceAsStream("/Excel/excelIpExport.xlsx");
        response.reset();
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");
        // 这里URLEncoder.encode可以防止中文乱码 当然和easyExcel没有关系
        //String fileName = URLEncoder.encode("测试", "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + "fileName" + ".xlsx");
        ServletOutputStream outputStream = response.getOutputStream();
        EasyExcel.write(outputStream, WriteIpEquipment.class)
                    .withTemplate(inputStream).sheet("moban")
                    .doFill(writeIpEquipmentList);
        outputStream.close();

2.mybatis if 动态标签(不知道是在xml写速度快还是用stream流排序快？)

使用==的时候，需要test外层使用 ’ ’ 单引号，里面的参数使用 " "双引号！

<if test=' param.sortField != null and param.sortField != "" and param.sortField =="equipmentType" and param.sortOrder =="ascend" '>
            ORDER BY equipment_type ASC
        </if>
<if test=' param.sortField != null and param.sortField != "" and param.sortField =="equipmentType" and param.sortOrder =="descend" '>
            ORDER BY equipment_type DESC
        </if>