jasper java_jasperReports 通过java导出各种格式报表，及javaweb项目整合显示各种报表...

注意：编写此项目时，请先手动编写**.jrxml或者用IReport生成**.jrxml或**.jasper

注：java导出报表与web项目显示报表方法其实是相同的，只不过有一句代码不同,如下

html.setParameter(JRHtmlExporterParameter.OUTPUT_FILE_NAME,"C:/Users/Administrator/Desktop/ireport/report1.html");//生成文件

//html.setParameter(JRHtmlExporterParameter.OUTPUT_WRITER,response.getWriter()); // web页面显示

maven依赖

net.sf.jasperreports

jasperreports

5.6.0

org.codehaus.groovy

groovy-all

2.2.2

通过java代码生成各种格式报表文件

JDBC文件

package com.hlzt.test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class JDBC{

public static String driver="com.mysql.jdbc.Driver";

public static String url="jdbc:mysql://localhost:3306/senyuan1";

public static String user="root";

public static String pwd="123456";

public static Connection conn=getConnection();

public static Statement statement=getStatement();

private static Connection getConnection(){

if(conn==null){

try{

Class.forName(driver);

conn=DriverManager.getConnection(url,user,pwd);

}catch(Exception e){

e.printStackTrace();

}

}

return conn;

}

private static Statement getStatement(){

if(statement==null){

try{

statement=conn.createStatement();

}catch(Exception e){

e.printStackTrace();

}

}

return statement;

}

public static ResultSet getResultSet(String sql){

ResultSet rs=null;

try{

rs=statement.executeQuery(sql);

}catch(Exception e){

e.printStackTrace();

}

return rs;

}

public static void closeAll(ResultSet rs,Statement st,Connection cn){

try{

if(rs!=null){

rs.close();

}

if(st!=null){

st.close();

}

if(cn!=null){

cn.close();

}

}catch(Exception e){

e.printStackTrace();

}

}

}

生成 各种格式

package com.hlzt.test;

import java.io.File;

import java.io.IOException;

import java.io.InputStream;

import java.util.HashMap;

import java.util.Map;

import javax.servlet.ServletContext;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import net.sf.jasperreports.engine.JRExporterParameter;

import net.sf.jasperreports.engine.JasperCompileManager;

import net.sf.jasperreports.engine.JasperFi