ireport group_ireport table_java ireport案例(3)

<%@page contentType="application/pdf;charset=GB2312"%>

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<%@page import="net.sf.jasperreports.engine.*"%>

<%@page import="java.util.*"%>

<%@page import="java.io.*"%>

<%@page import="java.sql.*"%>

<%

System.out.println("chenggong");

File reportFile = new File(application.getRealPath("ireports/report3.jasper "));

System.out.println(reportFile.getPath());

Map parameters = new HashMap();

parameters.put("getId", "50");

Connection conn = null;

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection("jdbc:oracle:thin:@*", "*", "*");

System.out.println("连接成功");

}

catch (Exception e) {

System.out.println(e);

}

//JasperRunManager run = new JasperRunManager();

System.out.println("abc");

byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(), parameters, conn);

System.out.println("def");

response.setContentType("application/pdf");

response.setContentLength(bytes.length);

ServletOutputStream ouputStream = response.getOutputStream();

ouputStream.write(bytes, 0, bytes.length);

ouputStream.flush();

ouputStream.close();

%>

4.2 jsp输出EXCEL报表

4.2.1 需要放到项目里的包

jasperreports-1.0.1.jar

poi-2.0-final-20040126.jar

4.2.2 输出excel要注意的:

(1) 输出excel报表必须fields的边界刚好填充满整个页面,不然会有大量的空白出现。

(2) 删除记录最下面的空行需要加上参数

exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);

(3) 删除多余的ColumnHeader需要加上参数

exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-35158-3.html