Por favor, estou com dificuldade em gerar meu relatório. Fiz teste usando códigos de diferentes tutoriais e não consegui sucesso. Segue abaixo o codigo da classe e a chamada jsp:
classe EmiteRel
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import java.sql.DriverManager;
import net.sf.jasperreports.engine.JasperPrint;
public class EmiteRel extends HttpServlet {
private static final long serialVersionUID = 42203657584556370L;
@SuppressWarnings("unchecked")
@Override
protected void service(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
Connection con=null;
try {
con = getConnection();
} catch (SQLException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} catch (ClassNotFoundException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
String pathJasper = getServletContext().getRealPath("/WEB-INF/classes/") + "/";
String pathImages = getServletContext().getRealPath("/WEB-INF/classes/") + "/";
String path = getServletContext().getRealPath("/");
Map parametros = new HashMap();
try {
JasperPrint impressao = JasperFillManager.fillReport(pathJasper +
"/RelatorioUsuario.jasper", parametros, con);
JasperExportManager.exportReportToPdfFile(impressao,
path + "/WEB-INF/classes/RelatorioUsuario.pdf");
res.sendRedirect("RelatorioUsuario.pdf");
} catch (Exception e) {
res.getWriter().println("Erro ao gerar o relatorio: " + e);
}
}
private Connection getConnection() throws ClassNotFoundException,SQLException{
String url="jdbc:mysql://localhost/isfv";
Class.forName("com.mysql.jdbc.Driver");
return DriverManager.getConnection(url,"root","admin");
}
}
.jsp
<%@ taglib uri="/WEB-INF/lib/mentawai.jar" prefix=“mtw” %>
mtw:requiresAuthentication/
<%@page contentType=“text/html” pageEncoding=“UTF-8”%>
<jsp:useBean id=“emiterel” scope=“session” class=“com.clau.jsp.EmiteRel”/>
JSP Pageweb.xml
RelatorioServlet
com.clau.jsp.EmiteRel