Ruoyi 导出

Domain

    @Excel(name = "学生编号",cellType = Excel.ColumnType.NUMERIC)//需要导出的主键
    private int id;
    @Excel(name = "学生姓名")//需要导出的字段
    private String name;
    @Excel(name = "年龄")
    private  int age;
    @Excel(name = "推荐")
    private  int success;
    @Excel(name = "TTid")
    private  int ttid;

Controller

    /**
     * 导出
     */
    @Log(title = "学生", businessType = BusinessType.EXPORT)
    @RequiresPermissions("system:student:export")
    @PostMapping("/export")
    @ResponseBody
    public AjaxResult export(Student student)
    {
        List<Student> list = studentService.selectStudentList(student);
        ExcelUtil<Student> util = new ExcelUtil<Student>(Student.class);
        return util.exportExcel(list, "学生");
    }

Html

 <a class="btn btn-warning" onclick="$.table.exportExcel()" shiro:hasPermission="system:student:export">
                <i class="fa fa-download"></i> 导出
            </a>
Logo

快速构建 Web 应用程序

更多推荐