接著,就是報表連接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();


%> 

以上,程式貼上,即可用網頁開啟報表

文章標籤
全站熱搜
創作者介紹
創作者 kyo 的頭像
kyo

鏡花水月-什麼是真?什麼是假?

kyo 發表在 痞客邦 留言(0) 人氣(239)