锘??xml version="1.0" encoding="utf-8" standalone="yes"?>最新国产精品亚洲,国产亚洲高清在线精品不卡,亚洲区小说区图片区 http://www.tkk7.com/michaelcao/zh-cn Mon, 12 May 2025 18:15:07 GMT Mon, 12 May 2025 18:15:07 GMT 60 鍒╃敤綰跨▼姹犱笂浼犲ぇ鏂囦歡(涓? http://www.tkk7.com/michaelcao/archive/2009/03/21/261173.html渚濈劧Fantasy 渚濈劧Fantasy Sat, 21 Mar 2009 02:40:00 GMT http://www.tkk7.com/michaelcao/archive/2009/03/21/261173.html http://www.tkk7.com/michaelcao/comments/261173.html http://www.tkk7.com/michaelcao/archive/2009/03/21/261173.html#Feedback 0 http://www.tkk7.com/michaelcao/comments/commentRss/261173.html http://www.tkk7.com/michaelcao/services/trackbacks/261173.html (鏂囩珷鏈漢鍘熷垱錛岃嫢杞澆璇鋒敞鏄庡嚭澶?
涓嬮潰鐪嬩竴涓嬩竴浜涘叿浣撶殑瀹炵幇錛屽厛鐪嬩竴涓婼ender鎺ュ彛鐨刢ommitData鏂規(guī)硶鐨凪ySql瀹炵幇錛屽嵆SenderMySqlImp綾伙細(xì)
public void commitData(String path, String file) {
......
Connection connect = null;
try {
// 鏍規(guī)嵁閰嶇疆鐢盚elper鏉ョ‘瀹氭槸鍚︾敤榪炴帴姹?榪欏彧璋冪敤getConnection()鍗沖彲
connect = Helper.getConnection();
connect.setAutoCommit(false);
FileInputStream fis = new FileInputStream(path + file);
//insert璇彞,鏈変笁涓弬鏁板垎鍒負(fù)id,image,filename瀛楁銆?/strong>
ps = connect.prepareStatement(sql.toString());
ps.setString(1, UUID.randomUUID().toString());
//灝嗗浘鐗囨枃浠舵祦鍖?鐢╦dbc鐩存帴鍐欏埌鏁版嵁搴?
ps.setBinaryStream(2, fis, fis.available());
ps.setString(3, file);
ps.executeUpdate();
connect.commit();
count++;
Logger.writeLog("宸插鐞嗘枃浠舵暟錛?+count+"錛屾椂闂達(dá)細(xì)"+new java.util.Date());
} catch (Exception e) {
........
}
寰堢畝鍗曞惂錛屽叾瀹炲氨鏄敤Stream鏉ュ仛錛屽彟澶栧湪緗戜笂鍙互鎵懼埌鏈夊叧Oracle涓婁紶blob鐨勫疄鐜幫紝涓鑸兘鏄厛insert涓鏉¤褰曪紝blob瀛楁鐢╡mpty_blob()鍑芥暟鎻掑叆涓涓┖鏁版嵁錛岀劧鍚庡啀鍙栧嚭榪欎釜blob瀛楁錛屾渶鍚庢寜瀛楄妭鍐欏叆blob錛屽叿浣撳弬鑰僑enderOracleImp綾誨惂銆備釜浜烘劅瑙夎繕鏄湪mysql鐨勮繖涓晥鐜囬珮浜涘茍涓旂湅璧鋒潵綆鍗曚簡寰堝銆?/p>
鐒跺悗鏉ョ湅鐪嬩嬌鐢ㄧ嚎紼嬫睜鐨凱rocessMulti綾伙細(xì)
public class ProcessMulti implements Process{
private String path;
private Vector < String > files = new Vector < String > ();
private Properties prop;
ProcessMulti() {
prop = ConfigMgr.getProperties(); //鍙朿onfig.properties涓厤緗俊鎭?br />
this .path = prop.getProperty( " path " );
this .files = Helper.getFiles(prop.getProperty( " filetype " ), this .path);
}
public void doProcess() {
//姝e鍓嶉潰涓ょ瘒鎵璇?榪欓噷鏄嚎紼嬫睜鏋勫緩鍣?浼犲叆鐩稿叧鍙傛暟
BlobSenderThreadPool tpe = new BlobSenderThreadPool(Integer
.valueOf(prop.getProperty( " corePoolSize " )), Integer
.valueOf(prop.getProperty( " maxPoolSize " )), Integer.valueOf(prop
.getProperty( " keepAliveTime " )), TimeUnit.SECONDS,
new ArrayBlockingQueue < Runnable > (Integer.valueOf(prop
.getProperty( " maxPoolSize " ))),
new BlobSenderThreadPool.DiscardPolicy(), files.size());
Logger.writeLogForce( " 寮濮嬪鐞?img src="http://www.tkk7.com/Images/dot.gif" alt="" />. " + new java.util.Date());
for ( int i = 0 ; i < this .files.size(); i ++ ) {
//鍚戠嚎紼嬫睜鎻愪氦瑕佸鐞嗙殑浠誨姟,綰跨▼姹犳牴鎹叾閰嶇疆榪涜澶勭悊
//Helper.getSender()浼?xì)鏍规嵁閰嵕|彇寰楁敮鎸乵ysql鎴栨槸oracel鐨勫啓鍏ユ柟娉?/strong>
tpe.execute( new Runner(path, files.get(i), Helper.getSender()));
Logger.writeLog( " 宸叉彁浜ょ " + ( int )(i + 1 ) + " 涓枃浠?/span>" + " 錛屾椂闂翠負(fù)錛?/span>"
+ new java.util.Date());
}
銆銆銆銆//鍙互鍦ㄨ繖閲屽啓涓涓墦鍗拌緭鍑?瀹為檯涓婄▼搴忓緢蹇氨鎵ц瀹屼笂闈㈢殑for,榪愯鍒拌繖閲?浣嗘槸澶勭悊騫舵病鏈夊畬鎴?
//涓葷▼搴忓ソ鍍忚亴涓氱粡鐞嗕漢,浠栫殑宸ヤ綔灝辨槸鍒嗛厤浠誨姟緇欎笅灞?鑷凡灝卞畬鎴愬伐浣滀簡,浣嗕笅灞炰滑榪樿鎺ョ潃蹇欐椿鍛靛懙...
System.out.println("浠誨姟宸插垎閰?..");
}
//綰跨▼姹犵被
class BlobSenderThreadPool extends ThreadPoolExecutor {
volatile int planTask;//璁″垝浠誨姟,鍗寵鍒掕鍐欑殑鏂囦歡鏁?br />
public BlobSenderThreadPool( int corePoolSize, int maximumPoolSize,
long keepAliveTime, TimeUnit unit,
BlockingQueue < Runnable > workQueue,
RejectedExecutionHandler handler, int planTask) {
super (corePoolSize, maximumPoolSize, keepAliveTime, unit, workQueue);
this .planTask = planTask;
}
@Override
//褰撴煇涓嚎紼嬪鐞嗗畬鏃朵細(xì)璋冪敤姝ゆ柟娉?/strong>
protected void afterExecute(Runnable r, Throwable t) {
Logger.writeLog( " 褰撳墠宸插畬鎴愪換鍔℃暟錛?/span>" + ( int )( this .getCompletedTaskCount() + 1 )
+ " 璁″垝浠誨姟鏁幫細(xì) " + planTask);
//鑻ュ凡澶勭悊瀹屼換鍔″拰璁″垝鐨勪換鍔℃暟鐩稿悓璇存槑鎵鏈夌嚎紼嬪凡瀹屾垚澶勭悊,緇堟綰跨▼姹犲鐞?br />
銆銆銆銆銆銆if (( this .getCompletedTaskCount() + 1 ) == planTask)
this .terminated();
super .afterExecute(r, t);
}
@Override
protected void terminated() {
Logger.writeLogForce( " 鎵鏈変換鍔″凡瀹屾垚 ,澶勭悊緇撴潫鏃墮棿===>> " + new java.util.Date());
System.exit( 0 );
}
}
//瑕佷嬌鐢ㄧ嚎紼嬭繘琛屽鐞?綾昏瀹炵幇Runable鎺ュ彛
class Runner implements Runnable {
String file;
String path;
Sender sender;
Runner(String path, String file, Sender sender) {
this .file = file;
this .path = path;
this .sender = sender;
}
//Runer鐨勫疄渚嬩細(xì)琚紶鍏ョ嚎紼嬫睜,綰跨▼琚繍琛屾椂浼?xì)璋冪敤run鏂規(guī)硶
public void run() {
sender.commitData(path, file);
}
}
]]>鍒╃敤綰跨▼姹犱笂浼犲ぇ鏂囦歡(浜? http://www.tkk7.com/michaelcao/archive/2009/03/21/261167.html渚濈劧Fantasy 渚濈劧Fantasy Sat, 21 Mar 2009 02:25:00 GMT http://www.tkk7.com/michaelcao/archive/2009/03/21/261167.html http://www.tkk7.com/michaelcao/comments/261167.html http://www.tkk7.com/michaelcao/archive/2009/03/21/261167.html#Feedback 0 http://www.tkk7.com/michaelcao/comments/commentRss/261167.html http://www.tkk7.com/michaelcao/services/trackbacks/261167.html (鏂囩珷鏈漢鍘熷垱錛岃嫢杞澆璇鋒敞鏄庡嚭澶?
銆銆鍦ㄥ疄闄呭綋涓殑鎯呭喌鏄郴緇熸暟鎹簱涓渶瑕佷笂浼犲ぇ閲忕収鐗囧埌鏁版嵁搴撲腑錛屾暟鎹噺姣旇緝澶э紝涓斾笉鑳藉湪鐣岄潰涓氳繃鎿嶄綔閫愪釜涓婁紶錛岃鎵歸噺鑷姩榪涜銆傚叾瀹炶搗鏉ヤ篃姣旇緝綆鍗曠洿鎺ュ埄鐢ㄧ嚎紼嬫睜灝嗙収鐗囨暟鎹鍙栨垚嫻佸啀瀛樺叆BLOB瀛楁鍗沖彲銆備絾鏄湪瀹炵幇鍚庝簺鍔熻兘鍚庡張榪涘叆浜嗕竴浜涙敼閫狅紝瀹炵幇浜嗙嚎紼嬫睜銆佸崟綰跨▼銆佹槸鍚︿嬌鐢ㄧ敤榪炴帴姹犮佷笉鍚屾暟鎹簱絳変笉鍚岀殑閰嶇疆錛岃繖鏍峰湪涓嶅悓閰嶇疆涓嬪彲浠ヨ瀵熷埌紼嬪簭鎬ц兘鐨勪笉鍚屻傚茍涓旂粡榪囪璁″垏鎹㈣繖浜涢厤緗笉闇瑕佷慨鏀圭▼搴忋?/p>
浣跨敤DbAccess鎺ュ彛鐨刧etConnect()鍙栧緱鏁版嵁搴撹繛鎺ワ紝DbImp鍜孌bPoolingImp瀹炵幇浜嗕笉浣跨敤榪炴帴姹犲拰浣跨敤榪炴帴姹犵殑涓や釜鐗堟湰銆係ender鎺ュ彛鐨刢ommitData()鐢ㄦ潵鎶夿LOB鏁版嵁鍐欏埌鏁版嵁搴撲腑錛屽洜涓轟笉鍚屾暟鎹簱鍙兘鍐欐硶鏈夌偣涓嶅悓鎵浠ヨ繖閲孲enderMySqlImp鍜孲enderOracleImp鍒嗗埆鏄疢ysql鍜孫racle鐨勫疄鐜般侾rocess鎺ュ彛鐨刣oProcess()鏄紑濮嬭繘琛屽鐞嗙殑鏂規(guī)硶錛屾棤璁烘槸鍗曠嚎紼嬭繕鏄綰跨▼銆傚洜姝rocessMulti鍜孭rocessSingle鏄垎鍒嬌鐢ㄧ嚎紼嬫睜浠ュ強(qiáng)鍗曠嚎紼嬪鐞嗙殑綾匯侰onfigMgr鐢ㄤ簬鍙栧緱config.properties鏂囦歡鍐呴厤緗俊鎭紝Logger鏄棩蹇楃被錛孒elper涓眹闆嗕簡涓浜涘叡鐢ㄧ殑闈欐佹柟娉曘傛渶鍚嶥ataSender鏄富紼嬪簭鐨勭被錛氾級
]]> 鍒╃敤綰跨▼姹犱笂浼犲ぇ鏂囦歡(涓) http://www.tkk7.com/michaelcao/archive/2009/03/19/260913.html渚濈劧Fantasy 渚濈劧Fantasy Thu, 19 Mar 2009 14:26:00 GMT http://www.tkk7.com/michaelcao/archive/2009/03/19/260913.html http://www.tkk7.com/michaelcao/comments/260913.html http://www.tkk7.com/michaelcao/archive/2009/03/19/260913.html#Feedback 0 http://www.tkk7.com/michaelcao/comments/commentRss/260913.html http://www.tkk7.com/michaelcao/services/trackbacks/260913.html (鏂囩珷鏈漢鍘熷垱錛岃嫢杞澆璇鋒敞鏄庡嚭澶?
銆銆銆鍦↗DK1.5鎻愪緵浜嗕竴涓嚎紼嬫睜ThreadPoolExecutor錛屽彲浠ュ鐞嗙敤鎴鋒彁浜よ繃鏉ョ殑綰跨▼銆傚鏋滄妸瑕佸鐞嗙殑浠誨姟姣斾綔鐩栦竴涓ぇ妤鹼紝閭d箞姣忎竴涓緩絳戝伐浜哄氨鐩稿綋浜庝竴涓嚎紼嬶紝閭d箞榪欎釜ThreadPoolExecutor灝卞ソ鍍忓寘宸ュご錛屽畠鏉ユ帶鍒剁洊榪欎釜澶фゼ闇瑕佸灝戜釜宸ヤ漢錛屼綍鏃舵嫑榪涙柊宸ヤ漢錛屼綍鏃惰緸閫宸茬粡闀挎椂闂存病鏈変簨鍋氱殑宸ヤ漢錛岀瓑絳夋綾諱簨鍔°備篃灝辨槸璇寸敤鎴風(fēng)▼搴忎笉鏂彁浜ゆ柊鐨勭嚎紼嬶紝ThreadPoolExecutor鎵ц鎻愪氦綰跨▼鐨勫悓鏃朵細(xì)鎺у埗鐩墠鎬誨叡鍚屾椂鎵ц鐨勭嚎紼嬫暟錛岄攢姣佸凡鎵ц瀹岄棽緗殑綰跨▼絳夋帶鍒惰涓猴紝淇濈暀鏈灝戦棽緗嚎紼嬫暟錛屽茍涓斿彲浠ラ厤緗笉鍚岀殑澶勭悊絳栫暐銆?/p>
銆銆銆涓轟粈涔堣浣跨敤綰跨▼姹犲憿錛岃繖涓庢暟鎹簱榪炴帴姹犵殑鍘熺悊鏈夌偣鐩鎬豢錛岀嚎紼嬬殑鍒涘緩鏄渶瑕佹垚鏈殑錛屽寘鎷湇鍔″櫒CPU鍜屽唴瀛樿祫婧愶紝鐢變簬澶氱嚎紼嬫槸騫惰榪愯錛岀▼搴忚繍琛岃繃紼嬩腑鍙兘鏈夌殑綰跨▼宸茬粡瀹屾垚鑷韓澶勭悊浠誨姟錛屽浜庨棽緗姸鎬侊紝濡傛灉鍦ㄨ繖縐嶆儏鍐典笅鍐嶄笉鏂垱寤烘柊浠誨姟灝辨槸鍦ㄦ氮璐規(guī)湇鍔″櫒璧勬簮錛屾鏃跺簲璇ュ敖閲忎嬌鐢ㄥ厛鍓嶅垱寤虹殑濂界殑騫朵笖鏄鐞嗛棽緗姸鎬佺殑綰跨▼鏉ュ鐞嗘柊浠誨姟錛岃岀嚎紼嬫睜灝卞彲浠ユ湁鏁堢殑瀵規(guī)榪涜鑷姩鍖栫鐞嗭紝褰撶劧榪欎釜綆$悊鏄彲浠ョ敱鐢ㄦ埛閰嶇疆鐨勩?/p>
ThreadPoolExecutor(int corePoolSize,
int maximumPoolSize,
long keepAliveTime,
TimeUnit unit,
BlockingQueue<Runnable> workQueue,
RejectedExecutionHandler handler)
榪欐槸綰跨▼姹犵殑鏋勫緩鍣紝鐢ㄦ埛紼嬪簭閫氳繃榪欎釜鏋勫緩鍣ㄤ紶鍙傛暟錛宑orePoolSize鏄嚎紼嬫睜涓牳蹇冪嚎紼嬫暟錛岃繍琛岀殑綰跨▼鏁頒笉鑳藉皯浜庤繖涓牳蹇冪嚎紼嬫暟錛屽惁鍒欏氨鏂板緩綰跨▼銆俶aximumPoolSize鏄厖璁告渶澶х殑綰跨▼鏁般俴eepAliveTime璁劇疆闄ゆ牳蹇冪嚎紼嬪鍏跺畠綰跨▼鐨勭┖闂叉椂闂達(dá)紝瓚呰繃榪欎釜鏃墮棿綰跨▼灝辮嚜鍔ㄧ粓姝€倁nit鏄寚鐨刱eepAliveTime鐨勬椂闂村崟浣嶃侭lockingQueue鎺ュ彛鎸夌敓浜у垯娑堣垂鑰呯畻娉曡璁$殑涓涓嚎紼嬫睜鍐呴儴澶勭悊綰跨▼闃熷垪鐨勬帴鍙o紝鏈変笁縐嶅疄鐜癝ynchronousQueue銆丩inkedBlockingQueue鍜孉rrayBlockingQueue錛屽湪瀹為檯榪愯紼嬪簭鏃跺彲浠ユ牴鎹繖涓夌瀹炵幇寰楀埌涓嶅悓鐨勬ц兘錛屾瘮濡傛湁鐨勫疄鐜板彲鑳藉湪鏈夋柊浠誨姟鏉ユ椂涓嶆柊寤虹嚎紼嬶紝鑰屾槸灝嗗叾鍔犲叆絳夊緟闃熷垪錛岀瓑鏈夌嚎紼嬭繍琛屽畬鏃跺啀鍒嗛厤緇欏叾浣跨敤銆傚叿浣撳疄鐜拌繕鏄弬鐪嬪畠浠殑JDK鏂囨。鍚э紝榪欓噷绔欏湪浣跨敤鐨勮搴﹀畠浠槸鍙互璋冩暣榪愯鎬ц兘鐨勫紑鍏熾傚綋鏈澶х嚎紼嬪拰宸ヤ綔闃熷垪瀹歸噺閮借揪鍒版渶澶у兼椂錛屽啀鎻愪氦緇欑嚎紼嬫睜鏂頒換鍔″氨浼?xì)琚嫆缁濆Q屾鏃剁嚎紼嬫睜浼?xì)璋冪敤RejectedExecutionHandler 鎺ュ彛榪涜澶勭悊錛屽叿浣撳疄鐜版湁鍥涚絳栫暐銆傛垜浠彧闇瑕侀夌敤鍏朵腑涓縐嶅湪鏋勫緩ThreadPoolExecutor鏃朵紶鍏ュ嵆鍙傚叿浣撳洓縐嶅疄鐜拌繕鏄弬鐪婮DK鏂囨。鍚с?a >鍏充簬ThreadPoolExecutor鐨凧DK鏂囨。銆傝嚦姝ゆ帶鍒剁嚎紼嬫睜榪愪綔鐨勫嚑涓弬鏁伴兘浠庢瀯寤哄櫒涓紶鍏ヤ簡銆?/p>
]]> Oracle涓繑鍥炵粨鏋滈泦鐨勫瓨鍌ㄨ繃紼?/title> http://www.tkk7.com/michaelcao/archive/2009/01/13/251189.html渚濈劧Fantasy 渚濈劧Fantasy Tue, 13 Jan 2009 13:55:00 GMT http://www.tkk7.com/michaelcao/archive/2009/01/13/251189.html http://www.tkk7.com/michaelcao/comments/251189.html http://www.tkk7.com/michaelcao/archive/2009/01/13/251189.html#Feedback 0 http://www.tkk7.com/michaelcao/comments/commentRss/251189.html http://www.tkk7.com/michaelcao/services/trackbacks/251189.html google浜嗕竴綃囦笉閿欑殑渚嬪瓙錛屽姞浜嗙偣娉ㄨВ錛岃繖鏍風(fēng)湅璧鋒潵鏇存柟渚夸簡錛氾級
Oracle涓嶅儚SQLServer閭f牱鍦ㄥ瓨鍌ㄨ繃紼嬩腑鐢⊿elect灝卞彲浠ヨ繑鍥炵粨鏋滈泦錛岃屾槸閫氳繃Out鍨嬬殑鍙傛暟榪涜緇撴灉闆嗚繑鍥炵殑銆傚疄闄呬笂鏄埄鐢≧EF CURSOR
--procedure榪斿洖璁板綍闆嗭細(xì)
----------------------澹版槑涓涓狿ackage--------------
CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE get (p_id NUMBER, p_rc OUT myrctype ); --Package涓0鏄庡悕涓篻et 鐨凱rocedure(鍙湁鎺ュ彛娌″唴瀹?
END pkg_test;
--------------------------------------------------------
-----------------澹版槑Package Body錛屽嵆涓婇潰Package涓殑鍐呭錛屽寘鎷琍rocedure get---------------------
CREATE OR REPLACE PACKAGE BODY pkg_test
AS
PROCEDURE get (p_id NUMBER, p_rc OUT myrctype )
IS
sqlstr VARCHAR2 (500);
BEGIN
IF p_id = 0 THEN
OPEN p_rc FOR
SELECT ID, NAME, sex, address, postcode, birthday
FROM student;
ELSE
sqlstr :=
'select id,name,sex,address,postcode,birthday
from student where id=:w_id '; --w_id鏄釜鍙傛暟錛?/p>
--浠ヤ笅 p_rc鏄釜 REF CURSOR 娓告爣綾誨瀷錛岃屼笖鏄疧UT鍨嬪弬鏁幫紝鍗沖彲榪斿洖涓涓褰曢泦浜嗐俇SING p_id灝辨槸鏇挎崲涓婇潰SQL涓?w_id鍊兼媺:)
OPEN p_rc FOR sqlstr USING p_id;銆
END IF;
END get;
END pkg_test;
--function榪斿洖璁板綍闆嗙殑渚嬪瓙錛屽師鐞嗗拰涓婇潰鐩稿悓錛岃屾槸鐢╢unction鐨剅eturn鍊兼潵榪斿洖璁板綍闆嗐?/strong>
鍑芥暟榪斿洖璁板綍闆?
寤虹珛甯ef cursor瀹氫箟鐨勫寘鍜屽寘浣撳強(qiáng)鍑芥暟錛?
CREATE OR REPLACE
package pkg_test as
/* 瀹氫箟ref cursor綾誨瀷
涓嶅姞return綾誨瀷錛屼負(fù)寮辯被鍨嬶紝鍏佽鍔ㄦ乻ql鏌ヨ錛?
鍚﹀垯涓哄己綾誨瀷錛屾棤娉曚嬌鐢ㄥ姩鎬乻ql鏌ヨ;
*/
type myrctype is ref cursor;
function get(intID number) return myrctype;
end pkg_test;
/
CREATE OR REPLACE
package body pkg_test as
--鍑芥暟浣?
function get(intID number) return myrctype is
rc myrctype; --瀹氫箟ref cursor鍙橀噺
sqlstr varchar2(500);
begin
if intID=0 then
--闈欐佹祴璇曪紝鐩存帴鐢╯elect璇彞鐩存帴榪斿洖緇撴灉
open rc for select id,name,sex,address,postcode,birthday from student;
else
--鍔ㄦ乻ql璧嬪鹼紝鐢?w_id鏉ョ敵鏄庤鍙橀噺浠庡閮ㄨ幏寰?
sqlstr := 'select id,name,sex,address,postcode,birthday from student where id=:w_id';
--鍔ㄦ佹祴璇曪紝鐢╯qlstr瀛楃涓茶繑鍥炵粨鏋滐紝鐢╱sing鍏抽敭璇嶄紶閫掑弬鏁?
open rc for sqlstr using intid;
end if;
return rc;
end get;
end pkg_test;
]]> 鍦∣RACLE瀛樺偍榪囩▼涓垱寤轟復(fù)鏃惰〃 http://www.tkk7.com/michaelcao/archive/2009/01/13/251185.html渚濈劧Fantasy 渚濈劧Fantasy Tue, 13 Jan 2009 13:23:00 GMT http://www.tkk7.com/michaelcao/archive/2009/01/13/251185.html http://www.tkk7.com/michaelcao/comments/251185.html http://www.tkk7.com/michaelcao/archive/2009/01/13/251185.html#Feedback 0 http://www.tkk7.com/michaelcao/comments/commentRss/251185.html http://www.tkk7.com/michaelcao/services/trackbacks/251185.html 鍦∣RACLE瀛樺偍榪囩▼涓垱寤轟復(fù)鏃惰〃
瀛樺偍榪囩▼閲屼笉鑳界洿鎺ヤ嬌鐢―DL璇彞錛屾墍浠ュ彧鑳戒嬌鐢ㄥ姩鎬丼QL璇彞鏉ユ墽琛?/span>
--ON COMMIT DELETE ROWS 璇存槑涓存椂琛ㄦ槸浜嬪姟鎸囧畾錛屾瘡嬈℃彁浜ゅ悗ORACLE灝嗘埅鏂〃錛堝垹闄ゅ叏閮ㄨ錛?
--ON COMMIT PRESERVE ROWS 璇存槑涓存椂琛ㄦ槸浼?xì)璇濇寚瀹氬Q屽綋涓柇浼?xì)璇濇椂ORACLE灝嗘埅鏂〃銆?/p>
CREATE OR REPLACE PROCEDURE temptest
(p_searchDate IN DATE)
IS
v_count INT;
str varchar2(300);
BEGIN
v_count := 0;
str:='drop table SETT_DAILYTEST';
execute immediate str;
str:='CREATE GLOBAL TEMPORARY TABLE SETT_DAILYTEST (
NACCOUNTID NUMBER not null,
NSUBACCOUNTID NUMBER not null)
ON COMMIT PRESERVE ROWS';
execute immediate str; ----浣跨敤鍔ㄦ丼QL璇彞鏉ユ墽琛?/span>
str:='insert into SETT_DAILYTEST (select naccountid,nsubaccountid from sett_dailyaccountbalance)';
execute immediate str;
END temptest;
涓婇潰寤虹珛涓涓復(fù)鏃惰〃鐨勫瓨鍌ㄨ繃紼?/p>
涓嬮潰鏄墽琛屼竴浜涙搷浣?鍚戜復(fù)鏃惰〃鍐欐暟鎹?/p>
CREATE OR REPLACE PROCEDURE PR_DAILYCHECK
(
p_Date IN DATE,
p_Office IN INTEGER,
p_Currency IN INTEGER,
P_Check IN INTEGER,
p_countNum OUT INTEGER)
IS
v_count INT;
BEGIN
v_count := 0;
IF p_Date IS NULL THEN
dbms_output.put_line('鏃ユ湡涓嶈兘涓虹┖');
ELSE
IF P_Check = 1 THEN
insert into SETT_DAILYTEST (select naccountid,nsubaccountid from sett_dailyaccountbalance
where dtdate = p_Date);
select
count(sd.naccountid) into v_count
from sett_subaccount ss,sett_account sa,sett_dailytest sd
where sd.naccountid = sa.id and sd.nsubaccountid = ss.id and sa.id = ss.naccountid
AND sa.nofficeid = p_Office AND sa.ncurrencyid = p_Currency
and rownum < 2;
COMMIT;
p_countNum := v_count;
dbms_output.put_line(p_countNum);
END IF;
IF P_Check = 2 THEN
insert into SETT_DAILYTEST (select naccountid,nsubaccountid from sett_dailyaccountbalance
where dtdate = p_Date);
select
count(sd.naccountid) into v_count
from sett_cfsubaccount ss,sett_account sa,sett_dailytest sd
where sd.naccountid = sa.id and sd.nsubaccountid = ss.id and sa.id = ss.naccountid
AND sa.nofficeid = p_Office AND sa.ncurrencyid = p_Currency
and rownum < 2;
COMMIT;
p_countNum := v_count;
dbms_output.put_line(p_countNum);
END IF;
END IF;
END PR_DAILYCHECK;
]]> Oracle:PL/SQL 涓浣曚嬌鐢ˋrray http://www.tkk7.com/michaelcao/archive/2009/01/13/251183.html渚濈劧Fantasy 渚濈劧Fantasy Tue, 13 Jan 2009 13:07:00 GMT http://www.tkk7.com/michaelcao/archive/2009/01/13/251183.html http://www.tkk7.com/michaelcao/comments/251183.html http://www.tkk7.com/michaelcao/archive/2009/01/13/251183.html#Feedback 0 http://www.tkk7.com/michaelcao/comments/commentRss/251183.html http://www.tkk7.com/michaelcao/services/trackbacks/251183.html Oracle鏈韓娌℃暟緇勭殑姒傚康錛屼絾鏄氳繃Oracle鐨凜ollections鍜孯ecords綾誨瀷鍙互妯′豢鍑哄崟緇存暟緇勫拰澶氱淮鏁扮粍銆?/p>
璇峰弬鑰?lt;<Oracle PL/SQL Programming>> Chapter 11銆丆hapter 12銆?/p>
---------------------- 鍗曠淮鏁扮粍 ------------------------
DECLARE
TYPE emp_ssn_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; ----娉細(xì)澹版槑涓涓狢ollection
best_employees emp_ssn_array;
worst_employees emp_ssn_array;
BEGIN
best_employees(1) := '123456';
best_employees(2) := '888888';
worst_employees(1) := '222222';
worst_employees(2) := '666666';
FOR i IN 1..best_employees.count LOOP
DBMS_OUTPUT.PUT_LINE('i='|| i || ', best_employees= ' ||best_employees(i)
|| ', worst_employees= ' ||worst_employees(i));
END LOOP;
END;
---------------------- 澶氱淮鏁扮粍 ------------------------
DECLARE
TYPE emp_type IS RECORD ---------娉細(xì)澹版槑涓涓猂ecord綾誨瀷銆emp_type
( emp_id employee_table.emp_id%TYPE, 銆銆銆銆銆銆銆銆銆銆----Record綾誨瀷涓殑鎴愬憳...
emp_name employee_table.emp_name%TYPE,
emp_gender employee_table.emp_gender%TYPE );
TYPE emp_type_array IS TABLE OF ----娉細(xì)澹版槑涓涓狢ollection綾誨瀷 emp_type_array 錛屽叾涓厓绱犱負(fù)emp_type綾誨瀷
emp_type INDEX BY BINARY_INTEGER;
emp_rec_array emp_type_array;
emp_rec emp_type;
BEGIN
emp_rec.emp_id := 300000000;
emp_rec.emp_name := 'Barbara';
emp_rec.emp_gender := 'Female';
emp_rec_array(1) := emp_rec;
emp_rec.emp_id := 300000008;
emp_rec.emp_name := 'Rick';
emp_rec.emp_gender := 'Male';
emp_rec_array(2) := emp_rec;
FOR i IN 1..emp_rec_array.count LOOP
DBMS_OUTPUT.PUT_LINE('i='||i
||', emp_id ='||emp_rec_array(i).emp_id
||', emp_name ='||emp_rec_array(i).emp_name
||', emp_gender = '||emp_rec_array(i).emp_gender);
END LOOP;
END;
-------------- Result --------------
i=1, emp_id =300000000, emp_name =Barbara, emp_gender = Female
i=2, emp_id =300000008, emp_name =Rick, emp_gender = Male
]]> Oracle PL/SQL浣跨敤%TYPE鍜?ROWTYPE http://www.tkk7.com/michaelcao/archive/2009/01/07/250212.html渚濈劧Fantasy 渚濈劧Fantasy Wed, 07 Jan 2009 00:38:00 GMT http://www.tkk7.com/michaelcao/archive/2009/01/07/250212.html http://www.tkk7.com/michaelcao/comments/250212.html http://www.tkk7.com/michaelcao/archive/2009/01/07/250212.html#Feedback 2 http://www.tkk7.com/michaelcao/comments/commentRss/250212.html http://www.tkk7.com/michaelcao/services/trackbacks/250212.html Oracle PL/SQL涓浣曚嬌鐢?TYPE鍜?ROWTYPE (杞澆)
1. 浣跨敤%TYPE
鍦ㄨ澶氭儏鍐典笅錛孭L/SQL鍙橀噺 鍙互鐢ㄦ潵瀛樺偍鍦ㄦ暟 鎹簱琛ㄤ腑鐨勬暟鎹傚湪榪欑鎯呭喌涓嬶紝鍙橀噺搴旇鎷ユ湁涓庤〃鍒楃浉鍚岀殑綾誨瀷銆備緥濡傦紝students琛ㄧ殑first_name鍒楃殑綾誨瀷涓篤ARCHAR2(20),鎴戜滑鍙互鎸夌収涓嬭堪鏂瑰紡澹版槑涓涓彉閲忥細(xì)
DECLARE
v_FirstName VARCHAR2(20);
浣嗘槸濡傛灉first_name鍒楃殑瀹氫箟鏀瑰彉浜嗕細(xì)鍙戠敓浠涔堬紙姣斿璇磋〃鏀瑰彉浜嗭紝first_name鐜板湪鐨勭被鍨嬪彉涓篤ARCHAR2(25)錛夛紵閭e氨浼?xì)瀵艰嚧鎵鏈変嬌鐢ㄨ繖涓垪鐨凱L/SQL浠g爜閮藉繀欏昏繘琛屼慨鏀廣傚鏋滀綘鏈夊緢澶氱殑PL/SQL浠g爜錛岃繖縐嶅鐞嗗彲鑳芥槸鍗佸垎鑰楁椂鍜屽鏄撳嚭閿欑殑銆?
榪欐椂錛屼綘鍙互浣跨敤"%TYPE"灞炴ц屼笉鏄皢鍙橀噺綾誨瀷紜х紪鐮併?
渚嬪錛?
DECLARE
v_FirstName students.first_name%TYPE;
閫氳繃浣跨敤%TYPE,v_FirstName鍙橀噺灝嗗悓students琛ㄧ殑first_name鍒楃殑綾誨瀷鐩稿悓錛堝彲浠ョ悊瑙d負(fù)灝嗕袱鑰呴偊瀹氳搗鏉ワ級銆?
姣忔鍖垮悕鍧楁垨鍛藉悕鍧楄繍琛岃璇彞鍧椾互鍙?qiáng)缂栬瘧瀛樺偍瀵硅薄锛垬q囩▼銆?zmkey style="border-bottom: 2px dotted rgb(255, 108, 0); font-weight: bold; float: none; cursor: pointer; margin-right: 3px;" class="zoomino-searchword">鍑芥暟銆佸寘銆佸璞$被鍜?zmkey style="border-bottom: 2px dotted rgb(255, 108, 0); font-weight: bold; float: none; cursor: pointer; margin-right: 3px;" class="zoomino-searchword">瑙﹀彂鍣?/zmkey>錛夋椂錛屽氨浼?xì)纭畾璇ゾc誨瀷銆?
浣跨敤%TYPE鏄潪甯稿ソ鐨勭紪紼嬮鏍鹼紝鍥犱負(fù)瀹冧嬌寰桺L/SQL鏇村姞鐏墊椿錛屾洿鍔犻傚簲浜?zmkey style="border-bottom: 2px dotted rgb(255, 108, 0); font-weight: bold; float: none; cursor: pointer; margin-right: 3px;" class="zoomino-searchword">瀵規(guī)暟鎹簱瀹氫箟鐨勬洿鏂般?
2. 浣跨敤%ROWTYPE
2.1 PL/SQL璁板綍
PL/SQL璁板綍綾誨瀷綾諱技浜嶤璇█涓殑緇撴瀯錛屾槸涓縐嶅鍚堢被鍨嬶紝鏄敤鎴?zmkey style="border-bottom: 2px dotted rgb(255, 108, 0); font-weight: bold; float: none; cursor: pointer; margin-right: 3px;" class="zoomino-searchword">鑷畾涔?/zmkey>鐨勩?
璁板綍鎻愪緵浜嗕竴縐嶅鐞嗙嫭绔嬬殑浣嗗張浣滀負(fù)涓涓暣浣撳崟鍏冪浉鍏崇殑鍙橀噺鐨勬満鍒躲傝鐪嬶細(xì)
DECLARE
v_StudentID NUMBER(5);
v_FirstName VARCHAR2(20);
v_LastName VARCHAR2(20);
榪?涓彉閲忓湪閫昏緫涓婃槸鐩鎬簰鍏寵仈鐨勶紝鍥犱負(fù)浠栦滑鎸囧悜students琛ㄤ腑涓嶅悓鐨?zmkey style="border-bottom: 2px dotted rgb(255, 108, 0); font-weight: bold; float: none; cursor: pointer; margin-right: 3px;" class="zoomino-searchword">瀛楁銆傚鏋滀負(fù)榪欎簺鍙橀噺澹版槑涓涓褰曠被鍨嬶紝閭d箞浠栦滑涔嬮棿鐨勫叧緋誨氨鍗佸垎鏄庢樉錛屽彲浣滀負(fù)涓涓崟鍏冭繘琛屽鐞嗐?
DECLARE
/*Define a record type to hold common student informationi*/
TYPE t_StudentRecord IS RECORD(
StudentID NUMBER(5),
FirstName VARCHAR2(20),
LastName VARCHAR2(20);
/*Declare a variable of this type.*/
v_StudentInfo t_StudentRecord;
2.2 璁板綍璧嬪?
鍙互鐢⊿ELECT璇彞鍚戣褰曡祴鍊鹼紝榪欏皢浼?xì)浠庢暟鎹簱涓瓔個绱㈡暟鎹茍灝嗚鏁版嵁瀛樺偍 鍒拌褰曚腑銆傛敞鎰忕殑鏄紝璁板綍涓瓧孌靛簲璇ュ拰鏌ヨ緇撴灉鍒楄〃涓殑瀛楁鐩稿尮閰嶃?
SELECT studentID,firstName,lastName
into v_StudentInfo
from students where studentID=32;
2.3 浣跨敤%ROWTYPE
鍦≒L/SQL涓皢涓涓褰曞0鏄庝負(fù)鍏鋒湁鐩稿悓綾誨瀷鐨勬暟鎹簱琛岀殑浣滄硶鏄緢甯歌鐨勩侾L/SQL鎻愪緵浜?ROWTYPE榪愮畻絎?/zmkey>錛屼嬌寰楄繖鏍風(fēng)殑鎿嶄綔鏇翠負(fù)鏂逛究銆?
渚嬪錛?
DECLARE
v_RoomRecord rooms%ROWTYPE;
灝嗗畾涔変竴涓褰曪紝璇ヨ褰曚腑鐨勫瓧孌靛皢涓巖ooms琛ㄤ腑鐨勫垪鐩稿搴斻?/p>
]]> 閲嶅洖NOKIA鎬鎶?/title> http://www.tkk7.com/michaelcao/archive/2008/10/13/234121.html渚濈劧Fantasy 渚濈劧Fantasy Mon, 13 Oct 2008 14:59:00 GMT http://www.tkk7.com/michaelcao/archive/2008/10/13/234121.html http://www.tkk7.com/michaelcao/comments/234121.html http://www.tkk7.com/michaelcao/archive/2008/10/13/234121.html#Feedback 0 http://www.tkk7.com/michaelcao/comments/commentRss/234121.html http://www.tkk7.com/michaelcao/services/trackbacks/234121.html 銆銆鍛?鎵嬫満涓嶅垢琚洍錛屽彲鎭剁殑灝忓伔錛屽伔鎴戠殑鎵嬫満浣犲氨鏂墜鏂剼鍚с傛槑澶╁噯澶囪仈緋葷儲鐖卞拰縐誨姩瀹㈡湇鐪嬫槸鍚﹁兘閫氳繃鎵嬫満涓茬爜鎶婃墜鏈哄睆钄斤紝鎹浠庢妧鏈搴﹁鏄彲浠ヨ鐨勯氱殑錛岄棶棰樺氨鏄繖縐嶄簨鎵嬫満榪愯惀鍟嗘効涓嶆効鎰忕粰鍋氫簡銆?a >鑻卞浗宸茬粡鏈夎繖縐嶆湇鍔″彲浠ヤ嬌琚洍鎵嬫満涓嶈兘鍐嶈浣跨敤錛屼笉鐭ラ亾鐗硅壊涓浗鍟ユ椂鑳芥湁榪欑鐪熸鐗硅壊鐨勬湇鍔″憿銆?/p>
鎴戠殑绱㈢埍W810鍚煶涔愰煶璐ㄨ秴濂斤紝鍏ヨ沖紡鑰蟲満涔熷緢媯掞紝鎰熻姣斾笓涓氱殑欖呮棌MP3榪橀珮涓絳?涓昏欖呮棌甯︾殑鑰蟲満澶儌,鑰屼笖欖呮棌闊寵川椋庢牸鏈夌偣鍋?鐗瑰埆閰嶄笂鑷甫鑰蟲満鍚庡惉闊充箰濉戞枡鎰熸瀬寮?銆倃810闊寵川椋庢牸鍩烘湰涓婂氨鏄疭ONY鏃╁勾CDWalkMan閭g鏃ョ郴椋庢牸錛屽姞涓婂叆鑰沖紡鑰蟲満浣庨煶寰堝己銆傚彟澶朏M鏀墮煶鍔熻兘涔熷緢涓嶉敊錛屼俊鍙峰緢濂斤紝榪欎釜鎴戜篃鏄拰欖呮棌鐨凪P3瀵規(guī)瘮榪囩殑錛屽悓鏍風(fēng)幆澧冧笅FM鏀墮煶淇″彿涔熷己涓浜涳紝鐩稿鐢變簬淇″彿寮遍犳垚鐨勮儗鏅櫔闊沖皬涓浜?鍔犱笂澹伴煶娓叉煋淇グ鐨勫ソ,涓嶄細(xì)鏈夌敱浜庝俊鍙蜂笉濂介犳垚鐨勫埡鑰沖0銆俉810鐨勬媿鐓у姛鑳戒篃涓嶉敊錛屾媿鐨勭収鐗囷紝鐗瑰埆鏄櫧澶╁厜綰垮ソ鏃訛紝鎷嶅嚭鏉ョ殑鐓х墖鍩烘湰涓婂彲浠ュ啋鍏呮暟鐮佺浉鏈虹殑浜嗐傛諱箣錛岀敤浜嗕竴騫達(dá)紝鎰熻W810鏈澶х己鐐瑰氨鏄煭淇℃湁瀹歸噺闄愬埗錛屾垜鍩烘湰涓婂崐涓湀灝卞緱娓呬竴鍥炴敹浠剁銆備釜浜鴻涓簑810浣滀負(fù)鎵嬫満鏉ョ敤鏄瘮涓嶄笂NOKIA鐨勫ソ鐢紝浣嗘槸闅忚韓鍚佹媿鐓у姛鑳界殑紜緢濂斤紝浼拌绱㈢埍鐨刉緋誨垪鍩烘湰涔熼兘鏄繖鏍楓傚搸鍙儨鐜板湪榪炰釜灝鎬綋閮芥病鐣欎笅..鎬蹇靛憖.....
w810
銆銆騫蟲椂蹇欐病鏃墮棿閫涘晢搴楋紝鍛?鍒版花姹熼亾婧滆揪浜嗕竴鍦堬紝鎹崠鎵嬫満鐨勬湇鍔″憳璇達(dá)紝澶╄鎵嬫満閿閲忓凡緇忚兘鍜孨OKIA鏈夌殑涓鎷間簡錛屾兂鎯充竴騫村鍓嶈繕鏄悕涓嶈緇忎紶錛屼笘鐣屽彉鍖栧揩鍛銆傜敱浜庝箣鍓嶅湪娣樺疂涓婄湅榪囦環(huán)鏍間簡錛屾墍浠ユ棤璁哄摢嬈炬墜鏈洪棬搴楅噷鐨勪環(huán)鏍煎熀鏈笂娌℃硶鎺ュ彈浜嗐傜幇鍦ㄦ秷璐硅蹇靛凡涓嶅悓浠庡墠浜?鏈夊彲鑳借鍏ㄧ悆緇忔祹鍗辨満鍚撳緱鍛靛懙锝?錛屽熀鏈笂2000鍏冧互涓婄殑鎵嬫満灝變笉鐪嬩簡錛屾壘浜嗗嚑嬈句粈涔堢儲鐖?a >M600i銆?a >880i浠ュ強(qiáng)澶忔柊E78 ...鏈鍚庤繕鏄洖鍙戠幇騫查夯涓嶄拱涓狽OKIA鏅鴻兘鏈虹殑鍛紝鎴戝湪W810鍓嶅氨鏄敤鐨凬OKIA6630鍛錛屽綋鏃舵劅瑙夋櫤鑳芥満寰堝己澶у緢DIY銆傛渶鍚庡彂鐜版窐瀹濅笂N72琛岃揣浠鋒牸宸茬粡鎺夊埌1300宸﹀彸(鍒氬嚭鏃跺緱鏈変笁鍥涘崈浜?錛岃繕緇欏紑鍙戠エ鍜屽叏鍥借仈淇濓紝OMG瓚呭鹼紝灝辨槸瀹冧簡.....銆
銆銆娌℃兂鍒伴偅涓?a >鍗栧鍒湅淇$敤鍊間笉楂橈紝涓滆タ鐩稿渚垮疁錛屾湇鍔℃佸害鍒版槸瓚呭ソ錛屽熀鏈笂綆楁槸閫佷簡涓?GB鍗★紝鍛ㄦ棩鎷嶅懆涓鏅氫笂灝辨敹鍒拌揣浜嗭紝涓鐪嬪寘瑁呭啓鐫鏄┖榪?..涓滆タ涔熶笉閿欙紝寮灝佸悗鏈哄櫒娌℃湁浠諱綍闂錛岃繕鏈夋瑙勫彂紲ㄣ傛湁鐨勪俊鐢ㄥ間笉楂樼殑鍗栧浼拌鏄兂钖勫埄澶氶攢鎷涙徑瀹㈡埛鍚э紝涓嶅儚鏈夌殑鍑犱釜閽繪垨鑰呮槸澶х殗鍐犵殑鍗栧錛屼拱涓笢瑗垮ソ鍍忚繕涓嶆槸寰堢儹鎯呯殑鏍峰瓙錛屼篃鏈夊彲鑳芥槸瀹㈡埛澶氬繖涓嶈繃鏉ヤ簡銆?/p>
璇磋N72錛屽熀瀹炲拰鎴戝湪w810涔嬪墠鐢ㄨ繃鐨?630娌″暐澶鍖哄埆錛岄兘鏄疦OKIA S60緋葷粺錛屽氨鏄褰㈠皬浜嗕竴鐐癸紝钖勪簡涓鐐圭偣錛屽唴瀛樺ぇ浜嗕簺錛岃繖鍥炴槸1GB瀛樺偍鍗°佹憚鍍忓ご鐢?30涓囧彉鎴?00涓?澶氫簡FM鏀墮煶鍔熻兘錛屾搷浣滅郴緇熺増鏈柊浜嗕簺銆傛垜鍩烘湰涓婂綋瀹冩槸鏂扮増6630鐢紝鍛靛懙锝?/p>
銆銆鍊煎緱涓鎻愮殑鏄紝NOKIA鐨勮蟲満涓鑸煶璐ㄥ儚鍦版憡璐э紝榪欏洖鐨勪篃涓鏍鳳紝鎵撳紑鍖呰鍘熼厤鐨勮蟲満灝辨墧鍒頒簡涓杈癸紝鎴戠敤NOKIA鐨凙D-15杞崲鍣?涓縐峃OKIA涓撶敤鑰蟲満杞帴鍣?澶栧姞鍔熺巼鏀懼ぇ鍔熻兘鐨勫皬涓滆タ)鎺ヤ笂鎴戠殑媯搗濉炶砅X200錛屽懙鍛碉綖锝為煶璐ㄨ秴鐖斤紝鍑犱箮宸茶秴瓚婁簡W810鐨勯煶璐紝浣嗘槸鍙︿竴縐嶉鏍間笉鍍忔槸鏃ョ郴闅忚韓鍚綆闊沖緢闂風(fēng)殑閭g銆備絾鏄緢濂囨鏋滄帴SonyE888闊寵川灝變笉鎬庝箞鍦幫紝璐硅В涓?.銆傝嚜姝や互鍚庡張鍙互涓嬭澆S60鍚勭搴旂敤杞歡銆佹父鎴忋丮P3鎾斁杞歡....閲嶅洖NOKIA鐨勬櫤鑳紻IY涓栫晫......涔熻鍝ぉ鑺卞嚑鐧炬悶涓摑鐗橤PS瀹氫綅鍣紝瑁呬釜鍦板浘杞歡錛屽氨鍙互瀹炵幇鎵嬫満GPS瀹氫綅浜嗐?/p>
n72 6630
]]> 寮濮嬬爺絀跺叾瀹炲凡緇忔柊浜嗗緢涔呯殑"鏂版灦鏋? http://www.tkk7.com/michaelcao/archive/2007/03/13/103570.html渚濈劧Fantasy 渚濈劧Fantasy Tue, 13 Mar 2007 08:09:00 GMT http://www.tkk7.com/michaelcao/archive/2007/03/13/103570.html http://www.tkk7.com/michaelcao/comments/103570.html http://www.tkk7.com/michaelcao/archive/2007/03/13/103570.html#Feedback 3 http://www.tkk7.com/michaelcao/comments/commentRss/103570.html http://www.tkk7.com/michaelcao/services/trackbacks/103570.html 銆銆鐢ㄤ竴涓凡涓嶅啓紼嬪簭鐨勬湅鍙嬬殑璇濊錛岀幇鍦↗ava涓栫晫閲岀湡鏄浜虹溂鑺辯輯涔憋紝涓嶄粎瀵逛簬鏂版墜錛屽氨綆楁槸榪囧幓鐔熸?zhèn)塖ervlet銆丣SP錛孍JB鐨刾rogrammer錛屼及璁¤瀹屽叏鎼炴槑鐧界幇鍦ㄧ殑鈥樻柊鐢熸佹灦鏋勨欎篃涓嶆槸寰堝鏄撱備粠N澶氬勾鍓嶇殑鈥樹竴嬈$紪璇戝埌澶勮繍琛屸欏埌鍚庢潵鐨凟JB錛屽啀鍒扮幇鍦ㄧ殑Spring銆丠ibernate銆乄ebwork銆丣SF絳夎澶氳〃鐜板眰銆佹暟鎹眰錛屼互鍙?qiáng)鏀寔MVC銆丄OP鐨勬鏋訛紝鍐嶅姞涓奐DK1.5鍚庡姞鍏ョ殑娉涘瀷絳夋柊鍔熻兘錛屽鏋滄槸涓鐩翠互Servlet,JSP銆丣DBC鎴栨槸EJB寮鍙戠殑璇濓紝鐜板湪紿佺劧鎺ヨЕ鍒拌繖浜涗笢瑗跨湡鏄瀛︿範(fàn)涓闃典簡銆傛渶榪戝湪鐪嬨婅秺鐙便嬶紝鎯寵搗涓涓茍涓嶆伆褰撶殑姣斿柣錛屽ソ浼間竴涓湇鍒?0騫寸殑鑰佸浼欙紝鏈変竴澶╃粓浜庡垜婊¢噴鏀撅紝緇撴灉鍑烘潵鍚庡嵈鍙戠幇澶栭潰鐨勪笘鐣屾棭宸蹭笉鏄粬鎵鎯崇殑閭f牱浜嗐傘傘?br /> 銆銆榪樺ソ鎴戜滑瀵逛簬榪欎簺鍙樺寲鏃╂湁鍑嗗錛屾渶蹇殑瀛︿範(fàn)鏂規(guī)硶鑾繃浜庣洿鎺ラ拡瀵逛竴涓郴緇熻繘琛屾簮鐮佸垎鏋愩佸涔?fàn)銆佸墺紱誨嚭鍏朵腑鐢ㄥ埌鐨勬妧鏈柟闈紝鐒跺悗灝濊瘯鐢ㄤ簬鎴戜滑鑷凡鐨勯」鐩垨浜у搧涓幓銆傜敤google銆乥aidu寰堝揩灝辨妸鐒︾偣瀹氫綅鍦ㄤ簡涓涓紑婧愮殑緗戜笂紺懼尯http://www.laoer.com/ 聽鍗沖ぉ涔欑ぞ鍖猴紝鎴戜滑鍏沖績鐨勬槸鎶鏈灦鏋勶紝瀹冪敤鐨勬槸Struts+Spring+Hibernate錛宻truts1.x鐗堟湰铏界劧姣旇搗JSF銆乀apestry銆乄ebwork浠ュ強(qiáng)Webwork鍜孲truts鍚堝茍鐨凷truts2.x錛宻trtus1.x騫朵笉鏄緢鍏堣繘錛屼絾榪欏婧愮爜鐨勬垚鐔熷害鍜岃繖涓灦鏋勭殑浣跨敤鐜囦竴瀹氬緢楂橈紝N澶氶」鐩兘鍦ㄧ敤榪欑鏋舵瀯錛屽喌涓?鑰呯粨鍚堝叾涓繀鏈夌巹鏈猴紝榪樻槸鏈夌殑瀛︿簡錛氾級 銆銆 銆銆綺楃湅浜嗕竴涓嬭繖濂楃郴緇熺殑鏋舵瀯浠ュ強(qiáng)婧愮爜錛屽ぇ綰︾悊浜嗕竴涓嬫濊礬錛屾墦綆楁牴鎹簮鐮佷腑鐢ㄥ埌鐨勬妧鏈紝鎸夊嚑涓柟闈㈠幓鐮旂┒錛屽洿緇曠ぞ鍖虹郴緇熶腑鐨勫簲鐢紝鍐嶅啓鍑犵瘒鏂囩珷灝卞綋鏄竴縐嶆垚鏋滃惂銆?br />聽聽聽聽聽聽聽聽涓昏鏈変互涓嬪嚑鏂歸潰錛?br />銆銆Struts涓嶴pring闆嗘垚搴旂敤 聽聽聽聽聽聽聽聽聽Hibernate涓嶴pring鐨勯泦鎴愬簲鐢?br />聽聽聽聽聽聽聽聽OSCache鐨勫簲鐢?榪欓噷涓昏鐢ㄤ簬緙撳瓨POJO) 聽聽聽聽聽聽聽 Intecepter鍗蟲嫤鎴櫒鐨勫簲鐢?br />聽聽聽聽聽聽聽 Ajax鐨勫簲鐢ㄤ互鍙?qiáng)Prototype 聽聽聽聽聽聽聽 銆傘傘傘?/p>
聽聽聽聽聽聽聽
]]>
主站蜘蛛池模板:
中文字幕无码亚洲欧洲日韩 |
国产精品一区二区三区免费
|
a级毛片免费高清视频 |
亚洲自偷自偷偷色无码中文 |
99re在线这里只有精品免费 |
亚洲欧美国产日韩av野草社区 |
国产精品xxxx国产喷水亚洲国产精品无码久久一区
|
亚洲日韩欧洲乱码AV夜夜摸
|
精品视频在线免费观看 |
亚洲av永久综合在线观看尤物 |
免费h黄肉动漫在线观看 |
午夜精品免费在线观看
|
国产精品区免费视频 |
亚洲av无码专区亚洲av不卡 |
99亚洲精品高清一二区 |
mm1313亚洲精品国产 |
亚洲成a人片在线不卡一二三区 |
亚洲一区二区三区在线视频 |
久久精品无码一区二区三区免费
|
免费黄色电影在线观看 |
18禁亚洲深夜福利人口 |
亚洲?v女人的天堂在线观看 |
精品无码人妻一区二区免费蜜桃 |
污网站在线免费观看 |
亚洲日韩涩涩成人午夜私人影院 |
4虎永免费最新永久免费地址 |
国产大片免费天天看 |
亚洲精品乱码久久久久久V |
亚洲美女在线观看播放 |
亚洲综合伊人久久大杳蕉 |
国产乱弄免费视频 |
无码国产精品一区二区免费I6 |
久久九九全国免费 |
国产无遮挡色视频免费观看性色 |
亚洲日韩国产精品乱 |
情侣视频精品免费的国产 |
亚洲精品偷拍视频免费观看 |
亚洲heyzo专区无码综合 |
亚洲人成黄网在线观看 |
亚洲一区二区影院 |
免费人成又黄又爽的视频在线电影 |