****************************处理打印的JSP*************************************
<%@ page contentType=\%> <%@ page import=\%> <%@ page import=\%> <%@ page import=\%> <%@ page import=\%> <%@ page import=\%> <%@ page import =\%> <%@ page import=\%> <%@ page import=\%> <%@ page import=\%> <%@ page import=\%>
<%@ page import =\%> <%@ page import= \%> <% com.paiao.app.db.DbBase dbbase = com.paiao.app.db.DbBase.getInstance();
String type=request.getParameter(\); String bdzid = request.getParameter(\); String filepath=request.getParameter(\); String sbrq=request.getParameter(\); String jzrq=request.getParameter(\); String jlflbh=request.getParameter(\); com.paiao.bdpm.system.Reportjiexiguize bean=new com.paiao.bdpm.system.Reportjiexiguize(); String
bdzname=com.paiao.app.util.Encoding.encodingUnicode(String.valueOf(reque
st.getParameter(\)));
com.paiao.app.util.Base base=new com.paiao.app.util.Base(); // Class.forName(\ Connection con=null; try{
con =dbbase.getConnection();
// DriverManager.getConnection(url,\ File reportFile = new
File(application.getRealPath(\+filepath)); Map parameters = new HashMap();
com.paiao.bdpm.runrecord.ReturnSql sql1=new com.paiao.bdpm.runrecord.ReturnSql(); String ss1=\,pdfname=\;
if(filepath.equals(\)) {
sql1.Addsql(bdzid,sbrq); ss1= sql1.GetjidianSql(); pdfname=\;
}else if(filepath.equals(\)) {
sql1.Addsql(bdzid,sbrq); ss1=sql1.GetyuanyouSql(); pdfname=\;
}else if(filepath.equals(\)) {
sql1.Addsql(bdzid,sbrq); ss1=sql1.GetbenyueSql(); pdfname=\;
}else if(filepath.equals(\)) {
sql1.Addsql(bdzid,sbrq); ss1=sql1.GetxinfaxianSql(); pdfname=\;
}else if(filepath.equals(\)) {
sql1.Addsql(bdzid,sbrq); ss1=sql1.GetzhanyongSql(); pdfname=\;
}else if(filepath.equals(\)) {
sql1.Addsql(bdzid,sbrq);
Calendar cal=Calendar.getInstance(); cal.setTime(base.stringToDate(sbrq)); cal.add(Calendar.DATE,+1);
jzrq= new SimpleDateFormat(\).format(cal.getTime()); ss1=sql1.GetzhibanjiluSql()+jzrq+\; parameters.put(\,sbrq+\); parameters.put(\,jzrq+\); parameters.put(\,bdzname); pdfname=\;
}else if(filepath.equals(\)) {
sql1.Addsql(bdzid,sbrq);
// Calendar cal=Calendar.getInstance(); // cal.setTime(base.stringToDate(sbrq)); // cal.add(Calendar.DATE,+1);
// jzrq= new SimpleDateFormat(\ ss1=sql1.GetweihujiluSql();//+jzrq+\ parameters.put(\,sbrq); // parameters.put(\ parameters.put(\,bdzname); pdfname=\;
}else if(filepath.equals(\)) { String
reportsql=com.paiao.app.util.Encoding.encodingUnicode(request.getParameter(\));
ss1=sql1.GetsbqxjlSql(reportsql); pdfname=\;
}else if(filepath.equals(\)) {
String keyid = request.getParameter(\); ss1=sql1.GetsbjxsyjlSql(keyid); pdfname=\;
}else if(filepath.equals(\)) {
if(!(type==null) && type.equals(\)) {
String reportsql=request.getParameter(\); ss1=sql1.Gettongji110kvSql(reportsql); }else{
String reportsql=request.getParameter(\); ss1=sql1.Get110kvSql(reportsql); }
pdfname=\;
}else if(filepath.equals(\)) {
if(!(type==null) && type.equals(\))
{ String
reportsql=com.paiao.app.util.Encoding.encodingUnicode(request.getParameter(\));
ss1=sql1.Gettongji6_10kvSql(reportsql); }else{ String
reportsql=com.paiao.app.util.Encoding.encodingUnicode(request.getParameter(\));
ss1=sql1.Get6_10kvSql(reportsql); }
pdfname=\;
}else if(filepath.equals(bean.getEnglishname(jlflbh)+\)) { String
reportsql=com.paiao.app.util.Encoding.encodingUnicode(request.getParameter(\));
ss1=sql1.Getautomaketablesql(reportsql,jlflbh); String titlename=bean.getTitlename(jlflbh);
if(!reportFile.exists() && !bean.getEnglishname(jlflbh).equals(\)) {
System.setProperty(
System.setProperty( }
parameters.put(\,titlename); pdfname=bean.getEnglishname(jlflbh); }
parameters.put(\,ss1); JasperPrint jasperPrint =
JasperFillManager.fillReport(reportFile.getPath(), parameters, con); JRExporter exporter = null;
String exportTo =\;//request.getParameter(\ if(\.equals(exportTo)) {
\, application.getRealPath(\) );
\,
application.getRealPath(\) + System.getProperty(\) + application.getRealPath(\) );
com.paiao.bdpm.system.NoXmlDesignApp.run(reportFile.getPath(),jlflbh);
exporter = new JRHtmlExporter();
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE); }
else if(\.equals(exportTo))//PDF方式打印 {
exporter = new JRPdfExporter();
response.setContentType(\);
response.setHeader(\,\filename=\+pdfname+\); }
else if(\.equals(exportTo)) {
// exporter = new JRXlsExporter();
response.setContentType(\);
}else if(\.equals(exportTo)) {
//exporter =new JRRtfExporter();
response.setContentType(\);
response.setHeader(\,\filename=\+jasperPrint.getName()+\);
}
else if(\.equals(exportTo)){ response.reset();
// exporter = new JRXlsExporter();
response.setContentType(\); response.setHeader(\,\filename=\+pdfname+\); }
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, \);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream()); exporter.exportReport();
}catch(Exception e){ e.printStackTrace(); }finally{
dbbase.freeconnection(con); }