iReport-Jasperreport例子

package com.dhcc.testjsaperreport; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import javax.servlet.ServletException; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JRResultSetDataSource; import net.sf.jasperreports.engine.JasperRunManager; public class DynamicCreateReportWithServletDateSource extends HttpServlet { private static final long serialVersionUID = 1L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Connection connection = null; Statement statument = null; ResultSet resultSet = null; String sql = "select name,sal from salary where sal>4000"; ServletOutputStream servletOutputStream = response.getOutputStream(); InputStream is = getServletConfig().getServletContext().getResourceAsStream("reports\\DBReport.jasper"); try { Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root1"); statument = connection.createStatement(); resultSet = statument.executeQuery(sql); //这里把ResultSet封装到JRResultSetDataSource对象里面了 JasperRunManager.runReportToPdfStream(is,servletOutputStream,new HashMap(), new JRResultSetDataSource(resultSet)); response.setContentType("application/pdf"); servletOutputStream.flush(); servletOutputStream.close(); connection.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } catch (JRException e) { e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } }