SpringBoot+jeefast框架导出Excel数据

SpringBoot+jeefast框架导出数据

Dao层

List<Student> queryList(Map<String,Object> map);
}

Service层

List<Student> queryList(Map<String,Object> map);

ServiceImpl

 @Override
    @DataFilter(tableAlias = "pst",user = false)
    public List<Student> queryList(Map<String,Object> map){
        return studentDao.queryList(map);
    }

Controller

    @RequestMapping("deleteImages")
    public R deleteImages(HttpServletRequest request) {
        String resultInfo = null;
        String filePath = request.getParameter("filePath");
        //这里是可以在控制器分割字符的一个方法
        //int lastIndexOf = filePath.lastIndexOf("/");
        //String sb = filePath.substring(lastIndexOf+1,filePath.length());
        //由于我们只获取了图片的名称并没有获取到所有的地址，，所以我们需要去给他进行添加存放图片的地址
        File file = new File("E:\\IDEA\\file"+filePath);
        if (file.exists()) {
            if (file.delete()) {
                resultInfo = "1-删除成功";
            }else {
                resultInfo = "0-删除失败";
            }
        }else {
            resultInfo = "文件不存在！";
        }
        return R.ok().put("resultInfo", resultInfo);
    }

Entity

  @ExcelResources(title="编号",order=1)//函数表示此为导出字段 title为自定义列名字 oeder为列的排次
    public int getId() {
        return id;
    }

    
    @ExcelResources(title="名字",order=2)
    public String getName() {
        return name;
    }

html

<a v-if="hasPermission('platform:student:exportExcel')" class="btn btn-primary btn-sm" @click="exportExcel"><i class="fa fa-trash-o"></i>&nbsp;导出</a>
               

js

exportExcel: function () {
            window.top.location.href = baseURL + "platform/student/exportExcel?token="+token;
        },