java导出Excel

最新推荐文章于 2024-07-03 14:13:18 发布

杜_小妖

最新推荐文章于 2024-07-03 14:13:18 发布

阅读量517

点赞数

分类专栏： Java基础文章标签：导出

本文链接：https://blog.csdn.net/duyusean/article/details/82083390

版权

Java基础专栏收录该内容

27 篇文章 0 订阅

订阅专栏

Controller层：

@RequestMapping("/export")
@ResponseBody
publicCommonStatusexport(Companybean,HttpServletRequestrequest,HttpServletResponseresponse){

ExcelUtil<Company>util=newExcelUtil<Company>(Company.class);
//可以设置条件
List<Company>list=this.service.export(null);

ByteArrayOutputStreamout=newByteArrayOutputStream();
StringfileName="入孵入驻公司信息.xls";
util.exportExcel(list,fileName,out);//导出

download(fileName,out,response);

returnsuccess();
}

mapper.xml

<!--导出-->
<selectid="export"resultMap="companyResultMap"parameterType="java.util.Map">
select<includerefid="table_columns"/>,
DATE(start_time)startTimeExport,
(CASEstatusWHEN1THEN"报名中"WHEN2THEN"进行中"WHEN0THEN"已完成"ELSEstatusEND)statusChinese,
(CASEpostion_typeWHEN1THEN"独立办公室"WHEN2THEN"开放工位"ELSEpostion_typeEND)postionTypeName,
(CASEmode_paymentWHEN1THEN"工位/日租"WHEN2THEN"工位/月租"WHEN3THEN"面积/天"ELSEmode_paymentEND)modePaymentName
fromt_company
<includerefid="whereSql"/>
</select>