一个简略的ireport报表（用spring的servlet）

一个简单的ireport报表（用spring的servlet）
1.在web.xml中配置springMVC的servlet

3.配置views.properties，内容如下：
public class JasperSpringController implements Controller{public ModelAndView handleRequest(HttpServletRequest arg0,HttpServletResponse arg1) throws Exception {String viewName = "testReportByPdf";Map param = new HashMap();List<TestModel> dataList = this.getData();JRDataSource dataset = new JRBeanCollectionDataSource(dataList);param.put("dataset", dataset);return new ModelAndView(viewName,param);}/** * 连数据库取数据 * @author yj * @return */private List<TestModel> getData() {List<TestModel> dataList = new ArrayList<TestModel>();Connection conn = null;Statement sta = null;ResultSet rs = null;try{Context context = new InitialContext();DataSource ds = (DataSource) context.lookup("java:/comp/env/MyDb");conn = ds.getConnection();sta = conn.createStatement();rs = sta.executeQuery("select * from a");while(rs.next()){TestModel tm = new TestModel();tm.setId(rs.getLong("id"));tm.setName(rs.getString("name"));tm.setType(rs.getString("type"));tm.setTotal(rs.getLong("total"));dataList.add(tm);}}catch(Exception e){e.printStackTrace();}finally{try{if(conn!=null){conn.close();conn = null;}if(sta != null){sta.close();sta = null;}if(rs != null){rs.close();rs = null;}}catch(SQLException se){se.printStackTrace();}}return dataList;}}


5.使用的jar包如下：
activation.jar
commons-collections-3.1.jar
jasperreports-3.7.0.jar
jasperreports-fonts-3.7.0.jar
jfreechart-1.0.12.jar
log4j-1.2.15.jar
ojdbc14.jar
spring.jar
commons-beanutils-1.8.0.jar
commons-digester-1.8.jar
spring-webmvc.jar
groovy-all-1.5.5.jar
iText-2.1.0.jar
iTextAsian.jar
iTextAsianCmaps.jar    1 楼    sjxinrui    2012-03-29              这位大哥，有木有不用servlet的。。