娉曚汉浠ｈ〃鑱岃矗 娉曚汉浠ｈ〃鍜屾硶浜虹殑鍏蜂綋鍖哄埆 鏈€濂借兘涓句釜鍏蜂綋鐨勪緥瀛悀~~~

娉曚汉浠ｈ〃鍜屾硶浜虹殑鍏蜂綋鍖哄埆 鏈€濂借兘涓句釜鍏蜂綋鐨勪緥瀛悀~~~聽聽

娉曚汉浠ｈ〃鍜屾硶浜虹殑鍏蜂綋鍖哄埆 鏈€濂借兘涓句釜鍏蜂綋鐨勪緥瀛悀~~~

鍏跺疄閫氬父寰堝浜洪兘鐢ㄩ敊浜嗚繖鍑犱釜姒傚康銆�
鈥滄硶浜衡€濆簲璇ユ槸鎸囩殑鍏锋湁娉曚汉璧勬牸鐨勪紒涓氫富浣擄紝涓€鑸灏辨槸鍏徃銆�
鈥滄硶浜轰唬琛ㄢ€濇槸涓笉瑙勮寖鐨勮娉曪紝娉曞緥涓婃病鏈夎繖涓蹇点€傞€氬父鎸囩殑鏄€滄硶瀹氫唬琛ㄤ汉鈥濄€�
娉曞畾浠ｈ〃浜猴紝灏辨槸鍏徃鎴愮珛鏃剁櫥璁扮殑浠ｈ〃浜猴紝涔熷氨鏄锛屼粬鐨勮亴鍔¤涓烘€绘槸浠ｈ〃浜嗘硶浜虹殑琛屼负銆�
涓句緥鏉ヨ锛氱櫨搴﹀叕鍙告槸娉曚汉锛屾潕褰﹀法闆嗕綔涓虹櫨搴﹀叕鍙哥殑娉曞畾浠ｈ〃浜猴紝鍦ㄧ粡钀ユ椿鍔ㄤ腑浠ｈ〃鐧惧害鍏徃銆傚鏋滀綘瑙夊緱鐧惧害鍏徃渚电姱浜嗕綘鐨勬潈鐩婏紝浣犺捣璇夌殑鐗╀欢鏄硶浜哄崟浣嶇櫨搴﹀叕鍙革紝鑰屼笉鏄硶瀹氫唬琛ㄤ汉鏉庡溅宸ㄩ泦锛屼絾鏉庡溅宸ㄩ泦鍙互浣滀负鐧惧害鍏徃鐨勪唬琛ㄥ嚭搴€傜櫨搴﹁触璇変簡锛岃禂缁欎綘鐨勯挶锛屼粠鐧惧害鍏徃璐︽埛涓婃敮浠橈紝鑰屼笉鏄敤鏉庡溅宸ㄩ泦鐨勭浜鸿储浜с€�

娉曚汉浠ｈ〃鐨勫叿浣撹亴璐�

绠€鍗曠殑璇达紝娉曞畾浠ｈ〃浜哄彧鏄澶栦唬琛ㄥ叕鍙革紝浠栨墍灞ヨ鐨勮亴璐ｆ槸鍏徃琛屼负
濡傛灉浣犵殑鍏徃杩濇硶锛屾硶寰嬭矗浠诲氨鏄敱娉曚汉浠ｈ〃鎵挎媴锛�
鏄庣櫧浜嗗惂锛�
鎴戣寰椾綘杩樻槸灏忓績閫夋嫨姣旇緝濂絶~

jsp杩炵嚎sql server2005鍏蜂綋鐨勬楠や笌鏂规硶锛屾渶濂借兘涓句釜渚嬪瓙

鍒�
:microsoft./downloads/details.aspx?FamilyID=E22BC83B-32FF-4474-A44A-22B6AE2C4E17&displaylang=zh-
涓嬭浇SQL Server 2005椹卞姩鏀惧埌Web涓撴鐨刲ib鐩綍涓�,鐒跺悗JSP绋嬪紡鐮佸涓�:
===============================================================
<%@page contentType="text/;charset=gbk" %>
<%@page import="java.sql.* ">
<%!
String dbDriver=".microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL="jdbc:sqlserver:localhost:1433;DataBaseName=浣犺杩炵嚎鐨勮祫鏂欏簱鍚�";
String dbUser="璧勬枡搴撲娇鐢ㄨ€呭悕绉�,涓€鑸负sa";
String dbPassword="璧勬枡搴撲娇鐢ㄨ€呭瘑鐮�,涓€鑸负sa";
Connection conn = null;
PreparedStatement pstmt= null;
String sql = null;
ResultSet rs = null;
%>
<%
try{
Class.forName(dbDriver);
conn = DriverManager.getConnection(dbURL,dbUser,dbPassword);
sql = "鍐欎綘鐨凷QL璇彞";
pstmt = conn.prepareStatement(sql);
瀵筽stmt杩涜鏈夊叧SQL璇彞鐨勮瀹�
pstmt.setString(1,"璁惧畾鍊�");
......
rs = pstmt.executeQuery();
while(rs.next){
澶勭悊rs缁撴灉闆嗚鍙�
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
%>
===================================
鐪嬬湅鎴戠殑Web涓撴鐨勭洰褰曠粨鏋�:
鈹斺€擶ebApp
鈹� index.jsp
鈹溾€擬ETA-INF
鈹� MANIFEST.MF
鈹�
鈹斺€擶EB-INF
鈹� web.xml
鈹�
鈹溾€攃lasses
鈹� databaseConf.properties
鈹�
鈹斺€攍ib
sqljdbc.jar杩欏氨鏄疭QL Server 2005鐨凧DBC椹卞姩

宸茬瀻 杩欎釜璇嶆槸瑜掍箟杩樻槸璐箟锛熸渶濂借兘涓惧叿浣撶殑渚嬪瓙銆�

涓嶆槸璐箟锛屽氨鏄竴绉嶈〃杈炬柟寮忥紝姣斿鐪嬪埌浠€涔堜綘涓嶆効鎰忔垨涓嶅枩娆㈢殑涓滆タ鏃跺氨鍙互杩欐牱璇�

瀹炰綋娉曚粠鏃э紝绋嬪紡娉曚粠鏂帮紝鑳戒妇涓叿浣撶殑渚嬪瓙鍚楋紵

渚嬪锛�08骞�1鏈�1鏃ュ墠锛屼紒涓氭墍寰楃◣绋庣巼涓�33%锛岀敵鎶ョ即绾崇殑鏈熼檺涓�4涓湀锛�08骞�1鏈�1鏃ュ悗锛屾墍寰楃◣绋庣巼涓�25%锛岀敵鎶ョ即绾崇殑鏈熼檺鐢�4涓湀鏀逛负5涓湀锛屽湪姹囩畻娓呯即07骞寸殑鎵€寰楃◣鏃讹紝鍥犱负杩欐槸鍘诲勾鐨勪笟鍔★紝鏍规嵁绋嬪紡娉曚粠鏂般€佸疄浣撴硶浠庢棫鐨勫師鍒欍€傝绠楁墍寰楃◣鏃惰鐢�33%鐨勭◣鐜囷紝鐢虫姤鏈熼檺鏄�5涓湀銆傚洜涓虹◣鐜囧睘浜庡疄浣撴硶鐨勫唴瀹癸紝鑰岀撼绋庢湡闄愬睘浜庣▼寮忔硶锛岃鎵ц鏂扮殑浼佷笟鎵€寰楃◣娉�5鏈�31鏃ュ墠姹囩畻娓呯即鐨勮瀹氥€�

娉曚汉璁剧珛浜哄拰娉曚汉浠ｈ〃鐨勫尯鍒�

鎴戞兂浣犺鐨勬硶浜轰唬琛ㄦ寚鐨勬槸娉曞畾浠ｈ〃浜恒€傛硶浜鸿绔嬩汉鏄浜猴紝鎸囩殑鏄绔嬫硶浜虹殑浜猴紱娉曞畾浠ｈ〃浜哄彧鏈変竴涓紝娉曞畾浠ｈ〃浜哄彲浠ユ槸娉曚汉璁剧珛浜恒€傛硶瀹氫唬琛ㄤ汉鎸囦緷娉曞緥鎴栨硶浜虹珷绋嬭瀹氫唬琛ㄦ硶浜鸿浣胯亴鏉冪殑璐熻矗浜恒€傛垜鍥芥硶寰嬪疄琛屽崟涓€娉曞畾浠ｈ〃浜哄埗锛屼竴鑸涓烘硶浜虹殑姝ｈ亴琛屾斂璐熻矗浜轰负鍏舵儫涓€娉曞畾浠ｈ〃浜恒€�

娉曚汉涓庢硶浜轰唬琛ㄤ汉鐨勫尯鍒� 鎴戜妇涓緥瀛愬府鎴戣В閲婁笅鐪嬬湅瀵逛笉瀵�

鍓嶄笁鍙ユ槸瀵圭殑
鍏徃閲岀殑鍛樺伐鍙槸娉曚汉闆囦剑鐨勫憳宸�
鍏徃鍑轰簨浜嗭紝鎵挎媴璐ｄ换鐨勬槸鍏徃锛屼篃灏辨槸娉曚汉鎵挎媴鍚庢灉
鐢变簬鏄綘寮€鐨勶紝浣犳姇璧勭殑锛屾墍浠ュ弽鏄犲埌閽变笂闈㈢殑纭槸浣犳壙鎷呰矗浠伙紝浣嗘槸浣犳姇璧勫灏戝氨鎵挎媴澶氬皯璐ｄ换锛堣繖鍙湁闄愯矗浠伙級

璇烽棶锛岃涓€涓汉寰堣兘瑁呮槸浠€涔堟剰鎬濓紵鏈€濂借兘涓惧叿浣撶殑渚嬪瓙銆�

鍖呭惈鐨勫お澶氫簡 瑁呴€� 鎺╅グ鐨勫緢濂� 鐭ラ亾闂鍗村亣瑁呬笉鐭ラ亾 閮藉彲浠ヨ繖鏍疯鐨� 灏辩湅褰撴椂鏄粈涔堟儏鍐� 鏄粈涔堟牱鐨勫璇濄€傚笇鏈涜兘甯埌浣� 鏈涢噰绾�

娉曚汉浠ｈ〃鐨勫叿浣撴潈鍔涙湁閭ｄ簺锛�

娉曞畾浠ｈ〃浜虹殑鏉冨姏鏈夊澶�,璇风湅浠栦滑缁勫缓鍏徃鏃跺埗璁㈢殑鍏徃绔犵▼.
涓€鑸潵璇�,娉曞畾浠ｈ〃浜轰竴涓汉涓嶈兘鍐冲畾鐧诲嚭鍏徃绛夐噸澶т簨浠�,瑕侀€氳繃钁ｄ簨浼氳璁哄悗鍐冲畾銆�
鍏徃绔犵▼鏄叕鍙告垚绔嬫椂蹇呴渶鍒惰鐨勶紝娌℃湁鍏徃绔犵▼锛屽伐鍟嗗眬灏变笉浼氭敞鍐屽叕鍙搞€�
闄ゅ叕鍙哥珷绋嬬害鏉熸硶瀹氫唬琛ㄤ汉鐨勭壒娈婃潈鍔涘锛堣懀浜嬩細鎴栬偂涓滀細璁ㄨ鍐冲畾锛夛紝鍏跺畠涓嶆槸寰堥噸瑕佺殑浜嬪垯娉曞畾浠ｈ〃浜洪兘鏈夋潈璇翠簡绠椼€�

娉曚汉鍜屾硶浜轰唬琛ㄧ殑鍖哄埆锛熸硶浜轰唬琛ㄧ殑鏉冨埄锛岃矗浠伙紝涔夊姟鏈夊摢浜涳紵

娉曚汉鐨勬蹇典富瑕佹槸鎸囩ぞ鍥㈡垨鍏徃鍜屼紒涓氾紝鏍规嵁娉曞緥鎴愮珛鐨勫洟浣撳寘鎷崗浼氥€佷紒浜嬩笟鍗曚綅绛夌瓑閮藉彲浠ョО浣滄硶浜恒€傛硶瀹氫唬琛ㄤ汉鐨勬蹇垫槸鎸囪繖涓洟浣撻€夊嚭鐨勪唬琛紝鏄寚鑷劧浜猴紝鍙互浠ｈ〃杩欎釜鍥綋琛屼簨銆傛硶浜轰唬琛ㄨ繖涓蹇靛彲鑳戒笉澶噯纭紝鎴戞兂浣犳槸闂硶瀹氫唬琛ㄤ汉鍚с€�
娉曞畾浠ｈ〃浜鸿閬靛惊鍥綋绔犵▼鎴栬€呭崗璁殑绾﹀畾锛屽叾鏉冨埄鍜屼箟鍔′富瑕佹潵婧愪簬姝ゃ€�