---------------------------------
]]>
1銆丮SSQL涓湁涓縐嶆暟鎹被鍨嬪彨UniqueIdentity錛屽畠浼氱敓鎴愪竴涓狦UID鏁版嵁錛屼絾濡傛灉瀵瑰簲鍒癙D涓殑姒傚康妯″瀷涓紝灝辨病鏈夊姙娉曞搴旓紝鐗╃悊妯″瀷涓篃涓鏍楓傚摢浣嶇煡閬撳憿錛?br /> 濡傛灉鍙嶅悜鍥炴潵錛屽湪PD涓紝鏄劇ず鐨勬槸Variable Multibyte (36)鐨勬暟鎹被鍨嬨?br />
2銆佸疄浣撻棿鐨勫叧緋?br />
鎴戜滑鐭ラ亾鍦≒D涓紝甯哥敤鐨勫疄浣撻棿鐨勮仈緋繪湁鍥涚錛氫竴瀵逛竴錛屼竴瀵瑰錛屽瀵逛竴錛屽瀵瑰
浣嗗湪閫夋嫨Cardnalities鏃訛紝cardnality 鏈夛細0,1 錛?0,n 錛?,n 錛?,1 榪欏洓涓張鏄鐨勪粈涔堝憿錛熷叧閿槸0,1鍜?,n鏄粈涔堟剰鎬濄?br />
鍦ㄤ笂鍥?姒傚康妯″瀷鍥?涓紝鎷呬繚欏圭洰涓庡淇濅細璁槸涓涓竴瀵瑰鐨勫叧緋匯傚悓鏃訛紝鍦ㄦ鍏崇郴涓紝鎷呬繚欏圭洰鏈灝戜竴涓紝瀹′繚浼氳鏈灝戜竴涓紝鏈澶歂涓紱
鍦ㄥ疄闄呯殑鏁版嵁搴撲腑錛岃繖鏄竴涓渶鏈鏅氱殑澶栭敭鍏寵仈鍏崇郴銆?br />
鍝綅鑳借В閲婁竴涓嬶紝涓轟粈涔堜笉鏄笅闈㈣繖涓浘鐨勬牱瀛愬憿錛?br />
]]>
-------------------------------------------------
1銆丣ava璁塊棶鏂囦歡
涔︽槸閮界湅榪囦簡錛屼絾鎴戣寰梛sp瀵規(guī)枃浠剁殑鎿嶄綔涓嶅錛屾殏鏃跺厛鏀句竴鏀俱?br />
濡傛灉鍝綅璇昏呰寰楄繖涓鍧楁湁鏋佸ぇ鐨勭敤澶勶紝璇風粰鎴戠暀璦鍟娿?br />
2銆佺敤java 榪炴帴鍒版暟鎹簱
a)銆丣DBC椹卞姩紼嬪簭鐨勭被鍨?br /> 綾誨瀷1錛欽DBC-ODBC 妗ラ┍鍔ㄧ▼搴?br /> 綾誨瀷2錛氭湰鏈篈PI--閮ㄥ垎Java椹卞姩紼嬪簭
綾誨瀷3錛欽DBC-緗戝崗璁函Java椹卞姩紼嬪簭
綾誨瀷4錛氭湰鍦板崗涔夌函Java椹卞姩紼嬪簭
綾誨瀷3鍜岀被鍨?鏄嬌鐢↗DBC API 璁塊棶鏁版嵁搴撶殑浼樺厛閫夌敤鐨勬柟娉曘?br />
b)銆佽鍏ラ┍鍔ㄧ▼搴?br /> Class.forName("org.gjt.mm.mysql.Driver");
c)銆丣DBC URL
鏁版嵁搴撹繛鎺ョ殑涓嬩竴姝ユ槸瀹氫箟涓涓狫DBC URL錛屽畠閾炬帴涓涓┍鍔ㄧ▼搴忓埌涓涓暟鎹簮銆?br /> 涓涓爣鍑嗙殑JDBC URL 鐨勫啓娉曟槸錛歫dbc:<subprotocol>:<data source identifier>
鍏朵腑jdbc浠ｈ〃鍗忚錛宻ubprotocol 鏄┍鍔ㄧ▼搴忕殑鍚嶇О錛宒ata source identifier鏄暟鎹簮鐨勫悕瀛椼?br /> 渚嬪錛?br /> jdbc-odbc 妗ラ┍鍔ㄧ▼搴忎嬌鐢ㄩ┍鍔ㄧ▼搴忔爣璇嗙odbc錛屼竴涓緥瀛愭槸錛歫dbc:odbc:wrox
濡傛灉闇瑕佺敤鎴峰悕鍜屽瘑鐮侊紝鍙互鏄細jdbc:odbc:wrox?username=aaa&pwd=cccc
鏇撮氱敤鐨勬柟寮忥細
jdbc:mysql://localhost/wrox?user=aaa&password=ccc
d)銆佸緩绔嬭繛鎺?br /> 鎴戜滑鍙互浣跨敤DriverManager.getConnection()鏂規(guī)硶寤虹珛榪炴帴銆?br /> String url="jdbc:odbc:worx";
Connection con=DriverManager.getConnection(url);
e)銆佸垱寤鴻鍙?br /> Statement st=con.createStatement();
f)銆佹墽琛岃鍙?br /> Statement瀵硅薄鏈変笁縐嶆柟娉曪細
executeUpdate()錛屾鏂規(guī)硶鐢ㄦ潵鎵цDDL璇彞錛屼互鍒涘緩琛ㄦ垨鍒犻櫎琛?br /> executeQuery()錛岃繑鍥炰竴涓崟涓鐨勭粨鏋滈泦錛屽涓涓猻elect 鐨勬墽琛岀粨鏋?br /> execute()錛岃繑鍥炰竴緇勭粨鏋滈泦
]]>
--------------------------------------------------
1銆丣sp 緗戠珯鐨勭粨鏋勫寲
鏈珷涓昏璁蹭簡涓浜涜繘琛岀粨鏋勫寲鐨勬妧鏈紝浠ヤ嬌紼嬪簭杈懼埌鍙淮鎶ゆу拰鍙噸鐢ㄦс?br />
include鏈哄埗錛?br /> <%@ include file="footer.jsp" %>
榪欑鏈哄埗鐨勭己鐐癸細濡傛灉琚寘鍚〉 footer.jsp 鍋氫簡淇敼錛屼絾涓嶄慨鏀瑰寘鍚〉 index.jsp 鐨勮瘽錛屽寘鍚〉 index.jsp 鐨勫唴瀹逛笉浼氬彂鐢熷彉鍖栥傚洜涓哄寘鍚〉灝嗚鍖呭惈欏靛仛浜嗙紪璇戝寘鍚簡榪涘幓錛涗絾鐜板湪琚寘鍚〉鍋氫簡鍙樺寲錛屽彉鍖栧悗鐨勫唴瀹規(guī)病鏈夎鍖呭惈榪涘幓錛堟病鏈夎緙栬瘧錛?br />
鍔ㄦ佸寘鍚細
<jsp:include page="footer.jsp" flush="true" />
榪欏彞璇濆悓鏍峰寘鍚簡footer.jsp欏碉紝騫朵笖澧炲姞浜嗗弬鏁癴lush="true"錛岃繖鏍峰彲浠ヤ繚璇侊紝濡傛灉footer.jsp鍙戠敓浜嗘敼鍙橈紝index.jsp欏典篃浼氬彂鐢熷彉鍖栥?br /> 浣跨敤涓嬮潰鐨勮娉曡繕鍙互緇欒鍖呭惈欏典紶閫掑弬鏁幫細
<jsp:include page="footer.jsp" flush="true">
<jsp:param name="menuitem1" value="news"/>
<jsp:param name="menuitem2" value="new2">
</jsp:include>
JSP Model 1錛?/strong>
Model 1 緇撴瀯鐨勪富瑕佺壒寰佹槸錛?br /> a銆佽〃鐜板眰鐢℉TML 鏂囦歡鎴朖SP鏂囦歡銆傚鏋滈渶瑕侊紝Jsp 鏂囦歡鍙互鐢?JavaBean 鍘誨瓨鍙栨暟鎹?br /> b銆丣sp 鏂囦歡榪樿礋璐ｆ墍鏈夌殑涓氬姟鍜屽鐞嗛昏緫錛屽鎺ユ敹鍒版潵鐨勮姹傦紝杞粰閫傚綋鐨凧SP錛屾縺媧婚傚綋鐨凧SP欏電瓑銆傝繖鎰忓懗鐫 Model 1 緇撴瀯鏄互欏甸潰璁捐涓轟腑蹇冪殑---鎵鏈夌殑閫昏緫鍜屽鐞嗛昏緫閮藉嚭鐜板湪JSP欏甸潰涓娿?br /> c銆佹暟鎹闂涔堥氳繃JavaBean 瀹炵幇錛屽湪Jsp涓敤JavaBean 錛岃涔堝湪Jsp 欏甸潰涓啓 scriptlet 瀹炵幇銆?br /> 鍦∕odel 1 緇撴瀯涓嬶紝搴旂敤紼嬪簭鐨勯昏緫鍜岀▼搴忔祦紼嬮兘鍦ㄩ〉闈腑鍑虹幇錛屽洜姝ら〉闈笌搴旂敤紼嬪簭鐨勯昏緫鏄?strong>绱ц﹀悎鐨勩?br /> 緙虹偣錛?br /> 鍦ㄥぇ鍨嬪簲鐢ㄧ▼搴忎腑錛岃繖縐嶆妸閫昏緫鑰﹀悎鍦ㄩ〉闈腑錛屼互鍙婇渶瑕佸皢欏甸敋閾懼湪涓璧風殑鏂瑰紡浼氬甫鏉ラ棶棰橈紝鐢變簬欏甸潰闂存槸绱ц﹀悎鐨勶紝鍥犳鍒嗗伐寰堥夯鐑︼紝鏈夊彲鑳藉仛緹庡伐鐨勮繕闇瑕佷簡瑙ｇ▼搴忕殑閫昏緫錛?br />
JSP Model 2 緇撴瀯錛?/strong>
鐢變簬 Model 1 瀛樺湪鐨勭己闄愶紝鍥犳涓轟簡灝嗚〃紺洪昏緫涓庢帶鍒墮昏緫鍒嗗紑錛屽氨浜х敓浜嗙浜岀緇撴瀯錛孧odel 2銆?br />
Model 2緇撴瀯涔熷氨鏄憲鍚嶇殑MVC緇撴瀯銆傚湪榪欑緇撴瀯涓紝灝嗗簲鐢ㄧ▼搴忓垎浜嗕笁縐嶈鑹睲odel銆?Controller銆?View
鍦ㄨ繖縐嶇粨鏋勪腑錛孷iew瑙嗗浘鏄寚琛ㄧず灞傦紝Controller鏄帶鍒跺櫒錛孧odel 鏄笌鏁版嵁鎵撲氦閬撶殑閮ㄥ垎銆?br />
鎺у埗鍣ㄦ帴鏀跺簲鐢ㄧ▼搴忕殑鎵鏈夎姹傦紝瀵規(guī)瘡涓涓帴鏀跺埌鐨勮姹傦紝鎺у埗鍣ㄥ皢閫夋嫨鏄仛鐩稿簲鐨勫鐞嗚繕鏄鏄劇ず鏁版嵁銆傝嫢瑕佹樉紺烘暟鎹紝瀹冨皢鎶婅姹傝漿鍙戠粰鍚湁琛ㄧず閫昏緫錛堝彨view鐨勫簲鐢級鐨凧SP錛涘鏋滆榪涜澶勭悊錛堝浠庢暟鎹簱涓鍙栨暟鎹級錛岃涔堣皟鐢ㄩ傚綋鐨凧avaBean鑷繁榪涜澶勭悊錛岃涔堟妸璇鋒眰鎸囨淳鎴栬漿鍙戠粰鍖呭惈鎵闇澶勭悊閫昏緫鐨凧SP銆?br />
杞彂鏍囩鐨勫啓娉曪細
<jsp:forward page="menu.jsp">
<jsp:param name="userid" value="wuxs">
<jsp:param name="pwd" value="pwd">
</jsp:forwar>
涓漢鐞嗚В錛氭墍璋撴帶鍒跺櫒錛孋ontroller 灝辨槸涓涓函綺圭殑Jsp欏碉紝瀹冨疄鐜頒笟鍔￠昏緫鍚庯紙鎴栧鐞嗗悗錛夛紝杞彂緇欏彟澶栦竴涓樉紺洪〉銆備篃灝辨槸璇達紝搴旂敤紼嬪簭鍙兘緇忚繃浜嗙О涓烘帶鍒跺櫒鐨凧SP欏碉紝浣嗕笉浼氬湪姝ゅ鍋滅暀銆?br />
涔熷彲浠ユ槸涓涓猻ervlet錛屼嬌鐢?servlet 鐨勭己鐐規(guī)槸浠ｇ爜涓細鍖呭惈鏈夊お澶氱殑HTML 浠ｇ爜銆?br />
-------------------------
2銆乻ervlet 鎶鏈粙緇?br /> servlet 錛氭槸涓縐嶇粍浠舵垨紼嬪簭錛屽畠鍙互鍔ㄦ佺殑鐢熸垚web鍐呭銆俿ervlet 鐢↗ava Servlet API 緙栧啓錛岀敤鍍廡omcat 榪欐牱鐨勬湇鍔″櫒鎴栧鍣ㄧ鐞嗐?br />
web 搴旂敤紼嬪簭涓璼ervlet 鐨勪綔鐢細
鑷畾涔夌殑servlet 緇ф壙鑷細java.servlet.http.HttpServlet銆傚湪鍐橦TTP Servlet 鏃訛紝鎴戜滑鍙互寰楀埌涓涓疄鐜頒簡java.servlet.http.HttpServletRequest 鎺ュ彛鐨剅equest 瀵硅薄鍜屼竴涓疄鐜頒簡java.servlet.http.HttpServletResponse鎺ュ彛鐨剅esponse瀵硅薄銆?br /> 鍏稿瀷鐨勶紝褰撳紑鍙戝熀浜嶩TTP鐨剆ervlet 鏃訛紝servlet 寮鍙戣呭彧鍏沖績doGet()鍜?doPost() 鏂規(guī)硶銆俿ervlet 蹇呴』閲嶈澆鑷沖皯榪欎袱涓柟娉曚腑鐨勪竴縐嶆柟娉曘?nbsp;
榪樻湁鍙﹀浜旂鍙噸杞界殑涓嶅父鐢ㄧ殑鏂規(guī)硶錛?br /> doHead() 錛氱敤浜庡鐞?Http Head 璇鋒眰銆傚湪HttpServlet 涓?doHead()鏂規(guī)硶鏄竴涓壒孌婄殑鏂規(guī)硶錛屽畠?yōu)畣鎵цdoGet()鏂規(guī)硶錛屼絾鍙粰瀹㈡埛榪斿洖鐢眃oGet()浜х敓鐨勫ご淇℃伅銆?br /> doOptions() 錛氱敤浜庡鐞咹ttp Options 璇鋒眰銆?doOptions() 鏂規(guī)硶鑷姩鍐沖畾servlet 鐩存帴鏀寔鍝竴縐岺ttp 鏂規(guī)硶錛屽茍鎶婁俊鎭繑鍥炵粰瀹㈡埛銆?br /> doTrace() 錛氱敤浜庡鐞咹ttp Trace璇鋒眰銆?doTrace()鏂規(guī)硶寮曡搗涓涓搷搴旓紝璇ュ搷搴斿甫鏈夊寘鍚玊race璇鋒眰涓墍鏈夊ご鐨勪俊鎭?br /> doPut() 錛氱敤浜庡鐞咹ttp Put 璇鋒眰銆?br /> doDelete() 錛氱敤浜庡鐞?Http Delete 璇鋒眰銆?br />
int() 錛氬垵濮嬪寲
destroy() 錛氭瀽鏋勩?br /> getServletInfo() 錛?璁﹕ervlet 鎻愪緵鑷韓鐨勪俊鎭?br />
servlet 鐨勭敓瀛樺懆鏈燂細
a)銆佽杞姐佸疄渚嬪寲鍙婂垵濮嬪寲錛氬綋絎竴嬈¤姹傛椂錛屾湇鍔″櫒鍔ㄦ佽杞藉茍瀹炰緥鍖杝ervlet 銆備篃鍙互閫氳繃閰嶇疆鏈嶅姟鍣紝浣縲eb 鏈嶅姟鍣ㄥ垵濮嬪寲鏃跺氨鍔犺澆servlet 銆傚洜姝わ紝鍦ㄥ紑鍙戣繃紼嬩腑錛屽鏋滄洿鏀逛簡servlet 鍐呭錛岃屾湇鍔″櫒娌℃湁閲嶅惎錛宻ervlet 鐨勫搷搴旀槸涓嶄細浜х敓鍙樺寲鐨勩?br /> b)銆佸鐞嗚姹傦細瀹瑰櫒鍦ㄦ帴鏀跺埌瀹㈡埛鐨勮闂姹傛椂錛屼細鏌ユ壘servlet錛屽茍鍔犺澆錛堝鏋滆繕娌℃湁鍔犺澆鐨勮瘽錛夛紝騫舵牴鎹敤鎴風殑璇鋒眰浣跨敤doPost()鎴杁oGet()鏂規(guī)硶榪涜鍝嶅簲銆?br />
Request 瀵硅薄錛歊equest 瀵硅薄灝佽浜嗘墍鏈夌殑鐢ㄦ埛璇鋒眰淇℃伅銆?br /> 鑾峰彇浼犻掔殑鍙傛暟錛?br /> getParameter() getParameterValues()
getQueryString() 錛岄拡瀵笻ttp Get璇鋒眰錛岃幏鍙栧弬鏁頒覆錛岄渶瑕佽嚜宸卞鐞?br /> getReader() 錛岄拡瀵笻ttp Post 璇鋒眰錛岃繑鍥炰竴涓狟ufferedReader 瀵硅薄
getInputStream() 錛岄拡瀵笻ttp Post 璇鋒眰錛岃繑鍥炰竴涓猄ervletInputStream 瀵硅薄
Response 瀵硅薄錛欻ttpServletResponse 鎺ュ彛涓哄簲絳斿鎴峰畾涔変簡servlet鏂規(guī)硶銆俁esponse 瀵硅薄灝佽浜嗕粠鏈嶅姟鍣ㄥ悜瀹㈡埛榪斿洖鐨勬墍鏈変俊鎭?br /> HttpServletResponse 瀵硅薄鎻愪緵浜唃etWriter() 鏂規(guī)硶鍜実etOutputStream()鏂規(guī)硶銆?br /> getWriter() 錛岃繑鍥濿riter瀵硅薄錛岀敤浜庤緭鍑烘枃鏈暟鎹紱
getOutputStream() 錛岃繑鍥瀞ervletOutputStream瀵硅薄錛岀敤浜庤緭鍑轟簩榪涘埗鏁版嵁銆?br /> 鍦ㄩ佸嚭鍝嶅簲涔嬪悗鍏抽棴Writer瀵硅薄鎴杝ervletOutputStream瀵硅薄銆?br /> 鍏跺畠鏂規(guī)硶錛?br /> sendRedirect()錛屾妸瀹㈡埛閲嶅畾鍚戝埌鍙﹀鐨刄RL錛岃繖閲岀殑URL蹇呴』鏄粷瀵瑰湴鍧錛?br /> sendError()錛岀敤褰撳墠鐨勫嚭閿欎唬鐮佺姸鎬侀佺粰瀹㈡埛涓涓嚭閿欎俊鎭?br />
c)銆佸嵏杞斤細
鍏稿瀷鎯呭喌涓嬶紝servlet 浠庡唴瀛樹腑鍗歌澆鏄湪瑕佹眰鍏抽棴瀹瑰櫒鏃躲傚鍣ㄤ細璋冪敤servlet鐨刣estroy()鏂規(guī)硶銆?br />
榪樻湁servlet 涓殑鐜閰嶇疆銆佸弬鏁拌幏鍙栧強浼氳瘽璺熻釜絳変笉璇︾粏鍒楀嚭銆?br />
]]>