<%@ page language="java" contentType="application/vnd.ms-excel; charset=gbk" pageEncoding="gbk"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%
File reportFile = new File(application.getRealPath("report/employee.jasper"));
Connection conn =null ;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=as";
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,"test","test");
Map parameters = new HashMap();
//String str=JasperRunManager.runReportToHtmlFile(reportFile.getPath(),parameters,conn);
//String str=JasperRunManager.runReportToHtmlFile(reportFile.getPath(),parameters,new JREmptyDataSource());
//System.out.println(str);
parameters.put("employeeId", new String("1001011"));
//生成EXCEL
JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile.getPath(),parameters,conn); JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
//exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream());
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(); response.setContentType("application/vnd.ms-excel");
conn.close();
}catch(Exception e){
e.printStackTrace();
}
%>
</body>
</html>一运行就提示保存...怎么让他在页面中显示EXCLE预览?
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%
File reportFile = new File(application.getRealPath("report/employee.jasper"));
Connection conn =null ;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=as";
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,"test","test");
Map parameters = new HashMap();
//String str=JasperRunManager.runReportToHtmlFile(reportFile.getPath(),parameters,conn);
//String str=JasperRunManager.runReportToHtmlFile(reportFile.getPath(),parameters,new JREmptyDataSource());
//System.out.println(str);
parameters.put("employeeId", new String("1001011"));
//生成EXCEL
JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile.getPath(),parameters,conn); JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
//exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream());
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(); response.setContentType("application/vnd.ms-excel");
conn.close();
}catch(Exception e){
e.printStackTrace();
}
%>
</body>
</html>一运行就提示保存...怎么让他在页面中显示EXCLE预览?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货