代码参考

来源：互联网发布：剑灵天族身材数据图编辑：程序博客网时间：2024/05/16 14:52

1.模板下载功能的实现

<button class="btn" id="deviceExport">导出</button>       <script type="text/javascript" src="user.js"></script>var User = function(){    this.init = function(){         // 用于导出excel        $("#userExport").click(function() {            var url =  '/user/export/';            location.href = url + "?queryJson="+JSON.stringify(user.acquireInquireData());        });    };    //获取查询条件    this.acquireInquireData = function(){        var inquireCondition = {                name:$('#name').val(),//名称                sex: $('#sex').val(),//性别                age: $('#age').val(),//年龄        };        return inquireCondition;    };}var user;$(function(){    user = new User();    user.init();});

模板的实现类见博客

调用具体的Controller@Controller@RequestMapping("/user")public class UserController {    @Autowired    private UserService userService;    /**     * 用于导出excel的查询结果     * @param queryJson     * @return     */    @RequestMapping("/export")    public void export(HttpServletRequest request, HttpServletResponse response,                        @RequestParam(value = "queryJson") String queryJson) {        User user = JSON.parseObject(queryJson, User.class);        List<user> userlList = userService.getUserForExcel(user);        ExportExcel<user> ee= new ExportExcel<user>();        String[] headers = { "序号", "姓名", "性别", "年龄" };        String fileName = "用户信息表";        ee.exportExcel(headers,userlList,fileName,response);    }}

0 0