Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.mycompany.reports;
- import com.mycompany.sample6.CityVO;
- import com.mycompany.sample6.Mapping;
- import java.io.File;
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.io.StringWriter;
- import java.util.ArrayList;
- import java.util.HashMap;
- import java.util.List;
- import javax.servlet.ServletException;
- import javax.servlet.ServletOutputStream;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import net.sf.jasperreports.engine.JRExporterParameter;
- import net.sf.jasperreports.engine.JasperFillManager;
- import net.sf.jasperreports.engine.JasperPrint;
- import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
- import net.sf.jasperreports.engine.export.JRPdfExporter;
- import net.sf.jasperreports.engine.type.OrientationEnum;
- @WebServlet(name = "GetReport", urlPatterns = {"/GetReport"})
- public class GetReport extends HttpServlet {
- protected void processRequest(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("application/pdf");
- ServletOutputStream servletOutputStream = response.getOutputStream();
- HttpSession session = request.getSession(false);
- File reportFile = null;
- HashMap<String, Object> parameterMap = new HashMap<String, Object>();
- reportFile= new File("D:/zia/report1.jasper");
- try {
- List<CityVO> cityList=(List<CityVO>)session.getAttribute("cityListReport");
- JRBeanCollectionDataSource dataSource = new JRBeanCollectionDataSource(cityList);
- JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile.getPath(),parameterMap,dataSource);
- jasperPrint.setOrientation(OrientationEnum.PORTRAIT);
- final JRPdfExporter pdfExporter = new JRPdfExporter();
- pdfExporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, "UTF-8");
- pdfExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
- pdfExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, servletOutputStream);
- pdfExporter.exportReport();
- } catch (Exception e) {
- StringWriter stringWriter = new StringWriter();
- PrintWriter printWriter = new PrintWriter(stringWriter);
- e.printStackTrace(printWriter);
- response.setContentType("text/plain");
- response.getOutputStream().print(stringWriter.toString());
- }finally{
- servletOutputStream.flush();
- servletOutputStream.close();
- }
- }
- @Override
- protected void doGet(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- processRequest(request, response);
- }
- @Override
- protected void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- processRequest(request, response);
- }
- @Override
- public String getServletInfo() {
- return "Short description";
- }// </editor-fold>
- }
- public String getCityList() {
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "mtxymn", "ys$mtx_2010#xtm1sys");
- pstmt = conn.prepareStatement("Select * from gen_cities");
- cityList = new ArrayList<CityVO>();
- ResultSet rset = pstmt.executeQuery();
- while (rset.next()) {
- CityVO city = new CityVO();
- city.setCityAdes(rset.getString("CITY_ADES"));
- city.setCityEdes(rset.getString("CITY_EDES"));
- city.setCityNo(rset.getInt("CITY_NO"));
- city.setCitySer(rset.getInt("CITY_SER"));
- city.setCntryNo(rset.getString("CNTRY_NO"));
- cityList.add(city);
- }
- if (cityList != null && cityList.size() > 0) {
- JSFUtils.storeOnSession("cityListReport", cityList);
- } else {
- JSFUtils.addFacesErrorMessage(JSFUtils.getStringFromBundle("CANNOT_FIND_DATA"));
- }
- } catch (SQLException | ClassNotFoundException ex) {
- Logger.getLogger(Mapping.class.getName()).log(Level.SEVERE, null, ex);
- }
- return null;
- }
- <script type="text/javascript">
- function poponload()
- {
- var link = window.location.protocol + "//" + window.location.host + "/" + "sample6" + "/" + "sec" + "/" + "GetReport.pdf";
- testwindow = window.open(link, "mywindow", "location=1,status=1,scrollbars=1,width=800,height=500");
- testwindow.moveTo(50, 50);
- }
- </script>
- <p:commandButton id="showReport" value="show Report" actionListener="#{mapping.cityList}" icon="ui-icon-print" iconPos="right" immediate="true" ajax="true" oncomplete="poponload()" />
- 18-Feb-2016 09:42:47.383 SEVERE [http-nio-9999-exec-22] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [GetReport] in context with path [/sample6] threw exception [Servlet execution threw an exception] with root cause
- java.lang.NoSuchMethodError: com.mycompany.sample6.Mapping.getCityList()Ljava/util/ArrayList;
- 18-Feb-2016 12:19:55.697 SEVERE [http-nio-9999-exec-13] com.sun.faces.context.AjaxExceptionHandlerImpl.handlePartialResponseError javax.el.MethodNotFoundException: Method not found: com.mycompany.sample6.Mapping@162e4f8f.cityList()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement