ï»??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲国产日韩综合久久精品,91久久电影,久久久久久a亚洲欧洲aⅴhttp://www.aygfsteel.com/kevinyao/zh-cnSat, 21 Jun 2025 04:22:09 GMTSat, 21 Jun 2025 04:22:09 GMT60- WEBå¼€å‘ä¸æ°´æ™¶æŠ¥è¡¨çš„ä‹É用心å¾?/title><link>http://www.aygfsteel.com/kevinyao/archive/2005/01/18/414.html</link><dc:creator>Kevin Yao</dc:creator><author>Kevin Yao</author><pubDate>Tue, 18 Jan 2005 00:48:00 GMT</pubDate><guid>http://www.aygfsteel.com/kevinyao/archive/2005/01/18/414.html</guid><wfw:comment>http://www.aygfsteel.com/kevinyao/comments/414.html</wfw:comment><comments>http://www.aygfsteel.com/kevinyao/archive/2005/01/18/414.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/kevinyao/comments/commentRss/414.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/kevinyao/services/trackbacks/414.html</trackback:ping><description><![CDATA[<P><STRONG><FONT size=1>[需求]</FONT></STRONG></P>
<P><FONT size=1>最˜q‘在™å¹ç›®å¼€å‘过½E‹ä¸åQŒå®¢æˆ¯‚¦æ±‚用Crystal Reports生æˆpdfæ ¼å¼çš„报表，òq¶å®žçŽ°è‡ªåŠ¨æ‰“å°åŠŸèƒ½ã€?/FONT></P>
<P><STRONG><FONT size=1>[实施索引]</FONT></STRONG></P>
<P><FONT size=1>1ã€åˆ›å»ºæ°´æ™¶æŠ¥è¡¨ï¼›</FONT></P>
<P><FONT size=1>2ã€Javaä¸åˆ©ç”¨æŠ¥è¡¨ç»„件包ž®†æŠ¥è¡¨ç»“果生æˆpdfåQ?/FONT></P>
<P><FONT size=1>3ã€å®Œæˆè‡ªåŠ¨æ‰“å°åŠŸèƒ½ã€?/FONT></P>
<P><STRONG><FONT size=1>[详细æ¥éª¤]</FONT></STRONG></P>
<P><FONT size=1>1ã€åˆ›å»ºæ°´æ™¶æŠ¥è¡?/FONT></P>
<P><FONT size=1>如果业务è¦æ±‚比较å¤æ‚åQŒè¦å…ˆåˆ›å»ÞZÍ时表和å˜å‚¨è¿‡½E‹ï¼Œå‡è®¾DB是ORACLEã€?/FONT></P>
<P><FONT size=1>1.1ã€åˆ›å»ÞZÍ时表</FONT></P>
<P><FONT size=1>CREATE global TEMPORARY TABLE <EM>table_name_temporary</EM><BR>( ......... ) on commit preserve rows;</FONT></P>
<P><FONT size=1>注：˜q™ç§æ–¹å¼¼‹®ä¿session之间åQŒæ•°æ®äº’ä¸å¹²æ‰°ã€?/FONT></P>
<P><FONT size=1>1.2ã€åˆ›å»ºå˜å‚¨è¿‡½E?/FONT></P>
<P><FONT size=1>创å¾åŒ…体åQŒåŒ…ä½“å†…å£°æ˜Žæ¸¸æ ‡ã€?/FONT></P>
<P><FONT size=1>æ ÒŽ®ä¸šåŠ¡é€»è¾‘åQŒå°†æ•°æ®ä¿å˜åœ¨äÍ时表ä¸ï¼Œ˜q”回水晶报表所需è¦çš„¾l“果集ã€?/FONT></P>
<P><FONT size=1>1.3ã€åˆ›å»ºæ°´æ™¶æŠ¥è¡?/FONT></P>
<P><FONT size=1>以å˜å‚¨è¿‡½E‹åšä¸ºæ•°æ®æºåQŒåˆ›å»ºæ°´æ™¶æŠ¥è¡¨ã€?/FONT></P>
<P><FONT size=1>2ã€Javaä¸åˆ©ç”¨æŠ¥è¡¨ç»„件包ž®†æŠ¥è¡¨ç»“果生æˆpdf</FONT></P>
<P><FONT size=1> 主è¦æ¥éª¤å¦‚下åQ?/FONT></P>
<P><FONT size=1> åQ?åQ‰ç™»å½•CrystalEnterpriseåQ?/FONT></P>
<P><FONT size=1> åQ?åQ‰è®¾¾|®reportå‚æ•°åQŒæ£€ç´¢reportåQ?/FONT></P>
<P><FONT size=1> åQ?åQ‰ç™»å½•DB ServeråQ?/FONT></P>
<P><FONT size=1> åQ?åQ‰è¾“出结果到pdfã€?/FONT></P>
<P><FONT size=1> 主è¦ä»£ç 如下åQ?/FONT></P>
<P><FONT size=1> IEnterpriseSession enterpriseSession = null;<BR> ReportClientDocument clientDoc = null;</FONT></P>
<P><FONT size=1> ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();<BR> enterpriseSession = sessionMgr.logon(<BR> RAS_ADMINISTRATOR,<BR> RAS_ADMIN_PWD, RASServer,<BR> RAS_SEC);<BR> IInfoStore iStore = (IInfoStore) enterpriseSession<BR> .getService(EAPTPrintConstants.RAS_INFOSTORE);<BR> IReportAppFactory reportAppFactory = (IReportAppFactory) enterpriseSession<BR> .getService(EAPTPrintConstants.RAS_REPORT_FACTORY);<BR> String query = "Select SI_ID From CI_INFOOBJECTS Where SI_NAME = '"<BR> + reportname + "' And SI_INSTANCE = 0 ";<BR> IInfoObjects result = null;<BR> try {<BR> result = iStore.query(query);<BR> } catch (SDKException e) {<BR> e.printStackTrace();<BR> }<BR> IInfoObject firstResult = (IInfoObject) result.get(0);</FONT></P>
<P><FONT size=1></FONT></P>
<P><FONT size=1> clientDoc = reportAppFactory.openDocument(firstResult, 0,<BR> Locale.ENGLISH);</FONT></P>
<P><FONT size=1> //logon to DataBase<BR> DatabaseController db = clientDoc.getDatabaseController();</FONT></P>
<P><FONT size=1> // need to transfer arguments</FONT></P>
<P><FONT size=1> db.logonEx(dbServer, sid, username,<BR> password);</FONT></P>
<P><FONT size=1> clientDoc.refreshReportDocument();</FONT></P>
<P><FONT size=1> this.setParameters(clientDoc, map); </FONT></P>
<P><FONT size=1> ByteArrayInputStream byteIS = (ByteArrayInputStream) clientDoc<BR> .getPrintOutputController().export(ReportExportFormat.PDF);</FONT></P>
<P><FONT size=1> byte byteArray[] = new byte[byteIS.available()];<BR> FileOutputStream fileOS = new FileOutputStream(filename);<BR> ByteArrayOutputStream byteOS = new ByteArrayOutputStream(byteIS<BR> .available());<BR> int x = byteIS.read(byteArray, 0, byteIS.available());<BR> byteOS.write(byteArray, 0, x);<BR> byteOS.writeTo(fileOS);<BR> byteOS.close();<BR> fileOS.close();</FONT></P>
<P><FONT size=1>3ã€å®Œæˆè‡ªåŠ¨æ‰“å°åŠŸèƒ?/FONT></P>
<P><FONT size=1> (1) 利用Itext技术é‡æ–°å¤„ç†pdfåQŒåœ¨å·²ç”Ÿæˆçš„pdfé‡ŒåŠ ä¸Šä»¥ä¸‹ä»£ç ：</FONT></P>
<P><FONT size=1> String js = "var pp = this.getPrintParams();\n";<BR> js = js + "var fv = pp.constants.flagValues;\n";<BR> js = js + "pp.flags = fv.setPageSize;\n";<BR> js = js + "pp.interactive = pp.constants.interactionLevel.automatic;\n";<BR> js = js + "pp.printerName = \"" + printer + "\";\n";<BR> js = js + "this.print(pp);\n";</FONT></P>
<P><FONT size=1> (2)jspä¸éœ€è¦IFrameæ ‡ç¾åQŒç„¶åŽè‡ªåŠ¨è°ƒç”¨ServletåQŒåœ¨servlet里将pdf输出æ¥ï¼Œç›´æŽ¥è¾“出到打å°æœºä¸Šã€?/FONT></P><img src ="http://www.aygfsteel.com/kevinyao/aggbug/414.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/kevinyao/" target="_blank">Kevin Yao</a> 2005-01-18 08:48 <a href="http://www.aygfsteel.com/kevinyao/archive/2005/01/18/414.html#Feedback" target="_blank" style="text-decoration:none;">å‘表评论</a></div>]]></description></item></channel></rss> <footer>
<div class="friendship-link">
<a href="http://www.aygfsteel.com/" title="狠狠久久亚洲欧美专区_中文字幕亚洲综合久久202_国产精品亚洲第五区在线_日本免费网站视频">狠狠久久亚洲欧美专区_中文字幕亚洲综合久久202_国产精品亚洲第五区在线_日本免费网站视频</a>
</div>
</footer>
Ö÷Õ¾Ö©Öë³ØÄ£°å£º
<a href="http://" target="_blank">º£°²ÏØ</a>|
<a href="http://" target="_blank">ÒËÖÝÊÐ</a>|
<a href="http://" target="_blank">°×ÓñÏØ</a>|
<a href="http://" target="_blank">¶«³ÇÇø</a>|
<a href="http://" target="_blank">ÍòÊ¢Çø</a>|
<a href="http://" target="_blank">±¾Ïª</a>|
<a href="http://" target="_blank">º£ÁÖÊÐ</a>|
<a href="http://" target="_blank">ÔƸ¡ÊÐ</a>|
<a href="http://" target="_blank">¹óÑôÊÐ</a>|
<a href="http://" target="_blank">Åî°²ÏØ</a>|
<a href="http://" target="_blank">ºÏ½ÏØ</a>|
<a href="http://" target="_blank">ÓôÄÏÏØ</a>|
<a href="http://" target="_blank">ÖÐɽÊÐ</a>|
<a href="http://" target="_blank">ÑÓÇìÏØ</a>|
<a href="http://" target="_blank">ÆѳÇÏØ</a>|
<a href="http://" target="_blank">¶îÃôÏØ</a>|
<a href="http://" target="_blank">¾°¶«</a>|
<a href="http://" target="_blank">²ìÓçÏØ</a>|
<a href="http://" target="_blank">ƽÄÏÏØ</a>|
<a href="http://" target="_blank">¶¨ÄÏÏØ</a>|
<a href="http://" target="_blank">º¼½õºóÆì</a>|
<a href="http://" target="_blank">ÇػʵºÊÐ</a>|
<a href="http://" target="_blank">ÎÚÇ¡ÏØ</a>|
<a href="http://" target="_blank">´óͬÊÐ</a>|
<a href="http://" target="_blank">ÌïÁÖÏØ</a>|
<a href="http://" target="_blank">´ó¸ÛÇø</a>|
<a href="http://" target="_blank">лͨÃÅÏØ</a>|
<a href="http://" target="_blank">¾äÈÝÊÐ</a>|
<a href="http://" target="_blank">Àû½òÏØ</a>|
<a href="http://" target="_blank">ÁùÅÌË®ÊÐ</a>|
<a href="http://" target="_blank">¹¢Âí</a>|
<a href="http://" target="_blank">¾¸½ÊÐ</a>|
<a href="http://" target="_blank">×ϽðÏØ</a>|
<a href="http://" target="_blank">ÒÍÁ¼ÏØ</a>|
<a href="http://" target="_blank">Õý¶¨ÏØ</a>|
<a href="http://" target="_blank">¾Þ¹ÏØ</a>|
<a href="http://" target="_blank">ÁÖ¿ÚÏØ</a>|
<a href="http://" target="_blank">ÐÂçÏØ</a>|
<a href="http://" target="_blank">Ã÷Ë®ÏØ</a>|
<a href="http://" target="_blank">Å®ÐÔ</a>|
<a href="http://" target="_blank">ÇåºÓÏØ</a>|
<script>
(function(){
var bp = document.createElement('script');
var curProtocol = window.location.protocol.split(':')[0];
if (curProtocol === 'https') {
bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
}
else {
bp.src = 'http://push.zhanzhang.baidu.com/push.js';
}
var s = document.getElementsByTagName("script")[0];
s.parentNode.insertBefore(bp, s);
})();
</script>
</body>