接著,就是報表連接JSP
以下是程式碼
<%@page import="net.sf.jasperreports.engine.design.JasperDesign"%>
<%@page import="net.sf.jasperreports.engine.*" %>
<%@page import="net.sf.jasperreports.engine.JasperRunManager"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.util.Map"%>
<%@page import="java.util.HashMap"%>
<%@page import="java.io.File"%>
<%@ page import="java.sql.*"%>
<%@ include file = "db.jsp"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%
String sql = "select * from send ";
ResultSet rs = stmt.executeQuery(sql);
File reportFile = new File(application.getRealPath("/report/report3.jasper"));
Map parameters = new HashMap();
JRDataSource dataSource = new JRResultSetDataSource(rs);
byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(), parameters, dataSource);
response.setContentType("application/pdf");
response.setContentLength(bytes.length);
ServletOutputStream outStream = response.getOutputStream();
outStream.write(bytes, 0, bytes.length);
outStream.flush();
outStream.close();
rs.close();
%>
以上,程式貼上,即可用網頁開啟報表
文章標籤
全站熱搜
