Jasperreport5.6.0 生成报表另存为多种格式
Jasperreport5.6.0 生 成 的 报 表 , 可 有 多 种 格 式 , 这 里 主 要 讲 生 成
PDF,RTF,EXCEL,HTML,XML 等格式.主要是在页面写的代码。
1. 生成 HTML 代码如下:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-
8"%>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%@ page
import="org.springframework.ui.jasperreports.JasperReportsUtils"
%>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()
+"://"+request.getServerName()+":"+request.getServerPort()
+path+"/";
%>
<%
//报表生成之后编译生成的.jasper 文件位置
File jasperFile=new
File("D:/Workspaces/zwjxSystem/WebRoot/jasper/report1.jasper");
String url ="jdbc:oracle:thin:@192.168.1.104:1521:orcl";
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn =
DriverManager.getConnection(url,"zwjx","zwjx");
String projectapproid =
request.getParameter("projectapproid");
System.out.println(projectapproid);
Map map = new HashMap();
map.put( "projectapproid" ,projectapproid) ;
//打印
JasperPrint print =
JasperFillManager.fillReport(jasperFile.getPath(), map,conn);
OutputStream os=response.getOutputStream();
//生成文件名
String fileNames="项目立项";
JRAbstractExporter exporter = new JRHtmlExporter() ;
response.reset();
response.setContentType("text/html");
response.setHeader("Content-
评论1