Creating Dynamic Database Reports - JasperReports for Java Developers

Java Reference

In-Depth Information

package net.ensode.jasperbook;

import java.io.IOException;

import java.io.InputStream;

import java.io.PrintWriter;

import java.io.StringWriter;

import java.sql.Connection;

import java.sql.DriverManager;

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.JasperRunManager;

public class DbReportServlet extends HttpServlet

{

protected void doGet(HttpServletRequest request, HttpServletResponse

response) throws ServletException, IOException

{

Connection connection;

ServletOutputStream servletOutputStream =

response.getOutputStream();

InputStream reportStream =

getServletConfig().getServletContext().getResourceAsStream

("/reports/DbReport.jasper");

try

{

Class.forName("com.mysql.jdbc.Driver");

connection = DriverManager.getConnection ("jdbc:mysql://

localhost:3306/flightstats?user=dbuser&password=secret");

JasperRunManager.runReportToPdfStream(reportStream,

servletOutputStream, new HashMap(), connection);

connection.close();

Search WWH ::

Custom Search

Home