quer q ele descubra na bolinha mágica oque quer q apareça? LOL
mandar sómente a conn nao resolve…
mande o query ou collection ou seja la oque for que tenha os dados do relatorio…
A
aline_silva
importcontroller.ControllerInterface;importjava.io.IOException;importjava.io.PrintWriter;importjava.sql.Connection;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjava.util.*;importjava.util.logging.Level;importjava.util.logging.Logger;importmodel.dao.ConnectionManager;importnet.sf.jasperreports.engine.JRException;importnet.sf.jasperreports.engine.JasperExportManager;importnet.sf.jasperreports.engine.JasperManager;importnet.sf.jasperreports.engine.JasperPrint;importnet.sf.jasperreports.engine.JasperReport;publicclassImprimirSolicitacaoimplementsControllerInterface{publicStringgerarPDF(HttpServletRequestrequest,HttpServletResponseresponse){Connectioncon=ConnectionManager.getConexao();Connectioncon2=ConnectionManager.getConexaoAdm();PrintWriterout=null;Stringcaminho="Financeiro/Solicitacao/PDF/";Stringquery="SELECT c.CodSolicitacao,c.Ano,CONVERT(CHAR, c.Data, 103) AS Data,"+"FROM SolicitacaoCompra c ";HashMapparametros=newHashMap();parametros.put("SQL",query);parametros.put("conexao",con2);parametros.put("SUBREPORT_DIR",caminho);try{out=response.getWriter();JasperReportjasperReport=JasperManager.loadReport(request.getServletContext().getRealPath(caminho+"SolicitacaoCompra.jasper"));JasperPrintjasperPrint=JasperManager.fillReport(jasperReport,parametros,con);JasperExportManager.exportReportToPdfFile(jasperPrint,request.getServletContext().getRealPath(caminho+"SolicitacaoCompra.pdf"));out.println(request.getServletContext().getRealPath(caminho+"SolicitacaoCompra.jasper"));}catch(IOExceptionex){Logger.getLogger(ImprimirSolicitacao.class.getName()).log(Level.SEVERE,null,ex);}catch(JRExceptionex){Logger.getLogger(ImprimirSolicitacao.class.getName()).log(Level.SEVERE,null,ex);}finally{out.close();}returncaminho+"SolicitacaoCompra.pdf";}publicStringcall(HttpServletRequestrequest,HttpServletResponseresponse){returngerarPDF(request,response);}}