正在装载数据…… ScriptX HTML打印控件 dullhunter @ 2007-07-03 09:41 | JAVA ScriptX HTML打印控件 配合ireport报表 view plaincopy to clipboardprint? - <%@ page language="java" contentType="text/html;charset=GBK"%>
- <%@ page import="net.sf.jasperreports.engine.JasperFillManager"%>
- <%@ page import="com.frameworkset.common.poolman.PreparedDBUtil"%>
- <%@ page import="com.frameworkset.common.poolman.util.SQLResult"%>
- <%@ page import="net.sf.jasperreports.engine.JasperPrint"%>
- <%@ page import="net.sf.jasperreports.engine.JRExporter"%>
- <%@ page import="net.sf.jasperreports.engine.export.JRHtmlExporter"%>
- <%@ page import="net.sf.jasperreports.engine.export.JRHtmlExporterParameter"%>
- <%@ page import="net.sf.jasperreports.engine.JRExporterParameter"%>
- <%@ page import="java.util.*"%>
- <%@ page import="java.sql.*"%>
- <%@ page import="java.net.*"%>
- <%@ page import="java.io.*"%>
- <%@ page import="com.chinacreator.shoa.common.OAUtil"%>
-
-
-
- <script defer="defer">
- function window.onload() {
-
- factory.printing.SetMarginMeasure(2);
-
- factory.printing.paperSize = "A4";
- factory.printing.paperSource = "Manual feed";
- factory.printing.collate = true;
- factory.printing.copies = 1;
- factory.printing.SetPageRange(false, 1, 1);
-
-
- factory.printing.header = "This is MeadCo";
- factory.printing.font = "宋体";
- factory.printing.footer = "Advanced Printing by ScriptX";
- factory.printing.portrait = false;
- factory.printing.leftMargin = 1.0;
- factory.printing.topMargin = 1.0;
- factory.printing.rightMargin = 1.0;
- factory.printing.bottomMargin = 1.0;
- }
- </script>
-
- <script language="javascript">
- function printTure()
- {
- document.all("dayinDiv").style.display="none";
- factory.printing.Print(true);
- document.all("dayinDiv").style.display="";
- }
-
- function printTurePre()
- {
- document.all("dayinDiv").style.display="none";
- factory.printing.Preview();
- document.all("dayinDiv").style.display="";
- }
-
- function printTureSet()
- {
- document.all("dayinDiv").style.display="none";
- factory.printing.PageSetup();
- document.all("dayinDiv").style.display="";
- }
- </script>
-
-
- <div id="dayinDiv" style="display: block;" name="dayinDiv">
- <input value="打印本页" class="buttonActive" onclick="printTure()" type="button">
- <input value="页面设置" class="buttonActive" onclick="printTureSet()" type="button">
- <input value="打印预览" class="buttonActive" onclick="printTurePre()" type="button">
- </div>
-
- <% String id = request.getParameter("id");
- String type = request.getParameter("type");
- String filename = "";
- String tablename = "arch_dispatch";
- if("1".equals(type)){
- filename = "fawen.jasper";
- } else if("2".equals(type)){
- filename = "audit.jasper";
- tablename = "td_workflow_use_audit";
- } else{
- filename = "shouwen.jasper";
- tablename = "arch_receive";
- }
- URL url = OAUtil.class.getResource("OAUtil.class");
- String pkgName = OAUtil.class.getPackage().getName();
- pkgName = pkgName.replace('.', '/');
- String filePath = url.getFile();
- String webinfoPath = filePath.substring(1, filePath.indexOf("WEB-INF/classes/" + pkgName));
-
- try {
- JasperPrint jp = null;
- java.util.Map map = new java.util.HashMap();
- java.sql.Connection con = null;
- PreparedDBUtil pd = new PreparedDBUtil();
- con = pd.getConection();
- map.put("SQLSTR", "select * from "+tablename+" where id ='"+id+"'");
- if("0".equals(type)){
- String tmpsql = "select id, createman,trans_flag,createdept,receive_no_postfix,receive_no1,pishinameid, pishiname,yuewennameid,yuewenname,yuebannameid,yuebanname,deptdealmanid,deptdealman, arch_co,arch_no,receive_no,secrecy_grade,title,to_char(createdate,'yyyy') ||' 年 '||to_char(createdate,'mm')||' 月 '||to_char(createdate,'dd')||' 日 ' as createdate,to_char(receivedate,'yyyy')||' 年 '||to_char (receivedate,'mm')||' 月 '||to_char(receivedate,'dd')||' 日 ' as receivedate,workmemo,auditmemo,readmemo,deptmemo,fd_num,yuebanren from arch_receive where id = '"+id+"'";
- map.put("SQLSTR", tmpsql);
- } else if("1".equals(type)){
- String subsqlstr = "select t.oldfilename,t.createman from td_afx_file t where t.businessid='"+id+"'";
- map.put("SUBSQLSTR", subsqlstr);
- map.put("SUBREPORT_DIR",webinfoPath);
- }else if("2".equals(type)){
- String tmpsql = "select id, code,createman,to_char(createdate,'yyyy')||' 年 '||to_char(createdate, 'mm')||' 月 '||to_char(createdate,'dd')||' 日 ' as createdate,dept, to_char(usedate,'yyyy')||' 年 '||to_char(usedate,'mm')||' 月 '||to_char (usedate,'dd')||' 日 ' as usedate,title,managerman,deptmemo,managermemo, checkresult,deptresult,managerresult,deptman,deptdate,managerdate,usememo,trans_flag,leader,leaderid from td_workflow_use_audit where id = '"+id+"'";
- map.put("SQLSTR", tmpsql);
- System.out.println(tmpsql);
- }
- jp = JasperFillManager.fillReport(webinfoPath+filename, map, con);
-
- StringBuffer sout = new StringBuffer();
-
- try {
-
- JRExporter exporter = new JRHtmlExporter();
- exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
- exporter.setParameter(JRExporterParameter.OUTPUT_STRING_BUFFER,
- sout);
- exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI, "report_image/");
- exporter.setParameter(JRHtmlExporterParameter.
- IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
- Boolean.TRUE);
- exporter.setParameter(JRHtmlExporterParameter.HTML_HEADER, "");
- exporter.setParameter(JRHtmlExporterParameter.
- BETWEEN_PAGES_HTML, "");
- exporter.setParameter(JRHtmlExporterParameter.HTML_FOOTER, "");
- exporter.setParameter(JRHtmlExporterParameter.
- IS_USING_IMAGES_TO_ALIGN,
- Boolean.valueOf(true));
- exporter.exportReport();
-
- %>
-
-
-
- <!--startprint-->
- <div id="jasper" style="display: block;" name="dayinDiv">
- <%
- out.println(sout.toString());
-
- %>
- </div>
- <!--endprint-->
- <object id="factory" viewastext="" style="display: none;" classid="clsid:1663ed61-23eb-11d2-b92f-008048fdd814" codebase="./ScriptX/smsx.cab#Version=6,2,433,70" height="0" width="0">
- </object>
-
- <%
- } catch (Exception e) {
- e.printStackTrace();
- sout.append("生成报表数据错误!");
- }
-
- } catch (Exception e1) {
- e1.printStackTrace();
-
- }
-
-
- %>
本文来源:http://blog.csdn.net/nickshen3/archive/2007/07/10/1684189.aspx
|