与SpringMVC整合,整了两天,终于可以了。
参考资源:资源已上传,等审核过就可以参考下
关键问题记录下:
1: 依赖jar包
<!-- iReport JasperReports -->
<dependency>
<groupId>net.sf.jasperreports</groupId>
<artifactId>jasperreports</artifactId>
<version>${jasperreports.version}</version>
</dependency>
<dependency>
<groupId>com.lowagie</groupId>
<artifactId>itext</artifactId>
<version>${itext.version}</version>
</dependency>
<dependency>
<groupId>com.lowagie</groupId>
<artifactId>itextasian</artifactId>
<version>${itextasian.version}</version>
</dependency>
<dependency>
<groupId>org.olap4j</groupId>
<artifactId>olap4j</artifactId>
<version>${olap4j.version}</version>
</dependency>
<dependency>
<groupId>org.codehaus.groovy</groupId>
<artifactId>groovy-all</artifactId>
<version>${groovy-all.version}</version>
</dependency>
<!-- 读取xml -->
<dependency>
<groupId>xml-apis</groupId>
<artifactId>xml-apis</artifactId>
<version>${xml-apis.version}</version>
</dependency>
有些jar包在maven仓库还找不到,最后还是放到自己仓库里面。apache poi的包没导入,poi这个包主要是导出xls的格式有用到,但发现我导入之后,会报方法找不到,
最后解决方案是:如果导出的是xls格式的,都用xlsx了去处理,只有在最后写给浏览器是把文件后缀换为xls。
2:主要用到的几个工具类
=================controller调用方法================
@Autowired
private DataSource dataSource;
@RequestMapping("download")
@RequiresPermissions("sys:user:download")
public void download(HttpServletRequest request,HttpServletResponse response){
try {
//获取查询条件参数
Map<String, Object> sqlParams=new HashMap<>();
EntityWrapper<User> ew=getWrapper(request);
if(StringUtils.isNotBlank(ew.getSqlSegment())){
sqlParams.put("conditions",ew.getSqlSegment());
}
//获取下载参数
Map<String,Object> reqMap= WebUtils.getParametersStartingWith(request,null);
//文件路径
String filePath=getJasperFilePath(request, reqMap.get("filePath"));
//是否下载
Boolean download=reqMap.get("download")!=null?Boolean.valueOf(String.valueOf(reqMap.get("download"))):true;
//报表类型
String type=String.valueOf(reqMap.get("type"));
//下载后的文件名
String downloadName=String.valueOf(reqMap.get("downloadName"));
//下载
ReportWebUtils.export(request, response, filePath, downloadName, type, download, sqlParams, dataSource);
} catch (Exception e) {
e.printStackTrace();
rendStr(response,"报表打印错误");
logger.error(Exceptions.getStackTraceAsString(e));
}
}
=========================================ReportWebUtils ======================
package com.mould.common.web;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.net.URLEncoder;
import java.sql.Connection;
import java.util.Map;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.springframework.jdbc.datasource.DataSourceUtils;
import com.mould.common.entity.ReportFileType;
import com.mould.common.utils.ReportUtils;
import com.mould.common.utils.StringUtils;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
/**
*
* @Description:jasperreports工具类
* @author linwp
* @time:2017年3月24日 下午9:57:45
*
*/
public class ReportWebUtils {
/**