锘??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲国产精品不卡毛片a在线,亚洲欧洲中文日韩久久AV乱码,亚洲高清有码中文字http://www.tkk7.com/henry1451/archive/2009/09/30/297039.htmlhenry1451henry1451Wed, 30 Sep 2009 09:38:00 GMThttp://www.tkk7.com/henry1451/archive/2009/09/30/297039.htmlhttp://www.tkk7.com/henry1451/comments/297039.htmlhttp://www.tkk7.com/henry1451/archive/2009/09/30/297039.html#Feedback0http://www.tkk7.com/henry1451/comments/commentRss/297039.htmlhttp://www.tkk7.com/henry1451/services/trackbacks/297039.html           鍦ㄥ疄闄呭紑鍙戣繍鐢ㄤ腑,甯鎬細鏈夊叧浜庢煡璇㈡帓鍚嶇殑闇姹?濡傛煡璇㈡煇涓鏁版嵁瀹屾垚姣旂巼鎯呭喌,閫氬父鍙互鐢ㄨ嚜韜〃鍏堣繘琛岀浉鍏寵綆楁煡璇?鍐嶅拰鍘熻〃榪涜鍏寵仈榪涜鏌ヨ,鍗沖彲鏌ヨ鍑虹浉鍏蟲墍闇鐨勬暟鎹?

         濡?瑕佹煡璇㈡煇涓鍐滅敯鎷嗚縼鎯呭喌,闇鏌ヨ鎷嗚縼欏圭洰鍚?鎷嗚縼瀹屾垚姣旂巼,鍙繖鏍鋒煡璇?
      

      select tt.projectname ,tt.wzbl, DENSE_RANK() OVER ( ORDER BY tt.wzbl DESC) as bm from
   
      (
       select * from kp_confiscate t0,(select kf.promiseunfinished/kf.taskridgepole*0.5+kf.finishedridgepole/kf.taskridgepole as wzbl,kf.id from kp_confiscate kf ) t1      
       where t0.id=t1.id
      
       ) tt;

 
   鍏朵腑:
            promiseunfinished:絳捐鍗忚鏈媶瀹屾暟;
            finishedridgepole:宸叉媶瀹屾暟;
            taskridgepole :浠誨姟鏁?br />        
            鎷嗚縼瀹屾垚姣斾緥=絳捐鍗忚鏈媶瀹屾暟/浠誨姟鏁皒50%+宸叉媶瀹屾暟/浠誨姟鏁?br />
           鎷嗚縼瀹屾垚姣斾緥鍗充負鎵闇鏌ヨ鏁版嵁.

          鍗蟲煡璇㈡椂,鍏堝鑷韓琛ㄨ繘琛岀浉鍏寵綆楁煡璇?瀹為檯鐨勯渶姹傚氨鍦ㄨ繖涓瓙鏌ヨ涓畬鎴?,鐒跺悗浣滀負涓涓瓙琛?鍜屽師琛ㄨ繘琛屽叧鑱旀煡璇?


          娉?瀛愯〃涓煡璇㈡椂,瑕佹寚瀹氭煡璇笅鏌愬瓧孌?姝ゅ瓧孌墊槸鍜屽師瀛楁榪涜鍏寵仈鏌ヨ鏃剁敤鐨?涓斿簲涓哄敮涓瀛楁,鍦ㄥ拰鍘熻〃鍏寵仈鏌ヨ鏃?涓嶅簲鏈夊啑浣欑殑鏁版嵁鍑虹幇.

henry1451 2009-09-30 17:38 鍙戣〃璇勮
]]>
鍦∣racle涓壘鍑洪噸澶嶇殑綰綍鐨勬柟娉?/title><link>http://www.tkk7.com/henry1451/archive/2009/06/12/281766.html</link><dc:creator>henry1451</dc:creator><author>henry1451</author><pubDate>Fri, 12 Jun 2009 02:56:00 GMT</pubDate><guid>http://www.tkk7.com/henry1451/archive/2009/06/12/281766.html</guid><wfw:comment>http://www.tkk7.com/henry1451/comments/281766.html</wfw:comment><comments>http://www.tkk7.com/henry1451/archive/2009/06/12/281766.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/henry1451/comments/commentRss/281766.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/henry1451/services/trackbacks/281766.html</trackback:ping><description><![CDATA[   <br />      鍦ㄤ竴浜涙暟鎹〃涓?鍙兘浼氭湁涓浜涢噸澶?鏌愪竴瀛楁,鎴栧叏閮ㄥ瓧孌?鐨勬暟鎹?鏍規嵁闇姹?鍙兘瑕佸幓鎺夎繖浜涢噸澶嶇殑鏁版嵁,涓嬮潰鏄父鐢ㄧ殑鏂規硶:<br /> --琛?test鏈夐噸澶嶇殑璁板綍1,10<br /> 銆銆SQL> select  *  from tt;<br /> 銆銆 ID<br /> 銆銆----------<br /> 銆銆 1<br /> 銆銆 2<br /> 銆銆 3<br /> 銆銆 4<br /> 銆銆 10<br /> 銆銆 1<br /> 銆銆 1<br /> 銆銆 1<br /> 銆銆 1<br /> 銆銆 1<br /> 銆銆 10<br /> 銆銆11 rows selected.<br /> <br /> 銆銆--鏌ヨ琛ㄤ腑鐨勫摢浜涜褰曟湁閲嶅<br /> 銆銆SQL> select * from tt  group by id having count(*)>1;<br /> 銆銆 ID<br /> 銆銆----------<br /> 銆銆 1<br /> 銆銆 10<br /> <br /> 銆銆--鏌ヨ鍑烘病鏈夐噸澶嶈褰曠殑緇撴灉闆?br /> 銆銆SQL> select * from tt  group by id;<br /> 銆銆 ID<br /> 銆銆----------<br /> 銆銆 1<br /> 銆銆 2<br /> 銆銆 3<br /> 銆銆 4<br /> 銆銆 10<br /> 銆銆SQL> select distinct * from tt;<br /> 銆銆 ID<br /> 銆銆----------<br /> 銆銆 1<br /> 銆銆 2<br /> 銆銆 3<br /> 銆銆 4<br /> 銆銆 10<br /> <br /> 銆銆--鍒犻櫎閲嶅鐨勮褰?br /> 銆銆SQL> delete from tt  a where a.rowid!=(select max(rowid) from tt  b <br /> 銆銆 2 where a.id=b.id);<br /> 銆銆6 rows deleted.<br /> 銆銆SQL> commit;<br /> 銆銆Commit complete.<br /> <br /> 銆銆--鍒犻櫎鍚庣殑鏌ヨ緇撴灉闆?br /> 銆銆SQL> select * from tt;<br /> 銆銆 ID<br /> 銆銆----------<br /> 銆銆 2<br /> 銆銆 3<br /> 銆銆 <br /> 銆銆 <br /> 銆銆 4<br /> 銆銆 1<br /> 銆銆 10<br /> <img src ="http://www.tkk7.com/henry1451/aggbug/281766.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/henry1451/" target="_blank">henry1451</a> 2009-06-12 10:56 <a href="http://www.tkk7.com/henry1451/archive/2009/06/12/281766.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鍏充簬瀵筁ist鐨刬terator()浣跨敤http://www.tkk7.com/henry1451/archive/2009/05/20/271769.htmlhenry1451henry1451Wed, 20 May 2009 10:08:00 GMThttp://www.tkk7.com/henry1451/archive/2009/05/20/271769.htmlhttp://www.tkk7.com/henry1451/comments/271769.htmlhttp://www.tkk7.com/henry1451/archive/2009/05/20/271769.html#Feedback0http://www.tkk7.com/henry1451/comments/commentRss/271769.htmlhttp://www.tkk7.com/henry1451/services/trackbacks/271769.html
           鍦ㄧ▼搴忎腑鎴戜滑甯鎬細浣跨敤List瀛樺偍綾誨瀷鏉ヤ繚瀛樻煇涓緋誨垪鐨勬暟鎹?濡傚瓧絎︿覆,瀵硅薄絳?褰撶劧,鍦ㄥ瓨鍌ㄦ椂娌¢棶棰?鐩存帴寰閲屾斁鍗砄K浜?浣嗗湪鍙栧嚭鏉ョ敤鐨勬椂鍊?灝辮娉ㄦ剰浜?鎴戜滑涓鑸槸鐢ㄤ竴涓狥or寰幆鏉ヤ竴涓鍙栧嚭鎴戜滑鎵闇鐨勫璞℃暟鎹?濡?
 
           for (Iterator it = Items.iterator(); it.hasNext();) {...ItemObject subject = (ItemObject ) it.next()---(1);System.out.println(subject.getId()---(2);)...}

           鍗崇敤List鐨?font style="background-color: #cbe9cb">iterator()
榪唬鏂規硶,鍙栧嚭瀵硅薄,鐒跺悗榪涜寮哄埗杞崲,杞崲涓烘垜浠綋鏃朵繚瀛樼殑瀵硅薄綾誨瀷,浣嗚繖褰揑tems瀵硅薄涓嶄負絀?涓旀湁鏁版嵁鍐呭鏃?榪欐牱浣跨敤鏄病闂鐨?濡傛灉Items瀵硅薄涓虹┖,鎴朓tems瀵硅薄涓嶄負絀?浣嗘暟鎹唴瀹?(鍗蟲病鏈夊瓨鍌ㄧ浉搴旂殑鏁版嵁瀵硅薄)鏃?榪欐牱鐩存帴鐢‵OR寰幆鏄細鎶ラ敊鐨?閫氬父浼氭姤:java.util.NoSuchElementException榪欐牱鐨勫紓甯?鎰忔濆嵆娌℃湁鐩稿簲鐨勫璞¢」,鍥犱負褰撴垜浠彇鍑轟簡鏌愪竴鏉℃暟鎹悗,榪涜浜嗗己鍒惰漿鎹?浣嗗彇鍑虹殑鏁版嵁騫朵笉鏄垜浠己鍒惰漿鎹㈢殑瀵硅薄綾誨瀷,鎵浠ュ綋鐒朵細鎶ヨ繖鏍風殑寮傚父鐨?

             鍏跺疄鍦ㄤ笂闈婦鐨勪唬鐮佷緥瀛愪腑,(1)榪欎竴姝ュ茍涓嶄細鎶ラ敊鐨?鎶ラ敊鍏跺疄鏄敱(2)榪欎竴姝ュ紩璧風殑,鍥犱負subject騫朵笉鏄?font style="background-color: #cbe9cb">ItemObject
瀵硅薄綾誨瀷,浣嗚繕瑕佽皟鐢ㄥ畠鐨勬柟娉?鎵浠ヨ偗瀹氬氨浼氭姤閿欑殑.\

           鎵浠ヤ竴鑸湪浣跨敤List鐨刬terator()鐨勬柟娉曟椂,鏈濂藉湪浠g爜鍓嶅姞涓鍙ュ垽鏂?  if ( Items  !=  null   &&  Items.size()>0  )  {.........} ,榪欐牱灝卞彲浠ュ敖鎯呯殑浣跨敤,鑰屼笉浼氭姤閿欎簡.



henry1451 2009-05-20 18:08 鍙戣〃璇勮
]]>
鍏充簬甯﹀寘鏃禼lasspath鐨勮緗?/title><link>http://www.tkk7.com/henry1451/archive/2009/05/05/269018.html</link><dc:creator>henry1451</dc:creator><author>henry1451</author><pubDate>Tue, 05 May 2009 09:01:00 GMT</pubDate><guid>http://www.tkk7.com/henry1451/archive/2009/05/05/269018.html</guid><wfw:comment>http://www.tkk7.com/henry1451/comments/269018.html</wfw:comment><comments>http://www.tkk7.com/henry1451/archive/2009/05/05/269018.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/henry1451/comments/commentRss/269018.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/henry1451/services/trackbacks/269018.html</trackback:ping><description><![CDATA[<br />         鐢變簬緇忓父浣跨敤ECLIPSE 絳塈DE寮鍙戝伐鍏?浠ヨ嚦浜庤鍦ㄥ懡浠よ涓繍琛屾煇涓甯﹀寘鐨凜LASS鏂囦歡鏃?涓鏃惰繕璁頒笉娓呭浣曟紜殑璁劇疆classpath,浠ヤ究JVM姝g‘鐨勫鎵懼埌瑕佹墽琛岀殑CLASS,瑕佹墽琛屼笉甯﹀寘鐨凜LASS鏂囦歡,濂借,鍦ㄧ幆澧冨彉閲忎腑璁懼畾 classpath ,鍊兼寚鍚慍LASS鏂囦歡鎵鍦ㄨ礬寰?鐒跺悗鍦ㄥ懡浠よ涓洿鎺ユ墽琛?JAVA  Abc(綾繪枃浠?鍗沖彲,濡傛灉鏄鎵ц甯﹀寘鐨凜LASS鏂囦歡,鍦ㄨ緗甤lasspath鏃?瑕佹敞鎰忎簡,鏄皢classpath鐨勫兼寚鍚慍LASS鏂囦歡鍖呯殑涓婁竴灞傜洰褰?渚?<br /> <br />          鏈変竴甯﹀寘鐨勭被鏂囦歡: Student.class,鎵鍦ㄥ寘涓篶om.app.test,鑰岃繖涓猄tudent.class綾繪枃浠剁殑緇濆璺緞涓?<br /> <font style="background-color: #cbe9cb">D:\eclipse3.2\workspace\MyProject\com\app\test\Student.class,</font>鍦ㄨ緗甤lasspath鏃?搴斿皢classpath鐨勫艱緗負:<font style="background-color: #cbe9cb">D:\eclipse3.2\workspace\MyProject\</font>,鑰屼笉鏄?font style="background-color: #cbe9cb">D:\eclipse3.2\workspace\MyProject\com\app\test</font>\榪欐牱甯﹀寘鐨勮礬寰?鍚﹀垯鍦ㄦ墽琛屾椂浼氭彁紺烘壘涓嶅埌鐩稿簲鐨勭被鏂囦歡.<br /> <br />        璁劇疆濂絚lasspath鍚?鐒跺悗鍦ㄥ懡浠よ涓?鍦ㄤ換浣曠洰褰曚笅(鍓嶆彁瑕佽緗ソpath),鎵ц:java  com.app.test.Student鍗沖彲,娉ㄦ剰榪欓噷瑕佸甫鍖呭悕,鍚﹀垯涔熷悓鏍蜂細鎻愮ず鎵句笉鍒扮浉搴旂殑綾? <img src ="http://www.tkk7.com/henry1451/aggbug/269018.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/henry1451/" target="_blank">henry1451</a> 2009-05-05 17:01 <a href="http://www.tkk7.com/henry1451/archive/2009/05/05/269018.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Oracle鍏寵仈鏌ヨ鏃跺鍏寵仈瀛楁鐨勬暟鎹被鍨嬭姹?/title><link>http://www.tkk7.com/henry1451/archive/2009/04/09/264668.html</link><dc:creator>henry1451</dc:creator><author>henry1451</author><pubDate>Thu, 09 Apr 2009 08:49:00 GMT</pubDate><guid>http://www.tkk7.com/henry1451/archive/2009/04/09/264668.html</guid><wfw:comment>http://www.tkk7.com/henry1451/comments/264668.html</wfw:comment><comments>http://www.tkk7.com/henry1451/archive/2009/04/09/264668.html#Feedback</comments><slash:comments>2</slash:comments><wfw:commentRss>http://www.tkk7.com/henry1451/comments/commentRss/264668.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/henry1451/services/trackbacks/264668.html</trackback:ping><description><![CDATA[<br />          鍦∣RACLE涓繘琛屽叧鑱旀煡璇㈡椂,浣滀負鍏寵仈鏌ヨ鐨勪袱瀛楁鏁版嵁綾誨瀷瑕佷竴鑷?鍚﹀垯浼氭姤:<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" alt="" />       <span style="color: #000000">ORA</span><span style="color: #808080">-</span><span style="font-weight: bold; color: #800000">01722</span><span style="color: #000000">:invalid </span><span style="font-weight: bold; color: #000000">number</span><span style="color: #000000"> </span></div> <br /> 榪欐牱鐨勯敊璇?濡備笅鏌ヨ璇彞: <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" alt="" />      <span style="color: #0000ff">select</span><span style="color: #000000">  </span><span style="color: #808080">*</span><span style="color: #000000"> </span><span style="color: #0000ff">from</span><span style="color: #000000"> A a,B b  </span><span style="color: #0000ff">where</span><span style="color: #000000"> a.loginid</span><span style="color: #808080">=</span><span style="color: #000000">b.userid;</span></div> <br />         濡傛灉a.loginid鐨勬暟鎹被鍨嬩負:number(n),鑰宐.userid鐨勬暟鎹被鍨嬩負:varchar2(n),鍒欎細鎶ヤ笂闈㈢殑閿欒,瑕佷簩鑰呬負鍚屼竴鏁版嵁綾誨瀷,涓婇潰鐨勬煡璇㈣鍙ユ墠鑳芥紜殑琚墽琛?騫蟲椂鍙兘鍦ㄥ仛涓浜涙煡璇㈢粺璁℃椂娌℃敞鎰忚繖浜涢棶棰?鍙兘琛ㄧ粨鏋勬槸鍒漢浜嬪厛宸茬粡寤哄ソ浜嗙殑,鑰屾垜浠彧鏄幓浣跨敤鑰屼簬),鎵浠ュ綋鎴戜滑鍦ㄨ璁¤〃緇撴瀯鏃?濡傛灉浠ュ悗鏌愪袱琛?鎴栧琛?涔嬮棿瀛樺湪鍏寵仈鍏崇郴,鍗蟲煡璇㈢浉鍏蟲暟鎹椂,瑕佸叧鑱斿畠浠箣闂寸殑鏌愪簺瀛楁,榪欐椂鎴戜滑灝辮娉ㄦ剰浜?瑕佸皢鍒版椂鍙兘鐢ㄤ簬鍏寵仈鏌ヨ鐨勫瓧孌電殑鏁版嵁綾誨瀷璁捐涓虹浉鍚岀殑綾誨瀷,褰撶劧瀛楁闀垮害鍙互涓嶄竴鏍?榪欐牱鍒版椂鍏寵仈鏌ヨ鏃跺氨涓嶄細鏈夐棶棰樹簡,鍚﹀垯浠ュ悗榪樿鏀瑰瓧孌墊暟鎹被鍨?鑰屼笖姝ゆ椂琛ㄤ腑鍙堟湁浜嗘暟鎹?涓轟簡闃叉鏁版嵁涓㈠け,鏀硅搗鏉ヨ繕鏈夌偣楹葷儲.<br /> <br />        榪欑闂鍦∣RACLE鍏崇郴鏁版嵁搴撲腑浼氬嚭鐜?鍦ㄥ叾瀹冨叧緋繪暟鎹簱涓笉鐭ラ亾浼氫笉浼氬嚭鐜?鐚滄祴鍙兘涔熶細鏈夌被浼奸棶棰?<br /> <br />        娉?  榪欏彲鑳芥槸涓涓緢綆鍗曠殑闂,浣嗚繖紜彲鑳芥槸寰堝鏄撳拷瑙嗙殑闂,鏈夋椂鍦ㄨ璁¤〃緇撴瀯鏃?鍙兘浼氱敱浜庤冭檻涓嶅懆,閫犳垚浠ュ悗瑕佸叧鑱旀煡璇㈢浉鍏蟲暟鎹椂鍑虹幇涓婇潰鐨勯敊璇?浠庤岃鍘繪敼鍙樿〃鐨勫瓧孌電被鍨?浠庤屽甫鏉ヤ竴浜涗笉蹇呰鐨勯夯鐑?<br /> <img src ="http://www.tkk7.com/henry1451/aggbug/264668.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/henry1451/" target="_blank">henry1451</a> 2009-04-09 16:49 <a href="http://www.tkk7.com/henry1451/archive/2009/04/09/264668.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>涓涓敺浜哄繀欏繪槑鐧界殑22涓亾鐞?銆愯漿杞姐?/title><link>http://www.tkk7.com/henry1451/archive/2009/04/08/264401.html</link><dc:creator>henry1451</dc:creator><author>henry1451</author><pubDate>Wed, 08 Apr 2009 02:12:00 GMT</pubDate><guid>http://www.tkk7.com/henry1451/archive/2009/04/08/264401.html</guid><wfw:comment>http://www.tkk7.com/henry1451/comments/264401.html</wfw:comment><comments>http://www.tkk7.com/henry1451/archive/2009/04/08/264401.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/henry1451/comments/commentRss/264401.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/henry1451/services/trackbacks/264401.html</trackback:ping><description><![CDATA[<br /> 1銆佺敺浜烘槸紺句細鐨勪富浣擄紝涓嶇浣犱俊鎴栦笉淇°傛墍浠ョ敺浜哄簲璇ユ湁縐嶈矗浠繪劅銆?<br /> 2銆?5宀佷箣鍓嶏紝璇瘋寰楋紝鐖辨儏閫氬父鏄亣鐨勶紝鎴栬呬笉鏄綘鎵鎯寵薄鐨勯偅鏍風函媧佸拰姘歌繙銆傚鏋滀綘榪囦簡25宀侊紝閭d箞浣犲簲璇ユ噦寰楄繖涓亾鐞嗐?<br /> 3銆佸悆楗?鎴愰ケ鏈鑸掓湇銆傚寰呭コ鍙嬫渶澶氫篃璇蜂綘淇濇寔鍦?鎴愩?<br /> 4銆?0宀佷箣鍓嶈鐖辨儨鑷繁鐨勮韓浣擄紝鍓?0騫翠綘鎵劇梾錛屽悗30騫寸梾鎵句綘銆傚鏋滀綘榪囦簡30宀?浣犺嚜鐒朵篃浼氭噦寰楄繖涓亾鐞嗐?<br /> 5銆佷簨涓氳繙姣旂埍鎯呴噸瑕併傚鏋滆浜嬩笟閮戒笉鑳芥案鎭掞紝閭d箞鐖辨儏鍙兘綆楁槸鏄欒姳涓鐜般?<br /> 6銆佷笉瑕佽交鏄撴帴鍙楄拷姹備綘鐨勫コ瀛┿傚コ榪界敺闅斿眰綰憋紝濡傛灉浣犲緢瀹規槗灝遍櫡榪涘幓錛屼綘浼氬彂鐜頒綘浼氶敊榪囧緢澶氫笢瑗匡紝澶卞幓寰堝涓滆タ銆?<br /> 7銆佽浣犵浉淇★紝鑳界敤閽辮В鍐崇殑闂錛岄兘涓嶆槸闂銆傚鏋滀綘璁や負閽辯儲鐜嬮亾錛屾湁閽辨湁濂充漢錛屾病閽辨病濂充漢錛岄偅涔堬紝濂充漢涓嶆槸闂銆?<br /> 8銆佽姘歌繙縐瀬鍚戜笂銆傛瘡涓敺浜洪兘鏈変粬鍙埍鐨勫湴鏂癸紝浣嗘槸涓嶅彲鐖辯殑鍦版柟鍙湁錛氫笉縐瀬闈㈠鐢熸椿銆?<br /> 9銆佷笉瑕佽繛緇?嬈¤鍚屼竴涓コ浜哄彈鍒頒激瀹熾傚ソ椹笉鍚冨洖澶磋崏鏄湁閬撶悊鐨勩傚鏋滆鐪熻冭檻榪囪鍒嗘墜錛岄偅涔堣涓嶈鍋氫換浣曡垗涓嶅緱鐨勮鍔ㄣ?<br /> 10銆佸鏋滀綘鍜屼綘鍓嶅コ鍙嬭兘鍋氭湅鍙嬶紝閭d箞浣犺闂嚜宸憋細涓轟粈涔堬紵濡傛灉鍒嗘墜鍚庤繕鏄湅鍙嬶紝閭d箞鍙湁2涓彲鑳斤細浣犱滑褰撳垵閮藉彧鏄帺鐜╄屽凡錛屾病浠樺嚭褰兼鏈鐪熺殑鎰熸儏錛涙垨鑰咃細蹇呭畾鏈変釜浜烘槸鍦ㄩ粯榛樼殑浠樺嚭鏃犳ㄦ棤鎮旓紒 <br /> 11銆佹案榪滀笉瑕佸お鐩鎬俊濂充漢鍦ㄦ亱鐖辨椂鐨勭敎璦铚滆銆傞兘璇村コ浜虹埍鍚敎璦铚滆錛屽叾瀹烇紝鐢蜂漢鏇村枩嬈€?<br /> 12銆佽涓嶈涓鴻嚜宸辯殑鐩歌矊鎴栬呰韓楂樿繃鍒嗘媴蹇冨拰鑷崙銆備漢鏄姩鐗╋紝浣嗘槸鍖哄埆浜庡姩鐗┿傚厛澶╂潯浠跺茍涓嶆槸闃繪尅浣犲ソ濂界敓媧葷殑鍊熷彛銆備漢鐨勫績鐏佃繙鑳滀簬鐩歌矊錛岃鐩鎬俊榪欑偣銆傚鏋滄湁浜轟互鐩歌矊鍙栦漢錛岄偅涔堜綘涔熸病蹇呰澶湪鎰忋傚洜涓轟粬浠庢煇縐嶆剰涔夋潵璁詫紝鍙槸鍙姩鐗╋紝浣犱細璺熷姩鐗╂勬皵鍚楋紵 <br /> 13銆佸け鎭嬫椂錛屽彧鏈?縐嶅彲鑳斤紝瑕佷箞浣犵埍濂瑰ス涓嶇埍浣狅紝鎴栬呯浉鍙嶃傞偅涔堬紝褰撲綘鐖辯殑浜轟笉鍐嶇埍浣狅紝鎴栬呬粠鏉ユ病鐖辮繃浣犳椂錛屼綘娌℃湁閬楁喚錛屽洜涓轟綘澶卞幓鐨勫彧鏄竴涓笉鐖變綘鐨勪漢銆?<br /> 14銆佽涓嶈嬈洪獥鍠勮壇鐨勫コ瀛┿傝繖涓笘鐣屼笂鍠勮壇鐨勫コ瀛╁お灝戙?<br /> 15銆佷笉鑳藉亸嬋鐨勮涓洪噾閽變竾鑳斤紝鑷沖皯錛岄噾閽辨不涓嶅ソ鑹炬粙鐥呫?<br /> 16銆佽涓瀹氳鏈夎嚜淇°備綘灝辨槸涓閬撻鏅紝娌″繀瑕佸湪鍒漢椋庢櫙閲岄潰浠拌銆?<br /> 17銆佸彈鍒板啀澶х殑鎵撳嚮錛屽彧瑕佺敓鍛借繕鍦紝璇風浉淇℃瘡澶╃殑澶槼閮芥槸鏂扮殑銆?<br /> 18銆佺埍鎯呮案榪滀笉鍙兘鏄ぉ騫熾備綘鎯沖湪鐖辨儏閲屽垢紱忓氨瑕佽垗寰椾激蹇冦?<br /> 19銆佸鏋滀綘鍠滄涓涓ス璁や負鍒漢搴旇瀵瑰ス濂界殑MM錛岃灝芥棭鏀懼純銆傛病鏈変漢鏄簲璇ュ涓涓漢濂界殑銆傚鏋滃ス涓嶆槑鐧借繖涓亾鐞嗭紝涔熷氨鏄ス鏍規湰涓嶆噦寰楃弽鎯溿?<br /> 20銆佷笉瑕佸洜涓哄瘋瀵炶?#8220;鎵?#8221;GF錛屽瘋瀵炵殑鐢蜂漢璇瘋瀛︿細鍝佸懗瀵傚癁銆傝璁頒綇錛氬嵆浣垮瘋瀵烇紝榪滄柟榛戞殫鐨勫絀轟笅錛屼竴瀹氭湁浜哄拰浣犱竴鏍鳳紝瀵傚癁鐨勪漢涓嶅悓錛屼話鏈涚殑鏄熺┖鍗存槸鍞竴銆?<br /> 21銆佷換浣曚簨娌℃湁姘歌繙錛屼篃鍒棶鎬庢牱鎵嶈兘姘歌繙銆傜敓媧繪湁寰堝鏃犲錛岃灝介噺鍏呭疄鑷繁錛屽厖瀹炵敓媧匯傝鍠勫緟鐢熸椿…… <br /> <br /> 鏈鍚庛佺敺浜烘湁寰堝鏃犲錛岀敓媧誨緢绱紝浣嗘槸鍥犱負鐢熸椿鎵嶆湁鎰忎箟銆傚綋浣犱互涓轟綘涓鏃犳墍鏈夋椂錛屼綘鑷沖皯榪樻湁鏃墮棿錛屾椂闂磋兘鎶氬鉤涓鍒囧垱浼ゃ傛墍浠ヨ涓嶈嫻佹唱銆?<br /> <img src ="http://www.tkk7.com/henry1451/aggbug/264401.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/henry1451/" target="_blank">henry1451</a> 2009-04-08 10:12 <a href="http://www.tkk7.com/henry1451/archive/2009/04/08/264401.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>灝戣蛋寮礬鐨勫崄鏉″繝鍛娿愯漿杞姐?/title><link>http://www.tkk7.com/henry1451/archive/2009/04/08/264398.html</link><dc:creator>henry1451</dc:creator><author>henry1451</author><pubDate>Wed, 08 Apr 2009 02:00:00 GMT</pubDate><guid>http://www.tkk7.com/henry1451/archive/2009/04/08/264398.html</guid><wfw:comment>http://www.tkk7.com/henry1451/comments/264398.html</wfw:comment><comments>http://www.tkk7.com/henry1451/archive/2009/04/08/264398.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/henry1451/comments/commentRss/264398.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/henry1451/services/trackbacks/264398.html</trackback:ping><description><![CDATA[ <br /> 1. 涔頒釜闂歸挓錛屼互渚挎寜鏃跺彨閱掍綘銆?<br /> <br /> 璐潯鍜屼笉瀹堟椂錛岄兘灝嗘垚涓轟綘宸ヤ綔鍜屼簨涓氫笂鐨勭粖鑴氱煶錛屼換浣曟椂鍊欓兘涓鏍楓備笉浠呰瀛︿細鍑嗘椂錛屾洿瑕佸浼氭彁鍓嶃傚氨濡備綘鍧愯濺鍘繪煇鍦幫紝娌塊旂殑椋庢櫙寰堢編錛屼綘蹇嶄笉浣忎笅杞︾湅涓鐪嬶紝鍚庢潵铏界劧浣犺繕鏄刀鍒頒簡鏌愬湴錛屽嵈涓嶆槸鍑嗘椂鍒拌揪銆?#8220;闂歸挓”鍙槸涓縐嶇畝鍗曠殑鏍囧織鍜屾彁紺猴紝鐪熸鐏墊椿銆佸疄鐢ㄧ殑鏃墮棿錛屾帉鎻″湪姣忎釜浜虹殑蹇冧腑銆?<br /> <br /> <br /> 2. 濡傛灉浣犱笉鍠滄鐜板湪鐨勫伐浣滐紝瑕佷箞杈炶亴涓嶅共錛岃涔堝氨闂槾涓嶈█銆?<br /> <br /> 鍒濆嚭鑼呭簮錛屽線寰鐪奸珮鎵嬩綆錛屽績楂樻皵鍌詫紝澶т簨鍋氫笉浜嗭紝灝忎簨涓嶆効鍋氥備笉瑕佸吇鎴愭寫涓夋嫞鍥涚殑涔犳儻銆備笉瑕侀洦澶╃儲鎵撲紴錛屼笉甯︿紴鍙堟曟穻闆紝澶勫琛ㄧ幇鍑轟笉婊$殑鎯呯華銆傝浣忥紝涓嶅仛鍒欏凡錛岃鍋氬氨瑕佸仛濂姐?<br /> <br /> 3. 姣忎釜浜洪兘鏈夊鐙殑鏃跺欍?<br /> <br /> 瑕佸浼氬繊鍙楀鐙紝榪欐牱鎵嶄細鎴愮啛璧鋒潵銆傚勾杞諱漢鍢誨樆鍝堝搱銆佹墦鎵撻椆闂規儻浜嗭紝鍒頒簡涓涓檶鐢熺殑鐜錛岄潰瀵瑰艦褰㈣壊鑹茬殑浜哄拰浜嬶紝涓涓嬪瓙涓嶇煡鎵鎺搗鏉ワ紝鏈夋椂榪炰竴涓彲浠ュ懼績璇磋瘽鐨勫湴鏂逛篃娌℃湁銆傝繖鏃訛紝鍗冧竾鍒誕韜侊紝瀛︿細闈欏績錛屽浼氬繊鍙楀鐙傚湪瀛ょ嫭涓濊冿紝鍦ㄦ濊冧腑鎴愮啛錛屽湪鎴愮啛涓崌鍗庛備笉瑕佸洜涓哄瘋瀵炶屼貢浜嗘柟瀵革紝鑰屽幓鍋氭棤鑱婃棤鐩婄殑浜嬫儏錛岀櫧鐧芥氮璐逛簡瀹濊吹鐨勬椂闂淬?<br /> <br /> <br /> 4. 璧拌繍鏃惰鍋氬ソ鍊掗湁鐨勫噯澶囥?<br /> <br /> 鏈変竴澶╋紝涓鍙嫄鐙歌蛋鍒頒竴涓憽钀勫洯澶栵紝鐪嬭閲岄潰姘寸伒鐏電殑钁¤悇鍨傛稁嬈叉淮銆傚彲鏄闈㈡湁鏍呮爮鎸$潃錛屾棤娉曡繘鍘匯備簬鏄畠涓鐙犲績緇濋涓夋棩錛屽噺鑲ヤ箣鍚庯紝緇堜簬閽昏繘钁¤悇鍥唴楗遍涓欏褲傚綋瀹冨績婊℃剰瓚沖湴鎯崇寮钁¤悇鍥椂錛屽彂瑙夎嚜宸卞悆寰楀お楗憋紝鎬庝箞涔熼捇涓嶅嚭鏍呮爮浜嗐傜浉淇′換浣曚漢閮戒笉鎰垮仛榪欐牱鐨勭嫄鐙搞傞璺悓鏍烽噸瑕併傞ケ甯﹀共綺紝鏅村甫闆ㄤ紴錛岀偣婊寸Н绱紝姘村埌娓犳垚銆傛湁鐨勪笢瑗夸粖澶╀技涔庝竴鏂囦笉鍊鹼紝浣嗘湁鏈濅竴鏃ヤ篃璁稿氨浼氳韓浠風櫨鍊嶃?<br /> <br /> 5. 涓嶈鍍忕幓鐠冮偅鏍瘋剢寮便?<br /> <br /> 鏈夌殑浜虹溂鐫涙葷洴鐫鑷繁錛屾墍浠ラ暱涓嶉珮鐪嬩笉榪滐紱鎬繪槸鍠滄鎬ㄥぉ灝や漢錛屼篃浣垮埆浜烘棤姣斿帉鐑︺傛病鏈夎嫤涓嫤錛屽摢鏉ョ敎涓敎錛熶笉瑕佸儚鐜葷拑閭f牱鑴嗗急錛岃屽簲鍍忔按鏅朵竴鏍烽忔槑錛屽お闃充竴鏍瘋緣鐓岋紝鑵婃涓鏍峰潥寮恒傛棦鐒剁潄寮鐪肩潧浜彈椋庣殑娓呭噳錛屽氨涓嶈鍩嬫ㄩ涓粏灝忕殑娌欑矑銆?<br /> <br /> <br /> 6. 綆′綇鑷繁鐨勫槾宸淬?<br /> <br /> 涓嶈璋堣鑷繁錛屾洿涓嶈璁鍒漢銆傝皥璁鴻嚜宸卞線寰浼氳嚜澶ц櫄浼紝鍦ㄥ悕涓嶅壇瀹炰腑澶卞幓鑷繁銆傝璁哄埆浜哄線寰闄峰叆楦℃瘺钂滅毊鐨勬槸闈炲彛鑸屼腑綰犵紶涓嶆竻銆傛瘡澶╀笅鐝悗鍜屼綘鐨勯偅浜涘悓浜嬫湅鍙嬪枬閰掕亰澶╁彲涓嶆槸浠跺ソ浜嬶紝鍥犱負錛岃繖涓棿寰寰浼氭妸璁鍚屼簨銆佹湅鍙嬪綋鍋氳瘽棰樸傝儗鍚庤璁轟漢鎬繪槸涓嶅ソ鐨勶紝灝ゅ叾鏄璁哄埆浜虹殑鐭錛岃繖浜涗細闄嶄綆浣犵殑浜烘牸銆?<br /> 7. 鏈轟細浠庝笉浼?#8220;澶辨帀”錛屼綘澶辨帀浜嗭紝鑷湁鍒漢浼氬緱鍒般?<br /> <br /> 涓嶈鍑′簨鍦ㄥぉ錛屽畧鏍緟鍏旓紝鏇翠笉瑕佸瘎甯屾湜浜?#8220;鏈轟細”銆傛満浼氬彧涓嶈繃鏄浉瀵逛簬鍏呭垎鍑嗗鑰屽張鍠勪簬鍒涢犳満浼氱殑浜鴻岃█鐨勩備篃璁革紝浣犳涓哄け鍘諱竴涓満浼氳屾噴鎮斻佸煁鎬ㄧ殑鏃跺欙紝鏈轟細姝h浣犲闈㈤偅涓悓鏍風殑“鍊掗湁楝?#8221;緇欐姄浣忎簡銆傛病鏈夋満浼氾紝灝辮鍒涢犳満浼氾紝鏈変簡鏈轟細錛屽氨瑕佸閥濡欏湴鎶撲綇銆?<br /> <br /> <br /> 8. 鑻ョ數璇濊佹槸涓嶅搷錛屼綘璇ユ墦鍑哄幓銆?<br /> <br /> 寰堝鏃跺欙紝鐢佃瘽浼氱粰浣犲甫鏉ユ剰鎯充笉鍒扮殑鏀惰幏錛屽畠涓嶆槸鑺辯摱錛屼粎浠呮垚涓轟竴縐嶆憜璁俱備氦浜嗘柊鏈嬪弸錛屽埆蹇樹簡鑰佹湅鍙嬶紝鏈嬪弸澶氫簡璺ソ璧般備氦闄呯殑涓澶ц瘈紿嶅氨鏄富鍔ㄣ傚ソ鐨勪漢緙樺ソ鐨勫彛紕戯紝寰寰鍔╀綘鐨勪簨涓氭洿涓婁竴涓彴闃躲?<br /> 9. 鍗冧竾涓嶈鍥犱負鑷繁宸茬粡鍒頒簡緇撳騫撮緞鑰岃崏鐜囩粨濠氥?<br /> <br /> 鎯崇粨濠氾紝灝辮鎵句竴涓兘鍜屼綘蹇冨績鐩稿嵃銆佺浉杈呯浉鎼虹殑浼翠荊銆備笉瑕佸洜涓烘斁綰靛拰娓告垙鑰屾亱鐖憋紝涓嶈鍥犱負鎭嬬埍鑰屽獎鍝嶅伐浣滃拰浜嬩笟錛屾洿涓嶈鍥犱竴妗╄崏鐜囪屽け璐ョ殑濠氬Щ鑰屼嬌浜虹敓鍙楅樆銆傛劅鎯呯敤浜嬪線寰浼氬洜灝忓け澶с?<br /> <br /> <br /> 10. 鍐欏嚭浣犱竴鐢熻鍋氱殑浜嬫儏錛屾妸鍗曞瓙鏀懼湪鐨す閲岋紝緇忓父鎷垮嚭鏉ョ湅銆?<br /> <br /> 浜虹敓瑕佹湁鐩爣錛岃鏈夎鍒掞紝瑕佹湁鎻愰啋錛岃鏈夌揣榪劅銆備竴涓張涓涓皬鐩爣涓茶搗鏉ワ紝灝辨垚浜嗕綘涓鐢熺殑澶х洰鏍囥傜敓媧誨瘜瓚充簡錛岀幆澧冩敼鍠勪簡錛屼笉瑕佸繕浜嗙毊澶歸噷閭e紶鐪嬩技钖勮杽鐨勫崟瀛愩?<br /> <img src ="http://www.tkk7.com/henry1451/aggbug/264398.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/henry1451/" target="_blank">henry1451</a> 2009-04-08 10:00 <a href="http://www.tkk7.com/henry1451/archive/2009/04/08/264398.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>ClientAbortException 寮傚父瑙e喅鍔炴硶http://www.tkk7.com/henry1451/archive/2009/03/20/261105.htmlhenry1451henry1451Fri, 20 Mar 2009 10:03:00 GMThttp://www.tkk7.com/henry1451/archive/2009/03/20/261105.htmlhttp://www.tkk7.com/henry1451/comments/261105.htmlhttp://www.tkk7.com/henry1451/archive/2009/03/20/261105.html#Feedback7http://www.tkk7.com/henry1451/comments/commentRss/261105.htmlhttp://www.tkk7.com/henry1451/services/trackbacks/261105.html         褰撴垜浠敤Servlet瀵煎嚭鍥劇墖,鎴栫敤JSP瀵煎嚭excel鏃?浼氬脊鍑轟竴涓笅杞界獥鍙?榪欐椂涓嶇偣涓嬭澆鑰岀偣鍙栨秷錛屽垯鎶ヤ笅闈㈢殑寮傚父:
ClientAbortException  Caused by: java.net.SocketException: Connection reset by peer: socket write error

鍦ㄧ綉涓婃煡鎵句簡浜嗕笅鍘熷洜錛屽ぇ姒傚綊緇撲負錛?
ClientAbortException: java.net.SocketException: Connection reset by peer: socket write error鐨勫師鍥犳槸鐢變簬澶勭悊http榪炴帴鏃訛紝姝e湪杈撳嚭鍐呭鏃訛紝鐢ㄦ埛鍏抽棴浜咺E錛屼細鍑虹幇涓涓?ClientAbortException"錛屽睘浜嶪/O澶勭悊涓嚭鐜扮殑涓涓紓甯革紝搴旂敤鏈嶅姟鍣ㄥ簲璇ヤ細鎹曟崏銆?
Connection reset by peer鐨勫師鍥狅細
緇忓父鍑虹幇鐨凜onnection reset by peer: 鍘熷洜鍙兘鏄鏂歸潰鐨勶紝涓嶈繃鏇村父瑙佺殑鍘熷洜鏄細
鈶狅細鏈嶅姟鍣ㄧ殑騫跺彂榪炴帴鏁拌秴榪囦簡鍏舵壙杞介噺錛屾湇鍔″櫒浼氬皢鍏朵腑涓浜涜繛鎺own鎺夛紱
鈶★細瀹㈡埛鍏蟲帀浜嗘祻瑙堝櫒錛岃屾湇鍔″櫒榪樺湪緇欏鎴風鍙戦佹暟鎹紱
鈶細嫻忚鍣ㄧ鎸変簡Stop 

        寰堝浜洪兘璇存槸瀹㈡埛绔犳垚鐨?娌℃湁鍔炴硶鎺у埗,鑰屼笖鍚庡彴浼氳褰曡繖涓紓甯革紝鏃ュ織涔熶細鐤媯鐖嗘弧,鏃墮棿闀夸簡,鑲畾浼欴OWN鎺夌殑.
       
        鏈漢瑙夊緱澶у鏁板彲鑳芥槸絎簩鏉¢棶棰樼殑鍘熷洜寮曡搗鐨?鍗沖ぇ澶氭暟嫻忚鍣ㄩ樆姝簡紿楀彛鐨勫脊鍑?鐩稿綋浜庡鎴峰叧鎺変簡嫻忚鍣?鍙瓑鏁堜簬嫻忚鍣ㄧ鎸変簡Stop ,鑰岃繖鏃舵湇鍔″櫒绔繕鍦ㄧ粰瀹㈡埛绔彂閫佹暟鎹?鎵浠ヤ駭鐢熶簡涓婂紓甯?緇忚繃鏈漢鐨勬祴璇?鍙戠幇鍙渶灝嗙綉绔欏湴鍧(鎴栨湰鏈哄湴鍧)鍔犲叆"鍙椾俊浠葷殑绔欑偣"鍗沖彲瑙e喅闂,鍥犱負榪欐牱璁劇疆浜嗕互鍚?嫻忚鍣ㄥ氨涓嶄細闃繪紿楀彛鐨勫脊鍑轟簡,榪欐牱嫻忚鍣ㄥ氨浼氱瓑鍒版湇鍔″櫒绔彂閫佸畬鏁版嵁鍚庡啀榪涜涓嬮潰鐨勫姩浣?鍥犺屽紓甯稿氨涓嶄細鍙戠敓浜?
 
      澶ф璁劇疆鏂瑰紡濡備笅:"宸ュ叿->internet(閫夐」..)->瀹夊叏->鍙椾俊浠葷殑绔欑偣->绔欑偣",灝嗗湴鍧鍔犲叆鍗沖彲.



henry1451 2009-03-20 18:03 鍙戣〃璇勮
]]>
淇敼ORACLE鏁版嵁瀛楁綾誨瀷http://www.tkk7.com/henry1451/archive/2009/03/04/257741.htmlhenry1451henry1451Wed, 04 Mar 2009 03:42:00 GMThttp://www.tkk7.com/henry1451/archive/2009/03/04/257741.htmlhttp://www.tkk7.com/henry1451/comments/257741.htmlhttp://www.tkk7.com/henry1451/archive/2009/03/04/257741.html#Feedback0http://www.tkk7.com/henry1451/comments/commentRss/257741.htmlhttp://www.tkk7.com/henry1451/services/trackbacks/257741.html         鍦∣RACLE鏁版嵁搴撹〃涓?鏈夋椂浼氭湁闇瑕佹洿鏀規暟鎹簱琛ㄤ腑瀛楁綾誨瀷鐨勬儏鍐?姣斿鐢盢UMBER(5)鏀逛負
VARCHAR(50)...,榪欐椂灝辮瑙嗘儏鍐墊潵鏇存敼浜?濡傛灉鍘熸暟鎹簱琛ㄤ腑娌℃湁鏁版嵁,鍒欏彲浠ョ洿鎺ヤ嬌鐢?
                
      alter   table  test  modify  name  VARCHAR2(50);

       浣嗘槸鏈夋暟鎹殑璇?灝變笉鑳界敤涓婇潰鏂規硶浜?

         

       alter table test add  name_temp number(5);
              
        
update test set  name_temp=name;

        
alter table drop column name;

         
alter  table  test rename column  name_temp to name;

        榪欑鏂規硶浼氫嬌鍒楀悕鍙戠敓鍙樺寲,鑰屼笖瀛楁欏哄簭澧炲姞 鏈夊彲鑳藉彂鐢熻榪佺Щ,瀵瑰簲鐢ㄧ▼搴忎細浜х敓褰卞搷

        浠ヤ笅鏂規硶鏄瘮杈冨ソ鐨勬柟娉?/font>

        涓嶇敤浣垮垪鍚嶅彂鐢熷彉鍖?涔熶笉浼氬彂鐢熻〃榪佺Щ,浣嗚繖涓湁涓己鐐規槸琛ㄨ鏇存柊涓ゆ

        濡傛灉鏁版嵁閲忚緝澶х殑璇?浜х敓鐨剈ndo鍜宺edo鏇村 ,鍓嶆彁涔熸槸瑕佸仠鏈哄仛

        瑕佹槸涓嶅仠鏈虹殑璇?,涔熷彲浠ラ噰鐢ㄥ湪綰塊噸瀹氫箟鏂瑰紡鏉ュ仛

        浠ヤ笅鏄剼鏈?

       alter table test  add name_temp number(5);

       
update  test  set name_temp=name,name=null;

       
alter table  test  modify name  VARCHAR2(50);
       
           update  test  set name=name_temp,name_temp=null;
       
           commit;
       
           alter table  test  drop column name_temp;
    
        
desc test;
         
          榪欐牱灝變笉浼氬嚭鐜頒笂榪扮殑闂浜?

henry1451 2009-03-04 11:42 鍙戣〃璇勮
]]>
cosmos妗嗘灦(杞?http://www.tkk7.com/henry1451/archive/2009/01/14/251297.htmlhenry1451henry1451Wed, 14 Jan 2009 08:13:00 GMThttp://www.tkk7.com/henry1451/archive/2009/01/14/251297.htmlhttp://www.tkk7.com/henry1451/comments/251297.htmlhttp://www.tkk7.com/henry1451/archive/2009/01/14/251297.html#Feedback0http://www.tkk7.com/henry1451/comments/commentRss/251297.htmlhttp://www.tkk7.com/henry1451/services/trackbacks/251297.htmlcosmos妗嗘灦涓昏鐢ㄦ潵鍋氫腑灝忛」鐩紑鍙戯紝涓㈠純浜嗕紶緇熺殑SSH鏋舵瀯錛屽埄鐢ㄧ函鐨凷ervlet+JDBC瀹炵幇鏁版嵁搴撴搷浣溿傚紑鍙慦eb欏圭洰錛屽彲浠ュ疄鐜版棤闇鍐橨ava浠g爜錛岃屽疄鐜頒笟鍔¢昏緫錛屽茍涓旂敱浜庝笉闇瑕佸啓Java浠g爜錛屽洜姝わ紝鍙互涓嶉渶瑕侀噸鍚拰閲嶆柊閮ㄧ講欏圭洰錛屽氨鍙互鐩存帴嫻嬭瘯錛岃揪鍒頒簡寮鍙?>鍒鋒柊嫻嬭瘯鐨勬按騫熾傛牴鎹洰鍓嶅涓」鐩殑搴旂敤瀹炶返鐪嬫潵錛屽熀鏈笂鍙互鎻愰珮涓鍊嶅埌2/3鐨勫紑鍙戞椂闂達紝鑰屼笖鎬ц兘姣旇搗SSH鏋舵瀯榪樿楂橈紝妗嗘灦榪樿鏇村姞杞婚噺綰с傚洜姝わ紝榪欎釜妗嗘灦榪樻槸姣旇緝鑳藉浣撶幇鏁忔嵎寮鍙戠殑鎬濇兂鐨勩?br />
鐢變簬妗嗘灦鎽掑純浜咹ibernate鐨凮/R Mapping宸ュ叿錛屽洜姝ゆ湁涓涓瘮杈冨ぇ鐨勯棶棰樺氨鏄叧浜庢暟鎹簱縐繪鎬х殑闂錛屼絾鏄紝鏍規嵁鍏徃瀵逛簬涓皬欏圭洰鐨勭粡楠岋紝涓鏃﹀鎴瘋縐繪鏁版嵁搴擄紝鍑犱箮灝遍渶瑕侀噸鏂板疄鐜頒笟鍔¢昏緫浜嗭紝鍥犳錛屽浜庝腑灝忛」鐩潵璇達紝榪欐槸涓涓笉閿欑殑閫夋嫨銆?br />
鈥斺斺斺斺斺?br /> 瀹樻柟浠嬬粛錛?br />

cosmos妗嗘灦鏄竴涓浜庡簳灞傛暟鎹簱銆乄eb鏈嶅姟銆丣NDI絳夎繘琛岀粺涓鐣岄潰灝佽鐨勬鏋訛紝鎻愪緵緇熶竴鐨勮皟鐢ㄦ帴鍙o紝騫墮噰鐢ㄥ懡浠よ璁℃ā寮忥紝灝嗘墍鏈夐渶瑕佽皟鐢ㄧ殑鍛戒護鏀劇疆鍒版暟鎹簱錛堟垨鑰呭叾浠栧煙錛変腑鍘伙紝浠庤屽彲浠ユ敼鍙樹紶緇熺殑j2ee搴旂敤璋冭瘯鐨勬祦紼嬶細寮鍙?閮ㄧ講-嫻嬭瘯鎴栬呭紑鍙?閮ㄧ講-閲嶆柊鍚姩-嫻嬭瘯錛岃揪鍒板儚PHP銆丳ERL閭f牱鐨勫紑鍙?->嫻嬭瘯鐨勬ā寮忋傛湁鏁堝湴鎻愰珮浜嗗紑鍙戦熷害銆?

鐢變簬鍏舵姏寮冧簡鎵鏈夌殑涓棿灞傛錛屽寘鎷儚Struts銆丼pring銆丠ibernate榪欐牱鐨勬鏋訛紝璋冪敤鏁版嵁搴撳簲鐢ㄧ洿鎺ョ敤JDBC鐨勬柟寮忚繘琛岋紝鍥犳鏈夋晥鍦版彁楂樹簡榪愯鎬ц兘銆傜敱浜庡紑鍙戠殑浠g爜鍙互瀹屽叏鏀劇疆鍒版暟鎹簱涓紝鍥犳錛屽彲浠ユ瘮杈冨鏄撳湴瀹炵幇鍏變韓寮鍙戯紝浠庤屾湁鏁堝湴璋冨姩璧峰紑鍙戜漢鍛樼殑縐瀬鎬с傚湪cosmos妗嗘灦涓紑鍙戜竴涓暟鎹簱搴旂敤鐨勬祦紼嬫槸錛氬紑鍙慡QL璇彞鎴栬呭瓨鍌ㄨ繃紼嬫垨鑰呭嚱鏁幫紱鐒跺悗寮鍙慗SP欏甸潰榪涜灞曠ず錛涙渶鍚庢祴璇曠粨鏋溿傚畬鍏ㄥ湴鐪佺暐浜嗗紑鍙慗ava浠g爜鐨勮繃紼嬶紝鍥犳錛屾湁鏁堝湴鎻愰珮浜嗗紑鍙戦熷害銆?cosmos妗嗘灦鏄竴涓兘鏈夋晥鍦板簲鐢ㄤ簬涓皬欏圭洰鐨勬鏋訛紝鍙互渚涘紑鍙戜漢鍛樺揩閫熷緩绔嬪師鍨嬶紝浠庤屽疄鐜版晱鎹峰紑鍙戠殑鐩殑銆傚湪妗嗘灦涓繕鍖呮嫭鏉冮檺鍜岃璇佺殑閮ㄥ垎妗嗘灦錛屽洜姝わ紝鐢ㄦ埛鍙互綆鍗曞湴瀹炵幇鐢ㄦ埛璁よ瘉鍜岀郴緇熸潈闄愮殑鍔熻兘銆?


http://code.google.com/p/cosmos4j/
      
        紜疄,瀵逛簬涓浜涗腑灝忓瀷欏圭洰,榪欎簺妗嗘灦榪樻槸寰堝煎緱鍘諱嬌鐢ㄧ殑,鏃犺瀵歸」鐩紑鍙戞晥鐜?寮鍙戦毦搴︾瓑,鐩稿閭d簺澶ф鏋惰繕鏄湁涓瀹氫紭鍔跨殑.

henry1451 2009-01-14 16:13 鍙戣〃璇勮
]]>
主站蜘蛛池模板: 伊人久久亚洲综合影院| 美女视频黄是免费的网址| 亚洲成av人片一区二区三区| 亚洲av无码专区青青草原| 四色在线精品免费观看| 亚洲视频在线免费播放| 亚洲男人都懂得羞羞网站| 亚洲免费视频在线观看| 亚洲精品无码久久久久久久| **aaaaa毛片免费| 亚洲av极品无码专区在线观看| 国内精自视频品线六区免费| 亚洲av永久无码精品天堂久久| 91黑丝国产线观看免费| 在线观看亚洲AV日韩A∨| 美女黄网站人色视频免费国产 | 亚洲视频在线观看网站| 亚色九九九全国免费视频| 亚洲婷婷第一狠人综合精品| 妞干网在线免费视频| 男男gay做爽爽免费视频| 国产亚洲精品AA片在线观看不加载| 中国黄色免费网站| 亚洲综合精品香蕉久久网97| 国产乱码免费卡1卡二卡3卡| 国产精品亚洲一区二区在线观看| 亚洲成a人片在线观看老师| 免费观看一区二区三区| 国产精品亚洲精品观看不卡| 国产一区视频在线免费观看| 久久嫩草影院免费看夜色| 97se亚洲综合在线| 国产成人精品免费视频大全五级 | 亚洲无人区码一二三码区别图片| 国产片免费在线观看| APP在线免费观看视频| 亚洲国产美女福利直播秀一区二区 | 亚洲人av高清无码| 亚洲男人的天堂www| 午夜性色一区二区三区免费不卡视频 | 国产精品免费视频网站|