jasperreports java web报表_JasperReports学习笔记4-查询数据库生成动态的报表（WEB）...

1 2 importjava.io.IOException;3 importjava.io.InputStream;4 importjava.sql.Connection;5 importjava.sql.DriverManager;6 importjava.sql.ResultSet;7 importjava.sql.SQLException;8 importjava.sql.Statement;9 importjava.util.HashMap;10 11 importjavax.servlet.ServletException;12 importjavax.servlet.ServletOutputStream;13 importjavax.servlet.http.HttpServlet;14 importjavax.servlet.http.HttpServletRequest;15 importjavax.servlet.http.HttpServletResponse;16 17 importnet.sf.jasperreports.engine.JRException;18 importnet.sf.jasperreports.engine.JRResultSetDataSource;19 importnet.sf.jasperreports.engine.JasperRunManager;20 21 publicclassDynamicCreateReportWithServletDateSourceextendsHttpServlet {22 23 privatestaticfinallongserialVersionUID=1L;24 25 publicvoiddoGet(HttpServletRequest request, HttpServletResponse response)26 throwsServletException, IOException {27 Connection connection=null;28 Statement statument=null;29 ResultSet resultSet=null;30 String sql="select tb.name as name,tb.age as age,tbs.marks as marks from jaspertb tb join jaspertbs tbs";31 ServletOutputStream servletOutputStream=response.getOutputStream();32 InputStream is=getServletConfig().getServletContext().getResourceAsStream("report\\JasperReportSQLResult.jasper");33 try{34 Class.forName("com.mysql.jdbc.Driver");35 connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/jasperreportdb","root","root");36 statument=connection.createStatement();37 resultSet=statument.executeQuery(sql);38 //这里把ResultSet封装到JRResultSetDataSource对象里面了39 JasperRunManager.runReportToPdfStream(is,servletOutputStream,newHashMap(),newJRResultSetDataSource(resultSet));40 response.setContentType("application/pdf");41 servletOutputStream.flush();42 servletOutputStream.close();43 connection.close();44 }catch(ClassNotFoundException e) {45 e.printStackTrace();46 }catch(SQLException e) {47 e.printStackTrace();48 }catch(JRException e) {49 e.printStackTrace();50 }51 }52 53 publicvoiddoPost(HttpServletRequest request, HttpServletResponse response)54 throwsServletException, IOException {55 this.doGet(request, response);56 }57 58 }