简单的使用Ireport
简单的使用Ireport
1、ireport5.6.0配置jdk; JDK1.7
参照文档：
https://blog.csdn.net/xht555/article/details/43409637
https://blog.csdn.net/yangydq/article/details/79023416
2、添加数据库驱动
在iReport-5.6.0\ireport\libs里加入驱动包
3、连接数据库
当确定连接属性都正确是还报错：General problem: nullPlease check your username and password. The DBMS is ru。。。。。
请换下你的mysql驱动试试
4、编写sql语句点击确定会自动把字段加入到Fields
选中报表右键选择padding and borders选择加入表格边框
pdf中文显示，右键选择表，右下角设置pdf
PDF导出报错：
at net.sf.jasperreports.engine.export.JRPdfExporter.getFont(JRPdfExporter.java:2117)
原因：缺少字体包 iTextAsian.jar
**
ireport+java的导出
1、导入的jar包
<!-- iReport JasperReports -->
<dependency>
<groupId>net.sf.jasperreports</groupId>
<artifactId>jasperreports</artifactId>
<version>5.6.0</version>
</dependency>
<dependency>
<groupId>org.codehaus.groovy</groupId>
<artifactId>groovy-all</artifactId>
<version>2.2.2</version>
</dependency>
<!--excel报表导出包-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.7</version>
</dependency>
对应的实体和ireport的数据源：实体类的字段名要和ireport数据源Fields的字段一致
Java
public static void main(String[] args) throws Exception {
System.out.println("--------------" +"开始");
String sourceFileName = "E:/Idea/work/springmvcmybatis/src/main/webapp/WEB-INF/jasper/report1.jasper";
String printFileName = null;
//自己获取的sql数据
DataBeanList DataBeanList = new DataBeanList();
ArrayList dataList = DataBeanList.getDataBeanList();
JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(dataList);
//定义了空的数据源
Map parameters = new HashMap();
try {
//获得文件，数据源
printFileName = JasperFillManager.fillReportToFile(sourceFileName,parameters, beanColDataSource);
//不为空开始导出
if (printFileName != null) {
/**
* 1- export to PDF
*/
JasperExportManager.exportReportToPdfFile(printFileName,"E:/home/test.pdf");
/**
* 2- export to HTML
*/
JasperExportManager.exportReportToHtmlFile(printFileName,"E:/home/test.html");
/**
* 3- export to Excel sheet
*/
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.INPUT_FILE_NAME, printFileName);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,"E:/home/test.xls");
exporter.exportReport();
}
} catch (JRException e) {
System.out.println("--------------" +"出错");
e.printStackTrace();
}
}
DataBeanList.java
package com.he.controller;
import com.he.entity.sysUser;
import java.util.ArrayList;
public class DataBeanList {
public ArrayList<sysUser> getDataBeanList() {
ArrayList<sysUser> dataBeanList = new ArrayList<sysUser>();
dataBeanList.add(produce("0950042", "0950042"));
dataBeanList.add(produce("0950051", "0950051"));
return dataBeanList;
}
}
ireport+ssm的导出
/**
* @describe 报表导出
* @param request
* @param response
* @param users
*/
@RequestMapping(value = {"/ireport", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void ireport(HttpServletRequest request, HttpServletResponse response, sysUser users) {
System.out.println("--------------" +"开始");
String sourceFileName = "/WEB-INF/jasper/report1.jasper";
String printFileName = null;
ServletContext context = request.getSession().getServletContext();
File reportFile = null;
reportFile = new File(context.getRealPath(sourceFileName));
//自己获取的sql数据对应Ireport的$F
users.setKeyId("0950042");
List<sysUser> uesrlist = sysUserService.listSysUser(users);
JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(uesrlist);
//定义的map数据源对应的Ireport的$P
Map parameters = new HashMap();
parameters.put("key_id","0950051");
try {
//获得文件，数据源
printFileName = JasperFillManager.fillReportToFile(reportFile.getPath(),parameters, beanColDataSource);
//不为空开始导出
if (printFileName != null) {
/**
* 1- export to PDF
*/
JasperExportManager.exportReportToPdfFile(printFileName,"E:/home/test.pdf");
/**
* 2- export to HTML
*/
JasperExportManager.exportReportToHtmlFile(printFileName,"E:/home/test.html");
/**
* 3- export to Excel sheet
*/
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.INPUT_FILE_NAME, printFileName);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,"E:/home/test.xls");
exporter.exportReport();
System.out.println("--------------" +"结束");
}
} catch (JRException e) {
e.printStackTrace();
System.out.println("--------------" +"出错");
}
}
少了DAO层的图
报错
1、检查字段是否对应
2、重新加入数据源
3、删除XML中field里的
网上借鉴
spring+jasperReport生成PDF格式的报表时报
java.lang.NoSuchMethodError: com.lowagie.text.pdf.PdfWriter.setRgbTransparencyBlending(Z)V异常
原因：iText.jar文件过旧，将之改为2.1版就没事了。
(2)java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException异常
原因：没有导入 groovy-all.jar 包，导入 groovy-all.jar 包就可以了。
(3)Excle 应用：
java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFCellStyle
出现上述错误提示加入 poi-3.2-FINAL-20081019.jar
(4)net.sf.jasperreports.engine.JRRuntimeException: Could not load the following font :
pdfFontName : STSong-Light
pdfEncoding : UniGB-UCS2-H
isPdfEmbedded : false
出现上述错误提示加入
iTextAsian.jar
(5)java.lang.NoClassDefFoundError: org/apache/commons/digester/Digester
出现上述错误提示加入 commons-digester-1.7.jar iReport/lib 功能简述：解析 xml 文件；
(6)java.lang.NoClassDefFoundError: org/apache/commons/collections/ArrayStack 出现上述错误提示加入
commons-beanutils-1.7.jar iReport/lib
(7)java.lang.NoClassDefFoundError: org/apache/commons/collections/ReferenceMap 出现上述错误提示加入
commons-collections-3.7.jar iReport/lib
(8)
异常：Found two components for namespace
解决方法.查看是否在工程目录添加了外部jar [jasperreports-X.X.X.jar],[jasperreports-X.X.X-javaflow.jar]
如果有同时添加了这两个jar.移除[jasperreports-3.5.3-javaflow.jar] 则可.
Ireport实际应用
工具类
package cn.com.zzcx.npl.common.utils;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.lang.reflect.Field;
import java.net.URLEncoder;
import java.sql.Connection;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JRAbstractExporter;
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporter;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperPrintManager;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.base.JRBaseReport;
import net.sf.jasperreports.engine.export.JExcelApiExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
import net.sf.jasperreports.engine.export.JRPdfExporter;
import net.sf.jasperreports.engine.export.JRRtfExporter;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;
import net.sf.jasperreports.engine.export.JRXmlExporter;
import net.sf.jasperreports.engine.util.JRLoader;
import net.sf.jasperreports.j2ee.servlets.ImageServlet;
import org.apache.log4j.Logger;
//import com.zzcx.cds.common.exception.TransException;
/**
* ireport Jasper 工具类 ClassName: JasperHelper date: 2018年3月15日 上午11:21:41
*
* @author
* @version
* @since JDK 1.7
*/
public class JasperHelper {
private static Logger logger = Logger.getLogger(JasperHelper.class);
public static final String PRINT_TYPE = "print";
public static final String PDF_TYPE = "pdf";
public static final String EXCEL_TYPE = "excel";
public static final String HTML_TYPE = "html";
public static final String WORD_TYPE = "word";
public static void prepareReport(JasperReport jasperReport, String type) {
logger.debug("The method======= prepareReport() start.......................");
/*
* 如果导出的是excel，则需要去掉周围的margin
*/
if ("excel".equals(type))
try {
Field margin = JRBaseReport.class.getDeclaredField("leftMargin");
margin.setAccessible(true);
margin.setInt(jasperReport, 0);
margin = JRBaseReport.class.getDeclaredField("topMargin");
margin.setAccessible(true);
margin.setInt(jasperReport, 0);
margin = JRBaseReport.class.getDeclaredField("bottomMargin");
margin.setAccessible(true);
margin.setInt(jasperReport, 0);
Field pageHeight = JRBaseReport.class.getDeclaredField("pageHeight");
pageHeight.setAccessible(true);
pageHeight.setInt(jasperReport, 2147483647);
} catch (Exception exception) {
}
}
/**
* 导出excel
*/
public static void exportExcel(JasperPrint jasperPrint, String defaultFilename, HttpServletRequest request,
HttpServletResponse response) throws IOException, JRException {
/*
* 设置头信息
*/
response.setContentType("application/vnd.ms-excel");
String defaultname = null;
if (defaultFilename.trim() != null && defaultFilename != null) {
defaultname = defaultFilename + ".xls";
} else {
defaultname = "export.xls";
}
response.setHeader("Content-Disposition",
"attachment; filename=\"" + URLEncoder.encode(defaultname, "UTF-8") + "\"");
ServletOutputStream ouputStream = response.getOutputStream();
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);
exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); // 删除记录最下面的空行
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);// 删除多余的ColumnHeader
//
exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);// 显示边框
exporter.exportReport();
ouputStream.flush();
ouputStream.close();
}
public static void exportExcel(JasperPrint jasperPrint, String path, String defaultFilename)
throws IOException, JRException {
String defaultname = null;
if (defaultFilename.trim() != null && defaultFilename != null) {
defaultname = defaultFilename + ".xls";
} else {
defaultname = "export.xls";
}
File file = new File(path + "WEB-INF\\report\\" + defaultname);
FileOutputStream fos = new FileOutputStream(file);
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, fos);
exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); // 删除记录最下面的空行
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);// 删除多余的ColumnHeader
//
exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);// 显示边框
exporter.exportReport();
fos.flush();
fos.close();
}
public static enum DocType {
PDF, HTML, XLS, XML, RTF
}
public static JRAbstractExporter getJRExporter(DocType docType) {
JRAbstractExporter exporter = null;
switch (docType) {
case PDF:
exporter = new JRPdfExporter();
break;
case HTML:
exporter = new JRHtmlExporter();
break;
case XLS:
exporter = new JExcelApiExporter();
break;
case XML:
exporter = new JRXmlExporter();
break;
case RTF:
exporter = new JRRtfExporter();
break;
}
return exporter;
}
/**
* 导出pdf，注意此处中文问题，
*
* 这里应该详细说：主要在ireport里变下就行了。看图
*
* 1）在ireport的classpath中加入iTextAsian.jar 2）在ireport画jrxml时，看ireport最左边有个属性栏。
*
* 下边的设置就在点字段的属性后出现。 pdf font name ：STSong-Light ，pdf encoding ：UniGB-UCS2-H
*/
private static void exportPdf(JasperPrint jasperPrint, String defaultFilename, HttpServletRequest request,
HttpServletResponse response) throws IOException, JRException {
response.setContentType("application/pdf");
String defaultname = null;
if (defaultFilename.trim() != null && defaultFilename != null) {
defaultname = defaultFilename + ".pdf";
} else {
defaultname = "export.pdf";
}
String fileName = new String(defaultname.getBytes("GBK"), "ISO8859_1");
response.setHeader("Content-Disposition", "attachment; filename=" + fileName);
ServletOutputStream ouputStream = response.getOutputStream();
JasperExportManager.exportReportToPdfStream(jasperPrint, ouputStream);
ouputStream.flush();
ouputStream.close();
}
/**
* 导出html
*/
private static void exportHtml(JasperPrint jasperPrint, String defaultFilename, HttpServletRequest request,
HttpServletResponse response) throws IOException, JRException {
response.setContentType("text/html");
ServletOutputStream ouputStream = response.getOutputStream();
JRHtmlExporter exporter = new JRHtmlExporter();
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE);
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, "UTF-8");
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);
exporter.exportReport();
ouputStream.flush();
ouputStream.close();
}
/**
* 导出word
*/
private static void exportWord(JasperPrint jasperPrint, String defaultFilename, HttpServletRequest request,
HttpServletResponse response) throws JRException, IOException {
response.setContentType("application/msword;charset=utf-8");
String defaultname = null;
if (defaultFilename.trim() != null && defaultFilename != null) {
defaultname = defaultFilename + ".doc";
} else {
defaultname = "export.doc";
}
String fileName = new String(defaultname.getBytes("GBK"), "utf-8");
response.setHeader("Content-disposition", "attachment; filename=" + fileName);
JRExporter exporter = new JRRtfExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream());
exporter.exportReport();
}
/**
* 按照类型导出不同格式文件
*
* @param datas
* 数据
* @param type
* 文件类型
* @param is
* jasper文件的来源
* @param request
* @param response
* @param defaultFilename默认的导出文件的名称
*/
public static void export(String type, String defaultFilename, File is, HttpServletRequest request,
HttpServletResponse response, Map parameters, Connection conn) {
try {
JasperReport jasperReport = (JasperReport) JRLoader.loadObject(is);
prepareReport(jasperReport, type);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn);
if (EXCEL_TYPE.equals(type)) {
exportExcel(jasperPrint, defaultFilename, request, response);
} else if (PDF_TYPE.equals(type)) {
exportPdf(jasperPrint, defaultFilename, request, response);
} else if (HTML_TYPE.equals(type)) {
exportHtml(jasperPrint, defaultFilename, request, response);
} else if (WORD_TYPE.equals(type)) {
exportWord(jasperPrint, defaultFilename, request, response);
} else if (PRINT_TYPE.equals(type)) {
printReport(jasperPrint, defaultFilename, request, response);
}
} catch (Exception e) {
logger.error("", e);
}
}
public static void export(String type, String defaultFilename, File is, HttpServletRequest request,
HttpServletResponse response, Map parameters, JRDataSource conn) {
try {
JasperReport jasperReport = (JasperReport) JRLoader.loadObject(is);
prepareReport(jasperReport, type);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn);
if (EXCEL_TYPE.equals(type)) {
exportExcel(jasperPrint, defaultFilename, request, response);
} else if (PDF_TYPE.equals(type)) {
exportPdf(jasperPrint, defaultFilename, request, response);
} else if (HTML_TYPE.equals(type)) {
exportHtml(jasperPrint, defaultFilename, request, response);
} else if (WORD_TYPE.equals(type)) {
exportWord(jasperPrint, defaultFilename, request, response);
} else if (PRINT_TYPE.equals(type)) {
if (!printReport(jasperPrint, defaultFilename, request, response)) {
throw new RuntimeException("打印失败！");
}
}
} catch (Exception e) {
throw new RuntimeException("服务器异常！", e);
}
}
public static void export(String type, String defaultFilename, String path,File is, Map parameters, Connection conn) {
try {
JasperReport jasperReport = (JasperReport) JRLoader.loadObject(is);
prepareReport(jasperReport, type);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn);
exportExcel(jasperPrint, path, defaultFilename);
} catch (Exception e) {
logger.error("", e);
}
}
/**
* 输出html静态页面，必须注入request和response
*
* @param jasperPath
* @param params
* @param sourceList
* @param imageUrl
* 报表文件使用的图片路径，比如 ../servlets/image?image=
* @throws JRException
* @throws IOException
* @throws ServletException
*/
public static void showHtml(String reportfile, HttpServletRequest request, HttpServletResponse response,
Map parameters, JRDataSource conn) throws JRException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
JRAbstractExporter exporter = getJRExporter(DocType.HTML);
JasperPrint jasperPrint = JasperFillManager.fillReport(reportfile, parameters, conn);
request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint);
PrintWriter out = response.getWriter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out);
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE);
exporter.exportReport();
out.flush();
}
public static void showHtml(String defaultFilename, String reportfile, HttpServletRequest request,
HttpServletResponse response, Map parameters, Connection conn) throws JRException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
JRAbstractExporter exporter = getJRExporter(DocType.HTML);
JasperPrint jasperPrint = JasperFillManager.fillReport(reportfile, parameters, conn);
request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint);
PrintWriter out = response.getWriter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out);
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE);
exporter.exportReport();
out.flush();
}
public static void showPdf(String defaultFilename, String reportfile, HttpServletRequest request,
HttpServletResponse response, Map parameters, Connection conn) throws JRException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
response.setContentType("application/pdf");
JRAbstractExporter exporter = getJRExporter(DocType.PDF);
JasperPrint jasperPrint = JasperFillManager.fillReport(reportfile, parameters, conn);
request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint);
PrintWriter out = response.getWriter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, out);
exporter.exportReport();
out.flush();
}
public static boolean printReport(String type, String defaultFilename, File is, HttpServletRequest request,
HttpServletResponse response, Map parameters, JRDataSource conn) {
try {
JasperReport jasperReport = (JasperReport) JRLoader.loadObject(is);
prepareReport(jasperReport, type);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn);
return printReport(jasperPrint, defaultFilename, request, response);
} catch (Exception e) {
// throw new TransException("服务器异常！",e);
throw new RuntimeException();
}
}
public static boolean printReport(JasperPrint jasperPrint, String defaultFilename, HttpServletRequest request,
HttpServletResponse response) {
try {
return JasperPrintManager.printReport(jasperPrint, true);
} catch (JRException e) {
// throw new TransException("打印异常！",e);
throw new RuntimeException();
} // 打印
}
}
SysUser：
package com.he.service;
import com.he.entity.sysUser;
import com.he.entity.testEntity;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* @author HeJiaQing
* @describe 用户接口
*/
@Service
public interface SysUser {
//查询用户
List<sysUser> listSysUser(sysUser users);
}
SysUserImpl：
package com.he.service.impl;
import com.he.dao.SysUserDAO;
import com.he.dao.sysUserMapper;
import com.he.entity.sysUser;
import com.he.entity.testEntity;
import com.he.service.SysUser;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class SysUserImpl implements SysUser {
@Autowired
sysUserMapper SysUserMapper;
@Autowired
SysUserDAO sysUserDAO;
@Override
public List<sysUser> listSysUser(sysUser users) {
List<sysUser> Users = sysUserDAO.getAll(users.getLoginName());
return Users;
}
}
SysUserDAO：
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.he.dao.SysUserDAO">
<!--目的:为dao接口方法提供sql语句配置
即针对dao接口中的方法编写我们的sql语句-->
<select id="getAll" resultType="com.he.entity.sysUser">
select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1
<if test="login_name != null and login_name != '' ">
and login_name = #{login_name}
</if>
</select>
</mapper>
Controller:
/**
* @describe 关闭数据库连接
* @param conn
*/
public void freeConnection(Connection conn) {
try {
// 关闭数据库连接
if (conn != null) {
conn.close();
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
/*-------------------------ireport定义的数据源是在写sql处定义参数$P!{sql},直接在后台传入sql语句当作数据源，在ireport会执行sql显示数据--------------------------------->
/**
* 输出报表在页面显示
* 使用的ireport模板是report1..jasper
* @param request
* @param response
* @param users
* @throws IOException
*/
@RequestMapping(value = {"/printHtml", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void printHtml(HttpServletRequest request, HttpServletResponse response, sysUser users) throws IOException {
//STEP 1 : 指定数据源
Map parameters = new HashMap();
parameters.put("sql","select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1 and login_name ='5400049' ");
//STEP 2 : 获取文件
File reportFile = null;
//绝对路径
//File reportFile = new File("E:/Idea/work/springmvcmybatis/out/artifacts/springmvcmybatis_war_exploded/WEB-INF/jasper/report1.jasper");
//相对路径
ServletContext context = request.getSession().getServletContext();
reportFile = new File(context.getRealPath("WEB-INF/jasper/report1.jasper"));
String exportFilePath = "tempPath";
//STEP 3 : 数据库连接
Connection conn = JDBCConnection.getConnection();
//STEP 4 : : 输出报表
/*使用HTML输出，表现为页面直接显示报表*/
try {
JasperHelper.showHtml(exportFilePath , reportFile.getPath(), request, response, parameters, conn);
} catch (JRException e) {
e.printStackTrace();
throw new RuntimeException("统计报表出现异常", e);
}finally {
freeConnection(conn);
}
}
/**
* 在ireport定义全局$P变量实现下载pdf
* 使用的ireport模板是report1..jasper
* @param request
* @param response
* @param users
* @throws IOException
*/
@RequestMapping(value = {"/printPdf", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void printPdf(HttpServletRequest request, HttpServletResponse response, sysUser users) throws IOException {
//STEP 1 : 指定数据源
Map parameters = new HashMap();
parameters.put("sql","select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1 and login_name ='5400049' ");
//STEP 2 : 获取文件
File reportFile = null;
//绝对路径
//File reportFile = new File("E:/Idea/work/springmvcmybatis/out/artifacts/springmvcmybatis_war_exploded/WEB-INF/jasper/report1.jasper");
//相对路径
ServletContext context = request.getSession().getServletContext();
reportFile = new File(context.getRealPath("WEB-INF/jasper/report1.jasper"));
String exportFilePath = "tempPath";
//STEP 3 : 数据库连接
Connection conn = JDBCConnection.getConnection();
// STEP 4 : 输出报表
try {
JasperHelper.export(JasperHelper.PDF_TYPE, "test", reportFile,request, response, parameters, conn);
JasperHelper.export("excel", "fileName", reportFile, request,response, parameters, conn);
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException("统计报表出现异常", e);
}finally {
freeConnection(conn);
}
}
/**
* 在ireport定义全局$P变量实现下载Excle
* 使用的ireport模板是report1..jasper
* @param request
* @param response
* @param users
* @throws IOException
*/
@RequestMapping(value = {"/printExcle", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void printExcle(HttpServletRequest request, HttpServletResponse response, sysUser users) throws IOException {
//STEP 1 : 指定数据源
Map parameters = new HashMap();
parameters.put("sql","select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1 and login_name ='5400049' ");
//STEP 2 : 获取文件
File reportFile = null;
//绝对路径
//File reportFile = new File("E:/Idea/work/springmvcmybatis/out/artifacts/springmvcmybatis_war_exploded/WEB-INF/jasper/report1.jasper");
//相对路径
ServletContext context = request.getSession().getServletContext();
reportFile = new File(context.getRealPath("WEB-INF/jasper/report1.jasper"));
String exportFilePath = "tempPath";
//STEP 3 : 数据库连接
Connection conn = JDBCConnection.getConnection();
// STEP 4 : 输出报表
try{
JasperHelper.export("excel", "fileName", reportFile, request,response, parameters, conn);
}catch (Exception e){
log.info("-------"+"excel错误");
e.printStackTrace();
}
}
/*-------------------------ireport定义的数据源是在写sql处定义参数$P!{sql},直接在后台传入获取的数据当作数据源，在ireport会直接对应数据实体显示--------------------------------->
/**
* 输出报表在页面显示
* 使用的ireport模板是report1..jasper
* @param request
* @param response
* @param users
* @throws IOException
*/
@RequestMapping(value = {"/outHtml", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void outHtml(HttpServletRequest request, HttpServletResponse response, sysUser users) throws IOException {
// STEP 1 : 指定ireport数据源 F
users.setLoginName("0950099");//陈长
List<sysUser> uesrlists = sysUserService.listSysUser(users);
//STEP 1 : 放入数据源
JRDataSource datasource = new JRBeanCollectionDataSource(uesrlists);
//STEP 1 : 指定ireport数据源 P
Map parameters = new HashMap();
/* parameters.put("sql","select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1 and login_name ='5400049' ");*/
//STEP 2 : 获取文件
File reportFile = null;
//绝对路径
//File reportFile = new File("E:/Idea/work/springmvcmybatis/out/artifacts/springmvcmybatis_war_exploded/WEB-INF/jasper/report1.jasper");
//相对路径
ServletContext context = request.getSession().getServletContext();
reportFile = new File(context.getRealPath("WEB-INF/jasper/report1.jasper"));
String exportFilePath = "tempPath";
//STEP 3 : 数据库连接
Connection conn = JDBCConnection.getConnection();
//STEP 4 : : 输出报表
/*使用HTML输出，表现为页面直接显示报表*/
try {
JasperHelper.showHtml(reportFile.getPath(), request,response, parameters, datasource);
} catch (JRException e) {
e.printStackTrace();
throw new RuntimeException("统计报表出现异常", e);
}finally {
freeConnection(conn);
}
}
/**
* 输出报表在页面显示
* 使用的ireport模板是report1.jasper
* @param request
* @param response
* @param users
* @throws IOException
*/
@RequestMapping(value = {"/outPdf", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void outPdf(HttpServletRequest request, HttpServletResponse response, sysUser users) throws IOException {
// STEP 1 : 指定ireport数据源 F
users.setLoginName("0950103");//胡永志
List<sysUser> uesrlists = sysUserService.listSysUser(users);
//STEP 1 : 放入数据源
JRDataSource datasource = new JRBeanCollectionDataSource(uesrlists);
//STEP 1 : 指定ireport数据源 P
Map parameters = new HashMap();
/* parameters.put("sql","select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1 and login_name ='5400049' ");*/
//STEP 2 : 获取文件
File reportFile = null;
//绝对路径
//File reportFile = new File("E:/Idea/work/springmvcmybatis/out/artifacts/springmvcmybatis_war_exploded/WEB-INF/jasper/report1.jasper");
//相对路径
ServletContext context = request.getSession().getServletContext();
reportFile = new File(context.getRealPath("WEB-INF/jasper/report1.jasper"));
String exportFilePath = "tempPath";
//STEP 3 : 数据库连接
Connection conn = JDBCConnection.getConnection();
//STEP 4 : : 输出报表
/*使用HTML输出，表现为页面直接显示报表*/
try {
JasperHelper.export(JasperHelper.PDF_TYPE,"导出PDF",reportFile, request,response, parameters, datasource);
} catch (Exception e) {
e.printStackTrace();
log.info("PDF导出错误"+e);
}finally {
freeConnection(conn);
}
}
/**
* 输出报表在页面显示
* 使用的ireport模板是report1.jasper
* @param request
* @param response
* @param users
* @throws IOException
*/
@RequestMapping(value = {"/outExcle", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void outExcle(HttpServletRequest request, HttpServletResponse response, sysUser users) throws IOException {
// STEP 1 : 指定ireport数据源 F
users.setLoginName("0950103");//胡永志
List<sysUser> uesrlists = sysUserService.listSysUser(users);
//STEP 1 : 放入数据源
JRDataSource datasource = new JRBeanCollectionDataSource(uesrlists);
//STEP 1 : 指定ireport数据源 P
Map parameters = new HashMap();
/* parameters.put("sql","select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1 and login_name ='5400049' ");*/
//STEP 2 : 获取文件
File reportFile = null;
//绝对路径
//File reportFile = new File("E:/Idea/work/springmvcmybatis/out/artifacts/springmvcmybatis_war_exploded/WEB-INF/jasper/report1.jasper");
//相对路径
ServletContext context = request.getSession().getServletContext();
reportFile = new File(context.getRealPath("WEB-INF/jasper/report1.jasper"));
String exportFilePath = "tempPath";
//STEP 3 : 数据库连接
Connection conn = JDBCConnection.getConnection();
//STEP 4 : : 输出报表
/*使用HTML输出，表现为页面直接显示报表*/
try {
JasperHelper.export(JasperHelper.EXCEL_TYPE,"导出EXCLE",reportFile, request,response, parameters, datasource);
} catch (Exception e) {
e.printStackTrace();
log.info("EXCLE导出错误"+e);
}finally {
freeConnection(conn);
}
}
/**
* 输出报表在页面显示
* 使用的ireport模板是report1.jasper
* @param request
* @param response
* @param users
* @throws IOException
*/
@RequestMapping(value = {"/outWord", ""}, method = {RequestMethod.GET, RequestMethod.POST})
public void outWord(HttpServletRequest request, HttpServletResponse response, sysUser users) throws IOException {
// STEP 1 : 指定ireport数据源 F
users.setLoginName("0950103");//胡永志
List<sysUser> uesrlists = sysUserService.listSysUser(users);
//STEP 1 : 放入数据源
JRDataSource datasource = new JRBeanCollectionDataSource(uesrlists);
//STEP 1 : 指定ireport数据源 P
Map parameters = new HashMap();
/* parameters.put("sql","select key_id keyId,login_name loginName,name,del_flag delFlag,email,employee_id employeeId,icon,identity,mobile,organization_name organizationName from sys_user where 1=1 and login_name ='5400049' ");*/
//STEP 2 : 获取文件
File reportFile = null;
//绝对路径
//File reportFile = new File("E:/Idea/work/springmvcmybatis/out/artifacts/springmvcmybatis_war_exploded/WEB-INF/jasper/report1.jasper");
//相对路径
ServletContext context = request.getSession().getServletContext();
reportFile = new File(context.getRealPath("WEB-INF/jasper/report1.jasper"));
String exportFilePath = "tempPath";
//STEP 3 : 数据库连接
Connection conn = JDBCConnection.getConnection();
//STEP 4 : : 输出报表
/*使用HTML输出，表现为页面直接显示报表*/
try {
JasperHelper.export(JasperHelper.WORD_TYPE,"导出WORD",reportFile, request,response, parameters, datasource);
} catch (Exception e) {
e.printStackTrace();
log.info("WORD导出错误"+e);
}finally {
freeConnection(conn);
}
}
public class JDBCConnection {
public static Connection getConnection(){
try {
String url = "jdbc:mysql://127.0.0.1:3306/xuli";
String userName = "root";
String password = "manager1";
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url,userName,password);
return connection;
}catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}