锘??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲一级毛片免费在线观看,久久精品国产精品亚洲艾,亚洲1区1区3区4区产品乱码芒果http://m.tkk7.com/314508313/媧葷潃灝辨槸涓轟簡鏀瑰彉涓栫晫zh-cnMon, 12 May 2025 17:09:19 GMTMon, 12 May 2025 17:09:19 GMT60JAVA 緇ф壙鍩烘湰綾匯佹娊璞$被銆佹帴鍙?http://m.tkk7.com/314508313/archive/2011/12/04/365523.html闄堝皬涓?/dc:creator>闄堝皬涓?/author>Sun, 04 Dec 2011 15:08:00 GMThttp://m.tkk7.com/314508313/archive/2011/12/04/365523.htmlhttp://m.tkk7.com/314508313/comments/365523.htmlhttp://m.tkk7.com/314508313/archive/2011/12/04/365523.html#Feedback0http://m.tkk7.com/314508313/comments/commentRss/365523.htmlhttp://m.tkk7.com/314508313/services/trackbacks/365523.htmlJava鏄竴涓潰鍚戝璞$殑璇█錛宩ava闈㈠悜瀵硅薄涓鑸湁涓夊ぇ鐗瑰緛錛氬皝瑁呫佺戶鎵褲佸鎬併?/p>

灝佽錛氬氨鏄妸涓浜涘睘鎬у拰鏂規硶灝佽鍒頒竴涓被閲屻?/p>

緇ф壙錛氬氨濡傚瓙綾葷戶鎵跨埗綾葷殑涓浜涘睘鎬у拰鏂規硶銆?/p>

澶氭?/strong>錛氬氨濡備竴涓埗綾繪湁澶氫釜涓嶅悓鐗硅壊鐨勫瓙綾匯?/p>

榪欓噷鎴戝氨涓嶅璁茶В錛屼笅闈㈡垜涓昏璇存槑涓涓戶鎵褲傜戶鎵挎槸OOP錛堥潰鍚戝璞★級鐨勪竴涓壒鑹詫紝java鍙敮鎸佸崟緇ф壙錛堝鏋滅戶鎵夸袱涓湁鍚屾牱鏂規硶鐨勭埗綾伙紝閭d箞灝變笉鐭ラ亾緇ф壙鍒伴偅涓埗綾葷殑錛屾墍浠ava鍙敮鎸佸崟緇ф壙錛夈傜戶鎵挎槸java鐨勪竴涓壒鑹詫紝鎴戜滑鐢ㄧ殑鎵浠ョ被閮界戶鎵縊bjict綾伙紝鎵浠ュ氨瑕丱bject綾葷殑鏂規硶錛屽toString()銆乬etClass()銆亀ait()……鎵浠ユ垜浠緩绔嬬殑綾婚兘鏈夌埗綾匯?/p>

Java涓竴鑸湁涓夌綾伙細

鍩烘湰綾?/strong>:涔熷氨鏄竴鑸殑綾伙紙涓鑸墍璇寸殑綾誨氨鏄熀鏈被錛夛紝鏄璞$殑妯℃澘錛屾槸灞炴у拰鏂規硶鐨勯泦鍚堛傚彲浠ョ戶鎵垮叾浠栧熀鏈被銆佹娊璞$被銆佸疄鐜版帴鍙c?/p>

鎶借薄綾?/strong>錛氭湁鎶借薄鏂規硶鐨勭被(鎶借薄鏂規硶灝辨槸璇ユ柟娉曞繀欏葷敱緇ф壙鏉ュ疄鐜幫紝鏈韓鍙畾涔夛紝涓嶅疄鐜?銆傛娊璞$被鍙互鏈変竴涓垨澶氫釜鎶借薄鏂規硶錛屼粬鏄熀鏈被鍜屾帴鍙g被鐨勮繃搴︺?/p>

鎺ュ彛綾?/strong>錛氫竴鑸彨鍋氭帴鍙o紝璇ョ被涓殑鎵鏈夋柟娉曢兘鏄娊璞℃柟娉曪紝璇ョ被鐨勬柟娉曟湰韜彧瀹氫箟涓嶅疄鐜般?/p>

鎶借薄綾誨拰鎺ュ彛涓涓敱銆恆bstract class + 鎶借薄綾誨悕銆戜竴涓敱銆恑nterface +鎺ュ彛鍚嶃戝畾涔夛紝鎺ュ彛涓殑鎵浠ユ柟娉曢兘鏄娊璞℃柟娉曪紝鑰屾娊璞$被鏈夐儴鍒嗘柟娉曟槸鑷韓瀹炵幇浜嗙殑錛屼竴浜涘彧瀹氫箟涓嶅疄鐜般?/p>

鍩烘湰綾葷殑瀹氫箟錛?/p>

public class Fruit {

    public void price() {

       System.out.println("姘存灉浠鋒牸");

    }

    public void weight() {

       System.out.println("姘存灉閲嶉噺");

    }

}

鎶借薄綾葷殑瀹氫箟錛?/p>

public abstract class Fruit {

    public void price() {

       System.out.println("姘存灉浠鋒牸");

    }

    public abstract void weight();

}

鎺ュ彛綾葷殑瀹氫箟錛?/p>

public interface Fruit {

    public void price();

    public void weight() ;

}

浠庝笂闈㈡垜浠彲浠ョ湅鍑烘帴鍙e氨鏄娊璞$被鐨勫崌綰х増錛岀敱浜庤綾葷殑鏂規硶鍏ㄦ槸鎶借薄鏂規硶錛屾墍浠ユ妸abstract鎹㈡垚interface銆傝屾帴鍙g殑鏂規硶蹇呴』鐢卞瓙綾繪墠鑳藉疄鐜般?/p>

 

緇ф壙

緇ф壙鍩烘湰綾伙紝鍙互緇ф壙鐖剁被鐨勬柟娉曪紝涔熷彲浠ヤ粠浜涳紝涔熷彲浠ユ墿鍏呫備笅闈㈡槸瀹炵幇鎺ュ彛鍩烘湰綾葷殑綾伙細

public class Apple extends Fruit {

}

璇ョ被涓氨鏈塅ruit鍩烘湰綾諱腑鐨勪袱涓柟娉曪細price()鍜寃eight()錛?/p>

緇ф壙鎶借薄綾伙紝蹇呴』瀹炵幇鎶借薄綾葷殑鎶借薄鏂規硶錛屽彲浠ヤ慨鏀圭埗綾葷殑鏂規硶錛屽拰娣誨姞鏂規硶銆備笅闈㈡槸緇ф壙鎶借薄綾葷殑綾伙細

public class Apple extends Fruit {

    @Override

    public void weight() {

       System.out.println("姘存灉閲嶉噺");

    }

}

璇ョ被緇ф壙綾籉ruit鐨刾rice()鏂規硶錛屽悓鏃跺疄鐜頒簡Fruit鎶借薄綾葷殑weight()鏂規硶銆?/p>

緇ф壙鎺ュ彛綾伙紙涔熷氨瀹炵幇鎺ュ彛錛夛紝蹇呴』瀹炵幇鎺ュ彛綾葷殑鎵鏈夌殑鎶借薄綾誨拰娣誨姞浜嗐備笅闈㈡槸緇ф壙鎺ュ彛鐨勭被錛?/p>

public class Aple implements Fruit {

    @Override

    public void price() {

       System.out.println("姘存灉浠鋒牸");

    }

    @Override

    public void weight() {

       System.out.println("姘存灉閲嶉噺");

    }

}

璇ョ被鏄疄鐜癋ruit鎺ュ彛鐨勬墍浠ユ娊璞℃柟娉曘?/p>

 

Java鍙敮鎸佸崟緇ф壙錛堢戶鎵垮熀鏈被鍜屾娊璞$被錛夛紝浣嗘槸鎴戜滑鍙互鐢ㄦ帴鍙f潵瀹炵幇錛堝緇ф壙鎺ュ彛鏉ュ疄鐜幫級

濡傦細public class Apple extends Fruit implements Fruit1, Fruit2{}

涓鑸垜浠戶鎵垮熀鏈被鍜屾娊璞$被鐢╡xtends鍏抽敭瀛楋紝瀹炵幇鎺ュ彛綾葷殑緇ф壙鐢╥mplements鍏抽敭瀛椼傚叾瀹炵戶鎵挎槸寰堢畝鍗曠殑錛屽彲浠ュ氨鏄病鏈夊紕娓呰繖涓や釜鍏抽敭瀛楋紝褰撴垜浠紕娓呮涔熷氨鏄瘮杈冪畝鍗曠殑銆?/p>

鎺ュ彛涔熷彲浠ョ戶鎵挎帴鍙e錛?strong>public interface Fruit1 extends Fruit {}榪欐槸鎺ュ彛涓殑澶氶噸緇ф壙錛屽悓鐞嗘娊璞$被鍜屽熀鏈被涔熷悓鐞嗐傚鏋滄垜浠妸鍩烘湰綾繪坊鍔?strong>final淇グ錛屼篃灝卞畾涔夎綾諱笉琚戶鎵匡紝璇ョ被涓嶈兘浣滀負鐖剁被銆傚悓鏃跺熀鏈被鐨勬柟娉曞彲浠ョ敤public 銆乸rivate銆乸roptected鏉ヤ慨楗版柟娉曪紝鐢╢inal鏉ラ樆姝㈢戶鎵胯鏂規硶銆?/p>

榪欓噷鍙槸鑷繁鐨勭悊瑙o紝鏈変簺鍦版柟鏃剁敤璇嶄笉褰撶殑錛屽彧鏄寰楄繖鏍風敤璇嶆洿濂界殑鐞嗚В錛岃澶у璋呰В銆傛湁浜涘湴鏂圭敱浜庝笉鏄繖閲岀殑閲嶇偣錛屾病鏈夎娓呮錛屽笇鏈涘ぇ瀹墮氳繃鍏朵粬鏂瑰紡浜嗚В銆?/p>

]]>
java瀹炵幇鍐掓場鎺掑簭http://m.tkk7.com/314508313/archive/2011/12/04/365522.html闄堝皬涓?/dc:creator>闄堝皬涓?/author>Sun, 04 Dec 2011 14:58:00 GMThttp://m.tkk7.com/314508313/archive/2011/12/04/365522.htmlhttp://m.tkk7.com/314508313/comments/365522.htmlhttp://m.tkk7.com/314508313/archive/2011/12/04/365522.html#Feedback0http://m.tkk7.com/314508313/comments/commentRss/365522.htmlhttp://m.tkk7.com/314508313/services/trackbacks/365522.htmlpublic class BubbleSort implements SortUtil.Sort{

     public void sort(int[] data) {

        int temp;

        for(int i=0;i<data.length;i++){

            for(int j=data.length-1;j>i;j--){

                if(data[j]<data[j-1]){

                    SortUtil.swap(data,j,j-1);

                }

            }

        }

    }



]]>
java鎻掑叆鎺掑簭http://m.tkk7.com/314508313/archive/2011/12/04/365521.html闄堝皬涓?/dc:creator>闄堝皬涓?/author>Sun, 04 Dec 2011 14:57:00 GMThttp://m.tkk7.com/314508313/archive/2011/12/04/365521.htmlhttp://m.tkk7.com/314508313/comments/365521.htmlhttp://m.tkk7.com/314508313/archive/2011/12/04/365521.html#Feedback0http://m.tkk7.com/314508313/comments/commentRss/365521.htmlhttp://m.tkk7.com/314508313/services/trackbacks/365521.htmlpublic class InsertSort implements SortUtil.Sort{

     public void sort(int[] data) {

        int temp;

        for(int i=1;i<data.length;i++){

            for(int j=i;(j>0)&&(data[j]<data[j-1]);j--){

                SortUtil.swap(data,j,j-1);

            }

        }       

    }

}



]]>
浠涔堟槸SQL娉ㄥ叆寮忔敾鍑?/title><link>http://m.tkk7.com/314508313/archive/2011/12/03/365438.html</link><dc:creator>闄堝皬涓?/dc:creator><author>闄堝皬涓?/author><pubDate>Fri, 02 Dec 2011 16:06:00 GMT</pubDate><guid>http://m.tkk7.com/314508313/archive/2011/12/03/365438.html</guid><wfw:comment>http://m.tkk7.com/314508313/comments/365438.html</wfw:comment><comments>http://m.tkk7.com/314508313/archive/2011/12/03/365438.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://m.tkk7.com/314508313/comments/commentRss/365438.html</wfw:commentRss><trackback:ping>http://m.tkk7.com/314508313/services/trackbacks/365438.html</trackback:ping><description><![CDATA[<font size="4">浠涔堟槸SQL娉ㄥ叆寮忔敾鍑伙紵 <br />鎵璋揝QL娉ㄥ叆寮忔敾鍑伙紝灝辨槸鏀誨嚮鑰呮妸SQL鍛戒護鎻掑叆鍒癢eb琛ㄥ崟鐨勮緭鍏ュ煙鎴栭〉闈㈣姹傜殑鏌ヨ瀛楃涓詫紝嬈洪獥鏈嶅姟鍣ㄦ墽琛屾伓鎰忕殑SQL鍛戒護銆傚湪鏌愪簺琛ㄥ崟涓紝鐢ㄦ埛杈撳叆鐨勫唴瀹圭洿鎺ョ敤鏉ユ瀯閫狅紙鎴栬呭獎鍝嶏級鍔ㄦ丼QL鍛戒護錛屾垨浣滀負瀛樺偍榪囩▼鐨勮緭鍏ュ弬鏁幫紝榪欑被琛ㄥ崟鐗瑰埆瀹規槗鍙楀埌SQL娉ㄥ叆寮忔敾鍑匯傚父瑙佺殑SQL娉ㄥ叆寮忔敾鍑昏繃紼嬬被濡傦細 <br />⑴ 鏌愪釜ASP.NET Web搴旂敤鏈変竴涓櫥褰曢〉闈紝榪欎釜鐧誨綍欏甸潰鎺у埗鐫鐢ㄦ埛鏄惁鏈夋潈璁塊棶搴旂敤錛屽畠瑕佹眰鐢ㄦ埛杈撳叆涓涓悕縐板拰瀵嗙爜銆?<br />⑵ 鐧誨綍欏甸潰涓緭鍏ョ殑鍐呭灝嗙洿鎺ョ敤鏉ユ瀯閫犲姩鎬佺殑SQL鍛戒護錛屾垨鑰呯洿鎺ョ敤浣滃瓨鍌ㄨ繃紼嬬殑鍙傛暟銆備笅闈㈡槸ASP.NET搴旂敤鏋勯犳煡璇㈢殑涓涓緥瀛愶細 <br />System.Text.StringBuilder query = new System.Text.StringBuilder( <br />   "SELECT * from Users WHERE login = '") <br />   .Append(txtLogin.Text).Append("' AND password='") <br />   .Append(txtPassword.Text).Append("'"); <br /><br />⑶ 鏀誨嚮鑰呭湪鐢ㄦ埛鍚嶅瓧鍜屽瘑鐮佽緭鍏ユ涓緭鍏?'鎴?1'='1"涔嬬被鐨勫唴瀹廣?<br />⑷ 鐢ㄦ埛杈撳叆鐨勫唴瀹規彁浜ょ粰鏈嶅姟鍣ㄤ箣鍚庯紝鏈嶅姟鍣ㄨ繍琛屼笂闈㈢殑ASP.NET浠g爜鏋勯犲嚭鏌ヨ鐢ㄦ埛鐨凷QL鍛戒護錛屼絾鐢變簬鏀誨嚮鑰呰緭鍏ョ殑鍐呭闈炲父鐗規畩錛屾墍浠ユ渶鍚庡緱鍒扮殑SQL鍛戒護鍙樻垚錛歋ELECT * from Users WHERE login = '' or '1'='1' AND password = '' or '1'='1'銆?<br />⑸ 鏈嶅姟鍣ㄦ墽琛屾煡璇㈡垨瀛樺偍榪囩▼錛屽皢鐢ㄦ埛杈撳叆鐨勮韓浠戒俊鎭拰鏈嶅姟鍣ㄤ腑淇濆瓨鐨勮韓浠戒俊鎭繘琛屽姣斻?<br />⑹ 鐢變簬SQL鍛戒護瀹為檯涓婂凡琚敞鍏ュ紡鏀誨嚮淇敼錛屽凡緇忎笉鑳界湡姝i獙璇佺敤鎴瘋韓浠斤紝鎵浠ョ郴緇熶細閿欒鍦版巿鏉冪粰鏀誨嚮鑰呫?<br />濡傛灉鏀誨嚮鑰呯煡閬撳簲鐢ㄤ細灝嗚〃鍗曚腑杈撳叆鐨勫唴瀹圭洿鎺ョ敤浜庨獙璇佽韓浠界殑鏌ヨ錛屼粬灝變細灝濊瘯杈撳叆鏌愪簺鐗規畩鐨凷QL瀛楃涓茬鏀規煡璇㈡敼鍙樺叾鍘熸潵鐨勫姛鑳斤紝嬈洪獥緋葷粺鎺堜簣璁塊棶鏉冮檺銆?<br />緋葷粺鐜涓嶅悓錛屾敾鍑昏呭彲鑳介犳垚鐨勬崯瀹充篃涓嶅悓錛岃繖涓昏鐢卞簲鐢ㄨ闂暟鎹簱鐨勫畨鍏ㄦ潈闄愬喅瀹氥傚鏋滅敤鎴風殑甯愭埛鍏鋒湁綆$悊鍛樻垨鍏朵粬姣旇緝楂樼駭鐨勬潈闄愶紝鏀誨嚮鑰呭氨鍙兘瀵規暟鎹簱鐨勮〃鎵ц鍚勭浠栨兂瑕佸仛鐨勬搷浣滐紝鍖呮嫭娣誨姞銆佸垹闄ゆ垨鏇存柊鏁版嵁錛岀敋鑷沖彲鑳界洿鎺ュ垹闄よ〃 <br />濡備綍闃茶寖SQL娉ㄥ叆寮忔敾鍑伙紵 <br />濂藉湪瑕侀槻姝SP.NET搴旂敤琚玈QL娉ㄥ叆寮忔敾鍑婚棷鍏ュ茍涓嶆槸涓浠剁壒鍒洶闅劇殑浜嬫儏錛屽彧瑕佸湪鍒╃敤琛ㄥ崟杈撳叆鐨勫唴瀹規瀯閫燬QL鍛戒護涔嬪墠錛屾妸鎵鏈夎緭鍏ュ唴瀹硅繃婊や竴鐣氨鍙互浜嗐傝繃婊よ緭鍏ュ唴瀹瑰彲浠ユ寜澶氱鏂瑰紡榪涜銆?<br />⑴ 瀵逛簬鍔ㄦ佹瀯閫燬QL鏌ヨ鐨勫満鍚堬紝鍙互浣跨敤涓嬮潰鐨勬妧鏈細 <br />絎竴錛氭浛鎹㈠崟寮曞彿錛屽嵆鎶婃墍鏈夊崟鐙嚭鐜扮殑鍗曞紩鍙鋒敼鎴愪袱涓崟寮曞彿錛岄槻姝㈡敾鍑昏呬慨鏀筍QL鍛戒護鐨勫惈涔夈傚啀鏉ョ湅鍓嶉潰鐨勪緥瀛愶紝"SELECT * from Users WHERE login = ''' or ''1''=''1' AND password = ''' or ''1''=''1'"鏄劇劧浼氬緱鍒頒笌"SELECT * from Users WHERE login = '' or '1'='1' AND password = '' or '1'='1'"涓嶅悓鐨勭粨鏋溿?<br />絎簩錛氬垹闄ょ敤鎴瘋緭鍏ュ唴瀹逛腑鐨勬墍鏈夎繛瀛楃錛岄槻姝㈡敾鍑昏呮瀯閫犲嚭綾誨"SELECT * from Users WHERE login = 'mas' -- AND password =''"涔嬬被鐨勬煡璇紝鍥犱負榪欑被鏌ヨ鐨勫悗鍗婇儴鍒嗗凡緇忚娉ㄩ噴鎺夛紝涓嶅啀鏈夋晥錛屾敾鍑昏呭彧瑕佺煡閬撲竴涓悎娉曠殑鐢ㄦ埛鐧誨綍鍚嶇О錛屾牴鏈笉闇瑕佺煡閬撶敤鎴風殑瀵嗙爜灝卞彲浠ラ『鍒╄幏寰楄闂潈闄愩?<br />絎笁錛氬浜庣敤鏉ユ墽琛屾煡璇㈢殑鏁版嵁搴撳笎鎴鳳紝闄愬埗鍏舵潈闄愩傜敤涓嶅悓鐨勭敤鎴峰笎鎴鋒墽琛屾煡璇€佹彃鍏ャ佹洿鏂般佸垹闄ゆ搷浣溿傜敱浜庨殧紱諱簡涓嶅悓甯愭埛鍙墽琛岀殑鎿嶄綔錛屽洜鑰屼篃灝遍槻姝簡鍘熸湰鐢ㄤ簬鎵цSELECT鍛戒護鐨勫湴鏂瑰嵈琚敤浜庢墽琛孖NSERT銆乁PDATE鎴朌ELETE鍛戒護銆?<br />⑵ 鐢ㄥ瓨鍌ㄨ繃紼嬫潵鎵ц鎵鏈夌殑鏌ヨ銆係QL鍙傛暟鐨勪紶閫掓柟寮忓皢闃叉鏀誨嚮鑰呭埄鐢ㄥ崟寮曞彿鍜岃繛瀛楃瀹炴柦鏀誨嚮銆傛澶栵紝瀹冭繕浣垮緱鏁版嵁搴撴潈闄愬彲浠ラ檺鍒跺埌鍙厑璁哥壒瀹氱殑瀛樺偍榪囩▼鎵ц錛屾墍鏈夌殑鐢ㄦ埛杈撳叆蹇呴』閬典粠琚皟鐢ㄧ殑瀛樺偍榪囩▼鐨勫畨鍏ㄤ笂涓嬫枃錛岃繖鏍峰氨寰堥毦鍐嶅彂鐢熸敞鍏ュ紡鏀誨嚮浜嗐?<br />⑶ 闄愬埗琛ㄥ崟鎴栨煡璇㈠瓧絎︿覆杈撳叆鐨勯暱搴︺傚鏋滅敤鎴風殑鐧誨綍鍚嶅瓧鏈澶氬彧鏈?0涓瓧絎︼紝閭d箞涓嶈璁ゅ彲琛ㄥ崟涓緭鍏ョ殑10涓互涓婄殑瀛楃錛岃繖灝嗗ぇ澶у鍔犳敾鍑昏呭湪SQL鍛戒護涓彃鍏ユ湁瀹充唬鐮佺殑闅懼害銆?<br />⑷ 媯鏌ョ敤鎴瘋緭鍏ョ殑鍚堟硶鎬э紝紜俊杈撳叆鐨勫唴瀹瑰彧鍖呭惈鍚堟硶鐨勬暟鎹傛暟鎹鏌ュ簲褰撳湪瀹㈡埛绔拰鏈嶅姟鍣ㄧ閮芥墽琛?#8212;—涔嬫墍浠ヨ鎵ц鏈嶅姟鍣ㄧ楠岃瘉錛屾槸涓轟簡寮ヨˉ瀹㈡埛绔獙璇佹満鍒惰剢寮辯殑瀹夊叏鎬с?<br />鍦ㄥ鎴風錛屾敾鍑昏呭畬鍏ㄦ湁鍙兘鑾峰緱緗戦〉鐨勬簮浠g爜錛屼慨鏀歸獙璇佸悎娉曟х殑鑴氭湰錛堟垨鑰呯洿鎺ュ垹闄よ剼鏈級錛岀劧鍚庡皢闈炴硶鍐呭閫氳繃淇敼鍚庣殑琛ㄥ崟鎻愪氦緇欐湇鍔″櫒銆傚洜姝わ紝瑕佷繚璇侀獙璇佹搷浣滅‘瀹炲凡緇忔墽琛岋紝鍞竴鐨勫姙娉曞氨鏄湪鏈嶅姟鍣ㄧ涔熸墽琛岄獙璇併備綘鍙互浣跨敤璁稿鍐呭緩鐨勯獙璇佸璞★紝渚嬪 RegularExpressionValidator錛屽畠浠兘澶熻嚜鍔ㄧ敓鎴愰獙璇佺敤鐨勫鎴風鑴氭湰錛屽綋鐒朵綘涔熷彲浠ユ彃鍏ユ湇鍔″櫒绔殑鏂規硶璋冪敤銆傚鏋滄壘涓嶅埌鐜版垚鐨勯獙璇佸璞★紝浣犲彲浠ラ氳繃CustomValidator鑷繁鍒涘緩涓涓?<br />⑸ 灝嗙敤鎴風櫥褰曞悕縐般佸瘑鐮佺瓑鏁版嵁鍔犲瘑淇濆瓨銆傚姞瀵嗙敤鎴瘋緭鍏ョ殑鏁版嵁錛岀劧鍚庡啀灝嗗畠涓庢暟鎹簱涓繚瀛樼殑鏁版嵁姣旇緝錛岃繖鐩稿綋浜庡鐢ㄦ埛杈撳叆鐨勬暟鎹繘琛屼簡"娑堟瘨"澶勭悊錛岀敤鎴瘋緭鍏ョ殑鏁版嵁涓嶅啀瀵規暟鎹簱鏈変換浣曠壒孌婄殑鎰忎箟錛屼粠鑰屼篃灝遍槻姝簡鏀誨嚮鑰呮敞鍏QL鍛戒護銆?System.Web.Security.FormsAuthentication綾繪湁涓涓?HashPasswordForStoringInConfigFile錛岄潪甯擱傚悎浜庡杈撳叆鏁版嵁榪涜娑堟瘨澶勭悊銆?<br />⑹ 媯鏌ユ彁鍙栨暟鎹殑鏌ヨ鎵榪斿洖鐨勮褰曟暟閲忋傚鏋滅▼搴忓彧瑕佹眰榪斿洖涓涓褰曪紝浣嗗疄闄呰繑鍥炵殑璁板綍鍗磋秴榪囦竴琛岋紝閭e氨褰撲綔鍑洪敊澶勭悊 </font><br /><br /><img src ="http://m.tkk7.com/314508313/aggbug/365438.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.tkk7.com/314508313/" target="_blank">闄堝皬涓?/a> 2011-12-03 00:06 <a href="http://m.tkk7.com/314508313/archive/2011/12/03/365438.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鐢℉QL榪涜瀹炰綋鏌ヨhttp://m.tkk7.com/314508313/archive/2011/12/03/365437.html闄堝皬涓?/dc:creator>闄堝皬涓?/author>Fri, 02 Dec 2011 16:05:00 GMThttp://m.tkk7.com/314508313/archive/2011/12/03/365437.htmlhttp://m.tkk7.com/314508313/comments/365437.htmlhttp://m.tkk7.com/314508313/archive/2011/12/03/365437.html#Feedback0http://m.tkk7.com/314508313/comments/commentRss/365437.htmlhttp://m.tkk7.com/314508313/services/trackbacks/365437.html渚嬪瓙1錛?
Hql浠g爜 澶嶅埗浠g爜
  1. String hql=”from User user ”; 銆銆   
  2. List list=session.CreateQuery(hql).list();   


鍥犱負HQL璇彞涓庢爣鍑哠QL璇彞鐩鎬技錛屾墍浠ユ垜浠篃鍙互鍦℉QL璇彞涓嬌鐢╳here瀛楀彞錛屽茍涓斿彲浠ュ湪where瀛楀彞涓嬌鐢ㄥ悇縐嶈〃杈懼紡錛屾瘮杈冩搷浣滅浠ュ強浣跨敤“and”,”or”榪炴帴涓嶅悓鐨勬煡璇㈡潯浠剁殑緇勫悎銆傜湅涓嬮潰鐨勪竴浜涚畝鍗曠殑渚嬪瓙錛?
Hql浠g爜 澶嶅埗浠g爜
  1. from User user where user.age=20;  


渚嬪瓙2錛堣繑鍥炰竴涓睘鎬э級錛?
Hql浠g爜 澶嶅埗浠g爜
  1. String hql= "select c.customerNamefrom Customer c“;   
  2. Query query= session.createQuery(hql);   
  3. Iteratorit = query.list().iterator();   
  4. System.out.println(query.list().size());   
  5. while(it.hasNext()) {   
  6. String c = (String)it.next();   
  7. System.out.println(c);   
  8. }  


渚嬪瓙3錛堣繑鍥炲涓睘鎬э級錛?
濡傛灉榪斿洖澶氫釜灞炴э紝閭d箞瀹冧滑灝嗚瑁呭叆鏁扮粍鎴栬呴泦鍚堜腑
Hql浠g爜 澶嶅埗浠g爜
  1. String hql= "select c.customerId, c.customerName“+   
  2. “from Customer c“;   
  3. Query query= session.createQuery(hql);   
  4. Iteratorit = query.list().iterator();   
  5. while(it.hasNext()) {   
  6. Object[] obj= (Object[])it.next();   // List list= (List)it.next();   
  7. Long id = (Long)obj[0];          //Long id = (Long)list.get(0);   
  8. String name = (String)obj[1];     //String name = (String)list.get(1);   
  9. System.out.println(id.longValue() + " " + name);   
  10. }  


]]>
鈥渕d5+闅忔満鈥濇柟寮忓姞瀵?/title><link>http://m.tkk7.com/314508313/archive/2011/11/29/365079.html</link><dc:creator>闄堝皬涓?/dc:creator><author>闄堝皬涓?/author><pubDate>Tue, 29 Nov 2011 01:40:00 GMT</pubDate><guid>http://m.tkk7.com/314508313/archive/2011/11/29/365079.html</guid><wfw:comment>http://m.tkk7.com/314508313/comments/365079.html</wfw:comment><comments>http://m.tkk7.com/314508313/archive/2011/11/29/365079.html#Feedback</comments><slash:comments>2</slash:comments><wfw:commentRss>http://m.tkk7.com/314508313/comments/commentRss/365079.html</wfw:commentRss><trackback:ping>http://m.tkk7.com/314508313/services/trackbacks/365079.html</trackback:ping><description><![CDATA[<div id="pbnnr39" class="blog_content">鎽樿錛?<br /><br />1 鍔燬alt鏁e垪 <br />2 ASP.NET 2.0 Membership涓笌瀵嗙爜鏁e垪鏈夊叧鐨勪唬鐮?<br /><br />澹版槑錛氭湰鏂囨墍緗楀垪涔嬫簮浠g爜鍧囬氳繃Reflector鍙栬嚜.NET Framework綾誨簱錛屽紩鐢ㄨ繖浜涗唬鐮佷粎鍑轟簬瀛︿範鍜岀爺絀剁殑鐩殑銆?<br /><br />鍏跺疄錛屽瀵嗙爜榪涜鏁e垪瀛樺偍涓嶆槸涓涓柊椴滆瘽棰樹簡錛岃В鍐寵搗鏉ヤ篃涓嶆槸寰堥毦錛屼絾寰堝浜鴻繕鏄笉澶т簡瑙c傝繖涓皬鏂囧彧鏄己璋冧竴涓?#8220;鍔燬alt鏁e垪”榪欎釜綆鍗曠殑鎶鏈紝騫剁粰鍑篈SP.NET Membership鎵浣跨敤鐨勪唬鐮併?<br /><br />鏈潵鎵撶畻鍐欎竴綃囦粙緇嶅浣曞疄鐜扮敤鎴風櫥褰曞姛鑳界殑鏂囩珷鐨勶紝浣嗗洜涓烘椂闂存湁闄愶紝鎵浠ュ厛浠嬬粛涓涓嬪瘑鐮佺殑鏁e垪錛屼笅涓綃囧啀浠嬬粛鐢ㄦ埛鐧誨綍銆?<br /><br />---- <br /><br />1 瀵嗙爜蹇呴』鏁e垪瀛樺偍 <br /><br />錛堝唴瀹圭暐錛?<br /><br />2 鍔燬alt鏁e垪 <br /><br />鎴戜滑鐭ラ亾錛屽鏋滅洿鎺ュ瀵嗙爜榪涜鏁e垪錛岄偅涔堥粦瀹紙緇熺О閭d簺鏈夎兘鍔涚獌鍙栫敤鎴鋒暟鎹茍浼佸浘寰楀埌鐢ㄦ埛瀵嗙爜鐨勪漢錛夊彲浠ュ涓涓凡鐭ュ瘑鐮佽繘琛屾暎鍒楋紝鐒跺悗閫氳繃瀵規瘮鏁e垪鍊煎緱鍒版煇鐢ㄦ埛鐨勫瘑鐮併傛崲鍙ヨ瘽璇達紝铏界劧榛戝涓嶈兘鍙栧緱鏌愮壒瀹氱敤鎴風殑瀵嗙爜錛屼絾浠栧彲浠ョ煡閬撲嬌鐢ㄧ壒瀹氬瘑鐮佺殑鐢ㄦ埛鏈夊摢浜涖?<br /><br />鍔燬alt鍙互涓瀹氱▼搴︿笂瑙e喅榪欎竴闂銆傛墍璋撳姞Salt錛屽氨鏄姞鐐?#8220;浣愭枡”銆傚叾鍩烘湰鎯蟲硶鏄繖鏍風殑——褰撶敤鎴烽嬈℃彁渚涘瘑鐮佹椂錛堥氬父鏄敞鍐屾椂錛夛紝鐢辯郴緇熻嚜鍔ㄥ線榪欎釜瀵嗙爜閲屾拻涓浜?#8220;浣愭枡”錛岀劧鍚庡啀鏁e垪銆傝屽綋鐢ㄦ埛鐧誨綍鏃訛紝緋葷粺涓虹敤鎴鋒彁渚涚殑浠g爜鎾掍笂鍚屾牱鐨?#8220;浣愭枡”錛岀劧鍚庢暎鍒楋紝鍐嶆瘮杈冩暎鍒楀鹼紝宸茬‘瀹氬瘑鐮佹槸鍚︽紜?<br /><br />榪欓噷鐨?#8220;浣愭枡”琚О浣?#8220;Salt鍊?#8221;錛岃繖涓兼槸鐢辯郴緇熼殢鏈虹敓鎴愮殑錛屽茍涓斿彧鏈夌郴緇熺煡閬撱傝繖鏍鳳紝鍗充究涓や釜鐢ㄦ埛浣跨敤浜嗗悓涓涓瘑鐮侊紝鐢變簬緋葷粺涓哄畠浠敓鎴愮殑salt鍊間笉鍚岋紝浠栦滑鐨勬暎鍒楀間篃鏄笉鍚岀殑銆傚嵆渚塊粦瀹㈠彲浠ラ氳繃鑷繁鐨勫瘑鐮佸拰鑷繁鐢熸垚鐨勬暎鍒楀兼潵鎵懼叿鏈夌壒瀹氬瘑鐮佺殑鐢ㄦ埛錛屼絾榪欎釜鍑犵巼澶皬浜嗭紙瀵嗙爜鍜宻alt鍊奸兘寰楀拰榛戝浣跨敤鐨勪竴鏍鋒墠琛岋級銆?<br /><br />涓嬮潰璇︾粏浠嬬粛涓涓嬪姞Salt鏁e垪鐨勮繃紼嬨備粙緇嶄箣鍓嶅厛寮鴻皟涓鐐癸紝鍓嶉潰璇磋繃錛岄獙璇佸瘑鐮佹椂瑕佷嬌鐢ㄥ拰鏈鍒濇暎鍒楀瘑鐮佹椂浣跨敤“鐩稿悓鐨?#8221;浣愭枡銆傛墍浠alt鍊兼槸瑕佸瓨鏀懼湪鏁版嵁搴撻噷鐨勩?<br /><br /><br />鐢ㄦ埛娉ㄥ唽鏃訛細 <br /><br />1錛夌敤鎴鋒彁渚涘瘑鐮侊紙浠ュ強鍏朵粬鐢ㄦ埛淇℃伅錛夛紱 <br />2錛夌郴緇熶負鐢ㄦ埛鐢熸垚Salt鍊鹼紱 <br />3錛夌郴緇熷皢Salt鍊煎拰鐢ㄦ埛瀵嗙爜榪炴帴鍒頒竴璧鳳紱 <br />4錛夊榪炴帴鍚庣殑鍊艱繘琛屾暎鍒楋紝寰楀埌Hash鍊鹼紱 <br />5錛夊皢Hash鍊煎拰Salt鍊煎垎鍒斁鍒版暟鎹簱涓?<br /><br /><br />鐧誨綍鏃訛細 <br />1錛夌敤鎴鋒彁渚涚敤鎴峰悕鍜屽瘑鐮侊紱 <br />2錛夌郴緇熼氳繃鐢ㄦ埛鍚嶆壘鍒頒笌涔嬪搴旂殑Hash鍊煎拰Salt鍊鹼紱 <br />3錛夌郴緇熷皢Salt鍊煎拰鐢ㄦ埛鎻愪緵鐨勫瘑鐮佽繛鎺ュ埌涓璧鳳紱 <br />4錛夊榪炴帴鍚庣殑鍊艱繘琛屾暎鍒楋紝寰楀埌Hash'錛堟敞鎰忔湁涓?#8220;鎾?#8221;錛夛紱 <br />5錛夋瘮杈僅ash鍜孒ash'鏄惁鐩哥瓑錛岀浉絳夊垯琛ㄧず瀵嗙爜姝g‘錛屽惁鍒欒〃紺哄瘑鐮侀敊璇?<br /><br />3 ASP.NET 2.0 Membership涓殑鐩稿叧浠g爜 <br />錛堢渷鐣ュ叧浜嶮embership鐨勪粙緇嶈嫢騫插瓧錛?<br />鏈枃Anders Liu浠呯爺絀朵簡SqlMembershipProvider錛岃綾諱綅浜嶴ystem.Web.dll錛孲ystem.Web.Security鍛藉悕絀洪棿涓?<br />棣栧厛錛岃浣跨敤Membership錛屽繀欏誨厛鐢╝spnet_regsql.exe鍛戒護鏉ラ厤緗暟鎹簱錛岃宸ュ叿浼氬悜鐜版湁鏁版嵁搴撲腑娣誨姞涓緋誨垪琛ㄥ拰瀛樺偍榪囩▼絳夛紝閰嶇疆濂界殑鏁版嵁搴撲腑鏈変竴涓〃aspnet_Membership錛屽氨鏄敤浜庡瓨鏀劇敤鎴峰笎鎴蜂俊鎭殑銆傚叾涓垜浠墍鍏蟲敞鐨勫垪鏈変笁涓?#8212;—Password銆丳asswordFormat鍜孭asswordSalt銆?<br /><br />Password瀛樻斁鐨勬槸瀵嗙爜鐨勬暎鍒楀鹼紝PasswordFormat瀛樻斁鐢ㄤ簬鏁e垪瀵嗙爜鎵浣跨敤鐨勭畻娉曪紝PasswordSalt灝辨槸緋葷粺鐢熸垚鐨凷alt鍊間簡銆?<br /><br />緗戠珯瀹夊叏浜嗭紝紼嬪簭鑷劧涔熷氨澶嶆潅浜?.. <br />     discuz鐨勫姞瀵嗘柟寮忥細md5(md5($password).$salt)錛?salt鏄竴涓?浣嶉殢鏈烘暟銆?<br />     娉ㄥ唽鐨勬椂鍊欙紝鎶婄敤鎴風殑瀵嗙爜鐢╩d5(md5($password).$salt)鍔犲瘑錛?salt鏄竴涓?浣嶉殢鏈烘暟瀛楋紝涓嬮潰鏄垜鐨勪竴涓幏鍙?浣嶉殢鏈烘暟鐨勪竴涓柟娉曪細 <br />     function randstr($len=6) { <br />     $chars='abcdefghijklmnopqrstuvwxyz0123456789'; <br />// characters to build the password from <br />     mt_srand((double)microtime()*1000000*getmypid()); <br />// seed the random number generater (must be done) <br />     $password=''; <br />     while(strlen($password)<$len) <br />         $password.=substr($chars,(mt_rand()%strlen($chars)),1); <br />     return $password; <br />} <br />     $salt=randstr();鎶妑andstr()璧嬪肩粰$salt錛岀劧鍚庣敤md5(md5(浼氬憳鎻愪氦鐨勫瘑鐮?.$salt)鍔犲瘑灝卞彲浠ヤ簡錛屼絾鏄崈涓囦笉瑕佸繕浜嗘妸$salt鍏ュ簱鍝︼紙uc_members琛級銆?<br />     鐧婚檰鐨勬椂鍊欐牴鎹敤鎴峰悕鎶?salt鍙栧嚭鏉ワ紝鐢╩d5(md5(浼氬憳鎻愪氦鐨勫瘑鐮?.$salt)鍖歸厤瀵嗙爜錛屽鏋滀竴鏍峰氨鐧婚檰鎴愬姛浜?</div><img src ="http://m.tkk7.com/314508313/aggbug/365079.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.tkk7.com/314508313/" target="_blank">闄堝皬涓?/a> 2011-11-29 09:40 <a href="http://m.tkk7.com/314508313/archive/2011/11/29/365079.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>緇ф壙鐨勪紭緙虹偣http://m.tkk7.com/314508313/archive/2011/11/29/365075.html闄堝皬涓?/dc:creator>闄堝皬涓?/author>Tue, 29 Nov 2011 01:37:00 GMThttp://m.tkk7.com/314508313/archive/2011/11/29/365075.htmlhttp://m.tkk7.com/314508313/comments/365075.htmlhttp://m.tkk7.com/314508313/archive/2011/11/29/365075.html#Feedback2http://m.tkk7.com/314508313/comments/commentRss/365075.htmlhttp://m.tkk7.com/314508313/services/trackbacks/365075.html浼樼偣
鏂扮殑瀹炵幇寰堝鏄擄紝鍥犱負澶ч儴鍒嗘槸緇ф壙鑰屾潵鐨?
寰堝鏄撲慨鏀瑰拰鎵╁睍宸叉湁鐨勫疄鐜?

緙虹偣
鎵撶牬浜嗗皝瑁咃紝鍥犱負鍩虹被鍚戝瓙綾繪毚闇蹭簡瀹炵幇緇嗚妭
鐧界洅閲嶇敤錛屽洜涓哄熀綾葷殑鍐呴儴緇嗚妭閫氬父瀵瑰瓙綾繪槸鍙鐨?
褰撶埗綾葷殑瀹炵幇鏀瑰彉鏃跺彲鑳借鐩稿簲鐨勫瀛愮被鍋氬嚭鏀瑰彉
涓嶈兘鍦ㄨ繍琛屾椂鏀瑰彉鐢辯埗綾葷戶鎵挎潵鐨勫疄鐜?
鐢辨鍙錛岀粍鍚堟瘮緇ф壙鍏鋒湁鏇村ぇ鐨勭伒媧繪у拰鏇寸ǔ瀹氱殑緇撴瀯錛屼竴鑸儏鍐典笅搴旇浼樺厛鑰冭檻緇勫悎銆傚彧


鏈夊綋涓嬪垪鏉′歡婊¤凍鏃舵墠鑰冭檻浣跨敤緇ф壙錛?
瀛愮被鏄竴縐嶇壒孌婄殑綾誨瀷錛岃屼笉鍙槸鐖剁被鐨勪竴涓鑹?
瀛愮被鐨勫疄渚嬩笉闇瑕佸彉鎴愬彟涓涓被鐨勫璞?
瀛愮被鎵╁睍錛岃屼笉鏄鐩栨垨鑰呬嬌鐖剁被鐨勫姛鑳藉け鏁?img src ="http://m.tkk7.com/314508313/aggbug/365075.html" width = "1" height = "1" />

]]>
瑙嗗浘涓庝復鏃惰〃鐨勫尯鍒?/title><link>http://m.tkk7.com/314508313/archive/2011/11/24/364691.html</link><dc:creator>闄堝皬涓?/dc:creator><author>闄堝皬涓?/author><pubDate>Thu, 24 Nov 2011 01:19:00 GMT</pubDate><guid>http://m.tkk7.com/314508313/archive/2011/11/24/364691.html</guid><wfw:comment>http://m.tkk7.com/314508313/comments/364691.html</wfw:comment><comments>http://m.tkk7.com/314508313/archive/2011/11/24/364691.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://m.tkk7.com/314508313/comments/commentRss/364691.html</wfw:commentRss><trackback:ping>http://m.tkk7.com/314508313/services/trackbacks/364691.html</trackback:ping><description><![CDATA[<div id="hf3tp9v" class="blog_content"><span style="font-size: large">涓存椂琛?/span> <br />    涓存椂琛ㄤ笌姘鎬箙琛ㄧ浉浼鹼紝浣嗕復鏃惰〃瀛樺偍鍦?tempdb 涓紝褰撲笉鍐嶄嬌鐢ㄦ椂浼氳嚜鍔ㄥ垹闄ゃ?<br />    涓存椂琛ㄦ湁涓ょ綾誨瀷錛氭湰鍦板拰鍏ㄥ眬銆傚畠浠湪鍚嶇О銆佸彲瑙佹т互鍙婂彲鐢ㄦт笂鏈夊尯鍒傛湰鍦頒復鏃惰〃鐨勫悕縐頒互鍗曚釜鏁板瓧絎﹀彿 (#) 鎵撳ご錛涘畠浠粎瀵瑰綋鍓嶇殑鐢ㄦ埛榪炴帴鏄彲瑙佺殑錛涘綋鐢ㄦ埛浠?SQL Server 瀹炰緥鏂紑榪炴帴鏃惰鍒犻櫎銆傚叏灞涓存椂琛ㄧ殑鍚嶇О浠ヤ袱涓暟瀛楃鍙?(##) 鎵撳ご錛屽垱寤哄悗瀵逛換浣曠敤鎴烽兘鏄彲瑙佺殑錛屽綋鎵鏈夊紩鐢ㄨ琛ㄧ殑鐢ㄦ埛浠?SQL Server 鏂紑榪炴帴鏃惰鍒犻櫎銆?<br />    渚嬪錛屽鏋滃垱寤轟簡 employees 琛紝鍒欎換浣曞湪鏁版嵁搴撲腑鏈変嬌鐢ㄨ琛ㄧ殑瀹夊叏鏉冮檺鐨勭敤鎴烽兘鍙互浣跨敤璇ヨ〃錛岄櫎闈炲凡灝嗗叾鍒犻櫎銆傚鏋滄暟鎹簱浼氳瘽鍒涘緩浜嗘湰鍦頒復鏃惰〃 #employees錛屽垯浠呬細璇濆彲浠ヤ嬌鐢ㄨ琛紝浼氳瘽鏂紑榪炴帴鍚庡氨灝嗚琛ㄥ垹闄ゃ傚鏋滃垱寤轟簡 ##employees 鍏ㄥ眬涓存椂琛紝鍒欐暟鎹簱涓殑浠諱綍鐢ㄦ埛鍧囧彲浣跨敤璇ヨ〃銆傚鏋滆琛ㄥ湪鎮ㄥ垱寤哄悗娌℃湁鍏朵粬鐢ㄦ埛浣跨敤錛屽垯褰撴偍鏂紑榪炴帴鏃惰琛ㄥ垹闄ゃ傚鏋滄偍鍒涘緩璇ヨ〃鍚庡彟涓涓敤鎴峰湪浣跨敤璇ヨ〃錛屽垯 SQL Server 灝嗗湪鎮ㄦ柇寮榪炴帴騫朵笖鎵鏈夊叾浠栦細璇濅笉鍐嶄嬌鐢ㄨ琛ㄦ椂灝嗗叾鍒犻櫎銆?<br /><br /><span style="font-size: large">瑙嗗浘</span>瑙嗗浘 <br />    鍙互琚湅鎴愭槸铏氭嫙琛ㄦ垨瀛樺偍鏌ヨ銆傞櫎闈炴槸绱㈠紩瑙嗗浘錛屽惁鍒欒鍥劇殑鏁版嵁涓嶄細浣滀負闈為噸澶嶅璞″瓨鍌ㄥ湪鏁版嵁搴撲腑銆傛暟鎹簱涓瓨鍌ㄧ殑鏄?SELECT 璇彞銆係ELECT 璇彞鐨勭粨鏋滈泦鏋勬垚瑙嗗浘鎵榪斿洖鐨勮櫄鎷熻〃銆傜敤鎴峰彲浠ラ噰鐢ㄥ紩鐢ㄨ〃鏃舵墍浣跨敤鐨勬柟娉曪紝鍦?Transact-SQL 璇彞涓紩鐢ㄨ鍥懼悕縐版潵浣跨敤姝よ櫄鎷熻〃 <br />    瑙嗗浘鏄竴涓櫄鎷熻〃錛屽叾鍐呭鐢辨煡璇㈠畾涔夈傚悓鐪熷疄鐨勮〃涓鏍鳳紝瑙嗗浘鍖呭惈涓緋誨垪甯︽湁鍚嶇О鐨勫垪鍜岃鏁版嵁銆傝鍥懼湪鏁版嵁搴撲腑騫朵笉鏄互鏁版嵁鍊煎瓨鍌ㄩ泦褰㈠紡瀛樺湪錛岄櫎闈炴槸绱㈠紩瑙嗗浘銆傝鍜屽垪鏁版嵁鏉ヨ嚜鐢卞畾涔夎鍥劇殑鏌ヨ鎵寮曠敤鐨勮〃錛屽茍涓斿湪寮曠敤瑙嗗浘鏃跺姩鎬佺敓鎴愩?<br />瀵瑰叾涓墍寮曠敤鐨勫熀紜琛ㄦ潵璇達紝瑙嗗浘鐨勪綔鐢ㄧ被浼間簬絳涢夈傚畾涔夎鍥劇殑絳涢夊彲浠ユ潵鑷綋鍓嶆垨鍏朵粬鏁版嵁搴撶殑涓涓垨澶氫釜琛紝鎴栬呭叾浠栬鍥俱傚垎甯冨紡鏌ヨ涔熷彲鐢ㄤ簬瀹氫箟浣跨敤澶氫釜寮傜被婧愭暟鎹殑瑙嗗浘銆備緥濡傦紝濡傛灉鏈夊鍙頒笉鍚岀殑鏈嶅姟鍣ㄥ垎鍒瓨鍌ㄦ偍鐨勫崟浣嶅湪涓嶅悓鍦板尯鐨勬暟鎹紝鑰屾偍闇瑕佸皢榪欎簺鏈嶅姟鍣ㄤ笂緇撴瀯鐩鎬技鐨勬暟鎹粍鍚堣搗鏉ワ紝榪欑鏂瑰紡灝卞緢鏈夌敤銆?<br />    閫氳繃瑙嗗浘榪涜鏌ヨ娌℃湁浠諱綍闄愬埗錛岄氳繃瀹冧滑榪涜鏁版嵁淇敼鏃剁殑闄愬埗涔熷緢灝戙?<br />    瑙嗗浘縐嶇被錛氱儲寮曡鍥懼拰绱㈠紩瑙嗗浘 <br />    SQL Server 2005 鏌ヨ澶勭悊鍣ㄥ绱㈠紩瑙嗗浘鍜岄潪绱㈠紩瑙嗗浘灝嗗尯鍒寰咃細 绱㈠紩瑙嗗浘鐨勮浠ヨ〃鐨勬牸寮忓瓨鍌ㄥ湪鏁版嵁搴撲腑銆傚鏋滄煡璇紭鍖栧櫒鍐沖畾浣跨敤鏌ヨ璁″垝鐨勭儲寮曡鍥撅紝鍒欑儲寮曡鍥懼皢鎸夌収鍩鴻〃鐨勫鐞嗘柟寮忚繘琛屽鐞嗐傚彧鏈夐潪绱㈠紩瑙嗗浘鐨勫畾涔夋墠瀛樺偍錛岃屼笉瀛樺偍瑙嗗浘鐨勮銆傛煡璇紭鍖栧櫒灝嗚鍥懼畾涔変腑鐨勯昏緫綰沖叆鎵ц璁″垝錛岃岃鎵ц璁″垝鏄畠涓哄紩鐢ㄩ潪绱㈠紩瑙嗗浘鐨?SQL 璇彞鐢熸垚鐨勩?<br />    SQL Server 鏌ヨ浼樺寲鍣ㄧ敤浜庡喅瀹氫綍鏃朵嬌鐢ㄧ儲寮曡鍥劇殑閫昏緫涓庣敤浜庡喅瀹氫綍鏃跺琛ㄤ嬌鐢ㄧ儲寮曠殑閫昏緫鐩鎬技銆傚鏋滅儲寮曡鍥句腑鐨勬暟鎹寘鎷墍鏈夋垨閮ㄥ垎 SQL 璇彞錛岃屼笖鏌ヨ浼樺寲鍣ㄧ‘瀹氳鍥劇殑鏌愪釜绱㈠紩鏄綆鎴愭湰鐨勮闂礬寰勶紝鍒欎笉璁烘煡璇腑鏄惁寮曠敤浜嗚瑙嗗浘鐨勫悕縐幫紝鏌ヨ浼樺寲鍣ㄩ兘灝嗛夋嫨姝ょ儲寮曘傚綋 SQL 璇彞寮曠敤闈炵儲寮曡鍥炬椂錛屽垎鏋愬櫒鍜屾煡璇紭鍖栧櫒灝嗗垎鏋?SQL 璇彞鐨勬簮鍜岃鍥劇殑婧愶紝鐒跺悗灝嗗畠浠В鏋愪負鍗曚釜鎵ц璁″垝銆?</div><img src ="http://m.tkk7.com/314508313/aggbug/364691.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.tkk7.com/314508313/" target="_blank">闄堝皬涓?/a> 2011-11-24 09:19 <a href="http://m.tkk7.com/314508313/archive/2011/11/24/364691.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>甯歌鐨勬暟鎹簱鍩虹闈㈣瘯棰樺ぇ鍏?/title><link>http://m.tkk7.com/314508313/archive/2011/11/24/364690.html</link><dc:creator>闄堝皬涓?/dc:creator><author>闄堝皬涓?/author><pubDate>Thu, 24 Nov 2011 01:17:00 GMT</pubDate><guid>http://m.tkk7.com/314508313/archive/2011/11/24/364690.html</guid><wfw:comment>http://m.tkk7.com/314508313/comments/364690.html</wfw:comment><comments>http://m.tkk7.com/314508313/archive/2011/11/24/364690.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://m.tkk7.com/314508313/comments/commentRss/364690.html</wfw:commentRss><trackback:ping>http://m.tkk7.com/314508313/services/trackbacks/364690.html</trackback:ping><description><![CDATA[<div id="l999f9t" class="blog_content">1. 鏁版嵁鎶借薄錛氱墿鐞嗘娊璞°佹蹇墊娊璞°佽鍥劇駭鎶借薄,鍐呮ā寮忋佹ā寮忋佸妯″紡 <br />2. SQL璇█鍖呮嫭鏁版嵁瀹氫箟銆佹暟鎹搷綰?Data Manipulation),鏁版嵁鎺у埗(Data Control) <br />鏁版嵁瀹氫箟錛欳reate Table,Alter Table,Drop Table, Craete/Drop Index絳?<br />鏁版嵁鎿嶇旱錛歋elect ,insert,update,delete, <br />鏁版嵁鎺у埗錛歡rant,revoke <br />3. SQL甯哥敤鍛戒護錛?<br />CREATE TABLE Student( <br />ID NUMBER PRIMARY KEY, <br />NAME VARCHAR2(50) NOT NULL);//寤鴻〃 <br />CREATE VIEW view_name AS <br />Select * FROM Table_name;//寤鴻鍥?<br />Create UNIQUE INDEX index_name ON TableName(col_name);//寤虹儲寮?<br />INSERT INTO tablename {column1,column2,…} values(exp1,exp2,…);//鎻掑叆 <br />INSERT INTO Viewname {column1,column2,…} values(exp1,exp2,…);//鎻掑叆瑙嗗浘瀹為檯褰卞搷琛?<br />UPDATE tablename SET name=’zang 3’ condition;//鏇存柊鏁版嵁 <br />DELETE FROM Tablename WHERE condition;//鍒犻櫎 <br />GRANT (Select,delete,…) ON (瀵硅薄) TO USER_NAME [WITH GRANT OPTION];//鎺堟潈 <br />REVOKE (鏉冮檺琛? ON(瀵硅薄) FROM USER_NAME [WITH REVOKE OPTION] //鎾ゆ潈 <br />鍒楀嚭宸ヤ綔浜哄憳鍙婂叾棰嗗鐨勫悕瀛楋細 <br />Select E.NAME, S.NAME FROM EMPLOYEE E S <br />WHERE E.SUPERName=S.Name <br />4. 瑙嗗浘錛?<br />5. 瀹屾暣鎬х害鏉燂細瀹炰綋瀹屾暣鎬с佸弬鐓у畬鏁存с佺敤鎴峰畾涔夊畬鏁存?<br />6. 絎笁鑼冨紡錛?<br />1NF:姣忎釜灞炴ф槸涓嶅彲鍒嗙殑銆?2NF:鑻ュ叧緋籖鏄紤NF,涓旀瘡涓潪涓誨睘鎬ч兘瀹屽叏鍑芥暟渚濊禆浜嶳鐨勯敭銆備緥SLC(SID#, CourceID#, SNAME,Grade),鍒欎笉鏄?NF; 3NF:鑻鏄?NF錛屼笖瀹冪殑浠諱綍闈為敭灞炴ч兘涓嶄紶閫掍緷璧栦簬浠諱綍鍊欓夐敭銆?<br />7. ER(瀹炰綋/鑱旂郴)妯″瀷 <br />8. 绱㈠紩浣滅敤 <br />9. 浜嬪姟錛氭槸涓緋誨垪鐨勬暟鎹簱鎿嶄綔錛屾槸鏁版嵁搴撳簲鐢ㄧ殑鍩烘湰閫昏緫鍗曚綅銆備簨鍔℃ц川錛氬師瀛愭с?<br />飦?鍘熷瓙鎬с傚嵆涓嶅彲鍒嗗壊鎬э紝浜嬪姟瑕佷箞鍏ㄩ儴琚墽琛岋紝瑕佷箞灝卞叏閮ㄤ笉琚墽琛屻?<br />飦?涓鑷存ф垨鍙覆鎬с備簨鍔$殑鎵ц浣垮緱鏁版嵁搴撲粠涓縐嶆紜姸鎬佽漿鎹㈡垚鍙︿竴縐嶆紜姸鎬?<br />飦?闅旂鎬с傚湪浜嬪姟姝g‘鎻愪氦涔嬪墠錛屼笉鍏佽鎶婅浜嬪姟瀵規暟鎹殑浠諱綍鏀瑰彉鎻愪緵緇欎換浣曞叾浠栦簨鍔★紝 <br />飦?鎸佷箙鎬с備簨鍔℃紜彁浜ゅ悗錛屽叾緇撴灉灝嗘案涔呬繚瀛樺湪鏁版嵁搴撲腑錛屽嵆浣垮湪浜嬪姟鎻愪氦鍚庢湁浜嗗叾浠栨晠闅滐紝浜嬪姟鐨勫鐞嗙粨鏋滀篃浼氬緱鍒頒繚瀛樸?<br />10. 閿侊細鍏變韓閿併佷簰鏂ラ攣 <br />涓ゆ閿佸崗璁細闃舵錛戯細鍔犻攣闃舵 闃舵錛掞細瑙i攣闃舵 <br />11. 姝婚攣鍙婂鐞嗭細浜嬪姟寰幆絳夊緟鏁版嵁閿侊紝鍒欎細姝婚攣銆?<br />姝婚攣澶勭悊錛氶闃叉閿佸崗璁紝姝婚攣鎭㈠鏈哄埗 <br />12. 瀛樺偍榪囩▼錛氬瓨鍌ㄨ繃紼嬪氨鏄紪璇戝ソ浜嗙殑涓浜泂ql璇彞銆?<br />1.瀛樺偍榪囩▼鍥犱負SQL璇彞宸茬粡棰勭紪緇庤繃浜嗭紝鍥犳榪愯鐨勯熷害姣旇緝蹇?<br />2. 鍙繚璇佹暟鎹殑瀹夊叏鎬у拰瀹屾暣鎬с傞氳繃瀛樺偍榪囩▼鍙互浣挎病鏈夋潈闄愮殑鐢ㄦ埛鍦ㄦ帶鍒朵箣涓嬮棿鎺ュ湴瀛樺彇鏁版嵁搴擄紝浠庤屼繚璇佹暟鎹殑瀹夊叏銆傞氳繃瀛樺偍榪囩▼鍙互浣跨浉鍏崇殑鍔ㄤ綔鍦ㄤ竴璧峰彂鐢燂紝浠庤屽彲浠ョ淮鎶ゆ暟鎹簱鐨勫畬鏁存с?<br />3.鍙互闄嶄綆緗戠粶鐨勯氫俊閲忋傚瓨鍌ㄨ繃紼嬩富瑕佹槸鍦ㄦ湇鍔″櫒涓婅繍琛岋紝鍑忓皯瀵瑰鎴鋒満鐨勫帇鍔涖?<br />4錛氬瓨鍌ㄨ繃紼嬪彲浠ユ帴鍙楀弬鏁般佽緭鍑哄弬鏁般佽繑鍥炲崟涓垨澶氫釜緇撴灉闆嗕互鍙婅繑鍥炲箋傚彲浠ュ悜紼嬪簭榪斿洖閿欒鍘熷洜 <br />5錛氬瓨鍌ㄨ繃紼嬪彲浠ュ寘鍚▼搴忔祦銆侀昏緫浠ュ強瀵規暟鎹簱鐨勬煡璇€傚悓鏃跺彲浠ュ疄浣撳皝瑁呭拰闅愯棌浜嗘暟鎹昏緫銆?nbsp;  <br />13. 瑙﹀彂鍣細 褰撴弧瓚寵Е鍙戝櫒鏉′歡錛屽垯緋葷粺鑷姩鎵ц瑙﹀彂鍣ㄧ殑瑙﹀彂浣撱?<br />瑙﹀彂鏃墮棿錛氭湁before,after.瑙﹀彂浜嬩歡錛氭湁insert,update,delete涓夌銆傝Е鍙戠被鍨嬶細鏈夎瑙﹀彂銆佽鍙ヨЕ鍙?<br />14.鍐呰仈鎺?澶栬仈鎺ュ尯鍒紵 <br />鍐呰繛鎺ユ槸淇濊瘉涓や釜琛ㄤ腑鎵鏈夌殑琛岄兘瑕佹弧瓚寵繛鎺ユ潯浠訛紝鑰屽榪炴帴鍒欎笉鐒躲?<br />鍦ㄥ榪炴帴涓紝鏌愪簺涓嶆弧鏉′歡鐨勫垪涔熶細鏄劇ず鍑烘潵錛屼篃灝辨槸璇達紝鍙檺鍒跺叾涓竴涓〃鐨勮錛岃屼笉闄愬埗鍙︿竴涓〃鐨勮銆傚垎宸﹁繛鎺ャ佸彸榪炴帴銆佸叏榪炴帴涓夌 </div><img src ="http://m.tkk7.com/314508313/aggbug/364690.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://m.tkk7.com/314508313/" target="_blank">闄堝皬涓?/a> 2011-11-24 09:17 <a href="http://m.tkk7.com/314508313/archive/2011/11/24/364690.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Maven甯哥敤鍛戒護http://m.tkk7.com/314508313/archive/2011/11/23/364613.html闄堝皬涓?/dc:creator>闄堝皬涓?/author>Wed, 23 Nov 2011 01:35:00 GMThttp://m.tkk7.com/314508313/archive/2011/11/23/364613.htmlhttp://m.tkk7.com/314508313/comments/364613.htmlhttp://m.tkk7.com/314508313/archive/2011/11/23/364613.html#Feedback0http://m.tkk7.com/314508313/comments/commentRss/364613.htmlhttp://m.tkk7.com/314508313/services/trackbacks/364613.html闃呰鍏ㄦ枃

]]>
主站蜘蛛池模板: 在线观看免费人成视频| 99久久久国产精品免费蜜臀| www.999精品视频观看免费| 亚洲人成在线播放网站岛国| 任你躁在线精品免费| 亚洲AV无码成人精品区在线观看| 国产网站在线免费观看| 一本天堂ⅴ无码亚洲道久久| 国产成人精品无码免费看 | 国产成人久久精品亚洲小说| 免费阿v网站在线观看g| 国产99在线|亚洲| 四虎成人精品一区二区免费网站| 久久亚洲精品无码播放| 中文字幕乱理片免费完整的| 亚洲色无码专区在线观看| 久久免费高清视频| 亚洲春色另类小说| 精品免费久久久久久成人影院| 国产亚洲高清不卡在线观看| 中文字幕看片在线a免费| 久久久久亚洲AV片无码| 99久久精品日本一区二区免费| 亚洲色偷拍另类无码专区| 久久w5ww成w人免费| 中文字幕亚洲综合久久综合| 日韩免费视频观看| 中文字幕无线码免费人妻| 亚洲黄色三级网站| 日韩成人免费aa在线看| 三根一起会坏掉的好痛免费三级全黄的视频在线观看 | 亚洲精品女同中文字幕| 又色又污又黄无遮挡的免费视| 久久久亚洲欧洲日产国码aⅴ| 免费视频精品一区二区| 亚洲成AV人在线播放无码| 我的小后妈韩剧在线看免费高清版| 久久久久亚洲av成人无码电影| 亚洲综合国产成人丁香五月激情| 久久国产精品免费看| 亚洲国产成人手机在线观看|