<!--
var timerID = null
var timerRunning = false
function showtime(){
var today,hour,second,minute,year,month,date;
var strDate ;
today=new Date();
var n_day = today.getDay();
switch (n_day)
{
case 0:{
strDate = "鏄熸湡鏃?
}break;
case 1:{
strDate = "鏄熸湡涓"
}break;
case 2:{
strDate ="鏄熸湡浜?
}break;
case 3:{
strDate = "鏄熸湡涓?
}break;
case 4:{
strDate = "鏄熸湡鍥?
}break;
case 5:{
strDate = "鏄熸湡浜?
}break;
case 6:{
strDate = "鏄熸湡鍏?
}break;
case 7:{
strDate = "鏄熸湡鏃?
}break;
}
year = today.getYear();
month = today.getMonth()+1;
date = today.getDate();
hour = today.getHours();
minute =today.getMinutes();
second = today.getSeconds();
if(month<10) month="0"+month;
if(date<10) date="0"+date;
if(hour<10) hour="0"+hour;
if(minute<10) minute="0"+minute;
if(second<10) second="0"+second;
timeValue =year + " 騫?" + month + " 鏈?" + date + " 鏃?" + strDate +" " + hour + ":" + minute + ":" + second
document.GG.MM.value = timeValue
wuxingjia= setTimeout("showtime()",1000)
}
//-->
</SCRIPT>
</HEAD> <BODY onLoad="showtime()">
<FORM NAME="GG" onSubmit="0">
<INPUT TYPE="text" NAME="MM" SIZE=40 >
</FORM>
]]>
1銆佸彇鍑哄垰鍒氭彃鍏?鍒犻櫎)鐨勬暟鎹甋ELECT 瀛楁鍚?FROM INSERTED(DELETED)
2銆佸浜嶶PDATE瀹為檯涓婃槸鍏圖ELETE鐒跺悗鍐岻NSERT鎵浠ュ鏋滄兂寰楀埌UPDATE鍓嶅悗鐨勬暟鎹鹼紝搴旇鍏堜粠DELETED鍙栧嚭錛岀劧鍚庝粠INSERTED鍙栧嚭錛?br />
3銆両F UPDATE(鍒楀悕)鍙互鍒ゆ柇鏇存柊鎴栨彃鍏ュ摢涓涓瓧孌電殑鍊鹼紱
4銆丂@ROWCOUNT鍙互鍒ゆ柇涓婁竴琛屾煡璇㈡搷浣滃緱鍒扮殑鍒楁暟錛?br />
5銆佺粰鍙橀噺璧嬪肩敤SET @ZQB = 13;
6銆佸療鐪嬫槸鍚︽湁絎﹀悎鏉′歡鐨勮褰旾F EXISTS (SELECT name FROM sysobjects WHERE name = 'reminder' AND type = 'TR');
7銆佸畾涔夋父鏍囷紝濡備笅錛?br />
DECLARE c1 CURSOR FOR
SELECT emp_mgr.emp
FROM emp_mgr, inserted
WHERE emp_mgr.emp = inserted.mgr
OPEN c1
FETCH NEXT FROM c1 INTO @e--浠庢父鏍囦腑鍙栧嚭鏁版嵁
WHILE @@fetch_status = 0--鍒ゆ柇鏄惁鍒版渶鍚?br />
BEGIN
UPDATE emp_mgr
SET emp_mgr.NoOfReports = emp_mgr.NoOfReports + 1 -- Add 1 for newly
WHERE emp_mgr.emp = @e -- added employee.
FETCH NEXT FROM c1 INTO @e
END
CLOSE c1
DEALLOCATE c1--鍒犻櫎娓告爣寮曠敤
]]>
(2)ActionServlet鎺ユ敹鍒拌姹傚悗錛屼細(xì)鏌ユ壘struts-config.xml鏂囦歡鏉ョ‘瀹氭湇鍔″櫒涓婃槸鍚︽湁鐢ㄦ埛璇鋒眰鐨勬搷浣滐紝姝ゅ鐢ㄦ埛璇鋒眰鐨勬搷浣滃簲涓虹櫥褰曟搷浣溿傚鏋滄病鏈夛紝鍒欒繑鍥炰竴涓敤鎴瘋姹傛棤鏁堢殑鍑洪敊淇℃伅銆?/span>
(3)褰揂ctionServlet鎵懼埌鐢ㄦ埛璇鋒眰鐨凙ction鍚庯紝棣栧厛灝嗙敤鎴瘋緭鍏ョ殑琛ㄥ崟鍙傛暟鎵撳寘鎴愪竴涓狝ctionForm瀵硅薄錛岃繖涓狝ctionForm瀵硅薄鍏跺疄涔熷氨鏄竴涓狫avaBean錛岄噷闈㈠寘鍚袱涓瓧孌碉紝鍒嗗埆鏄敤鎴峰悕鍜屽瘑鐮併傛帴鐫ActionServlet鍐嶆牴鎹畇truts-config.xml涓殑閰嶇疆淇℃伅鍐沖畾鏄惁瑕佹墽琛孉ctionForm瀵硅薄涓殑Validate鏂規(guī)硶銆傝嫢Validate鏂規(guī)硶鎵ц鏈夐敊錛屽垯榪斿洖錛涘惁鍒欙紝緇х畫(huà)涓嬩竴姝ャ?br /> (4)緋葷粺鐢熸垚涓涓敤鎴鋒墍璇鋒眰鐨凙ction鐨勫疄渚嬪璞★紝灝嗗墠闈㈢殑ActionForm瀵硅薄浼犻掔粰瀹冿紝榪愯瀹冪殑execute()鏂規(guī)硶銆傝繖涓姝ュ叾瀹炲氨鏄敤鎴風(fēng)櫥褰曠殑鎺у埗鍣紝鍦ㄦ墽琛宔xecute()鏂規(guī)硶鏃訛紝鍙互璋冪敤鍚庡彴妯″瀷楠岃瘉鐧誨綍鍚嶅拰瀵嗙爜鏄惁姝ｇ‘絳変俊鎭?br /> (5)execute()鎵ц緇撴潫鍓嶄細(xì)鐢熸垚涓涓狝ctionForward綾誨瀷鐨勫璞″茍灝嗕箣榪斿洖緇橝ctionServlet錛岃瀵硅薄鐨勪綔鐢ㄦ槸鍛婅瘔ActionServlet涓嬩竴姝ュ簲璇ヨ煩杞埌鍝噷錛屽亣濡傚悗鍙版ā鍨嬫楠岀敤鎴峰悕鍜屽瘑鐮佹紜紝鍒橝ctionForward灝變唬琛ㄨ煩杞埌涓涓櫥褰曟垚鍔熺殑鐣岄潰銆侫ctionServlet灝嗗涔嬭繘琛屽垎鏋愶紝鍏跺疄灝辯浉褰撲簬鎺ユ敹鍒頒竴涓柊鐨勮姹傦紝閲嶅(2)~(5)鐨勮繃紼嬶紝鐩村埌灝嗘煇涓晫闈㈣繑鍥炵敤鎴蜂負(fù)姝€?br /> 浠ヤ笂灝辨槸Struts鐨勫熀鏈伐浣滄祦紼嬶紝鍙互鐪嬪嚭struts-config.xml鍦ㄦ暣涓祦紼嬩腑璧峰埌浜?jiǎn)涓涓被浼肩珯鐐瑰湴鍥劇殑浣滅敤錛屽畠璁板綍浜?jiǎn)鎵鏈夊彲鑳界殑璇鋒眰璺寵漿銆傚叾瀹烇紝鍦╓eb瀹瑰櫒鍔犺澆Struts搴旂敤紼嬪簭鍚庯紝struts-config.xml灝辮棣栧厛璇誨叆鍐呭瓨鎴愪負(fù)涓涓狝ctionMapping瀵硅薄錛屽墠闈㈡墍璇寸殑鏌ユ壘struts-config.xml鏂囦歡錛屽疄闄呬笂鏄煡鎵続ctionMapping瀵硅薄銆傚浜庡垵瀛﹁呮潵璇村彲浠ヤ笉蹇呮繁絀跺叾涓殑緇嗚妭……
鎽樿嚜娓呭崕澶у鍑虹増紺懼嚭鐗堢殑銆奡truts-Web璁捐涓庡紑鍙戝ぇ鍏ㄣ?/span>
]]>