Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void getReporte2(String ruta, String op) throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException {
- Connection conexion;
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- conexion = DriverManager.getConnection("jdbc:mysql://localhost:3306/basedatos", "usuario", "contrasenia");
- String path = JSFUtil.getPath() + "/resources/images/membrete.png";
- //Se definen los parametros si es que el reporte necesita
- Map parameter = new HashMap();
- parameter.put("operador", op);
- parameter.put("P_RUTAIMAGEN", path);
- try {
- File file = new File(ruta);
- HttpServletResponse httpServletResponse = (HttpServletResponse) FacesContext.getCurrentInstance().getExternalContext().getResponse();
- httpServletResponse.setContentType("application/pdf");
- httpServletResponse.addHeader("Content-Type", "application/pdf");
- JasperReport jasperReport = (JasperReport) JRLoader.loadObjectFromFile(file.getPath());
- JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameter, conexion);
- JRExporter jrExporter = null;
- jrExporter = new JRPdfExporter();
- jrExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
- jrExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, httpServletResponse.getOutputStream());
- if (jrExporter != null) {
- try {
- jrExporter.exportReport();
- } catch (JRException e) {
- e.printStackTrace();
- }
- }
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- if (conexion != null) {
- try {
- conexion.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
- }
- public void verReporte2(String ape) throws SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException {
- reporteDetalle rDetalle = new reporteDetalle();
- FacesContext facesContext = FacesContext.getCurrentInstance();
- ServletContext servletContext = (ServletContext) facesContext.getExternalContext().getContext();
- String ruta = servletContext.getRealPath("/resources/reportes/deudaXalumno.jasper");
- //le pasamos los paramtros al reporte
- rDetalle.getReporte2(ruta, ape);
- //rCliente.getReporte(ruta);
- FacesContext.getCurrentInstance().responseComplete();
- }
- <p:menuitem value="Listado de Alumnos con deudas" actionListener="#{alumnoDataController.verReporte2(loginBean.toString())}" icon="ui-icon-close" ajax="false"/>
Add Comment
Please, Sign In to add comment