jasperreport使用list输出
http://www.blogjava.net/pdw2009/archive/2007/11/01/157570.html
jasperreport中可以使用List作为数据源,使用格式如下.
得填充数据后,即可输出显示到PDF,Excel,Html
到PDF:
到Html:
public byte[] generateHtml(String begCustNo, String endCustNo,
到Excel:
jsp调用方法:
======================================
servlet 输出
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
Java代码 public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Connection conn=null; try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1481;DatabaseName=pdw","sa","123456"); ServletContext servletContext=this.getServletContext(); Map parameters=new HashMap(); parameters.put("vname","裴德万"); File reportfile=new File(servletContext.getRealPath("/classes.jasper")); System.out.println(reportfile.getPath()); byte[] bytes=JasperRunManager.runReportToPdf(reportfile.getPath(),parameters,conn); response.setContentType("application/pdf"); response.setContentLength(bytes.length); ServletOutputStream outputStream=response.getOutputStream(); outputStream.write(bytes,0,bytes.length); outputStream.flush(); outputStream.close(); }catch(Exception e){ e.printStackTrace(); } } |