package com.mandi.common;
|
|
import java.io.File;
|
import java.io.IOException;
|
import java.io.OutputStream;
|
import java.io.UnsupportedEncodingException;
|
import java.net.URLEncoder;
|
import java.sql.Connection;
|
import java.sql.SQLException;
|
import java.util.HashMap;
|
import java.util.Map;
|
import java.util.Map.Entry;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import javax.sql.DataSource;
|
|
import org.apache.log4j.Logger;
|
|
import net.sf.jasperreports.engine.JRException;
|
import net.sf.jasperreports.engine.JasperFillManager;
|
import net.sf.jasperreports.engine.JasperPrint;
|
import net.sf.jasperreports.engine.JasperReport;
|
import net.sf.jasperreports.engine.JasperRunManager;
|
import net.sf.jasperreports.engine.export.JRPdfExporter;
|
import net.sf.jasperreports.engine.util.JRLoader;
|
import net.sf.jasperreports.export.SimpleExporterInput;
|
import net.sf.jasperreports.export.SimpleOutputStreamExporterOutput;
|
|
/**
|
* @author mengly
|
* @version 创建时间：2015年10月6日 下午7:00:56
|
* 类说明
|
*/
|
|
public class JasperMethod {
|
private static Logger log=Logger.getLogger(JasperMethod.class);
|
public static void writepdfbypost(HttpServletRequest request,HttpServletResponse response,String path,DataSource ds)
|
{
|
String jaspername=RequestParam.getString(request, "jaspername");
|
if(jaspername==null)
|
return;
|
jaspername=path+jaspername+".jasper";
|
Map<String, String[]> params=request.getParameterMap();
|
Map<String, Object> jasperparams=new HashMap<String, Object>();
|
if(request.getAttribute("jasperparams")!=null)
|
jasperparams=(Map<String, Object>)request.getAttribute("jasperparams");
|
for (Entry<String, String[]> entry : params.entrySet()) {
|
String key=entry.getKey();
|
String[] values=entry.getValue();
|
if(key.startsWith("jasper_")&&key.length()>7&&values.length>0)
|
{
|
String param=key.substring(7);
|
String value=values[0];
|
jasperparams.put(param, value);
|
}
|
}
|
String filepath=request.getSession(true).getServletContext().getRealPath(jaspername);
|
File file=new File(filepath);
|
if(!file.exists())
|
{
|
log.info("file not exist");
|
}
|
log.info(file.getPath());
|
Connection con=null;
|
OutputStream out=null;
|
try {
|
JasperReport report=(JasperReport) JRLoader.loadObject(file);
|
con=ds.getConnection();
|
JasperPrint print=JasperFillManager.fillReport(report, jasperparams, con);
|
JRPdfExporter exporter=new JRPdfExporter();
|
exporter.setExporterInput(new SimpleExporterInput(print));
|
out= response.getOutputStream();
|
exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(out));
|
String displayname="已经生产pdf报表.jasper";
|
displayname=URLEncoder.encode(displayname,"utf-8");
|
response.setHeader("Content-Disposition", "attachment; filename=\""+displayname+"\"");
|
response.setCharacterEncoding("utf-8");
|
response.setContentType("application/pdf");
|
exporter.exportReport();
|
out.flush();
|
out.close();
|
} catch (JRException e) {
|
e.printStackTrace();
|
} catch (UnsupportedEncodingException e) {
|
e.printStackTrace();
|
} catch (IOException e) {
|
e.printStackTrace();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}finally{
|
if(con!=null)
|
try {
|
con.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
|
public static void writepdfbyfile(Map<String,Object> param,File f,HttpServletResponse response,DataSource ds)
|
{
|
Connection con=null;
|
try {
|
//JasperReport report=(JasperReport) JRLoader.loadObject(f);
|
con=ds.getConnection();
|
OutputStream out=response.getOutputStream();
|
byte[] bytes = JasperRunManager.runReportToPdf(f.getPath(), param, con);
|
response.setContentType("application/pdf");
|
response.setContentLength(bytes.length);
|
String displayname=System.currentTimeMillis()+".pdf";
|
displayname=URLEncoder.encode(displayname,"utf-8");
|
response.setHeader("Content-Disposition", "inline; filename=\""+displayname+"\"");
|
response.setCharacterEncoding("utf-8");
|
response.setContentType("application/pdf");
|
out.write(bytes, 0, bytes.length);
|
out.flush();
|
out.close();
|
} catch (JRException e1) {
|
e1.printStackTrace();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}finally{
|
if(con!=null)
|
try {
|
con.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
}
|
