exportallaction.java

iReport源码,下载就可运行,结合struts和ibatis的使用

package com.hgs.iReportTest.Action;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.text.DateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperRunManager;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class exportAllAction extends Action {
	public ActionForward execute(
	        ActionMapping mapping,
	        ActionForm form,
	        HttpServletRequest request,
	        HttpServletResponse response) throws SQLException, JRException, IOException  {
		
		Connection conn = null;
		ServletOutputStream ouputStream=null;
		try {
			//get connect url for database
			Class.forName("org.gjt.mm.mysql.Driver");
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/newtest?username=;password=");
			//get .jasper file 
			File reportFile = new File("E:/work/ireportTest/allUserExport.jasper");
			//define parameter
			Map parameters = new HashMap();
			Date now =new Date();
			DateFormat d = DateFormat.getDateInstance(); 
			String datenaw= d.format(now);
			//"date" is a parameter that in the report file
			parameters.put("date",datenaw);
			//output pdf by bytes
			byte[] bytes=JasperRunManager.runReportToPdf(reportFile.getPath(),parameters,conn);
			//open pdf on the ie
			response.setContentType("application/pdf");
			response.setContentLength(bytes.length);
			//out file 
			ouputStream = response.getOutputStream();
			ouputStream.write(bytes, 0, bytes.length);
			ouputStream.flush();
			ouputStream.close();
		} catch (ClassNotFoundException e) {
			ouputStream.close();
			e.printStackTrace();
		}
		
		return mapping.findForward("success");
	}
}