java csv下载_java下载CSV-excel文件

最新推荐文章于 2021-02-12 15:33:00 发布

东林251

最新推荐文章于 2021-02-12 15:33:00 发布

阅读量125

点赞数

文章标签： java csv下载

本文链接：https://blog.csdn.net/weixin_32307021/article/details/114055964

版权

这是一个关于Struts2框架中操作日志导出为CSV格式的代码实现。Action类中定义了导出方法exportCSV，通过OperationLogService获取CSV数据，设置响应头并写入内容，实现下载操作日志的CSV文件。

摘要由CSDN通过智能技术生成

1 package com.bjpowernode.egov.web.action;2

3 import java.util.ArrayList;4 import java.util.HashMap;5 import java.util.List;6 import java.util.Map;7

8 import javax.annotation.Resource;9

10 import org.apache.struts2.convention.annotation.Action;11 import org.apache.struts2.convention.annotation.Namespace;12 import org.apache.struts2.convention.annotation.Result;13 import org.springframework.context.annotation.Scope;14 import org.springframework.stereotype.Controller;15

16 import com.bjpowernode.egov.domain.OperationLog;17 import com.bjpowernode.egov.service.OperationLogService;18 import com.bjpowernode.egov.vo.PaginationVO;19

20 @Controller21 @Namespace("/operationLog")22 @Scope("prototype")23 public class OperationLogAction extends BaseAction {24

25 @Resource(name="operationLogService")26 private OperationLogService operationLogService;27

28 private Integer pageNo;29 private Integer pageSize;30 private String operatorName;31 private String operationType;32 private String startTime;33 private String endTime;34

35 public void setPageNo(Integer pageNo) {36 this.pageNo = pageNo;37 }38

39 public void setPageSize(Integer pageSize) {40 this.pageSize = pageSize;41 }42

43 public void setOperatorName(String operatorName) {44 this.operatorName = operatorName;45 }46

47 public void setOperationType(String operationType) {48 this.operationType = operationType;49 }50

51 public void setStartTime(String startTime) {52 this.startTime = startTime;53 }54

55 public void setEndTime(String endTime) {56 this.endTime = endTime;57 }58

100

101 @Action("exportCSV")102 public String exportCSV() throws Exception{103 String csv = operationLogService.getCsv();104 response.setContentType("application/vnd.ms-excel;charset=GBK");105 response.getWriter().write(csv);106 //response.addHeader("Content-Disposition","attachment;filename=operation_log.csv");107 response.addHeader("Content-Disposition","attachment;filename="+new String("操作日志".getBytes("UTF-8"),"ISO8859-1")+".csv");108 return null;109 }110

111

112 }