锘??xml version="1.0" encoding="utf-8" standalone="yes"?>男人的天堂亚洲一区,你懂的免费在线观看视频网站,欧美裸体bbwbbwbbwhttp://www.aygfsteel.com/linlin2005/archive/2012/06/18/381018.htmllubaolinlubaolinMon, 18 Jun 2012 09:11:00 GMThttp://www.aygfsteel.com/linlin2005/archive/2012/06/18/381018.htmlhttp://www.aygfsteel.com/linlin2005/comments/381018.htmlhttp://www.aygfsteel.com/linlin2005/archive/2012/06/18/381018.html#Feedback0http://www.aygfsteel.com/linlin2005/comments/commentRss/381018.htmlhttp://www.aygfsteel.com/linlin2005/services/trackbacks/381018.html
struts2鐨剆錛歩terator 鍙互閬嶅巻 鏁版嵁鏍堥噷闈㈢殑浠諱綍鏁扮粍錛岄泦鍚堢瓑絳?浠ヤ笅鍑犱釜綆鍗曠殑demo錛?br />s:iterator 鏍囩鏈?涓睘鎬э細
    value錛氳榪唬鐨勯泦鍚?br />    id   錛氭寚瀹氶泦鍚堥噷闈㈢殑鍏冪礌鐨刬d
    status 榪唬鍏冪礌鐨勭儲寮?/div>
1:jsp欏甸潰瀹氫箟鍏冪礌鍐欐硶 鏁扮粍鎴杔ist

<s:iterator value="{'1','2','3','4','5'}" id='number'>
    <s:property value='number'/>A
</s:iterator>
鎵撳嵃緇撴灉涓? 1A2A3A4A5A
2:绱㈠紩鐨勭敤娉?br />濡傛灉鎸囧畾浜唖tatus錛屾瘡嬈$殑榪唬鏁版嵁閮芥湁IteratorStatus鐨勫疄渚嬶紝瀹冩湁浠ヤ笅鍑犱釜鏂規硶
int getCount()榪斿洖褰撳墠榪唬浜嗗嚑涓厓绱?br />int getIndex()榪斿洖褰撳墠鍏冪礌绱㈠紩
boolean isEven()褰撶劧鐨勭儲寮曟槸鍚﹀伓鏁?br />boolean isFirst()褰撳墠鏄惁絎竴涓厓绱?br />boolean isLast()
boolean isOdd()褰撳墠鍏冪礌绱㈠紩鏄惁濂囨暟
<s:iterator value="{'a','b','c'}" id='char' status='st'>
    <s:if test="#st.Even">
        鐜板湪鐨勭儲寮曟槸濂囨暟涓?<s:property value='#st.index'/>
    </s:if>
    褰撳墠鍏冪礌鍊鹼細<s:property value='char'/>
</s:iterator>
3錛氶亶鍘唌ap
value鍙互鐩存帴瀹氫箟涓猴細
value="#{"1":"a","2":"b"}"
姣忎釜鍏冪礌浠ラ兘濂介殧寮銆傚厓绱犱箣闂寸殑key鍜寁alue 鍐掑彿闅斿紑
value涔熷彲浠ユ槸鏁版嵁鏍堥噷闈㈢殑java.util.Map瀵硅薄
閬嶅巻鍐欐硶濡備笅錛?/div>
<s:iterator value="map" id="id" status="st">
     key : <s:property value='key'/>
     value:<s:property vlaue='value'/>
</s:iterator>
褰撶劧key 鍜寁alue 閮藉彲浠ヤ嬌java 鐨?Object
3錛氶亶鍘嗘暟鎹爤.綆鍗曠殑List綾伙紝
List<Attr>
class Attr{String attrName;String getAttrName(){return "123";}}
<s:iterator value="label" id="id">
    <s:property value="#id.attrName" />
</s:iterator>
褰撶劧value 榪樺彲浠ュ啓鎴?value="%{label}" label鍙互鏈?鎿嶄綔
label鐨勫睘鎬ist 鍙互鍐欐垚value="%{label.list}" 鐩稿綋浜庯細getLabel().getList();
4錛氶亶鍘?涓猯ist錛?br />List<AttrName> attrN {color,size,style}
List<AttrValue> attrV {red,20,gay}
榪?涓猯ist鐨勫厓绱犳槸涓涓瀵瑰簲鐨勶紝涓涓猘ttrN瀵瑰簲涓涓猘ttrV
<s:iterator value="%{attrN }" id="id"   status="status">
index    is : <s:property value='status.index'/>
attrName is : <s:property value='id'/> or <s:property value='%{id}'/>
attrName is : <s:property value='%{attrV[#status.index]}'/>
</s:iterator>  
杞嚜錛?a href="http://www.aygfsteel.com/Reg/archive/2009/11/20/303085.html">http://www.aygfsteel.com/Reg/archive/2009/11/20/303085.html


lubaolin 2012-06-18 17:11 鍙戣〃璇勮
]]>濡備綍鎵懼洖鏄劇ず妗岄潰http://www.aygfsteel.com/linlin2005/archive/2011/04/21/348670.htmllubaolinlubaolinThu, 21 Apr 2011 01:11:00 GMThttp://www.aygfsteel.com/linlin2005/archive/2011/04/21/348670.htmlhttp://www.aygfsteel.com/linlin2005/comments/348670.htmlhttp://www.aygfsteel.com/linlin2005/archive/2011/04/21/348670.html#Feedback0http://www.aygfsteel.com/linlin2005/comments/commentRss/348670.htmlhttp://www.aygfsteel.com/linlin2005/services/trackbacks/348670.html

lubaolin 2011-04-21 09:11 鍙戣〃璇勮
]]>
HTML杞箟絎?/title><link>http://www.aygfsteel.com/linlin2005/archive/2010/09/07/331340.html</link><dc:creator>lubaolin</dc:creator><author>lubaolin</author><pubDate>Tue, 07 Sep 2010 10:30:00 GMT</pubDate><guid>http://www.aygfsteel.com/linlin2005/archive/2010/09/07/331340.html</guid><wfw:comment>http://www.aygfsteel.com/linlin2005/comments/331340.html</wfw:comment><comments>http://www.aygfsteel.com/linlin2005/archive/2010/09/07/331340.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/linlin2005/comments/commentRss/331340.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/linlin2005/services/trackbacks/331340.html</trackback:ping><description><![CDATA[     鎽樿: HTML瀛楃瀹炰綋錛圕haracter Entities錛夛紝杞箟瀛楃涓詫紙Escape Sequence錛? 涓轟粈涔堣鐢ㄨ漿涔夊瓧絎︿覆錛?HTML涓?lt;錛?gt;錛?amp;絳夋湁鐗規畩鍚箟錛?lt;錛?gt;錛岀敤浜庨摼鎺ョ錛?amp;鐢ㄤ簬杞箟錛夛紝涓嶈兘鐩存帴浣跨敤銆傝繖浜涚鍙鋒槸涓嶆樉紺哄湪鎴戜滑鏈緇堢湅鍒扮殑緗戦〉閲岀殑錛岄偅濡傛灉鎴戜滑甯屾湜鍦ㄧ綉欏典腑鏄劇ず榪欎簺絎﹀彿錛岃鎬庝箞鍔炲憿錛? 榪欏氨瑕佽鍒癏TML杞箟瀛楃涓詫紙Esca...  <a href='http://www.aygfsteel.com/linlin2005/archive/2010/09/07/331340.html'>闃呰鍏ㄦ枃</a><img src ="http://www.aygfsteel.com/linlin2005/aggbug/331340.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/linlin2005/" target="_blank">lubaolin</a> 2010-09-07 18:30 <a href="http://www.aygfsteel.com/linlin2005/archive/2010/09/07/331340.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>浣跨敤jzip鍋氭墦鍖呬笅杞?/title><link>http://www.aygfsteel.com/linlin2005/archive/2009/10/22/299360.html</link><dc:creator>lubaolin</dc:creator><author>lubaolin</author><pubDate>Thu, 22 Oct 2009 06:30:00 GMT</pubDate><guid>http://www.aygfsteel.com/linlin2005/archive/2009/10/22/299360.html</guid><wfw:comment>http://www.aygfsteel.com/linlin2005/comments/299360.html</wfw:comment><comments>http://www.aygfsteel.com/linlin2005/archive/2009/10/22/299360.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/linlin2005/comments/commentRss/299360.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/linlin2005/services/trackbacks/299360.html</trackback:ping><description><![CDATA[<p>import java.io.File;<br /> import java.io.FileInputStream;<br /> import java.io.IOException;<br /> import java.util.Date;</p> <p>import javax.servlet.ServletException;<br /> import javax.servlet.http.HttpServlet;<br /> import javax.servlet.http.HttpServletRequest;<br /> import javax.servlet.http.HttpServletResponse;</p> <p>import net.sf.jazzlib.ZipEntry;<br /> import net.sf.jazzlib.ZipOutputStream;</p> <p>public class BatchDownload extends HttpServlet {</p>  public BatchDownload() {<br />   super();<br />  }<br /> <p> public void doGet(HttpServletRequest request, HttpServletResponse response)<br />    throws ServletException, IOException {<br />   response.setContentType("APPLICATION/OCTET-STREAM");<br />   response.setHeader("Content-Disposition","attachment; filename="+this.getZipFilename());<br />   System.out.println("in BatchDownload................"); <br />   ZipOutputStream zos = new ZipOutputStream(response.getOutputStream());   <br />      File[] files = new File[2];<br />      files[0]=new File("c:/zip/鏂囦歡A.doc");<br />      files[1]=new File("c:/zip/鏂囦歡B.doc");<br />      zipFile(files, "", zos);   <br />      zos.flush();   <br />      zos.close();   </p> <p> }<br />  private void zipFile(File[] subs, String baseName, ZipOutputStream zos) throws IOException {     <br />       for (int i=0;i<subs.length;i++) {<br />        File f=subs[i];<br />        zos.putNextEntry(new ZipEntry(baseName + f.getName()));   <br />        FileInputStream fis = new FileInputStream(f);   <br />        byte[] buffer = new byte[1024];   <br />        int r = 0;   <br />        while ((r = fis.read(buffer)) != -1) {   <br />            zos.write(buffer, 0, r);   <br />        }   <br />        fis.close(); <br />       }<br />  }<br />  private String getZipFilename(){<br />   Date date=new Date();<br />   String s=date.getTime()+".zip";<br />   return s;<br />  }</p>  public void doPost(HttpServletRequest request, HttpServletResponse response)<br />    throws ServletException, IOException {<br />   this.doGet(request, response);<br />  }<br /> } <img src ="http://www.aygfsteel.com/linlin2005/aggbug/299360.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/linlin2005/" target="_blank">lubaolin</a> 2009-10-22 14:30 <a href="http://www.aygfsteel.com/linlin2005/archive/2009/10/22/299360.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>ORA-28547:榪炴帴鏈嶅姟鍣ㄥけ璐ワ紝鍙兘鏄疧racle Net綆$悊閿欒http://www.aygfsteel.com/linlin2005/archive/2009/09/21/295886.htmllubaolinlubaolinMon, 21 Sep 2009 09:19:00 GMThttp://www.aygfsteel.com/linlin2005/archive/2009/09/21/295886.htmlhttp://www.aygfsteel.com/linlin2005/comments/295886.htmlhttp://www.aygfsteel.com/linlin2005/archive/2009/09/21/295886.html#Feedback3http://www.aygfsteel.com/linlin2005/comments/commentRss/295886.htmlhttp://www.aygfsteel.com/linlin2005/services/trackbacks/295886.html
杞嚜錛歨ttp://blog.csdn.net/chenjuntj2007/archive/2009/07/04/4321640.aspx

lubaolin 2009-09-21 17:19 鍙戣〃璇勮
]]>
oracle鍒涘緩琛ㄧ┖闂?/title><link>http://www.aygfsteel.com/linlin2005/archive/2009/07/23/287980.html</link><dc:creator>lubaolin</dc:creator><author>lubaolin</author><pubDate>Thu, 23 Jul 2009 02:35:00 GMT</pubDate><guid>http://www.aygfsteel.com/linlin2005/archive/2009/07/23/287980.html</guid><wfw:comment>http://www.aygfsteel.com/linlin2005/comments/287980.html</wfw:comment><comments>http://www.aygfsteel.com/linlin2005/archive/2009/07/23/287980.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/linlin2005/comments/commentRss/287980.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/linlin2005/services/trackbacks/287980.html</trackback:ping><description><![CDATA[//鍒涘緩涓存椂琛ㄧ┖闂?<br /> <br /> create temporary tablespace test_temp <br /> tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf' <br /> size 32m <br /> autoextend on <br /> next 32m maxsize 2048m <br /> extent management local; <br /> <br /> //鍒涘緩鏁版嵁琛ㄧ┖闂?<br /> create tablespace test_data <br /> logging <br /> datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf' <br /> size 32m <br /> autoextend on <br /> next 32m maxsize 2048m <br /> extent management local; <br /> <br /> //鍒涘緩鐢ㄦ埛騫舵寚瀹氳〃絀洪棿 <br /> create user username identified by password <br /> default tablespace test_data <br /> temporary tablespace test_temp; <br /> <br /> //緇欑敤鎴鋒巿浜堟潈闄?<br /> <br /> grant connect,resource to username; <br /> <br /> //浠ュ悗浠ヨ鐢ㄦ埛鐧誨綍錛屽垱寤虹殑浠諱綍鏁版嵁搴撳璞¢兘灞炰簬test_temp 鍜宼est_data琛ㄧ┖闂達紝榪欏氨涓嶇敤鍦ㄦ瘡鍒涘緩涓涓璞$粰鍏舵寚瀹氳〃絀洪棿浜嗐?br /> <br /> 杞澆錛歨ttp://virgos.javaeye.com/blog/337976 <img src ="http://www.aygfsteel.com/linlin2005/aggbug/287980.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/linlin2005/" target="_blank">lubaolin</a> 2009-07-23 10:35 <a href="http://www.aygfsteel.com/linlin2005/archive/2009/07/23/287980.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>SSH-ERROR:org.hibernate.LazyInitializationException: failed to lazily initializehttp://www.aygfsteel.com/linlin2005/archive/2009/07/03/285366.htmllubaolinlubaolinFri, 03 Jul 2009 08:19:00 GMThttp://www.aygfsteel.com/linlin2005/archive/2009/07/03/285366.htmlhttp://www.aygfsteel.com/linlin2005/comments/285366.htmlhttp://www.aygfsteel.com/linlin2005/archive/2009/07/03/285366.html#Feedback0http://www.aygfsteel.com/linlin2005/comments/commentRss/285366.htmlhttp://www.aygfsteel.com/linlin2005/services/trackbacks/285366.htmlstruts2+spring2.x+hibernate3.x 鎳掑姞杞藉紓甯革細org.hibernate.LazyInitializationException: failed to lazily initialize

Hibernate鐨凩azy鍒濆鍖?:n鍏崇郴鏃訛紝蹇呴』淇濊瘉鏄湪鍚屼竴涓猄ession鍐呴儴浣跨敤榪欎釜鍏崇郴闆嗗悎錛屼笉鐒禜iernate灝嗘姏鍑哄紓甯革細org.hibernate.LazyInitializationException: failed to lazily initialize of....
涓ょ澶勭悊鏂規硶錛?br /> 涓銆佽緗甽azy=false錛屾鏂規硶涓嶅啀绱堪銆?br /> 浜屻佺敤OpenSessionInViewFilter榪囨護鍣紝娉ㄦ剰hibernateFilter榪囨護鍣ㄥ拰struts2榪囨護鍣ㄥ湪鏄犲皠鏃剁殑鍏堝悗欏哄簭銆傚悓鏃惰閰嶇疆浜嬬墿澶勭悊錛屽惁鍒欎細瀵艱嚧session澶勪簬鍙鐘舵佽屼笉鑳藉仛淇敼銆佸垹闄ょ殑鍔ㄤ綔銆?br /> 鍗沖湪web.xml鏂囦歡涓涓嬮厤緗細
     <!-- Spring ApplicationContext閰嶇疆鏂囦歡鐨勫姞杞界洰褰曘?-->  
 <context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>classpath*:spring/applicationContext.xml</param-value>
 </context-param>

 <!-- 瑙e喅寤惰繜鍔犺澆鐨勯棶棰?-->
 <filter>
  <filter-name>hibernateFilter</filter-name>
  <filter-class>
   org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
  </filter-class>
 </filter>
 
 <!-- 緇ф壙Struts2鐨凢ilterDispatcher綾伙紝鍏峰GBK絳夌紪鐮佽瀹氬姛鑳戒笌struts2鐨刟ction榪囨護鍔熻兘銆?-->
 <filter>
  <filter-name>struts2</filter-name>
  <filter-class>
   com.iman.nrms.opm.web.common.FilterDispatcher
  </filter-class>
  <init-param>
   <param-name>encoding</param-name>
   <param-value>GBK</param-value>
  </init-param>
 </filter>
 <filter>
         <filter-name>struts-cleanup</filter-name>
         <filter-class>
             org.apache.struts2.dispatcher.ActionContextCleanUp
         </filter-class>
     </filter>
 
 <filter-mapping>
  <filter-name>hibernateFilter</filter-name>
  <url-pattern>/*</url-pattern>
 </filter-mapping>
 
 <filter-mapping>
  <filter-name>struts2</filter-name>
  <url-pattern>/*</url-pattern>
 </filter-mapping>
 
 <filter-mapping>
  <filter-name>struts-cleanup</filter-name>
  <url-pattern>/*</url-pattern>
 </filter-mapping>

Hibernate 鍏佽瀵瑰叧鑱斿璞°佸睘鎬ц繘琛屽歡榪熷姞杞斤紝浣嗘槸蹇呴』淇濊瘉寤惰繜鍔犺澆鐨勬搷浣滈檺浜庡悓涓涓?Hibernate Session 鑼冨洿涔嬪唴榪涜銆傚鏋?Service 灞傝繑鍥炰竴涓惎鐢ㄤ簡寤惰繜鍔犺澆鍔熻兘鐨勯鍩熷璞$粰 Web 灞傦紝褰?Web 灞傝闂埌閭d簺闇瑕佸歡榪熷姞杞界殑鏁版嵁鏃訛紝鐢變簬鍔犺澆棰嗗煙瀵硅薄鐨?Hibernate Session 宸茬粡鍏抽棴錛岃繖浜涘鑷村歡榪熷姞杞芥暟鎹殑璁塊棶寮傚父銆傝孲pring涓烘垜浠彁渚涚殑OpenSessionInViewFilter榪囨護鍣ㄤ負鎴戜滑寰堝ソ鐨勮В鍐充簡榪欎釜闂銆侽penSessionInViewFilter鐨勪富瑕佸姛鑳芥槸浣挎瘡涓姹傝繃紼嬬粦瀹氫竴涓?Hibernate Session錛屽嵆浣挎渶鍒濈殑浜嬪姟宸茬粡瀹屾垚浜嗭紝涔熷彲浠ュ湪 Web 灞傝繘琛屽歡榪熷姞杞界殑鎿嶄綔銆侽penSessionInViewFilter 榪囨護鍣ㄥ皢 Hibernate Session 緇戝畾鍒拌姹傜嚎紼嬩腑錛屽畠灝嗚嚜鍔ㄨ Spring 鐨勪簨鍔$鐞嗗櫒鎺㈡祴鍒般傛墍浠?OpenSessionInViewFilter 閫傜敤浜?Service 灞備嬌鐢℉ibernateTransactionManager 鎴?JtaTransactionManager 榪涜浜嬪姟綆$悊鐨勭幆澧冿紝涔熷彲浠ョ敤浜庨潪浜嬪姟鍙鐨勬暟鎹搷浣滀腑銆?
request-->open session-->鎵撳紑榪炴帴銆佸紑濮嬩簨鍔?->鎸佷箙鎿嶄綔-->娓叉煋錛堝叧闂繛鎺ャ乻ession錛?->response 鍏朵腑涓浜涜繃紼嬬渷鐣ヤ簡錛屼笉鏄緢鍏沖績銆?/p>

 

寮曡嚜錛?a >http://blog.csdn.net/fhwbj/archive/2009/03/25/4022805.aspx



lubaolin 2009-07-03 16:19 鍙戣〃璇勮
]]>
eclipse涓嬪畨瑁卝s鎻掍歡-spket(鏀寔Ext)http://www.aygfsteel.com/linlin2005/archive/2009/04/06/264158.htmllubaolinlubaolinMon, 06 Apr 2009 14:20:00 GMThttp://www.aygfsteel.com/linlin2005/archive/2009/04/06/264158.htmlhttp://www.aygfsteel.com/linlin2005/comments/264158.htmlhttp://www.aygfsteel.com/linlin2005/archive/2009/04/06/264158.html#Feedback0http://www.aygfsteel.com/linlin2005/comments/commentRss/264158.htmlhttp://www.aygfsteel.com/linlin2005/services/trackbacks/264158.html Name: "Spket", Url: "http://www.spket.com/update/"涓嬭澆瀹屾瘯閲嶅惎 Eclipse

2銆乄indow -> Preferences -> Spket -> JavaScript Profiles -> New 錛?
杈撳叆“ExtJS”鐐瑰嚮OK錛?
閫夋嫨“ExtJS” 騫剁偣鍑?#8220;Add Library”鐒跺悗鍦ㄤ笅鎷夋潯涓夊彇“ExtJS”錛?
閫夋嫨 “ExtJS”騫剁偣鍑?#8220;Add File”錛岀劧鍚庡湪浣犵殑./ext-2.x/source鐩綍涓夊彇“ext.jsb” 鏂囦歡錛?

3銆佽緗柊鐨凟xtJS Profile錛岄変腑騫剁偣鍑?#8220;JavaScript Profiles” 瀵硅瘽妗嗗彸鎵嬭竟鐨?#8220;Defalut”鎸夐挳錛?

4銆丣S鎵撳紑鏂瑰紡涓?Window -> Preferences ->General-> Editors-> File...閫夋嫨JS  涓?Spket JavaScript Editor(default)

lubaolin 2009-04-06 22:20 鍙戣〃璇勮
]]>
絎竴嬈¤瘯姘寸郴緇熷垎鏋愬笀鑰冭瘯http://www.aygfsteel.com/linlin2005/archive/2008/07/21/216350.htmllubaolinlubaolinMon, 21 Jul 2008 06:34:00 GMThttp://www.aygfsteel.com/linlin2005/archive/2008/07/21/216350.htmlhttp://www.aygfsteel.com/linlin2005/comments/216350.htmlhttp://www.aygfsteel.com/linlin2005/archive/2008/07/21/216350.html#Feedback0http://www.aygfsteel.com/linlin2005/comments/commentRss/216350.htmlhttp://www.aygfsteel.com/linlin2005/services/trackbacks/216350.html鍗婂勾鍓嶏紝鎶ヨ冧簡緋葷粺鍒嗘瀽甯堬紝涔熸病鎬庝箞鐪嬩功,鍙槸鎶辯潃璇曡瘯姘存湁澶氭繁鐨勬兂娉曞幓鑰冪殑錛岀粨鏋滄棦鍦ㄦ垜鎰忔枡涔嬩腑錛屼篃鍦ㄦ垜鎰忔枡涔嬪錛屽緱浜嗕釜39/33/39錛屽彧宸?/12/6鍒嗗氨鍙互閫氳繃浜嗭紝灝ゅ叾鏄鏂?灞呯劧寰椾簡39鍒嗭紝鐪嬫潵榪樻槸鏈夊笇鏈涚殑錛屾墍浠ュ喅瀹氬啀嬈″啿鍑伙紝騫朵互姝ゅ仛涓哄鉤鍙幫紝緇冧範璁烘枃鍐欎綔錛屽亣濡傚啓涓綃囪鏂囧氨鍜屽啓涓綃囨棩璁頒竴鏍鋒墜鍒版搾鏉?..........



lubaolin 2008-07-21 14:34 鍙戣〃璇勮
]]>
oracle 瀵瑰垪姹傜Н http://www.aygfsteel.com/linlin2005/archive/2008/07/21/216347.htmllubaolinlubaolinMon, 21 Jul 2008 06:26:00 GMThttp://www.aygfsteel.com/linlin2005/archive/2008/07/21/216347.htmlhttp://www.aygfsteel.com/linlin2005/comments/216347.htmlhttp://www.aygfsteel.com/linlin2005/archive/2008/07/21/216347.html#Feedback0http://www.aygfsteel.com/linlin2005/comments/commentRss/216347.htmlhttp://www.aygfsteel.com/linlin2005/services/trackbacks/216347.htmlSQL> select * from t1;

        N1 V1                NID
---------- ---------- ----------
         1 aa                 61
         2 aa                 62
         3 bb                 83
         4 aa                 64

SQL> select exp(sum(ln(nid))) from t1 where v1='aa';

EXP(SUM(LN(NID)))
-----------------
           242048

宸茬敤鏃墮棿:  00: 00: 00.02

楠岃瘉涓涓?)
SQL> select 61*62*64 from dual;

  61*62*64
----------
    242048

宸茬敤鏃墮棿:  00: 00: 00.00

鍏堝垎緇勭劧鍚庢眰縐?font face="瀹嬩綋">
SQL> select exp(sum(ln(nid))) from t1 group by v1;

EXP(SUM(LN(NID)))
-----------------
           242048
               83


oracle 榪欎笢涓滄尯鏈夋剰鎬?
杞嚜:http://blog.sina.com.cn/s/blog_54eeb5d901000ae5.html



lubaolin 2008-07-21 14:26 鍙戣〃璇勮
]]>
主站蜘蛛池模板: 昭平县| 阆中市| 香河县| 双牌县| 平昌县| 巩义市| 临泽县| 平阳县| 竹溪县| 尚义县| 淮安市| 黄石市| 扶风县| 哈密市| 英吉沙县| 昌黎县| 农安县| 武夷山市| 沾化县| 江门市| 定陶县| 虹口区| 营口市| 大化| 通渭县| 罗城| 南丹县| 乐清市| 贺兰县| 莱阳市| 澳门| 柳州市| 巧家县| 西平县| 公主岭市| 从江县| 民和| 祁东县| 湟源县| 汽车| 临高县|