JasperReport的使用

最近工作中用到报表，而我在学习JasperReport的过程中遇到了很多问题（主要是国内的资料太少了），网上很少找得到，在此我就把我找到的一些资料和大家共享，希望能对大家有所帮助。
1、JasperReport和iReport的资源，最新版本可以到下面官方网站得到

iReport官方网站：
http://ireport.sourceforge.net
　　　　　JasperReport官方网站：
http://jasperreports.sourceforge.net

2、安装
　　　1）、JDK的安装，并配置JAVA_HOME
比如我的JAVA_HOME路径如下：
JAVA_HOME　　D:\Program Files\j2sdk1.4.2_03

2）、由于中文的问题，所以还需要下载：itext-1.02b.jar和iTextAsian.jar包
下载地址：http://itext.sourceforge.net/downloads/iTextAsian.jar
并在CLASSPATH中设置
　　　　　 例如我的CLASSPATH如下：
CLASSPATH
E:\Program Files\Apache Group\Tomcat4.1\webapps\testreport\WEB-INF\lib\itext-1.02b.jar;E:\Program

Files\Apache Group\Tomcat 4.1\webapps\testreport\WEB-INF\lib\iTextAsian.jar;E:\Program Files\Apache

Group\Tomcat 4.1\webapps\testreport\WEB-INF\lib;D:\tools\iReport0.2.3\lib

　　　3）、iReport的安装iReport只要解压就OK，如果没有安装Ant，可以直接在iReport下的noAnt目录下，
运行startup.bat就可以了，这样iReport就可以启动了

4）、JasperReport
Jasperreport不需要任何配置，你只需将下载以后的jar包放到classpath下即可
5）、数据库的JDBC驱动包
加入到CLASSPATH中

3、详细资源
iReport官方提供了一些关于iReport视频，对于初学者很有帮助：
　　　地址：http://ireport.sourceforge.net/docs.html

JasperReport官方提供的使用指南
地址：http://jasperreports.sourceforge.net/tutorial/index.html

JasperReport提供的一些例子：
地址：http://jasperreports.sourceforge.net/samples/index.html

4、常见问题
1）、iReport中提示框输入中文是不能正常显示，请将iReport下lib中的这个包删除tinylaf.jar
　　 2）、在iReport中运行报表时如果出现乱码问题，请检查itext-1.02b.jar和iTextAsian.jar这两个包是否加到CLASSPATH
3）、在jsp或servlet高度报表时出现乱码或不显示，请检查你在报表设计过程中所设置的字体及其编码
比如：pdfname、pdfencoding
5、下面是两个调试例子
　　Servlet:
import javax.servlet.*;
import javax.servlet.http.*;
import dori.jasper.engine.*;
import java.io.*;
import java.util.*;
import java.sql.*;

/**
* @author Administrator
*
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class TestReport extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null;

try {

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn =
DriverManager.getConnection(


"jdbc:microsoft:sqlserver://192.168.0.10:1433;DatabaseName=am;user=sa;password=sa");

ServletContext servletContext =this.getServletContext();
File reportFile = new File(servletContext.getRealPath("test/iteminfo.jasper"));
Map parameters = new HashMap();
Integer i=new Integer(8);
parameters.put("pjId", i);
byte[] bytes =
JasperRunManager.runReportToPdf(
reportFile.getPath(),
parameters,
conn);
response.setContentType("application/pdf");
response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();
} catch (JRException jre) {
System.out.println("JRException:" + jre.getMessage());
} catch (Exception e) {
System.out.println("Exception:" + e.getMessage());
}

}

public void doPost(
HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {

doGet(request, response);

}

} 

jsp写法如下：

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="dori.jasper.engine.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.zx.report.util.CarUse"%>
<%@ page import="dori.jasper.engine.data.*" %>

<%
Connection conn = null;
Statement st = null;
ResultSet rs = null;
byte[] bytes = null;
List carUseList=new ArrayList();

try{

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn =DriverManager.getConnection("jdbc:microsoft:sqlserver://10.10.10.207:1433;DatabaseName=report;user=sa;password=111111");

//以输入流方式
   InputStream reportFile = getClass().getClassLoader().getResourceAsStream("carUserBd.jasper");

//以reportFile方式
//File reportFile =new File(request.getRealPath("/report/carUserBd.jasper"));

Map parameters = new HashMap();

String sqlCarUser="SELECT car.carNo, dept.Name , people.peopleName,carUse.useDescription ," +
" carUse.beginTime , carUse.planEndTime , carUse.comment , carUse.driver," +
" carUse.peopleNumber ,OneWay= case carUse.isOneWay  when 0 then '双程'  else '单程'  end, " +
"isFirst= case carUse.priority when 0  then '低' when  1  then  '中'  else  '高'  end, carUse.start , " +
"carUse.destination , people.peopleName as ratifier FROM DEPT_CARUSELOG carUse , DEPT_CARINFO car , " +
"ADMIN_ORGANIZATION dept , PUBLIC_PEOPLEINFO people WHERE carUse.id=290 and " +
"caruse.carId=car.carId and carUse.departId=dept.id and carUse.peopleId=people.peopleId";

st = conn.createStatement();
rs = st.executeQuery(sqlCarUser);

while(rs.next()){
CarUse carUse=new CarUse();
carUse.setCarNo(rs.getString(1));
carUse.setName(rs.getString(2));
carUse.setPeopleName(rs.getString(3));
carUse.setUseDescription(rs.getString(4));
carUse.setBeginTime(rs.getDate(5));
carUse.setPlanEndTime(rs.getDate(6));
carUse.setComment(rs.getString(7));
carUse.setDriver(rs.getString(8));
carUse.setPeopleNumber(rs.getString(9));
carUse.setOneWay(rs.getString(10));
carUse.setIsFirst(rs.getString(11));
carUse.setStart(rs.getString(12));
carUse.setDestination(rs.getString(13));
carUse.setRatifier(rs.getString(14));

carUseList.add(carUse);

}

JRBeanCollectionDataSource ds = new JRBeanCollectionDataSource(carUseList);

bytes =
JasperRunManager.runReportToPdf(
reportFile,
parameters,
ds);
String fileName = "test.pdf";
response.setContentType("application/pdf");
response.addHeader(
"Content-Disposition",
"attachment;filename=\"" + fileName);

response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();

System.out.println("5");
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();

} catch (SQLException sqle) {

System.out.println("SQLException:" + sqle.getMessage());

} catch (JRException e) {
e.printStackTrace();
}catch(ClassNotFoundException cnfe){

}

%>
jasperreport可以用Collection做为数据源，这种方式比用Connection方式更为灵活方便。