锘??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲乱理伦片在线观看中字,亚洲国产精品国自产拍AV,亚洲AV无码一区二区乱子伦http://www.tkk7.com/davidxu/浠ョ敤鎴瘋搴﹀嚭鍙?浣犲氨宸茬粡鎴愬姛涓鍗婁簡.zh-cnFri, 09 May 2025 05:03:53 GMTFri, 09 May 2025 05:03:53 GMT60鏀句釜闊充箰鐩?/title><link>http://www.tkk7.com/davidxu/archive/2006/03/03/33338.html</link><dc:creator>涓鍑ITO</dc:creator><author>涓鍑ITO</author><pubDate>Thu, 02 Mar 2006 17:07:00 GMT</pubDate><guid>http://www.tkk7.com/davidxu/archive/2006/03/03/33338.html</guid><description><![CDATA[<script type='text/javascript' language='JavaScript' src='http://www.diymusic.com/embed.js'></script> <script type='text/javascript' language='JavaScript'> var base_xml = UrlEncode('http://www.diymusic.com/blog/soundbox_post_xml.php?post_id=126&user_id=36'); var u_str = 'http://www.soundon.com:8080/lps/mp3/soundblox.lzx?lzt=swf&data_url='+base_xml; var objectParams = { url: u_str,bgcolor: '#ffffff', width: '180',height: '420' } lzEmbed(objectParams); </script><img src ="http://www.tkk7.com/davidxu/aggbug/33338.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/davidxu/" target="_blank">涓鍑ITO</a> 2006-03-03 01:07 <a href="http://www.tkk7.com/davidxu/archive/2006/03/03/33338.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>騫村熬,騫村垵濂藉浜嬪共鍛http://www.tkk7.com/davidxu/archive/2006/01/27/29310.html涓鍑ITO涓鍑ITOFri, 27 Jan 2006 12:00:00 GMThttp://www.tkk7.com/davidxu/archive/2006/01/27/29310.htmlhttp://www.tkk7.com/davidxu/comments/29310.htmlhttp://www.tkk7.com/davidxu/archive/2006/01/27/29310.html#Feedback0http://www.tkk7.com/davidxu/comments/commentRss/29310.htmlhttp://www.tkk7.com/davidxu/services/trackbacks/29310.html1.springside Promatic Enterprise Application KickStart欏圭洰
   璇村疄鍦?鐢變簬榪欐鏃墮棿姣旇緝蹇?榪樻病鏀懼灝戞椂闂翠笂鍘?鐪熼毦涓?A href="/calvin">鐧借。鑰佸ぇ浠ュ強鍑犱綅team Worker浜?)
  http://www.tkk7.com/calvin/archive/2006/01/02/26347.html

2.鍚勪釜寮婧愮殑鏂扮増鏈繕娌℃湁鏃墮棿鐮旂┒
    spring 2.0
    hibernate3.1

3.璇磋鍔犲己鐨勪笢瑗胯繕娌″畨鎺?/STRONG>
   oracle

4.鏂頒竴騫寸殑寮婧愬伐鍏峰ソ璞″彲浠ョ敤涓婂満浜?/STRONG>
   bi tools
   openi (Roadmap 鍒氫慨鏀逛簡,浼拌1.2鐗堟湰鍦?006 1Q release,絳変簡鎴戝ソ涔?
   birt (2.0鐗堟湰綆鍗曚粙緇?A HREF="/davidxu/archive/2006/01/27/29305.html">http://www.tkk7.com/davidxu/archive/2006/01/27/29305.html) 
   pentaho
 
榪樻湁濂藉鐢靛瓙娌$湅鍛?)
涓嶇鎬庢牱錛屽勾榪樻槸瑕佽繃錛宧appy new year!


]]>
birt 2.0 is now available....鍗犱釜澶翠綅,瀹d紶涓涓?/title><link>http://www.tkk7.com/davidxu/archive/2006/01/27/29305.html</link><dc:creator>涓鍑ITO</dc:creator><author>涓鍑ITO</author><pubDate>Fri, 27 Jan 2006 08:58:00 GMT</pubDate><guid>http://www.tkk7.com/davidxu/archive/2006/01/27/29305.html</guid><wfw:comment>http://www.tkk7.com/davidxu/comments/29305.html</wfw:comment><comments>http://www.tkk7.com/davidxu/archive/2006/01/27/29305.html#Feedback</comments><slash:comments>10</slash:comments><wfw:commentRss>http://www.tkk7.com/davidxu/comments/commentRss/29305.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/davidxu/services/trackbacks/29305.html</trackback:ping><description><![CDATA[<H1><A name=top></A>what is BIRT</H1> <P>BIRT is an open source, Eclipse-based reporting system that integrates with your application to produce compelling reports for both web and PDF. </P> <P>BIRT provides core reporting features such as report layout, data access and scripting. The current released version is 2.0. Please try BIRT and tell us what you think by filling bugs reports & enhancement requests through Bugzilla as explained on the <A >community</A> page. </P><FONT size=4> <H1></FONT>New and Notable Features within BIRT 2.0</H1> <BLOCKQUOTE> <UL> <LI>New BIRT Viewer <LI>JavaScript/Java Events And Report Debugging <LI>Runtime Data Source Property Binding <LI>Chart Builder and SVG Output <LI>Templates <LI>Libraries <LI>XML ODA <LI>URL Builder <LI>Multi-pass Aggregate, Sorting and Filtering <LI>Improved Report Performance and PDF Fidelity <LI>Dynamic Parameters/Cascading Parameters <LI>Expression Builder <LI>Importing of Style Sheets <LI>Report XML Editor <LI>Passing of External Object to Custom Data Sources <LI>Stored Procedures <LI>CLOB/BLOB Support <BR></LI></UL> <P>New and Notable Features within BIRT 2.0錛?BR><A >http://www.eclipse.org/birt/phoenix/project/notable2.0.php</A><BR><BR>project home:<A >http://www.eclipse.org/birt/</A><BR><BR><SPAN onclick="img1.style.display=''"><U>new report viewer [鎴浘] </U><SPAN><BR><IMG id=img1 style="DISPLAY: none; WIDTH: 661px; HEIGHT: 481px" height=539 alt="" hspace=0 src="http://www.eclipse.org/birt/phoenix/project/images/toc.jpg" width=721 align=baseline border=0> <BR><SPAN onclick="img2.style.display=''"><U>The Viewer also supports data extraction to CSV format [鎴浘]</U></SPAN> <BR><IMG id=img2 style="DISPLAY: none; WIDTH: 663px; HEIGHT: 491px" height=486 alt="" hspace=0 src="http://www.eclipse.org/birt/phoenix/project/images/export1.jpg" width=644 align=baseline border=0><BR><SPAN onclick="img3.style.display=''"><U>export to CSV [鎴浘]</U></SPAN><BR><IMG id=img3 style="DISPLAY: none" hspace=0 src="http://www.eclipse.org/birt/phoenix/project/images/export3a.png" align=baseline border=0><BR><BR></P> <P>瀹冪殑report designer 榪樼嫭绔嬪嚭鏉ワ紙涓嶇敤渚濊禆eclipse錛夌洿鎺ユ墦寮銆BIRT.exe銆灝憋集錛紟</P></BLOCKQUOTE><BR>涓漢鎰熻榪涙浜嗕笉灝戯紝浣嗚礋璐e湴璇翠竴鍙ワ紝搴旂敤鍒板疄闄呴」鐩腑鎴戠寽鎯寵繕浼氭湁涓嶅皯鐨勯棶棰橈紝榪樿澶у鎶卞涔犵殑鎬佸害銆?BR><BR> <DIV style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000">椹笂灝忚瘯浜嗕竴涓嬶紝鍙戠幇涔嬪墠濂藉嚑鐐圭枒闂兘鍙互涓嶇敤鎷呭績浜嗭紝鍩烘湰瑙e喅鎺変簡:<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">1</SPAN><SPAN style="COLOR: #000000">錛嶢JAX鐨勫垎欏?BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>銆銆鍙鑷畾涔夊ソ鎶ヨ〃</SPAN><SPAN style="COLOR: #000000">/</SPAN><SPAN style="COLOR: #000000">grid鐨勫浠ュ強楂橈紝瀹炵幇css鍒嗛〉錛屽垵姝ユ劅瑙夋晥鏋滆繕涓嶉敊錛堟湁寰呭疄闄呭簲鐢級<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">2</SPAN><SPAN style="COLOR: #000000">錛庡鍑篹xcel<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>      鏀寔export to csv錛堣櫧鐒舵湁涓枃涔辯爜闂錛夛紝鍙﹀褰撴姤琛ㄦ病鏈塪ataset(闈欐佹姤琛?鏃跺ソ璞″涓嶅嚭錛?BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">3</SPAN><SPAN style="COLOR: #000000">錛嶣IRT and POJOs as datasources example<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>      http:</SPAN><SPAN style="COLOR: #008000">//</SPAN><SPAN style="COLOR: #008000">tools.osmosis.gr/blog/archives/2005/06/birt_and_object.html</SPAN><SPAN style="COLOR: #008000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">4</SPAN><SPAN style="COLOR: #000000">錛庢洿浜烘у寲錛屾彁渚涘洓涓猻ervlet<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>銆a. </SPAN><SPAN style="COLOR: #000000">/</SPAN><SPAN style="COLOR: #000000">frameset</SPAN><SPAN style="COLOR: #000000">?</SPAN><SPAN style="COLOR: #000000">__report</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">test.rptdesign   (宸ュ叿鏉?鐩綍瀵艱埅,鍒嗛〉鎿嶄綔)<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    b.</SPAN><SPAN style="COLOR: #000000">/</SPAN><SPAN style="COLOR: #000000">preview</SPAN><SPAN style="COLOR: #000000">?</SPAN><SPAN style="COLOR: #000000">__report</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">test.rptdesign (宸ュ叿鏉?鐩綍瀵艱埅,鍒嗛〉鎿嶄綔)<BR><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    c.</SPAN><SPAN style="COLOR: #000000">/</SPAN><SPAN style="COLOR: #000000">run</SPAN><SPAN style="COLOR: #000000">?</SPAN><SPAN style="COLOR: #000000">__report</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">test.rptdesign<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    d.</SPAN><SPAN style="COLOR: #000000">/</SPAN><SPAN style="COLOR: #000000">download</SPAN><SPAN style="COLOR: #000000">?</SPAN><SPAN style="COLOR: #000000">__report</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">test.rptdesign</SPAN></DIV><BR></SPAN></SPAN><img src ="http://www.tkk7.com/davidxu/aggbug/29305.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/davidxu/" target="_blank">涓鍑ITO</a> 2006-01-27 16:58 <a href="http://www.tkk7.com/davidxu/archive/2006/01/27/29305.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>浜嗚Вjasperreport ,璁﹚eb鎶ヨ〃璺戝緱鏇村ソhttp://www.tkk7.com/davidxu/archive/2005/11/28/jasperreportskills.html涓鍑ITO涓鍑ITOMon, 28 Nov 2005 12:35:00 GMThttp://www.tkk7.com/davidxu/archive/2005/11/28/jasperreportskills.htmlhttp://www.tkk7.com/davidxu/comments/20946.htmlhttp://www.tkk7.com/davidxu/archive/2005/11/28/jasperreportskills.html#Feedback6http://www.tkk7.com/davidxu/comments/commentRss/20946.htmlhttp://www.tkk7.com/davidxu/services/trackbacks/20946.html涓銆佷負浠涔堟槸jasperreport
         寰堢畝鍗曚袱鐐癸細
銆銆銆銆錛戙鍏嶈垂
銆銆銆銆錛掋鍦ㄥぇ澶氭暟寮婧愪駭鍝佷腑鏈鑳芥弧瓚蟲湰浜?鍏徃鐨勯渶姹傦紟
銆銆     濡傛灉瑕佷竴鍙ヨ瘽鎬葷粨閭d箞灝辨槸 "閫傚悎灝卞ソ!" 錛屽叾嬈″啀鎯蟲彃涓鍙?鍏跺疄jasperreport鍙互鍋氬緱鏇村ソ錛屽彧鏄己灝戝ぇ瀹跺幓鍙戠幇銆? 

             鍦╡rp杞歡寮鍙戜腑涓濂楀己澶ф槗鐢ㄧ殑鎶ヨ〃宸ュ叿榪樻槸鐩稿綋閲嶈鐨勫湴浣嶏紝鍦ㄨ繖閲屾垜鍙拡瀵逛竴浜涙棩甯鎬笟鍔℃姤琛紟
              jasperreport + ireport 鎶ヨ〃濂楄鍦ㄦ櫘閫氱殑鎶ヨ〃涓凡鍋氬緱寰堜笉閿欙細嫻佹按璐﹀紡鐨勶紝鍒嗙粍鎶ヨ〃閮藉彲浠ヨ交鏉懼疄鐜?鍦ㄨ繖閲屾彁鍑虹殑鏄竴浜涚浉瀵圭壒鍒互鍙婂皯鐢ㄥ埌鐨勬姤琛ㄨ璁¢棶棰橈紟
             褰撳墠鐗堟湰 : jasperreport  1.1.0
                                 ireport  : 0.5.2

浜屻侀棶棰樹笌瑙e喅
           
1.鎿嶄綔
        鍒濈敤ireport 璁捐鎶ヨ〃錛堢壒鍒槸鏃╂湡鐨勭増鏈級鎰熻榪樻槸姣旇緝鍘熷錛岀浉瀵逛簬birt 綾諱技浜庡湪 Dreamweaver涓敾table 寮忕殑璁捐榪樻槸鏈夌偣宸窛錛庝絾鏂扮増鏈?0.5.2)涓篃鏈変笉灝忕殑鏀瑰杽錛屽鍔犱簡寰堝蹇熷榻愶紝鏍煎紡鍖栫殑宸ュ叿鏍忎互鍙婂揩鎹鋒搷浣滄柟寮忥紟閫氳繃緇撳悎榪欎簺鎿嶄綔榪樼畻鏄柟渚夸簡涓嶅皯錛?BR>
2.鍒嗛〉
           鍒氭帴瑙asper report 錛屾棤璁烘槸鐪嬪叾瀹樻柟鐨別xample榪樻槸鑷繁鍔ㄦ墜璁捐鎶ヨ〃,  html view 鎬葷粰浜哄緢娣辯殑鍗拌薄錛?鎬庝箞瀛椾綋閭d箞灝忥紝鑰屼笖瀹為檯鎵撳嵃涓涓嬶紝鍒嗛〉鍔熻兘騫舵病鐪熸瀹炵幇"
        緇忚繃瀹㈡埛涓杞殑鎶椾箟錛屾渶緇堣繕鏄笅瀹氬喅蹇冨幓淇ˉ涓涓嬶紝
銆銆鍏跺疄jasper report 鍘熺悊榪樻槸鎸虹畝鍗曪細
銆   瀹冮粯璁ょ殑鍒嗛〉鏂瑰紡鏄兘榪囦竴杞殑楂樺害璁$畻錛屽啀鐢ㄤ袱涓?lt;br>灝變互涓轟簡浜嬩簡錛?/P>
<table>
<tr>
 
<td>
   
<table>
    
   
</table>
   
<br/> <!--涓や釜br鍒嗚鏍囪-->
   
<br/>
   
<table>
    
   
</table>
 
</td>
</tr>
</table>


       瑙e喅鏂規錛?BR>       濂藉湪jasperreport榪樻彁渚涗簡寰堝ソ鐨勬墿灞曟柟妗?瀹冨厑璁告垜浠嚜瀹氫箟鍒嗛〉鏂瑰紡錛堝氨鏄鍦ㄤ袱欏?table涔嬮棿鑳借鎴戜滑鏀捐嚜宸辯殑浠g爜錛夛紝鑷繁瀹氫箟betweenPagesHtml 灝憋集錛簡錛屽彲浠ヨ兘榪囷跡錛籌汲瀹氫箟鍒嗛〉錛庡湪榪欓噷錛屾垜灝辯洿鎺ユ敼瀹冧唬鐮佺畻浜嗭紟澶у鍙互鑷繁閫夋嫨.
    
net.sf.jasperreports.engine.export.JRHtmlExporter

<!--CSS浠g爜-->
pageEnd 
{page-break-after:always}

 

if (betweenPagesHtml == null)
                        
{
                            writer.write(
"<br class=\"pageEnd\">");   // 鍘熸潵鏄袱涓?<br/>
                        }
 else
                        
{
                            writer.write(betweenPagesHtml);
                        }

3. 鎵撳嵃
    銆銆鍒嗛〉瑙e喅鍚庡彲浠ュ彂鐜板綋鎶ヨ〃棰勮鏃剁湡鐨勮兘涓欏典竴欏靛垎寰楀緢濂斤紟鍗村張鍙戠幇浜嗕竴涓棶棰橈紟鎶ヨ〃鏄庢樉涓嶈兘婊′竴寮狅肌錛斿紶澶у皬(ireport 璁捐閫夋嫨鐨勬槸錛★紨綰稿紶),鐤戞儜浜嗕竴闄呭瓙錛屽叾瀹炰笉鑳界畻鏄疊UG錛?BR>銆銆銆ireport 鎶ヨ〃灞炴т腑鏄庢樉(21 * 29.7 CM) 涓寮狅肌錛旂焊鐨勫ぇ灝忥紝涓轟粈涔堬績錛達輯錛嚭鏉ョ殑鏁堟灉鍗存槑鏄懼皬鐨勯偅涔堝浜嗭紟鍏跺疄榪欎笌璁$畻鏈虹殑鍒嗚鯨鐜囨湁鍏?BR>銆銆銆璁$畻鏈轟腑鐨勫垎杈ㄧ巼錛屾櫘閬嶆槸72 璞$礌/鑻卞錛岃屾墦鍗版満鏅氭槸300璞$礌/鑻卞錛?BR>銆銆銆jasperreport 涓巌report 榛樿鍗曚綅鏄痯x錛屾垜鐚滄兂濡傛灉鐢–M鍋氬崟浣嶇殑璇濆彲浠ヨВ鍐寵繖涓棶棰橈紟浣嗗湪榪欓噷鎴戜滑鐨勫仛娉曟槸灝介噺鍔犲ぇ鎶ヨ〃璁捐鏃剁殑瀹藉害涓庨珮搴︼紟鍙︿竴涓娉ㄦ剰鐨勬槸璁板緱灝嗘墍鏈夐〉杈硅窛璁句負0,鍥犱負榪欎簺璁劇疆鍦ㄦ墦鍗扮殑鏃跺欏凡鍦緝錛ワ紡嫻忚鍣ㄤ腑璁懼畾浜嗭紝涓嶇敤閲嶅錛?BR>   
4.鍒嗘爮
    銆銆浠ュ墠娌″娉ㄦ剰,浣嗗垰鐢╥report鏂扮増鏈椂鍙互鍙戠幇鍦ㄦ姤琛ㄥ睘鎬ц璁$殑鏃跺欏彲浠ヨ緗爮錛庤繖涓嬪瓙濡傛灉褰撴姤琛ㄤ富浣撻儴鍒嗗垪鏁頒笉澶氭椂瀹炵幇鍒嗘爮鏄劇ず錛屼互鑺傜渷綰稿紶錛?BR>
5.鏂戦┈綰垮紡鏄劇ず鎶ヨ〃涓諱綋
銆銆銆
鏈夋椂鎴戜滑鎯寵鎶ヨ〃鏇寸編鍖栵紝璁╃敤鎴鋒洿鏂逛究鍦拌鐪嬫暟鎹紝鍙互璁劇疆涓ょ鑹茬浉闅旓紟榪欑鏁堟灉鍦╦asperreport 涓殑example涓湁demo涓涓嬶紝澶у濡傛灉鎯沖涔犲彲浠ヤ笅杞界湅鐪嬶紟

6.浜ゅ弶鎶ヨ〃

銆銆銆鍏充簬jasperreport鐨勪氦鍙夋姤琛ㄨ璁$綉涓婅繕鏄湁涓嶅皬鐨勮璁猴紝鑰岀湡姝e疄鐜扮殑涓嶅錛庢垜瑙傚療榪囧ぇ澶氱敤jasperreport瀹炵幇閮芥槸浼氦鍙夋姤琛紟騫朵笉鏄湡姝e疄鐜扮湡姝g殑鍔ㄦ佽涓庡垪錛?BR>銆銆銆鍏跺疄鍦╦aspert report涓嬭澆鍖呬腑榪樻槸鏈変釜浜ゅ弶鎶ヨ〃鐨勫疄鐜癳xample(crosstabs)錛屽彧涓嶈繃鎹垜浜嗚В錛岀幇鍦╥report榪樹笉鑳藉疄鐜拌璁★紟鍙兘閫氳繃鎵嬪伐鍐檍rxml鏂囦歡瀹炵幇錛庢湰浜哄皬璇曚竴涓嬶紝榪樻槸鎸轟笉閿欑殑錛?BR> 

涓夈佸緟鐮旂┒
銆閫氳繃緇ф壙net.sf.jasperreports.engine.export.JRHtmlExporter ,榪樻槸鑳芥墿灞曚笉灝忕殑鍔熻兘錛庝緥濡傜敤錛o汲錛蟲牸寮忓寲錛屽彲浠ュぇ澶у噺灝忎唬鐮侀噺錛屽姩鎬佸垪錛忓彲璁懼垪瀹藉害澶уぇ澧炲己鎴戜滑鐨勬姤琛ㄥ姛鑳斤紟
銆鐜版湰浜哄垵閮ㄥ疄鐜?00錛呭搴︼紝涓嶅啀鐢╦asperreport涓環ardcode鍒楀害絳夌瓑,浠ヤ笅涓夌偣榪樻湁寰呮椂闂村幓璺熻繘:)

1.鍔ㄦ佸垪

2.鍙鍒楀搴?BR>
3.CSS璁捐
銆銆


 

]]>
[ec] extreme Table 鐗堟湰璺熻繘鍙戝竷鍖?/title><link>http://www.tkk7.com/davidxu/archive/2005/08/27/11316.html</link><dc:creator>涓鍑ITO</dc:creator><author>涓鍑ITO</author><pubDate>Sat, 27 Aug 2005 07:09:00 GMT</pubDate><guid>http://www.tkk7.com/davidxu/archive/2005/08/27/11316.html</guid><wfw:comment>http://www.tkk7.com/davidxu/comments/11316.html</wfw:comment><comments>http://www.tkk7.com/davidxu/archive/2005/08/27/11316.html#Feedback</comments><slash:comments>20</slash:comments><wfw:commentRss>http://www.tkk7.com/davidxu/comments/commentRss/11316.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/davidxu/services/trackbacks/11316.html</trackback:ping><description><![CDATA[<STRONG><FONT size=5>璇存槑</FONT></STRONG><BR><STRONG><FONT size=5><A >extreme Table </A></FONT></STRONG>鏄釜寰堜笉閿欑殑table tag,鎵撶畻璁板綍搴曞畠鐨勭増鏈彂甯?change Log :)<BR><BR><BR>瀹冪殑RoadMap : <BR><A >http://extremecomponents.org/extremesite/public/roadMap.jsp</A><BR>浠ュ線鏈珺LOG浠嬬粛: <A href="/davidxu/archive/2005/08/09/9683.aspx">http://www.tkk7.com/davidxu/archive/2005/08/09/9683.aspx</A><BR><BR><BR><BR>鎴戜滑浠庤繖閲屽紑濮?<BR><STRONG><BR><FONT size=5>[</FONT><A style="COLOR: black" ><STRONG><FONT size=5>1.0.0-M2-A2</FONT></STRONG></A><FONT size=5>]</FONT><BR></STRONG><A style="COLOR: black" ><STRONG>1.0.0-M2-A2</STRONG></A> - by 瀹樻柟 <UL> <LI>Able to mix the ColumnTag and the ColumnsTag. Will need to use the method <BR>model.getColumnHandler().<B>addAutoGenerateColumn</B>(column); <LI>Every attribute of every tag will accept an EL Expression <LI>Will accept a Set for the collection now </LI></UL> <P><BR><STRONG>閮ㄥ垎浣跨敤璇存槑 --by david xu</STRONG></P> <P><STRONG></STRONG>1  table 鏂板鍔爒ar灞炴?鏀寔瀹氫箟bean name (鍙夋嫨),鍙互涓嶇敤${collectionName.memberName}榪欐牱闅句互鐞嗚В鐨勮娉?<BR>    鐢ㄥ畼鏂圭殑璇濆氨鏄?BR>    "Added TableTag var attribute. Used (optionally) as the name of the variable to hold the current bean. "<BR>   <BR></P> <DIV style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:table<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    collection</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">humanList</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    action</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">${pageContext.request.contextPath}/index.jsp</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    imagePath</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">${pageContext.request.contextPath}/images/table/*.gif</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    cellpadding</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">1</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    saveFilterSort</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">true</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    <FONT color=#ff0000>var</FONT></SPAN><FONT color=#ff0000><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">human</SPAN><SPAN style="COLOR: #000000">"</SPAN></FONT><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    title</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">鎴戠殑絎竴涓猼ag table</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000"></< SPAN><SPAN style="COLOR: #000000">ec:table</SPAN><SPAN style="COLOR: #000000">></SPAN><SPAN style="COLOR: #000000"><BR><IMG id=Codehighlighter1_268_279_Open_Image onclick="this.style.display='none'; Codehighlighter1_268_279_Open_Text.style.display='none'; Codehighlighter1_268_279_Closed_Image.style.display='inline'; Codehighlighter1_268_279_Closed_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ExpandedBlockStart.gif" align=top><IMG id=Codehighlighter1_268_279_Closed_Image style="DISPLAY: none" onclick="this.style.display='none'; Codehighlighter1_268_279_Closed_Text.style.display='none'; Codehighlighter1_268_279_Open_Image.style.display='inline'; Codehighlighter1_268_279_Open_Text.style.display='inline';" src="http://www.tkk7.com/images/OutliningIndicators/ContractedBlock.gif" align=top>$</SPAN><SPAN id=Codehighlighter1_268_279_Closed_Text style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff"><IMG src="http://www.tkk7.com/images/dot.gif"></SPAN><SPAN id=Codehighlighter1_268_279_Open_Text><SPAN style="COLOR: #000000">{human.name}</SPAN></SPAN><SPAN style="COLOR: #000000"> 鍙栧緱</SPAN></DIV> <P><BR><FONT size=4><STRONG><BR><FONT size=5>[1.0.1-M2]<BR></FONT></STRONG><STRONG><FONT size=3>1.0.1-M2 release</FONT></STRONG><FONT size=3><STRONG>  by 瀹樻柟<BR><BR></STRONG></FONT></P> <DIV style="BORDER-RIGHT: #999 1px solid; BORDER-TOP: #999 1px solid; OVERFLOW: auto; BORDER-LEFT: #999 1px solid; WIDTH: 735px; BORDER-BOTTOM: #999 1px solid; HEIGHT: 211px"> <DIV> <H4>1. Things that changed and need to be aware of:</H4><SPAN> <UL> <LI><B>The ColumnTag exportable attribute has been removed</B> <UL> <LI>Replaced with the viewsAllowed and the viewsDenied attributes (see items 3 and 4) </LI></UL> <LI><B>Changed Cell interface</B> <UL> <LI><I>new interface -></I>public void init(BaseModel model, Column column); <LI>Matches the View interface for consistency <LI>The rowcount is part of the new Row bean. Can retrieve the rowcount by doing a model.getRowHandler().getRow().getRowCount() </LI></UL> <LI><B>Changed View interface</B> <UL> <LI><I>new interface -></I> public void body(BaseModel model, Column column); <LI>Matches the Cell interface for consistency <LI>Can get the column position by doing column.isFirstColumn() and column.isLastColumn() </LI></UL> <LI><B>New TableTag attributes to replace the deprecated collection attribute</B> <UL> <LI>The collection attribute has been deprecated in favor of three new attributes. The attributes are call tableId, items, and var <LI>Read the <A >full discussion</A> for more information </LI></UL> <LI><B>Moved the <TD>element back on the Cell for the FilterCell.</B> <UL> <LI>If you modified the HtmlView, and specifically the filter row, then remove the <TD>element in the View. </LI></UL></LI></UL></SPAN></DIV> <DIV> <H4>2. New RowTag with cooresponding Row Bean</H4><SPAN> <UL> <LI>Able to do row level javascript onmouseover, onmouseout, and onclick <LI>Ability to do row level highlighting. See stylesheet change (below) for proper formating. <LI>Moved the stylesheet class attribute from the column (<TD>) to the row (<TR>) </LI></UL></SPAN></DIV> <DIV> <H4>3. New ColumnTag attribute viewsAllowed</H4><SPAN> <UL> <LI>Can specify whether the column should be used for the current view. The views include html, pdf, xls, csv, plus any custom views. <LI>If you specify a given view (or views), then only that view (or views) will use the column <LI>For example you can specify viewsAllowed="pdf" which will use the column for the PDF export, but not any other export or default html View <LI>Replaces the ColumnTag exportable attribute </LI></UL></SPAN></DIV> <DIV> <H4>4. New ColumnTag attribute viewsDenied</H4><SPAN> <UL> <LI>Can specify whether the column should <B>not</B> be used for the current view. The views include html, pdf, xls, csv, plus any custom views <LI>If you specify a given view (or views), then only that view (or views) will <B>not</B> use the column <LI>For example you can specify viewsDenied="html" which will <B>not</B> use the column for the html View, but will for all the exports <LI>Replaces the ColumnTag exportable attribute </LI></UL></SPAN></DIV> <DIV> <H4>5. Enhancements</H4><SPAN> <UL> <LI>Every attribute of every tag will accept an EL Expression <LI>Will accept a Set for the collection now <LI>Confirmed to work with a RowSetDynaClass (if send as List) <LI>Able to mix the ColumnTag and the ColumnsTag. Will need to use the method model.getColumnHandler().addAutoGenerateColumn(column); <LI>Improved the default stylesheet <UL> <LI>My initial intentions were to just change the stylesheet to work with the row highlighting, but I ended up tweaking it enough that now it just works better. For instance if you have some filters turned off then it seamlessly flows with the statusbar because it no longer uses cellspacing. If you use the new stylesheet be sure to remove the table.cellspacing=2 from your extremecomponents.properties file. </LI></UL></LI></UL></SPAN></DIV> <DIV> <H4>6. Bugs Fixed</H4><SPAN> <UL> <LI>Fixed Rows Displayed bug <UL> <LI>The Rows Displayed was not working correctly with the Show All under certain conditions <LI>Can set the median and max values in the extremecomponents.properties. The default values are table.medianRowsDisplayed=50 and table.maxRowsDisplayed=100, respectively </LI></UL></LI></UL></SPAN></DIV></DIV> <P><STRONG>閮ㄥ垎浣跨敤璇存槑 --by david xu<BR>1銆乀ableTag 鐨勬敼鍔?BR>      collection attribute</STRONG> 涓嶅啀璧炴垚浣跨敤,鍙互浣跨敤tableId, items, and var 鍙栬屼唬涔?BR></P> <DIV style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:table <BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    items</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">customerList</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>        tableId</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">customer</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>        var</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">customer</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>    title</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">customerList</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>        鈥︹︹︹?BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>鈥︹︹︹?BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000"></< SPAN><SPAN style="COLOR: #000000">ec:table</SPAN><SPAN style="COLOR: #000000">></SPAN></DIV> <P><BR><STRONG>2銆丆olumnTag 鏂板睘鎬х殑鐢ㄦ硶viewAllowed錛寁iewsDenied<BR>      鏀寔view鍖呮嫭:</STRONG>html, pdf, xls, csv浠ュ強鑷畾鐨剉iew</P> <DIV style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000">     viewsAllowed</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">pdf</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">    </SPAN><SPAN style="COLOR: #008000">//</SPAN><SPAN style="COLOR: #008000">璇存槑錛氬彧鍏佽鍦╬df view 涓?/SPAN><SPAN style="COLOR: #008000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">      viewsAllowed</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">html,xls</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #008000">//</SPAN><SPAN style="COLOR: #008000">涔熷彲浠ョ敤,鍒嗛殧</SPAN></DIV><BR>3銆?STRONG> Cell interface</STRONG> 鐨勬敼鍔?BR>       閫氳繃model.getRowHandler().getRow().getRowCount() 榪斿洖 rowcount <BR>4銆佹柊澧濺owTag <BR>     <DIV style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:row <FONT color=#ff0000>highlightRow</FONT></SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">true</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"> <FONT color=#ff0000>onclick</FONT></SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">alert('david')</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"> </SPAN><SPAN style="COLOR: #000000">></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>   </SPAN><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:column</SPAN><SPAN style="COLOR: #000000">/></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>   </SPAN><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:column</SPAN><SPAN style="COLOR: #000000">/></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>   </SPAN><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:column</SPAN><SPAN style="COLOR: #000000">/></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>   鈥︹︹︹?BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000"></< SPAN><SPAN style="COLOR: #000000">ec:row</SPAN><SPAN style="COLOR: #000000">></SPAN></DIV></SPAN></FONT><BR><FONT size=4>5銆乻et ,RowSetDynaClass 鐨勬敮鎸?/FONT><FONT size=4><BR> <DIV style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000"><%</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>聽聽聽聽List聽customerList聽</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">聽</SPAN><SPAN style="COLOR: #0000ff">new</SPAN><SPAN style="COLOR: #000000">聽ArrayList();<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>聽聽聽聽LazyDynaBean聽temp聽</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">聽</SPAN><SPAN style="COLOR: #0000ff">new</SPAN><SPAN style="COLOR: #000000">聽LazyDynaBean();<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>聽聽聽聽temp.set(</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">code</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">,聽</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">001</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">);<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>聽聽聽聽temp.set(</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">name</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">,聽</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">david聽xu</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">);<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>聽聽聽聽customerList.add(temp);<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>聽聽聽聽request.setAttribute(</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">customerList</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">,聽customerList);聽<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">%><BR></SPAN><SPAN style="COLOR: #000000"><?xml:namespace prefix = ec /><ec:table><BR>   鈥︹︹︹?BR>  鈥︹︹︹?BR></ec:table><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN></DIV></FONT><BR><FONT size=4>6銆乀otalling Columns</FONT> <BR> <DIV style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 98%; WORD-BREAK: break-all; PADDING-TOP: 4px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #eeeeee"><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:table<BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>        totalTitle</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">鍚堣</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000">></SPAN><SPAN style="COLOR: #000000">      <BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top>   </SPAN><SPAN style="COLOR: #000000"><</SPAN><SPAN style="COLOR: #000000">ec:column property</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">salary</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000"> showTotal</SPAN><SPAN style="COLOR: #000000">=</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">true</SPAN><SPAN style="COLOR: #000000">"</SPAN><SPAN style="COLOR: #000000">/></SPAN><SPAN style="COLOR: #000000"><BR><IMG src="http://www.tkk7.com/images/OutliningIndicators/None.gif" align=top></SPAN><SPAN style="COLOR: #000000"></< SPAN><SPAN style="COLOR: #000000">ec:table</SPAN><SPAN style="COLOR: #000000">></SPAN></DIV><BR><BR><BR> <H3 style="COLOR: #e75a08">New and Noteworthy 1.0.1-M3</H3> <P><SPAN>This build represents a massive refacoring of the handler code and includes a new limit package. I believe the state of the code is the best it has ever been and in general has really gone to a new level. This was initially sparked by a refactoring of the Pagination (now Limit) and Rows Displayed features but then trickled down into the handler code and also resulted in a new Limit and LimitFactory. </SPAN></P> <P><SPAN>Be sure to give yourself time to move to this release as you will need to fix your custom cells and views. I had to move some classes to different packages as things changed internally. The changes will make working with the eXtremeTable much easier and were unavoidable. </SPAN></P> <DIV> <H4>1. Things that changed and need to be aware of:</H4><SPAN> <UL> <LI>The Show All is no longer an option in the Rows Displayed droplist. It was confusing as the median and max rows would sometimes appear and sometimes go away. It was way to buggy also...you could filter the rows, select show all, and the hit clear. At that point you would display all the rows. <LI>The BaseModel moved from the base package to the core package as there is no base package left. <LI>The Limit, CollectionOfBeans, CurrentCollectionBean moved to the BaseModel. <LI>org.extremecomponents.table.base.ModelUtils --> (moved) org.extremecomponents.table.core.ExportFilterUtils <LI>The TableTag attribute rowsDisplayed="0" no longer has any meaning. If you would like to show all the rows then remove the pagination with the TableTag attribute showPagination="false". The reason for the change is because the rows displayed was reworked and the meaning dropped. Also, I could tell from code examples that many people were confused by the attribute and its meaning as both the showPagination="false" and rowsDisplayed="0" were used together. I would prefer one clear way to display all the rows. </LI></UL></SPAN></DIV> <DIV> <H4>2. Limit and LimitFactory</H4><SPAN> <P>Basically you just build a Limit object and it self populates with everything that you need to figure out the sorting, filtering, rowStart, rowEnd, page, currentRows and totalRows. You used to have to deal with Strings and Maps versus now you work with simple intuitive objects and ints. I also use the Limit object internally with a different factory. </P> <P>This is all you have to do: </P><PRE> Limit limit = LimitFactory.createInstanceOfLimit(request, tableId); LimitFactory.setLimitFilterAndSortAttr(limit); //once you know the total rows LimitFactory.setLimitPageAndRowAttr(limit, DEFAULT_ROWS_DISPLAYED, totalRows);</PRE> <P>The example demonstrates how to work in a Controller (Spring) or Action (Struts). </P> <P>Then in your JSP set the callbacks to point to the LimitCallback. </P><PRE><ec:table retrieveRowsCallback="org.extremecomponents.table.callback.LimitCallback" filterRowsCallback="org.extremecomponents.table.callback.LimitCallback" sortRowsCallback="org.extremecomponents.table.callback.LimitCallback" ... ></PRE></SPAN></DIV> <DIV> <H4>3. Enhancements</H4><SPAN> <UL> <LI>If you hard coded in any of the filter parameters then be sure to look at the TableContants class to see how they changed. The URL is more of a code than something you can read now. </LI></UL></SPAN></DIV> <DIV> <H4>4. Bugs Fixed</H4><SPAN> <UL> <LI>Fixed the FOP errors messages associated with the PDF Export View. <LI>If the filter is invoked with no filter criteria the table no longer tries to match empty results. The effect before was the table would show no results, and now just remains the same. <LI>Removed org.extremecomponents.table.tag.TableTagExtraInfo </LI></UL></SPAN></DIV></SPAN></SPAN></SPAN><img src ="http://www.tkk7.com/davidxu/aggbug/11316.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/davidxu/" target="_blank">涓鍑ITO</a> 2005-08-27 15:09 <a href="http://www.tkk7.com/davidxu/archive/2005/08/27/11316.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Excel 綆鏄庢搷浣?http://www.tkk7.com/davidxu/archive/2005/08/27/11291.html涓鍑ITO涓鍑ITOSat, 27 Aug 2005 03:30:00 GMThttp://www.tkk7.com/davidxu/archive/2005/08/27/11291.htmlhttp://www.tkk7.com/davidxu/comments/11291.htmlhttp://www.tkk7.com/davidxu/archive/2005/08/27/11291.html#Feedback3http://www.tkk7.com/davidxu/comments/commentRss/11291.htmlhttp://www.tkk7.com/davidxu/services/trackbacks/11291.html絎竴绔?/SPAN> 鎬諱綋璇存槑... 2

鍓嶈█... 2

鎿嶄綔鐣岄潰... 2

絎簩绔?/SPAN> 瀹炰緥鎿嶄綔... 2

鎴愮嘩鍗曞疄渚?/SPAN>... 2

絎笁绔?/SPAN> 鍏跺畠琛ュ厖... 2

    鏍煎紡鍖?/FONT>... 3

    鎵撳嵃... 5

 

絎竴绔?/SPAN> 鎬諱綋璇存槑

鍓嶈█

MS璁捐鐨?/SPAN>office濂楄姣忎竴涓兘鏈夊叾涓撴敞錛屾瘡涓鏂歸潰閮戒負鐢ㄦ埛鐫鎯籌紝涓嶈兘涓嶈禐錛屼漢瀹惰禋閽辨槸涓虹敤鎴鋒兂鍒版渶濂斤紒錛?/SPAN>

Excel榪欐槸涓涓敤浜庡緩绔嬩笌浣跨敤鐢靛瓙鎶ヨ〃(琛ㄦ牸)鐨勫疄鐢ㄧ▼搴忥紝浠ヨ〃鏍肩殑褰㈠紡鏉ュ偍瀛樻暟鎹紝鏀寔涓鏁村鍑芥暟鎿嶄綔錛屾柟渚跨粺璁′互鍙婃墦鍗般?BR>     鏃犺鏄儲鍔¢儴闂ㄥ埗浣滃伐璧勮〃榪樻槸鏁欏笀鑱屽伐鍒朵綔瀛︾敓鎴愮嘩琛紝鏃犻渶寰堝己鐨勭數鑴戞搷浣滆兘鍔涳紝閮借兘蹇熷埗琛?
pay.gif

mark.gif


鎿嶄綔鐣岄潰

鍏堜簡瑙d竴浜涙蹇碉細
宸ヤ綔綈?/U>: Excel涓畾涔変竴涓?/SPAN>EXCEL鏂囦歡灝辨槸涓涓伐浣滅翱錛屽伐浣滅翱涓彲浠ユ斁N寮犳湁鐩稿叧鐨勫伐浣滆〃銆?/SPAN>
宸ヤ綔琛?/U>: 鑻ュ共涓伐浣滆〃緇勬垚涓涓伐浣滅翱錛?/SPAN>EXCEL鏂囦歡錛夛紝宸ヤ綔琛ㄤ箣闂村彲浠?SPAN class=article>浣跨敤鐗瑰畾鐨勬柟娉曠浉浜掑紩鐢ㄦ暟鎹?/SPAN>.
             濡備笅鍥撅細鏈涓嬮潰鐨凷heet1 Sheet2絳夊氨鏄竴涓竴涓伐浣滆〃錛屽彲鑳介氳繃鍙屽嚮灝嗗叾鏀瑰悕錛屼互鍙婂彸閿柊澧炲姞宸ヤ綔琛紟

琛ㄦ牸閫氬父涓涓伐浣滆〃涓嚦灝戝寘鍚竴涓〃鏍鹼紝琛ㄦ牸鍙敱琛ㄥご錛屽垪(Excel涓互A銆丅銆丆絳夊瓧姣嶈〃紺?錛岃(Excel涓互1銆?銆?鏁板瓧琛ㄧず)緇勬垚.
鍗曞厓錛氬崟鍏冩槸鏈灝忕殑鍗曚綅錛屽崟鍏冮夊畾鐨勮涓庡垪緇勬垚錛?BR>          渚嬪A鍒楃殑絎竴琛屽氨鏄疉1鍗曞厓,B鍒楃殑絎叚琛屽氨鏄疊6鍗曞厓

鍑芥暟: excel涓彁渚涗竴鏁村鍑芥暟鍏紡鏂逛究鐢ㄦ埛榪涜鏁版嵁緇熻涓庤繍綆? 濡侫VERAGE(D3:D8)銆鎰忔寚緇熻D3-D8鐨勫鉤鍧囧垎.

濡備笅鍥懼彲浠ョ洿瑙傚湴浜嗗鍏舵湁涓ぇ姒傜殑浜嗚В:
exceltable.gif

絎簩绔?/SPAN> 瀹炰緥鎿嶄綔

鎴愮嘩鍗曞疄渚?/SPAN>

1銆佸埗浣滆〃澶?/SPAN>
閫夋嫨鑼冨洿,璁劇疆鍗曞厓鏍煎睘鎬?/SPAN>

newexcel.gif

瀵歸綈鍏ㄥ茍鍗曞厓鏍?BR>unitecell.gif

鍦?[瀵歸綈]鏍囩涓璠鍚堝茍鍗曞厓鏍糫鎿嶄綔錛屽茍鍦ㄥ瓧浣撲腑璁劇疆鍔犵矖錛岃緭鍏ワ紓瀛︾敓鎴愮嘩琛紓銆鏁堟灉濡備笅:

btitle.gif

2銆佽緭鍏ヨ澶?浠ュ強鐩稿叧鐨勫熀紜鏁版嵁
鐐瑰嚮鍗曞厓錛坈ell錛夊垎鍒綍鍏ョ浉鍏崇殑鏁版嵁錛屽お綆鍗曪紝榪欓噷璺寵繃錛氾級

tableDemo.gif

3銆佸嚱鏁頒嬌鐢?BR>
榪欓噷涓昏瀛︿範鐨勬槸鍑芥暟鐨勪嬌鐢紝浠ュ叾涓瑼VERAEG涓轟緥璇存槑

A.鐐歸夎褰曞叆鐨勫崟鍏?/FONT>

B.鎻掑叆鍑芥暟
function.jpg

C.閫夋嫨瑕佽繘琛屽鉤鍧囧垎鐨勫崟鍏?BR>function[2].gif

OK,榪欐牱灝卞畬鎴愪簡緇熻璇枃騫沖潎鎴愮嘩鐨勫伐浣滐紟
瑙傚療涓涓嬩笂闈㈢殑鍑芥暟鍏徃涓?=AVERAGE(C3,C4,C5,C6,C7,C8)銆
鍏跺疄濡傛灉鎴戜滑鐔熸倝鐩稿叧鐨勫嚱鏁幫紝鍙互鍦ㄨ緭鍏ユ涓洿鎺ヨ緭鍏?=AVERAGE(C3:C8) 涔熻揪鍒板悓鏍風殑鏁堟灉.

絎笁绔?/SPAN>
鍏跺畠琛ュ厖
1.鏍煎紡鍖?BR>鏂囧瓧绔栫潃鏉?BR>鏈夋椂鍊欐垜浠灝嗕竴浜涙枃瀛楁牸寮忓寲鎴愮珫璧鋒潵鐨勬晥鏋滐紝excel鎿嶄綔涔熸尯綆鍗?/FONT>
exceltext.gif


2.鎵撳嵃
璁劇疆鎵撳嵃欏剁鏍囬琛?BR>鏈夋椂鍊欒〃鏍煎お闀匡紝鎵撳嵃鍑烘潵鍚庝細鍒嗛〉錛岀劧鑰屾垜浠澶存槸涓嶅彉錛屽笇鏈涘畠鑳藉湪姣忎竴欏電殑欏靛ご閮借兘鎵撳嚭鏉ワ紟
絎竴欏碉細


page1.gif

絎簩欏?
page2.gif

榪欑鎯呭喌鎴戜滑灝辮璁劇疆欏剁鏍囬琛?

鍏蜂綋鎿嶄綔:
鏂囦歡- 欏甸潰灞炴?- 宸ヤ綔琛?錛嶉《绔爣棰樿錛嶃鐒跺悗鐐瑰嚮閫夋嫨姣忎簩琛岋紙鍦ㄨ繖閲岀浜岃鏄《绔爣棰樿錛?/FONT>

excelthead.gif




]]>
[other] office "鍔炲叕涓夊墤瀹?http://www.tkk7.com/davidxu/archive/2005/08/27/11177.html涓鍑ITO涓鍑ITOSat, 27 Aug 2005 02:47:00 GMThttp://www.tkk7.com/davidxu/archive/2005/08/27/11177.htmlhttp://www.tkk7.com/davidxu/comments/11177.htmlhttp://www.tkk7.com/davidxu/archive/2005/08/27/11177.html#Feedback0http://www.tkk7.com/davidxu/comments/commentRss/11177.htmlhttp://www.tkk7.com/davidxu/services/trackbacks/11177.html鏈漢甯翰鎴氭湅鍙嬭鏈轟笉涓嬪崄鍙幫紝
浣跨敤鑰呬粠澶х殑涓夊洓鍗佸瞾鍒板皬鐨勫崄鏉ュ瞾閮芥湁,鍩烘湰涓婄洰鐨勯兘寰堟槑紜斺斺斺斿涔?宸ヤ綔闇瑕併?BR>鎴戜及璁¢殢鐫紺句細鍙戝睍錛岀數鑴戞櫘鍙婄巼浼氭洿楂橈紝鍒版椂瑁呮満鍙兘浼氳薄鐜板湪鑿滃競鍦轟竴鏍鳳細錛?BR>   鍏充簬淇℃伅鍖栫殑璇濋鍙兘璇翠笂N澶╀篃璇翠笉瀹岋紝浠婂ぉ灝變笉鎵緱澶繙,涓昏浠嬬粛涓涓媜ffice "鍔炲叕涓夊墤瀹?錛?BR>娉ㄦ剰榪欒竟璇寸殑涓嶆槸緗戦〉鍒朵綔鏈変笁鍓戝錛圖W,FW,FLASH錛?鑰屾槸寰蔣鍏徃鐨刼ffice杞歡涓殑word,excel,powerpoint銆?BR>鍥犱負瀹墮噷鏈夊紵寮熷濡逛滑榪樺湪璇誨垵涓侀珮涓紝浜嗚В鍒頒粬浠殑璇劇▼涓棭鏈夎綆楁満
榪欓棬璇撅紝鍚榪樻槸瀛︾綉欏靛埗浣滅瓑鐨勶紝鍝堬紝鍚潵鏈夌偣鎼炵瑧錛屼笉鎳傚緱涓轟粈涔堣繖鏍瘋璁¤紼嬶紒
    涓漢璁や負錛岀幇鍦ㄤ腑灝忓鐢熸渶闇瑕佸涔犵殑璁$畻鏈烘妧鑳藉叾瀹炲簲璇ヤ笌瀹為檯紺句細闇姹傜浉鍚誨悎錛屽氨鏄姙鍏蔣浠剁殑搴旂敤錛屽師鍥犲緢綆鍗曪紝
榪欎簺涓滆タ涓嶇瀵逛簬涓漢榪樻槸浠ュ悗宸ヤ綔閮芥槸蹇呬慨璇俱?BR>    鏈夊垢鍑虹敓鍦ㄤ俊鎭寲鐨勬椂浠o紝鎰熷彈榪囦俊鎭寲緇欎簣鎴戜互鍙婃垜鐨勫伐浣滃甫鏉ョ殑濂藉錛屼綋楠岃繃韜竟鏈嬪弸鐨勯渶瑕?
    鍦ㄨ繖閲屼互鎴戜釜浜虹粡楠岋紝鎬葷粨涓涓嬶紝涓繪墦涓変釜:
   
    鏂囨。緙栧啓--word
    琛ㄦ牸鍒朵綔--excel
    婕旂ず錛岃浠跺埗浣?-powerpoint
   
娉?鏂囩珷閮ㄥ垎鏄墠鏃墮棿涓哄閲屼竴浜涙湅鍙嬪啓鐨?鐜板湪鎷垮嚭鏉ヤ笌澶у鍒嗕韓涓涓嬨?BR>   鏈枃浠嬬粛鐨勬槸涓浜涘熀紜錛屼篃鏄疄鐢ㄧ殑涓滆タ錛岄傚悎瀵硅繖鏂歸潰浜嗚В鐢氬皯鐨勬湅鍙?)
  
 
   Windows 鏂囨湰鎿嶄綔杞歡浣跨敤璇存槑
  
   excel綆鏄庢搷浣?/A>
  
   powerpoint 瀹炴搷鎸囧崡
  
  


]]>
Window 鏂囨湰鎿嶄綔杞歡浣跨敤璇存槑http://www.tkk7.com/davidxu/archive/2005/08/26/11180.html涓鍑ITO涓鍑ITOFri, 26 Aug 2005 02:53:00 GMThttp://www.tkk7.com/davidxu/archive/2005/08/26/11180.htmlhttp://www.tkk7.com/davidxu/comments/11180.htmlhttp://www.tkk7.com/davidxu/archive/2005/08/26/11180.html#Feedback2http://www.tkk7.com/davidxu/comments/commentRss/11180.htmlhttp://www.tkk7.com/davidxu/services/trackbacks/11180.html闃呰鍏ㄦ枃

]]>
[BI] 閮ㄥ垎鍟嗕笟鏅鴻兘鍙婃姤琛ㄥ伐鍏蜂竴瑙?/title><link>http://www.tkk7.com/davidxu/archive/2005/08/20/BIReportTools.html</link><dc:creator>涓鍑ITO</dc:creator><author>涓鍑ITO</author><pubDate>Sat, 20 Aug 2005 04:44:00 GMT</pubDate><guid>http://www.tkk7.com/davidxu/archive/2005/08/20/BIReportTools.html</guid><wfw:comment>http://www.tkk7.com/davidxu/comments/10580.html</wfw:comment><comments>http://www.tkk7.com/davidxu/archive/2005/08/20/BIReportTools.html#Feedback</comments><slash:comments>4</slash:comments><wfw:commentRss>http://www.tkk7.com/davidxu/comments/commentRss/10580.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/davidxu/services/trackbacks/10580.html</trackback:ping><description><![CDATA[<FONT color=#000000><FONT size=4><STRONG><FONT size=5>涓銆?Microsoft Office Web Components</FONT><BR><BR><IMG height=116 alt=officeComponents.gif src="http://www.tkk7.com/images/blogjava_net/davidxu/officeComponents.gif" width=357 border=0><BR><BR></STRONG>Spreadsheets<BR><STRONG><IMG height=138 alt=excel.gif src="http://www.tkk7.com/images/blogjava_net/davidxu/excel.gif" width=295 border=0></STRONG>  </FONT></FONT><BR><STRONG>Charts</STRONG><BR><IMG height=401 alt=chart.gif src="http://www.tkk7.com/images/blogjava_net/davidxu/chart.gif" width=601 border=0><BR><BR><FONT size=4><STRONG><FONT size=5>浜屻丱pen Source</FONT><BR><BR>1 銆乸entaho<BR></STRONG>Project Home Page: </FONT><A ><STRONG><FONT size=4>http://www.pentaho.org/</FONT></STRONG></A><BR><FONT size=4><IMG height=86 alt=de_logo.png src="http://www.tkk7.com/images/blogjava_net/davidxu/de_logo.png" width=219 border=0><BR><BR><STRONG>2銆乷perni</STRONG></FONT><BR><A ><BR><FONT color=#000000>Project Home Page:</FONT>  http://openi.sourceforge.net/</A><FONT color=#800080><BR><U><IMG height=82 alt=openi-logo-with-tag[1].jpg src="http://www.tkk7.com/images/blogjava_net/davidxu/openi-logo-with-tag[1].jpg" width=200 border=0><BR><BR></U><FONT color=#000000>婕旂ず:</FONT>   <A >http://demo.openi.org/</A>          <FONT color=#000000>鐢ㄦ埛錛歵omcat  瀵嗙爜錛歴hallow</FONT><BR><FONT color=#000000>浠嬬粛:</FONT> <U>http://openi.sourceforge.net/open_source_BI-openi_story.PDF</U><BR><BR><BR><FONT color=#000000 size=4><STRONG>3銆丣asperReports</STRONG></FONT><BR><FONT color=#000000>Project Home Page:</FONT> <A >http://jasperreports.sourceforge.net/</A><BR></FONT><IMG height=25 alt=jasperreports[1].png src="http://www.tkk7.com/images/blogjava_net/davidxu/jasperreports[1].png" width=139 border=0><BR><BR><BR><span id="mzjmpzg" class=indextop><STRONG><FONT size=4>4銆丒clipse BIRT Project</FONT></STRONG></SPAN> <BR>Project Home Page: <A >http://www.eclipse.org/birt</A><BR><BR><STRONG><FONT size=4>5銆乯freechar</FONT></STRONG><BR>Project Home Page: <A >http://www.jfree.org/jfreechart<BR></A><BR><BR>鍏跺畠鐩稿叧 錛氱敓xsl 錛宲df<BR>jakarta poi    <A >http://jakarta.apache.org/poi/</A><BR>itext  <A >http://www.lowagie.com/iText</A><BR>FOP  <A >http://xml.apache.org/fop/index.html</A><BR><BR>鍚庢敞錛氭湰绔欏皢涓嶅畾鏈熷彂甯冪浉鍏崇殑搴旂敤鏂囩珷:)<BR><BR><BR><BR><img src ="http://www.tkk7.com/davidxu/aggbug/10580.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/davidxu/" target="_blank">涓鍑ITO</a> 2005-08-20 12:44 <a href="http://www.tkk7.com/davidxu/archive/2005/08/20/BIReportTools.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>涓変釜灝弔ipshttp://www.tkk7.com/davidxu/archive/2005/08/18/10458.html涓鍑ITO涓鍑ITOThu, 18 Aug 2005 11:21:00 GMThttp://www.tkk7.com/davidxu/archive/2005/08/18/10458.htmlhttp://www.tkk7.com/davidxu/comments/10458.htmlhttp://www.tkk7.com/davidxu/archive/2005/08/18/10458.html#Feedback0http://www.tkk7.com/davidxu/comments/commentRss/10458.htmlhttp://www.tkk7.com/davidxu/services/trackbacks/10458.html灝忓皬鐨則ips璁板綍涓涓?

涓銆佸彇鍥瀖ysql ROOT綆$悊鍛樺瘑鐮?/STRONG>
         [1] 璺寵繃MySQL鐨勮闂帶鍒?BR>              榪涘叆CMD鍛戒護琛?nbsp;      
              C:\mysql\bin > mysqld-nt --skip-grant-tables&
             榪欐牱浠諱綍浜洪兘鍙互鍦ㄤ互綆$悊鍛樼殑韜喚榪涘叆MySQL,涓轟慨鏀筊OOT瀵嗙爜鎻愪緵鍓嶆彁鏉′歡.
         [2] 鎺у埗鍙拌繘鍏ysql
               C:\mysql\bin>mysql
               mysql> select * from mysql.user;          //鏌ョ敤鎴瘋〃
               mysql> update mysql.user set password=password('david') where user='root';
               mysql>commit;
               閲嶅惎mysql鏈嶅姟鍗沖彲鐢ㄥ垰鎵嶆垜浠緗殑'david'瀵嗙爜鐧誨綍浜?)
     
浜屻佺敤jsp鏂囦歡瀛樻斁CSS
        閫氬父鎴戜滑鏈夎繖鏍風殑闇瑕侊紝鍦跡錛籌汲涓畾涔夊浘鐗囦互鍙婁竴浜涳績錛達跡鏂囦歡錛?BR>鐒惰屽湪緙栧啓榪囩▼涓紝鎴戜滑鐨勪唬鐮佹諱細璞¤繖鏍?
background: #66A1D5 url(../images/headBg.gif) center left repeat;

form input.Rootcalendar 
{
    width
: 65px;
    behavior
: url(../js/calendar.htc)
}


       浣跨敤鐩稿璺緞鐨勫艦寮忥紝榪欐牱鍋氭湁涓涓檺鍒訛紝灝辨槸璋冪敤鏂囦歡鐨勮礬寰勪竴瀹氭槸鍥哄畾鐨勶紟
鐒惰屽綋姣旇緝娣卞叆鐨勬枃浠惰皟鐢ㄦ椂錛屽氨浼氭壘涓嶅埌鐩稿簲鐨勫浘鐗囨垨鐩稿叧鐨勮祫婧愶紟
       濂藉湪jstl <c:url value=""/> 緇欐垜浠彁渚涗簡涓縐嶈В鍐蟲柟妗?鐒惰岃姹俢ss鏀懼埌jsp涓繖鏍風殑闇瑕佸氨鏉ヤ簡,搴旂敤鎸虹畝鍗?BR>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
//鍘熸潵鐨勶跡錛籌汲浠g爜
鈥︹︹︹︹︹?BR>鈥︹︹︹︹︹?BR>鈥︹︹︹︹︹?BR>background: #66A1D5 url(<c:url value="/images/headBg.gif" />) center left repeat;

鈥︹︹︹︹︹?BR>鈥︹︹︹︹︹?BR>鈥︹︹︹︹︹?BR>鈥︹︹︹︹︹?BR>鈥︹︹︹︹︹?/FONT>

鍏跺畠欏甸潰涓皟鐢?BR>
<link rel="stylesheet" href="<c:url value="/css/style.jsp"/>" type="text/css">

 
涓夈佹棩鏈熸椂闂村嚱鏁?/STRONG>
        1銆丱racel 鐗?BR>        [1]鍙栧綋鏈堢殑鏃ュ瓙鏁?
               
select to_char(last_day(sysdate),'dd') from dual
//濡傛湰鏈?8鏈? - 31鏃?/SPAN>
               

        [2]EXTRACT鐨勫簲鐢紙鍙栧勾鏈堟棩錛?BR>
select EXTRACT(year FROM SYSDATE) from dual;
//鏈勾 2005
select EXTRACT(month FROM SYSDATE) from dual;
//鏈湀 8鏈堜喚
select EXTRACT(day FROM SYSDATE) from dual; 
//鏈棩 18鏃?/SPAN>


        2銆?nbsp;Mysql 鐗?BR>
(鏈枃鏈畬!!)


]]>
主站蜘蛛池模板: 亚洲AV无码专区在线观看成人| 久久亚洲精品11p| 久久亚洲精品无码| 亚洲精品乱码久久久久久久久久久久| 亚洲一区二区三区免费| 亚洲日本韩国在线| 久久精品国产亚洲Aⅴ香蕉| 中文字幕亚洲乱码熟女一区二区 | 亚洲AV色欲色欲WWW| 亚洲中文字幕无码mv| 亚洲Av无码国产一区二区| 国产亚洲一卡2卡3卡4卡新区 | 亚洲av无码片vr一区二区三区| 久久人午夜亚洲精品无码区| 亚洲AV无码专区在线电影成人| 边摸边吃奶边做爽免费视频99| 一级做a爰黑人又硬又粗免费看51社区国产精品视 | 99久久这里只精品国产免费| 欧洲乱码伦视频免费| 久久免费观看国产精品88av| av电影在线免费看| a级毛片毛片免费观看永久| 日韩免费无码一区二区三区| 四虎最新永久免费视频| 欧洲美熟女乱又伦免费视频| 亚洲一级毛片免费看| 午夜a级成人免费毛片| 亚洲A∨午夜成人片精品网站| 中文字幕亚洲乱码熟女一区二区| 亚洲高清在线视频| 亚洲www77777| japanese色国产在线看免费| 久久免费看少妇高潮V片特黄| 国产精品久久久久免费a∨| 国产一级一片免费播放| 国产伦精品一区二区三区免费下载 | 99久久这里只精品国产免费| 免费国产成人午夜电影| 精品久久香蕉国产线看观看亚洲 | 四虎免费永久在线播放| 国产亚洲综合网曝门系列|