Relatorios com pesquisa

0 respostas
M

Caros, tirei este exemplo no site, ele não gerar o relatório. tem como vcs me ajudar.

agradeço muito.

Marciojp18

/*

  • To change this template, choose Tools | Templates
  • and open the template in the editor.
    */

package br.com.integrator.web;

import br.com.integrator.util.ConnectionFactory;

import com.mysql.jdbc.Connection;

import <a href="http://java.io">java.io</a>.<em>;

import <a href="http://java.net">java.net</a>.</em>;
import java.util.HashMap;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.servlet.<em>;

import javax.servlet.http.</em>;

import net.sf.jasperreports.engine.JasperRunManager;

/**
*

  • @author Administrador
    */
    public class Relatorio extends HttpServlet {

    /**

    • Processes requests for both HTTP GET and POST methods.
    • @param request servlet request
    • @param response servlet response
    • @throws javax.servlet.ServletException
    • @throws java.io.IOException
      */
      protected void processRequest(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
      ServletOutputStream servletOutputStream =
      response.getOutputStream();
    String caminho = /relatorio/;
    
    String relatorio = caminho +relatorio.jasper;
    
    InputStream reportStream = getServletConfig().
    
    getServletContext().
    
    getResourceAsStream(relatorio);
    

    Connection connection = null;

    String id = request.getParameter(“id”);
    try {

    connection =  (Connection) ConnectionFactory.getConnection( );
     HashMap<String, Integer> parameterMap = 
     	new HashMap<String, Integer>( );
    

    //o Nome do parâmetro e o valor é passado ao HashMap
    parameterMap.put(“ID”, Integer.parseInt(id));

    // envia o relatório em formato PDF para o browser
       response.setContentType("application/pdf");
       //para gerar o relatório em PDF
       // o método runReportToPdfStream foi usado
    

    // JasperRunManager.runReportToPdfStream(reportStream,
    // servletOutputStream, parameterMap,connection)
    ;

    }
    
    catch (Exception ex) {
    
    Logger.getLogger(Relatorio.class.getName()).log(Level.SEVERE, null, ex);
    
    }
    
    finally{
    
    servletOutputStream.flush();
    
    servletOutputStream.close();
    
    try {
    
    ConnectionFactory.closeConnection(connection);
         } catch (Exception ex) {
             Logger.getLogger(Relatorio.class.getName()).log(Level.SEVERE, null, ex);
         }
    

    }

    }

    //
    /**

    • Handles the HTTP GET method.
    • @param request servlet request
    • @param response servlet response
      */
      protected void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
      processRequest(request, response);
      }

    /**

    • Handles the HTTP POST method.
    • @param request servlet request
    • @param response servlet response
      */
      protected void doPost(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
      processRequest(request, response);
      }

    /**

    • Returns a short description of the servlet.
      */
      public String getServletInfo() {
      return “Short description”;
      }
      //
      }
Criado 28 de fevereiro de 2014
Respostas 0
Participantes 1