<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="net.sf.jasperreports.engine.design.*" %>
<%@ page import="net.sf.jasperreports.engine.data.*"%>
<%@ page import="net.sf.jasperreports.engine.export.*"%>
<%@ page import="net.sf.jasperreports.engine.util.*"%>
<%@ page import="net.sf.jasperreports.view.*"%>
<%@ page import="net.sf.jasperreports.view.save.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%
// System.out.println("Comienza el Reporte----------------------------");
%>
<%
try{
ResultSet rs = null;
Statement st = null;
String sql = null;
String driver = "com.mysql.jdbc.Driver";
String connectString = "jdbc:mysql://localhost/mybase";
String user = "root";
String password = "";
Class.forName(driver);
Connection conn = DriverManager.getConnection(connectString, user, password);
/////////////////////////////////////////////
//System.out.println("********Compilamos pago_nomina.jrxml OK********");
System.setProperty(
"jasper.reports.compile.class.path",
application.getRealPath("/WEB-INF/lib/jasperreports-1.2.5.jar") +
System.getProperty("path.separator") +
application.getRealPath("/WEB-INF/classes/")
);
//System.out.println("*****Cargamos el jasperreports-x.x.x.jar OK*********");
System.setProperty(
"jasper.reports.compile.temp",
application.getRealPath("/jsps/")
);
JasperCompileManager.compileReportToFile(applicati on.getRealPath("/jsps/ejemplo2.jrxml"));
//System.out.println("******Fin de la Compilamos el archivos***********");
/////////////////////////////////////////////
File reportFile = new File(application.getRealPath("/jsps/ejemplo2.jasper"));
Map parameters = new HashMap();
byte[] bytes =
JasperRunManager.runReportToPdf(
reportFile.getPath(),
parameters,
conn
);
response.setHeader("Content-Type","application/pdf");
response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();
// System.out.println("jasperPDF OK..............");
///////////////////////////////////////////////////////////////
//System.out.println("Fin del reporte pago_reporte_nomina.............");
}catch (JRException e)
{System.out.println("Error:" +e.getMessage());}
catch (Exception e)
{
e.printStackTrace();
System.out.println("Error2:" +e.getMessage());
}
%>





Mode Lineal
