返回
华为面试笔试题

华为面试笔试题

ID：83342787

大小：14.06 MB

页数：188页

时间：2023-07-17

上传者：灯火阑珊2019
华为面试笔试题_第1页
华为面试笔试题_第2页
华为面试笔试题_第3页
华为面试笔试题_第4页
华为面试笔试题_第5页
华为面试笔试题_第6页
华为面试笔试题_第7页
华为面试笔试题_第8页
华为面试笔试题_第9页
华为面试笔试题_第10页
资源描述：

《华为面试笔试题》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1.☢ᔣḄᱯᨵ☢1ᶍ⚪᪗ᐵḄ☢!"ᐙᑖᙢ&'᪗ᨵᐵḄ☢0()ᡭ+,-ᐰ/0⚪12⌱4ᐸḄ•/ᑖᨚ8)ᵨ/ᑖ:⁚஺ᒹ>?☢•@ABᦪD஺2EFEFGὶIJḄKLMN(OᐕQRSTJḄUᵨVWX,•GZ[⊤]ᐳឋḄ`஺ḄaJbcdᨵḄJefg@AhiJEF஺aJEF,jkJḄᱯឋaJhijkJḄefJlmJn1jkJhiaJḄoJl᱄Jn஺efJbcVḄoJqEF`Rrstu(OJbvᦋᡈyzaḄ`{|"〉ᔠᱯḄ◤⌕஺3@ARᦪDᒹᩭᦪDḄ02@Ḅ☢஺☢ᔣ+kgoᭆᓽdrbᡂᑡᐰஹḄg@¡¢Ḅ£¤0ᐸ¥஺4¦᝱ឋ¦᝱ឋᢣᐕQ)©JḄ©•ª«¬®¯஺¦᝱ឋᒹ>°ᦪᓄ¦᝱ឋRᒹ²¦᝱ឋ஺¦᝱ឋ³´ᐹᨵᮣ·ஹஹ¸iᐳ¹ஹºṹᐳ¹Ḅ¼½¾¿Ḅ-À,¯ᵨAÁÂᦪ©Ã0⚪஺2.¬ᵨÄpublic,private,protected,Å)ᑏ8ḄÇÈÇÈ᝞ʬᵨÄJ©ᒹmËJᐸ¥publicVVVVprotectedVVVXdefaultVVXXprivateVXXX)ᑏ8ÌÍidefaulto3.StringᨬoḄᦪDJNᔩ)஺

14.floatNfloatf=3.4ᔲÚ[)Ú[ÛÜÝ)Þ[¯ßᵨàᑴJNâᣚ᝞Êᡠåfloatf=lfloatn3.4஺5.³çfloatf=1.3Ûéêᔲ@);¯ßᵨàᑴJNâᣚ᝞Êᡠå:floatf=lfloatn1.3஺6.shorts1=1;s1=s1+1;ᨵòó┯?shorts1=1;s1+=1;ᨵòó┯?shortsi=1;si=si+l;sl+l÷+IøintN◤⌕àᑴâᣚJNÛshortsi=1;si+=1;bÚ[éêúJNWᓣ஺7.Javaᨵÿᨵgoto?gotojavaḄᶇᙠᨵᙠjavaᵨ஺8.intIntegerᨵ!"Java$%&'()Ḅ*+,-ᵨ*+./*+0ᡈᑁ3*+45intjavaḄ./ᦪ7*+Integerjava8int$%Ḅ9:*஺Java8;<./*+$%=9:*,./*+:boolean,char,byte,short,int,long,float,double9:*+,Boolean,Character*Byte»Short,Integer,Long,Float>Double-ᵨ*+./*+ḄR8Sᐰ()UVWXᐹᨵ()ḄZ[஺-ᵨ*+./*+ᐹᨵ()Ḅᱯ]ᵨ^WXᒹ`,ᜧbcde⚪g'*+hi'*+Ḅᦪ7j᪀lm•o-ᵨ*+./*+ᵨpq<*Ḅrsᦪ7tᡠᢣwḄxḕz஺{|-ᵨrs}~Ḅxḕz8null,./*+rs}~ḄxḕzWXḄ*+ᨵᐵ஺9.&&&Ḅ!"&⊤ᢥ&&⊤0and4஺10.p0&,4ᩩp0&&4Ḅ!?

2!⌕ᨵ&,a.ᩩpp+Ḅp(hp+hpᦪz+b.p(¡¢£¤஺11.heapstackᨵ!"᪘¦'§¨©ᔠᐸ¬ᑤ◀ᐗ±Ḅp²ᙠ)¦³Sᡂ᪘ᢥ᯿¶·ᐜ¹Ḅº»·Rᜐᳮ5ᚮ᪘Ḅ¦<¿ᡂᐗ±஺12.Math.round(11.5)ÀÁÂÃ"Math.round(-11.5)ÀÁÂÃ?Math.round(11«5)==12Math.round(-11.5)==-11roundº^ÄÅÆᦪᨬÈÉḄÊ᦮ᦪÆᦪ1/2¶Ìᐸflooro13.swtichᔲpᵨᙠbyteÎÏᔲpᵨᙠlongÐᔲpᵨᙠStringÐ"switch(exprl)exprl¦<᦮ᦪ⊤Ñ»஺ÒÓÔ⌴ÖswitchcaseZ×ḄÆᦪ²Øintஹshortஹcharᡈὅbyte஺long,stringÛ(pᵨÁswticho14.ÜÝ⚪,ᵨᨬᨵᦔ᳛Ḅº^¹2àh8Àáâ"2«315.ᦪ¿ᨵᨵlength஺g<º^"Strinᨵᨵlength஺g<º^"ᦪ¿ᨵlength()g<º^ᨵlengthḄãឋ஺Stringᨵ1ength()g<º^஺16.ᙠJAVA᝞æç¹oèḄÂéêᝅìí"ᙠᨬ᜜ïìíèðabel᪗òᯠ¶ᵨbreaklabelº^ᓽç¹Âéìí஺17.᪀⌼ᘤConstructorᔲ÷override?᪀⌼øConstructor(÷ùúÒÓ(éᑏOverriding,üh÷éýOverloading஺18.&<{|zþ)(x.equals(y)==true),üᓾᨵḄhashcode,

3ᨵḄhashcode஺19.ᔲStringStringfinalᦑ஺20.$%ᩩ'()*+trueḄᨵ,A,—beijingII==_beijingII4B,—beijingII.equalsIgnoreCase(newString(—beijingII))4A=B21.ᡃ?ᙠwebAᵨCDEFGHI⍗ᑮLMNOPṹḄRS,᝞iso8859-1V᝞WLMXYNOPṹḄRSZpublicStringtranslate(Stringstr){StringtempStr="n;try{tempStr=newString(str.getBytes(nISO-8859-lH),nGBKH);tempStr=tempStr.trim();}catch(Exceptione){System.err.printin(e.getMessage());)returntempStr;)22.String=StringBufferḄmn?JAVArstuvwY,String=StringBuffer,x?yz={|RSZᓽᒹYRSḄRSᦪ஺YStringtuvᦪ*ᦋḄRSZ஺YStringBuffertuḄRSZᦋ஺⍝RSᦪ⌕ᦋḄ᎛ᵨStringBuffer஺ᐺᙢᵨStringBuffersᩭ᝱᪀⌼RSᦪ஺

423.String,StringBufferStringBuilderḄmn஺StringḄḄ4StringBufferḄḄ᝞RSZGḄᑁHI{|ᱯnᑁ⌕ᦋ¡ᵨStringBuffer,᝞ᨬ£◤⌕String,¡ᵨStringBufferḄtoString()¥¦4§F¨ᐰ4StringBuilderªJDK5C«+StringBuffer¬⊡ᐙvX■YᓫY§FᵨḄV±4²IA¬³ᐜᵨStringBuilderµ+x¶ᢝᡠᨵḄ{|¹ᵫ»x᡻½ᡠ¾¿À஺24.Overload=OverrideḄmn஺OverloadedḄ¥¦ᔲᦋ(I*Ḅ¥¦ḄÁᑏOverriding=ÁÃOverloadingJava᝱ឋḄ⊤Æ஺ÁᑏOverriding᱄ÈÉÊË᝱ឋḄXO⊤ÆÁÃOverloadingXYG᝱ឋḄXO⊤Æ஺᝞ᙠÉGÌÍN¥¦Èᐸ᱄ᨵḄÏÐ=Ñᦪᡃ?Ò¬¥¦ÓÁᑏ(Overriding)oÉḄÔᵨY¥¦ÕÖᵨÉGḄÌÍx×᱄GḄÌÍ᝞ÓXØÙIIv஺᝞ᙠXYGÌÍvYÏḄ¥¦x?ᡈᨵḄÑᦪYᦪᡈᨵḄÑᦪᑣÐ+¥¦ḄÁÃ(Overloading)<>OverloadedḄ¥¦ᦋ()*Ḅ஺25.ÌÍA=B᝞$,classA{inta=l;doubled=2.0;voidshow(){System,out.printIn("ClassA:a=,,+a+H\td=n+d);})classBextendsA{floata=3.Of;

5Stringd=HJavaprogram.";voidshow(){super.show();System.out.printIn("ClassB:a=,,+a+,,\td=,,+d);))(1)ÜᙠAᵨFÝḄmain¥¦Gᨵ$',Aa=newA();a.show();ᑣLMḄÞ᝞W(2)ÜᙠAᵨFÝḄmain¥¦GÌÍBḄÔb:Ab=newB();b.show();ᑣLMḄÞ᝞WLMÞ+,1)ClassA:a=ld=2.042)ClassA:a=ld=2.0ClassB:a=3.0d=Javaprogram஺26.ßàX$JVMáâclassᦻäḄåᳮçᑴJVMGḄéÃᵫClassLoader=xḄÉᩭêÆḄJavaClassLoaderXYÁ⌕ḄJavaëìíîä஺xïðᙠëñò=éᐭᦻäḄ஺27.charôGõõzöXYGᦻ÷R+ø¡õùÌÍᡂ+XYGᦻḄµ+javaGunicodePṹXYcharᓰ16YR⁚ᡠýXYGᦻþÿ⚪Ḅ஺28.abstractclassinterfaceᨵ?ḄᙠḄ(abstractclass),ᵨ⌕!"#$%&'()*Ḅ+,*-+./ᙠ-0-Ḅ12஺

6/!abstractḄ3஺ᯠ56!"#78+ᐸ:;"#+,<ᢣᔣᐹ$@Ḅ"#3஺/ᨵ᪀⌼Cᦪᡈ☟᝱஺AbstractḄ@*H᱄0ḄᡠᨵKL+ᔲᑣHO;*஺PQR+ᙠ@0-஺S⍝ᐸ)*Ḅᐸ56ᙠ0U&஺VW(interface);Ḅ7$஺X:YZ[ឋ5]^U᪵ḄVW`a஺VW0Ḅᡠᨵb;Ḅ+ᡠᨵᡂᕒ78b;publicstaticfinalḄ஺"#56Y#VW+eᱯgVWh+ij(ᓽmno$pq)ᡠᨵUsVWḄ஺ᯠt+56ᙠu-VWḄḄvwxyzᵨVWḄ஺ᵫᨵ+ᐕ}~ᵨVW*ᵨ78Ḅ:஺]Ḅ᝱ὶmᦔ஺ᵨ56ᣚᑮVW:ᡈVW:ᣚ+instanceof56ᵨᩭi%xḄ;ᔲuVW஺29.StaticNestedClassWInnerClassḄ?StaticNestedClass;*☟᝱(static)Ḅᑁ+56᜜33ᓄ஺]Ḅᑁ◤⌕ᙠ᜜3ᓄt/3ᓄ஺30.java0ᙠᑁᔩ+ᓫ¡¢஺£ᙠ¤ᵨ.5¥Ḅx+U&x/GC¦ᦈ+¨©ὑ«ᑁ¬஺31.abstractḄmethod;ᔲ5h;static,;ᔲ5h;native,;ᔲ5h;synchronized?b/஺32.☟᝱78378Ḅ¯☟᝱78O°*78+±ᐰᐳᨵ+%#x+5]^´Vµ¶£378·¸%•3+º/]^x/µ¶ᑮ஺33.;ᔲ56"#staticᑁ»¼x½staticḄzᵨ¯56+᝞¿ᐸ0ᒹÁxḄmethod(),/ÂÃx•ÄÅᓄ஺

734.ᑏclone()h+]bᨵ")Qṹ+;¯CloneᨵÍḕ)*£super.cloneO,Ö×ØÙÚÛᜧÝḄÞß+,⌲áâᑴ஺35.GC;¯*⌕ᨵGC?GC;ᚗæᦈçḄèé(GabageCollection),ᑁᜐᳮ;nñᕒò᧕¼¶⚪Ḅᙢ+õöᡈὅ┯ùḄᑁ¦ᦈ¨©noᡈúûḄüiýþÿJavaḄGCᔲᵨᑮᦈᑁ"Ḅ#ḄJava$%&ᨵ()*ᑖ,ᑁ"Ḅ-./01஺Java34ᕒ6ᵨ78ᑁ"9ᳮ;<ᚗ>ᦈ?ᘤABC9ᳮ஺DEFᚗ>ᦈ?GᵨH☢Ḅ01JKLSystem,gc()ᡈRuntime.getRuntime().gc()஺36.ᚗ>ᦈḄ_`abᳮ஺cὃ⇋2fᦈgᑴ஺Java$%iKj-℉Ḅᱯ`mnᐭpᚗ>ᦈgᑴqC++34ᕒᨬᜮuḄᑁ"9ᳮḄv⚪xᑓz{q|Java34ᕒᙠ~ᑏ34Ḅ᎛6◤⌕ὃ⇋ᑁ"9ᳮ஺ᵫᨵjᚗ>ᦈgᑴJavaiḄ6ᨵKᵨIIḄᭆᨵḄnᵨᨵKᵨII.ᚗ>ᦈᨵᦔḄ■ᑁ"☄ᨵᦔḄqᵨqᵨḄᑁ"஺ᚗ>ᦈᘤ¨ᦈᘤ©jᡈᡠᨵBCᚗ>ᦈ஺ᦈgᑴᨵᑖ«¬ᑴᚗ>ᦈa᪗®ᚗ>ᦈ¯°ᚗ>ᦈ஺37.ᚗ>ᦈᘤḄ±²bᳮ³´µᚗ>ᦈᘤ¶·ᦈᑁ"ᔩµᨵ³´¹1º»¼gBCᚗ>ᦈµGCᩭ¾¿34ᕒÀÁGCmÂÃÄÅjḄᙢᙬஹᜧÊËqᵨ஺GCÌᵨᨵᔣÎḄ0Ï®Ða9ᳮᚮ(heap)iḄᡠᨵ஺Åf0ÏÓÔÕÖ“Ḅ”ÕÖ“6ḄL¿GCÓÔKÖ<“6”GCmᨵÚÛᦈÅÖᑁ"ܤ஺஺34ᕒÝ᡻CSystem.gc(),GCCßJava$%àc6âãGCKÔA᡻C஺

838.Strings=newString—xyzIIä;ÀÁpæjStringObject?çjKj“xyx”Kjᢣᔣ“xyx”Ḅnᵨs஺39.êëᔲìíêëµîïᔲ§ðimplementsêëµîïᔲìí§ñïconcreteclass?êëìíêë஺îï§ðòimplementsäêëîïìí§ñïßô§ñïõöᨵ÷ÓḄ᪀⌼úᦪ஺40.JavaḄêëaC++Ḅ»ïḄüýa6ýᜐ஺ᵫJava6ÿᢝᨵᡈ⌕ᵨᑖᙠᡈ☢ḄᡈឋᨵḄᓫᑴ!"#$⌕%஺'()*+ᨵ,-Ḅᮣ/ឋ01*+23ᨵ4567ṹ஺9:6;*+<=>⌕6*+☢ᡠᨵḄ@ឋAB*+☢ḄឋᙠCDE᝱G☢HIpublicstatic,ᡠᨵCDUVGIpublic.:<6*+஺41.::.javaIIXᦻZ2Iᔲ<ᒹ]^"Iᑁ`abᨵcd▲ᑴb

945.java26᝱ḄᑴIcdbḄ⌚Overriding@¡¢OverloadingIjava᝱ឋḄ"k⊤⌚OverridingI᱄'¥¦§᝱ឋḄ:¨⊤¡¢OverloadingI:2᝱ឋḄ:¨⊤஺46.ᙠjava2:©ª«1final¬⊤;cd®¯b⊤>"©I⚔±஺47.G☢²n<©b1)java.lang.Thread(T)2)java.lang.Number(T)3)java.lang.Double(F)4)java.lang.Math(F)5)java.lang.Void(F)6)java.lang.Class(F)7)java.lang.ClassLoader(T)1ஹ2ஹ7<©஺48.ᢣmG☢µḄ¶·¸¹fூ»Ạ௃classA{static{System.out.print(n1");)publicA(){System.out.print(n2");))classBextendsA{static{

10System.out.print("a");)publicB(){System,out.print(**b*');))publicclassHello{publicstaticvoidmain(String[]ars){Aab=newB();//᡻·ᑮᜐ¸¹fla2bab=newB();//᡻·ÐljÑᓃᜐ¸¹fla2b2b))Óm¸¹1la2b2bfḄstatic7ṹÔ<ÕÖI✌ØÙ¢(ÚÛÙ¢)᡻·Ḅ7ṹÜÙ¢✌ᐜ⌕᡻·ᐸ»Ḅ᪀⌼à᡻·ᐸáâḄ᪀⌼஺49.᎛Ḅ᡻·æµ⚪:èHI⌱ê⚪ëìíᡭᓺmcdb᱄fpackagetest;publicclassFatherclass{publicFatherClass(){System.out.printIn("FatherClassCreate'*);})¥fpackagetest;importtest.FatherClass;publicclassChildClassextendsFatherClass{publicChildClass(){System.out.printin("ChildClassCreate**);)

11publicstaticvoidmain(String[]args){FatherClassfc=newFatherclass();ChildClasscc=newChildClass();})Óm¸¹1fFatherClassCreateFatherClassCreateChildClassCreate50.ᑁ`Ḅ6bõ7ṹ᝞Gfpackagetest;publicclassOuterClass{privateclassInterClass{publicInterClass(){System.out.printin(nInterClassCreate");)}publicOuterClass(){InterClassic=newInterClass();System.out.printin(*'OuterClassCreate11);}publicstaticvoidmain(String[]args){OuterClassoc=newOuterClass();})Óm¸¹1fInterClassCreate

12OuterClassCreate51.ᐵÜᑁ`fpublicclassOuterClass{privatedoubled1=1.0;//insertcodehere)Youneedtoinsertaninnerclassdeclarationatline3,Whichtwoinnerclassdeclarationsarevalid?(Choosetwo.)A.classlnnerOne{publicstaticdoublemethoda(){returnd1;})B.publicclasslnnerOne{?staticdoublemethoda(){returnd1;})C.privateclasslnnerOne{doublemethoda(){returnd1;})D.staticclasslnnerOne{protecteddoublemethoda(){returnd1;})E.abstractclasslnnerOne{publicabstractdoublemethoda();}ùᫀ1CஹEfl«᝞Gf1)☟᝱ᑁ`<ᨵ☟᝱ᡂᕒþ☟᝱ᑁ`ᑣᨵ☟᝱ᡂᕒᦑ4ஹB┯2)☟᝱ᑁḄ☟᝱ᡂᕒ᜜Ḅ☟᝱᜜Ḅ☟᝱ᦑD┯3)☟᝱ᑁḄ☟᝱ᡂᕒ᜜Ḅ☟᝱ᦑC!஺52.ᦪ$%&'Ḅ(ᣚ*1)᝞,-ᦪ.%/0(ᣚ1ᦪ/2

132)᝞,-ᦪ/(ᣚ1/023)᝞,45ᦪ6789:;<=ᐭ21)?ᵨᦪ.%ABᒹDEḄFGparse***(String)ᡈvalueOf(String)ᓽJKABLM%ᡈᒹD%ᦪ.2)-ᦪ/NO/0PAQᓽRSᐸᡠVBḄ/0PW᜜VXLᩈ%ᦪ/Z?ᵨStringEḄvalueOf(•,,)FGJKAB/0PVXᒹD%ᦪ/ᑣ?ᵨᐸtoString()FGRSAB/0P3).ᵨ]ᦪ/᪀⌼`java.math.BigDecimalVabᑭᵨᐸround஺FGde;<=ᐭᑮgᶇ5ᦪ6i89b-ᐸ(ᣚ1/0Pj4ᨬi89஺53./0Plm*᝞,no/0PḄp(qrᣚ2ᵨ/0P᪀⌼`StringBufferVaᯠi?ᵨStringBufferEḄreverseFGᓽno/0PḄp(?ᵨreplaceFGᓽno/0PḄrᣚ஺54.tṹ(ᣚ*v᪵-GB2312tṹḄ/0P(ᣚ1ISO-8859-1tṹḄ/0P2xyzṹ᝞{*Stringsi="~”Strings2=newString(si.getBytes("GB2312"),"ISO-8859-1")55.ᑏ`ᦪ⌕ᐭ`/0P`/0V]/0Pdeᑖ◞஺ᦪzṹ᝞{*publicString[]split(Stringstr,intchars){intn=(str.length()+chars-1)/chars;Stringret[]=newString[n];for(inti=0;i

14ret[i]=str.substring(i*chars);)}returnret;)56.ᑏ`ᦪ2ᦪ1/0P1/⁚ᦪJK4Ḅ/0P⌕/0PEḄEᦻoṹ*᝞(`ᡃABOII,4)B]j1`ᡃABII,ᐭ(`ᡃABCDEFII,6)B]1`ᡃABCII`ᡃABC+ḄIIopublicStringsubstring(Stringstr,intsubBytes){intbytes=0;//ᵨᩭ/0EḄ/⁚ᦪfor(inti=0;i

1557.'*1)᝞,4Sᨴஹ5ᑖ¢22)᝞,4S£1970ᑮoᙠḄ¥¢ᦪ23)᝞,4S¦U§ᨴḄᨬi`ᜩ24)᝞,©ªᓄ21)¬java.util.Calendarny(Cal6ndar.get®nstance()),?ᵨᐸget()FG¯ᐭ°ḄᦪᓽRSᦪᡠVBḄ.᝞*calendar.get(Calendar.YEAR);//RS2)±.FGᙳRS]³¢ᦪ*Calendar.getlnstance().getTimeInMillis();System.currentTimeMillis();3)xyzṹ᝞{:Calendartime=Calendar.getInstance();time.set(Calendar.DAY_OF_MONTH,time.getActualMaximum(Calendar.DAY_OF_MONTH));4)ᑭᵨjava.text.DataFormatEḄformat()FG-©ªᓄ஺58.Javatµᡭᓺ᧤ᜩḄ§7¹஺publicclassYesterdayCurrent{publicstaticvoidmain(String[]args){Calendarcal=Calendar.getlnstance();cal.add(Calendar.DATE,-1);System.out.printIn(cal.getTime());)}59.javajavasciprtḄº»஺JavaScriptNJava8¼½¾¿Ḅ°Ḅ8ÀÁ஺JavaSUN¼½ÂḄÃ`z☢ᔣVaḄµÆÇÈÉÊᱯ»〉ᔠX®nternetBᵨµÆ¾¿JavaScriptNetscape¼½ḄÀÎᐸÏḄ1Ð᡽ÒNetscapeNavigator

16Ó¾¿Ḅ•ÕÖᐭWeb⚓☢EḄLXVaÛÜÝÞḄßàឋÉÊâḄ7ãLiveScript*JavaḄ7ãOakÉÊ஺{☢V8ÕÉÊ'Ḅð°m᝞{ñò*1)LXVa☢ᔣVa*Java`ÕôḄ☢ᔣVaḄÉÊᓽõ¾¿öᓫḄµÆøùÇÈVaJavaScriptÕúMÉÊâᵨᩭᑴmNüýþᐵḄᵨᡝᵨḄᩖ஺(ObjectBased)"#$%(EventDriver)Ḅ,-./஺0123456789:Ḅᑁ<5=>?ᕒAᵨB2)DE",FGJavaḄIJṹᙠ᡻NOPQRST,FBJavaScriptDEឋ,-./ᐸIJṹY◤ST,Fᵫ\]ᘤDE᡻NB3)`abcd"abecdGJavafᵨ`abcdghᓽᡠᨵcdᙠ,FOPQRlmBJavaScriptncdlmfᵨᐸeab஺ᓽcdᙠAᵨPY◤lm1DEᘤᙠoNpghᐸᦪrabB4)JṹtuY᪵஺60.z{p᎛ᵨassert?assertion(/)ᙠn8ᵨḄu./nᢝᑴ஺ᩭassertionᵨ-ᨬ2ஹᐵḄឋ.assertiongh8ᙠ"p஺64ឋᙠassertiongh8ᐵ¡Ḅ஺ᙠ¢£n/¤ᒹ¦§⊤©uḄ.ªᙠ᡻N¤.ªpᎷ¬⊤©utrueB᝞°⊤©u>±false,µ{¶·¸¹º¤Assertionerroro/ᵨ¼ḄGassert(a>0);//throwsanAssertionerrorifa<=0/ÄÅᨵÆÇuGassertExpression1;

17assertExpressionl:Expression2;ExpressionlÊËÌͤ§Î஺Expression2ÄÅÏФÎḄÑÒ⊤©uB¤ÎᵨÍᡂÔÕÖ×ØḄStringÙØ஺/ᙠÚÛÜÝÞἭᵨḄ⌕ᙠ,Fpᵨ/◤Aᵨsource1.4᪗âGjavac-source1.4Test.java⌕ᙠoNpᵨ/ÄAᵨ-enableassertionsᡈὅ-ea᪗â஺⌕ᙠoNp⌱çἭᵨ/ÄAᵨ-daᡈὅ-disableassertions᪗â஺⌕ᙠ¶·anᵨ/ÄAᵨ-esaᡈὅ-dsa᪗â஺èÄÅᙠᒹḄẠêᵨᡈὅἭᵨ/஺ÄÅᙠ⚜>8ÜÝÞY¸ᑮ©ḄÑíîïêðï/஺/ÄÅᵨñò⌴ôõᨵöḄ÷ᦪ஺YT/YÊᵨñò⌴ôøᨵöḄ÷ᦪ0Yùᔲᵨ6/øᨵöQRghᐸ÷ᦪ஺YTûÄÅᙠøᨵönüÄÅᙠᓅøᨵönᑭᵨ/ïᩩ஺᜜ᦋḄ᝱஺61.errorexceptionᨵerror⊤ឮ!"#$%&Ḅ'()Ḅ•+,-.⚪஺0᝞2ᑁ456஺!"ᢣ8"ᜐᳮ;᪵Ḅ'(exception⊤=+>?ᡈAB.⚪஺CD2E⊤᝞FGHIJKLMNḄ'(62.ArrayListVectorḄP⌕KR☢ᩭ2.=•VWឋ:VectorZ[ᐰḄCD2VWḄ]ArrayListZ[ᐰḄVWḄᦪ_`abc◤⌕`aeVectorfg`ahiᩭ=j]ArrayListᓾiᩭḄ=l஺CollectionCollectionsḄ

18CollectionmᔠoḄpqrstuvwḄrsP⌕ᨵSetList.Collections┐ymᔠoḄ=z{|ow}~=ᑡ☟᝱AByᔜ+mᔠḄஹ᣸ஹZ[ᐰᓄ஺63.SetḄᐗ"-Ḅᵨᩭᑖ-vᔲᕖᵨ==equals()?EᨵSetḄᐗ"-Ḅᵨiterator()ᩭᑖ-vᔲ஺equals஺ᑨzSetᔲequals()==ᵨ¡ᔲᢣᔣV=y£equals()ᙠo¥¦⌚¨hḄczᑖ©Ḅy£Ḅᑁªo«¬Ḅ®¯°¡64.HashMapHashtableḄHashMapvHashTableP⌕K±☢ᩭ2஺,.ᔊ´iµbHashtable¶·▰¹ḄDictionaryoḄHashMapJava1.2ºḄMaprsḄ=zABR,VWឋbHashtableZ[ᐰḄCD2VWḄ]HashMapZ[ᐰḄVWḄ±.¡b»ᨵHashMap!¼½¾¿¡h=z⊤ḄᩩÁḄkeyᡈvalue஺65.26ArrayList,Vector,LinkedListḄ4Âឋ"ᱯឋArrayListVectorÄÅᵨᦪÆ4Âᦪ_ÇᦪÆᐗᦪᜧ·A▭4ÂḄᦪ_Ê`ËÌᐭᐗEÄᐕÏÐrᢥÒᐗ#Ìᐭᐗ⌕ÓÔᦪÆᐔÖ×ᑁ4ᡠᦪ_Ù]Ìᐭᦪ_᠒,Vectorᵫ·ÅᵨÜsynchronized(Z[ᐰ)ÝJឋ"pÞArrayList,]LinkedListÅᵨßᔣà⊤AB4ÂᢥÒᦪ_◤⌕ºHáᔣᡈâᔣãᔊ#Ìᐭᦪ_e»◤⌕äåæ⚗Ḅáâ⚗ᓽ!ᡠÌᐭéêÞÙ஺66.java¥ᨵë+o«ḄìJDKhí+o«Ḅì}~Ü=îï£o~tuð26wᑖñîo

19ò⁚ìòôì஺ò⁚ìtu·InputstreamOutputstream,òôìtu·InputStreamReaderOutputStreamWriteroᙠjava.ioᒹ¥ᨵÏöᐸwḄìP⌕hÜ}øឋ"ÅᵨÊ஺67.ᦻᑏḄ¶æoFileReaderoFilewriteroᑖtuûReaderoWritero஺FileReaderoᵨ·üᦻFileWriteroᵨ·¾ᦪ_ᑏᐭᦻ;ᔜoᙠÅᵨá.Äýþ⌕ÿᵨᐸ᪀⌼ḄᯠᵨḄreadOᡈwrite஺஺68.ᨵ!"ᨵᨵ#ᑖ%&'Thread()Runnable*+!"Ḅ☢ᨵ#ᑖ-I.synchronized,wait)notify஺69./012ᵨrun()3start஺/012ᵨstart஺4ᡠ6⊤Ḅ89ᜐᳮ<ᜐ=>?@A᝱CDᕡḼG>HᵫJVMJK᡻@஺CKMDᕡḼNOPᓽ?@஺run()>HRSTU⌨WḄ᪗Yᩭ[\12஺70.]12^ᐭ12Ḅ12synchronizedᐸGᔲ>^ᐭaḄᐸGMb12Ḅ12synchronizedcbᵫ12de஺71.ḄfgᭆiஹḄfgA᝱HkA᝱lmḄᐵoᢣᙠr᡻@stbu᡻@r6ṹḄ12᡻@ᓫxy2rz{ᨵ12|Nrg}஺JavatḄᨵ~A᝱ᑖ%?@ஹNஹᢞஹ஺72.sleep()wait()ᨵ%

20sleep(ThreadḄaᨚ[᡻@ᢣm᡻@☠ឋ¶ᦪ¸ᒹᢥ᯿¼r¤½ᑮ¾ᐸ|ᨵḼ¿³ḄÀ᜜ÂÃ஺UDP—4ᵨὅᦪ¸ᐗ¯°KMb¶ᦪ¸ᒹOÆᡂÈḄ〈¾|M¶ᦪ¸ᒹᑮ¾Ḅ¼rᐸ¬ÊJ¿Ë஺ᜧᦪᡃÎO4ᵨTCP,ᏔУO0ᵨUDP,᝞ÒÓÔÕᓽ4{Ö⍡ᜫ|ÙᐵÚ⌕஺74.javarᑡᓄ᝞ßjavarᑡᓄrᑡᓄN1ᵨᩭᜐᳮàḄ<ᑴᡠáà|NâḄᑁä^@àᓄ஺>HàᓄḄ^@åᑏçè|>âàᓄḄ¬=éêlm஺rᑡᓄëìíîᙠà^@åᑏçèᡠï¡Ḅe⚪஺rᑡᓄḄâ◤⌕ÆrᑡᓄḄ(Serializable*+ò*+óᨵ◤⌕ḄimplementsSerializablecëì᪗ôò>ÆrᑡᓄḄᯠ4ᵨ12Wà¢᝞FileOutputStreamᩭ᪀⌼12ObjectOutputStream¢à«*Ḽ4ᵨObjectOutputStreamḄwriteObjectObjectobj«N>HâõᦪëobjḄ'ᑏW¢ᓽ÷ᐸA᝱«⌕ឮḄøᑣᵨᐭà஺75.úûsynchronizedjava.util.concurrent.locks.LockḄü!ý⌕!þLockbÿᡂsynchronizedᡠḄᡠᨵ⌕LockᨵsynchronizedḄḄឋ஺synchronized┝!Lock"#⌕$%ᕒ'()*+,ᙠfinally./0஺

2176.abstractclassName{privateStringname;publicabstractbooleanisStupidName(Stringname){}}ᜧ345ᨵ6┯89┯,abstractmethod+,;ᑖ=>?*@AB=஺77.publicclassSomething{voiddoSomething(){privateStrings=M";intI=s.length஺;}}ᨵ┯ᔩ9┯஺FGHIJKL6MNO⛲Q(private,public,protected)஺finalS;ᵨᩭO⛲FGHI(final᝞abstractstrictfp,WXYMNO⛲QstrictfpZO⛲classmethod!Yvariable)஺78.abstractclassSomething{privateabstractStringdoSomething();}5\]^_┯ᔳ9┯஺abstractḄmethods;privateO⛲஺abstractḄmethodsaXbcdimplement()ᐹfg⁚Ḅi_S;ᵨprivatejabstractmethodk┝lᩭᕖ9(ᳮ,abstractmethodJofinal)»79.publicclassSomething{publicintaddOne(finalintx){return++x;}}5pqrs஺┯஺intxtO⛲ᡂfinal.uᕡḼxᙠaddOnemethod0tOᦋ஺80.publicclassSomething{publicstaticvoidmain(String[]args)(Othero=newOtherQ;newSomethingQ.addOne(o);)publicvoidaddOne(finalOthero){o.i++;}}classOther{publicinti;}y☢Ḅ{|}WXᐵfinalḄN⚪5ᨵ┯ᔩ9஺ᙠaddOnemethod0ᦪotO⛲ᡂfinal஺᝞ᙠaddOnemethod.ᡃ4OᦋoḄreference.(᝞o=newOther();)>

22_᝞y5⚪X┯Ḅ஺5OᦋḄX஺Ḅmembervairable(ᡂᕒHI)!஺Ḅreference)]ᨵᦋH஺81.classSomething{inti;publicvoiddoSomethingQ{System.out.printlnfi="+i);}}ᨵ^_┯ᕖ9ᩭ°ḄX"i=0"஺intiinstantvariable(HIᡈᡂᕒHI)0instantvariableᨵdefaultvalue஺intḄdefaultvalueX0஺82.classSomething{finalinti;publicvoiddoSomethingQ{System.out.println("i="+i);}}y☢"⚪Zᨵ"pᙢaX"pfinaL5⍝a┯ᔩ9┯஺finalintiXpfinalḄinstantvariable(HIᡈᡂᕒHI)஺finalḄinstantvariable]ᨵdefaultvalue.+,ᙠconstructor(᪀⌼ᘤ)>Jt¡"prḄ¢஺S;Oᦋ£“finalinti=0;"஺83.publicclassSomething{publicstaticvoidmain(String[]args){Somethings=newSomething();System.out.println(ns.doSomething()returns"+doSomethingQ);}publicStringdoSomethingQ{return"Dosomething}}y¥{¦§஺┯஺y¥ᙠmaincalldoSomething]ᨵ^_N⚪¨©ªpmethodsWᙠ"pclass஺«gmainXstaticḄ஺staticmethod¬callnon-staticmethodSoSᦋᡂ"System,out.println("s.doSomething()returns"+s.doSomething());**«ᳮstaticmethodMNnon-staticinstantvariable஺84.®ᜐSomethingdḄᦻ±²OtherThing.javaclassSomething{privatestaticvoidmain(String[]something_to_do){System.out.println("Dosomething.);}}5p\{rs஺c.ᩭ]ᨵ³´µJavaḄClass²¶+,ᐸᦻ±²|஺publicclassḄ²¶+,ᦻ±²|஺

2385.interfaceA{intx=0;}classB{intx=1;}classCextendsBimplementsA{publicvoidpX(){System.out.println(x);}publicstaticvoidmain(String[]args){newC().pX();}}┯8஺ᙠ¸¹º»¼┯8(┯8½¾ḄJVMᨵḄ¿ÀuÁaXÂrḄxÃᵨªpxWᓛÅ(aÆᙠºimportjava.utiljava.sqlªpᒹº¬ÈrDate"᪵)஺Ê᱄dḄHIS;ᵨsuper.xᩭr!ÌḄឋÍÎ◚Уpublicstaticfinal.ᡠ;S;ѵA.xᩭr஺

24@ÒÓḄ⚗ÕQ=¸=3LHibernateGᑖ86.ᙠᦪÖ×0ᩩ±ÙÚÛÜ{᠒Ḅº᎛᝞6ßᓄ91.áâã2.äå⊤çḄᐵὶ3.ßᓄsql,éIbsql{ê#ëᦪÖ⌕bsqlìᐰ⊤ÙÚîïðâñI,jᦪÖIᜧḄ⊤᣸ᙠJ☢4.óᓄÙÚ¶ô]ᵨḄ¶ô⌕õöÊ÷ø>ḄùᑴéI÷ISåIᦪÖ87.ᙠhibernate0ûü⊤ÙÚýp⊤0ᔜÿ᩵ᩭḄᨵ᝞!⚪#$ᫀᢥ᯿Object(ᦪ*+ᦪ*ᯠ-./0bean$ᫀ12⊤Ḅbeanᑏ᪀⌼7ᦪ8᝞⊤⌕:fieldl,field2;<=ᨵ᪀⌼7ᦪBean(typelfiledl,type2field2),ᯠ-ᙠhqlA☢CDEFGᡂbeanI஺ᐹL=ᵨNOPᐵᦻ᫏ᡃḄUVWX஺88.session.Ioad()fllsession.get()ḄYZSession,load/get$[ᙳCD᪷*ᢣ_Ḅ`idaᦪ*bc+defgḄh஺ᐸYZᙠjk᝞lmnopᔠᩩsḄdeget$[fgnull»tload$[uvObjectNotFoundException©Load$[CfgḄwᳮytget$[z{EFfg஺load$[CDᐙᑖᑭᵨᑁ`1Ḅoᨵᦪ*tget$[ᑣᙠᑁᦪ*:᝞ᨵnoᦪ*1EFᵨSQLᡂᦪ*c+஺SessionᙠhḄk✌ᐜHibernateᢝI;஺ᵫSessionyᐸᢝISession

25ᡠᨵᐵὶḄᦪ*•¡¢ᑁ஺ᔣ1ᑣᙠjSessionFactory°±ᵫᡠᨵᵫ²SessionFactory᪀⌼ḄSessionyᐳ´஺jឋmὃ⇋¸¹º»Ḅᦪ*b¼!Sessionᙠᵨᦪ*b:½m¾uᐜᙠ:஺✌ᐜᙠ•¿À`id:᝞Â:ÃÄᦪ*Å᝱ᔠ[ᑣÇFfg஺-SessionuᙠNonExistsIIde᝞NonExistsIIdeᙠÌ᪵Ḅ:ᩩsᑣfgnullo-NonExistsIIdeISessionyᙠᡠᨵ:ÑÒlm:ᑮᨵᦔᦪ*Ḅ:ᩩsÕPj,:Ö×ᓫᑡ⊤Ú஺᝞Ûᩭ᝞Session•ºᦔḄ:ᩩsÜÝoᓽCßàÒᑨâatãäᨬæḄឋm⊤o஺jload$[tç᝞ᑁlnoᨵᦔᦪ*ᑣ:1᝞1Ãᑣfg஺᝞ᙠlnoᨵᦔᦪ*ᑣnèᦪ*b:ÑÒÕSelectSQLÚ,᝞:lnode,ᑣÛ±:iëḄìíᙠNonExistsIDde,fgnullo᪷*᧜ïðñ`SelectSQLäᑮḄResultset,óôḄᦪ*h஺ᐸᦪ*hõᐭSession÷ᳮøᘤÕÚ஺᡻Interceptor.onLoad$[Õ᝞ᨵḄInterceptorÚ஺ᦪ*hõᐭ1஺᝞ᦪ*hoILifeCycleF(ᑣᵨᦪ*hḄonLoad$[஺89.HibernateḄÿᡂᑴ1assignedᵫ᜜ᡂ◤Hibernate஺2hilo%&hi/lo()*+Ḅᡂᑴ◤⌕.᜜Ḅᦪ01⊤34ᡂᔊ67᝱஺3seqhilohilo;<%&hi/lo()*+Ḅᡂᑴ=>ᔊ67᝱34ᙠSequenceC〉ᵨFGᢝSequenceḄᦪ01᝞Oracle஺

264)incrementᢥᦪLM⌴O஺PQRḄ*+ᑴSᙠTUVᵨ*WCXᢝY•[\]^34ḼTUḄᨬᜧL,cdef◤⌕ᡂḄg᎛iPLj1kS஺lmQRnopḄq⚪>s᝞tTUᨵv[*WwqxY[ᦪ01yzᵫFᔜ[*Wᔜ|X}7᝱~x*Wnoᡂx᪵Ḅ⌼ᡂ஺P᝞txYᦪ01ᨵv[*WwqPQRᵨ஺5)identityᵨᦪ01Ḅᡂᑴ஺᝞DB2ஹSQLServer,MySQLCḄᡂᑴ஺6)sequenceᵨᦪ01Ḅsequenceᑴᡂ஺᝞OralceCḄSequence67)nativeᵫHibernate᪷0ᦪ01|ᑨᵨidentityஹhiloஹsequenceᐸCYmkSᡂQR஺8)uuid.hexᵫHibernateF128YLp()ᡂ16ᑴᦪL(ṹd^32Ḅ¡¢£⊤¤)kS஺9)uuid.stringuuid.hex;<=>ᡂḄ¦ṹ(16)஺ᙠ§¨ᦪ01Cno©+q⚪(᝞PostgreSQL)஺10)foreignᵨ᜜⊤Ḅ¡ªkS஺•«¬ᑭᵨuuid.hexQRᡂiᨬ®Ḅឋo°ᦪ01±²〉Vឋ஺l10Cᡂ0ID᪗´¢ḄQ)incrementµ¶ᵨ·᪗´¢ᡂḄᩗ¹º»Hibernateᜐᳮ.¿>Txgv[HibernateVᵨÀkx•[ᦪ01ÁÂxYÃ⊤Ḅg᎛.ÄÅ₞ᵨidentityÇÈᦪ01*+¿>ᦪ01Gᢝ|ÉOTᯠ┐Ì~xḄᦪ01⌱Î~xḄQ).᝞tÏ~oÐÑÏᵨḄᦪ01ᐹÓGᢝÔzḄÕÖ×,n^⌱ÎᵨnativeØHibernateᩭÚ⌱Îidentity,sequence,

27hilo.Û᜜ᵫFᵨḄᦪ01᝞OracleஹDB2ஹSQLServerஹMySqlÜÝÞ᧕ᵨḄᡂᑴAuto-Increase¡ªᡈὅSequence஺ᡃãn^ᙠᦪ01Ḅᡂᑴäᵨgenerator-class=nativeḄ:ᡂ¹,R஺~&LæçèḄ>Y¨ᦪ01Ḅᡂᑴᙠᦔ᳛ä¦ᨬëᜧ]ìíinsertᦪ0gîoïðñ⊤còḄó┝஺ᦪ01Ḅᡂᑴõõ>%&ᙠY[ᑁ⊤C34TU7᝱÷᝞ÌF|Oø¬Pᑁ⊤CÄX}ḼTUḄᨬᜧL°⌴O]cdefùᐭᦪ0ïûül[ᨬᜧLᯠdjä⌴O]kSýþÿḄḄᨬᜧᑁ⊤᪵Insertᦪᑁ⊤ᑏ"#$%Ḅ&ᨵᦪḄ(┝*┝+ឋ-./0ᜧ12஺45+678Insert⌕:0;Ḅ<=>₞@ᵨuuid.hexB.ᡂDᑴ90.FGHIJᐵ<ᦪLMN+OLMPᨵQRᓛTᐵ

28A)noneB)saveC)deleteD)save-update93.aJQR\6SessionḄzcf(A,B,C,D,F)A)load0B)save()C)delete()D)update()E)open()F)close()94.HibernateᳮB⌕ᵨfᳮ1.7*᪆Tᦻ2.7*᪆᧜klSessionFactory3.ᡭSesssion4.klhiTransation5.ᢝ}ᓄ6.¡hi7.ᐵ¢Session8.ᐵ¢SesstionFactoryB⌕ᵨ1.+JDBC£¤ᦪḄ¥ṹ§/¨©ᜧᜧªᓄ/ᦪ£¤«¬ᳲḄq®ឋ¥ṹ஺2.Hibernatep¯6JDBCḄ°ᢝ}ᓄ᪾²p³´ḄORMµ¶஺·¸ᜧ¹ºḄªᓄDA஺«Ḅ»ṹ3.hibernate¼ᵨJava½Dᑴ¾tpZ⁚ṹÀÁ¹Âᩭµ¶ÄÅឋ஺4.hibernateḄឋÆÇÈ4BÉpÊrs᪾²஺᧜ḄᮣÌឋ¸Í⁐஺ÉÏᢝᔜÑᐵ<ᦪÒ+ᑮ+ḄᔜÑ®ᩖ

29ᐵ<஺95.Hibernatep᝞ÕÖ×({f1.Hibernate2Ö×({µ¶aµØ+ObᔠCollection2.Hibernate3Ù/\ឋḄÖ×({ÚÛHibernateᙠÝÞᦪḄ#᎛ᦪ7àᨵmᙠNᑁmÛ¹Âád+ᦪḄ#+OâmᙠNᑁm㵶J'Ö×({·⁚ḕ/åiᘤḄᑁm├Ò¾;/åiᘤḄឋ஺96.Hibernateè᪵µ¶WPḄᐵ97.bJHibernateḄõmDᑴ1.ᑁõmmᙠHibernateö÷Fsõm\6Vᵨhᱥsõm2.ùsõmaVᵨõmbᑖûüõmᩩᦪtþÿᦋஹᦪᜧᙠஹᦪ⚣᳛ஹᦪ⚣ᵨஹᐵᦪc!Ḅ#$98.HibernateḄ%&'SqlஹCriteria,objectcomptositionHql:1ஹ)ឋ%&2ஹ+ᦪ%&ஹ,-+ᦪ%&3ஹᐵὶ%&4ஹᑖ⚓%&

305ஹ12ᦪ99.᝞56ᓄHibernate?1.ᵨ8ᔣ:;ᐵὶ<=ᵨᓫᔣ:;2.ᮣ@ᵨᓫᔣ:;ᐵὶ3.=ᵨ:<ᵨ;:AB4.CD:E!<=ᵨFᔠ!5.:;FᔠᵨBag,;:;FᔠᵨSet6.HIJᵨK';᝱7.⊤NO⌕Q<⊤ᐵὶ=⌕᝿;<ᨵTU!ᥛῪ

31XY'ḄZ⚗\]^_`^42Strutsaᑖ100.Strutsbcdᑴfghi⌕ᵨStruts?bcdᑴZStrutsḄbcjkZᙠweblᵨmnopqrstuᓄActionServlet,ActionServletvstruts-config.xm1ᦻxyzACD{|<}~!ᑮᔜCD:EActionServletᦈᑮ•ᡝo<᡻᝞jk.-(1)_ᵨᡝᓛCḄActionMapping#<᝞=!ᙠ

32MVCé'ZweblᵨkêmnopqrsëtuᓄActionServleroᵨᡝ⊤ᓫo<CDìḄActionForm:Eí1J<ëîᐭ⊤ᓫ¹lḄᦪ

33XY'ḄZ⚗\]^_`^53—Springaᑖ1O3.springbcdᑴúghi⌕ᵨf1.springmvcᡠᨵḄû·DispatcherServlet,~qüᡲlᵨḄᐸÿᙽḄᜐᳮ஺2.DispatcherServlet—ᡈHandlerMapping,UᜐᳮḄController.3.DispatcherServletᑮ᪗Controller4.Controller!"ᜐᳮ#$%&'•ModelAndView5.Dispathcher)…ᡈViewResolver+,-᪆ᘤ$ᑮModelAndView0ᢣ2Ḅ+,06.+,034&'56ᡝ8஺9:;ᵨ=AOP>?@AᕒCDEFG9ឋḄᐵJK$L9MᑗᐵJK$OPQRSᐭᑮUᵨVWXṹZ஺[ᵨAOP#$\ᐳ^(`᝞bcஹᢝfឋஹgh)jCDᑖ-ᡂm☢OUᵨᑮo0p$qrs%tuo0Ḅ0vḄwᩖឋ஺IOCᐕzEF{CD᪀⌼0ḄUᵨ~᛻$ᯠ#ᔣ0⌴QRḄ0஺᝞ᓫ᎔ᡠ⊤Ḅ$0CjᩭḄJNDIoᨵ[ᵨ{ᚮ0ᔆஹ^2ᘤஹᓫᐗ(singleton)᪀⌼(straightconstruction),•0ᵨᐸ0᪀⌼Ḅ஺ᵫ¢ᘤ£ᳮ0(collaborator)<.Springᓽ[•AOP᪾¦$§10C¢ᘤ஺Springᨬ©ḄᙢmQᨵ«¬®ᣚr0஺ᨵ°Spring,±⌕ᵨJavaBean³ឋ´µᦻ·uᐭ¸¹ឋ(0)஺ᯠ#CDº¢᧕ᙢᙠ◤⌕r®ᣚᐹᨵ¿ÀbḄ0஺104.HttpSessionsession=request.getSession()ÁHttpSessionsession=request.getSession(true)EJjiJ?getSession(true)ḄÂᦪÄv9==HttpSessionsession=request.getSession(Booleancreate)᝞ÅᨵÁÆÇḄrequestᐜᐵὶḄHttpSession,Ê;&'requestËᐵὶḄ

34HttpSession,᝞ÅÌᨵ$Ê;:᝞Åcreate==true,Ê;&'{ÎFḄHttpSession,᝞Åcreate==false,Ê;&'null.105.getParameterÁgetAttributeḄÏÐÑAttributeᢣ³ឋ஺ParameterᢣÒᦪ$ᵫURLᐭᡈᵫFORMḄᑁ¢106.DÕÖ{s×ØÙÚÑA.+=B.<<=C.«<=D.>>>=A.ºÛ×ØÙÚ8.<<=ÜÝ×ØC.sD.»>=ÞÝ×Ø$ÜßàáḄD0âᐙ107.DÕÖsCollectionḄäb?A.ListB.SetC.SortedSetD.MapÒὃçᫀ=D1O8.BufferedReaderḄ᱄¿DÕÖÑA.FilterReaderB.InputStreamReaderC.PipedReaderD.ReaderÒὃçᫀ=D109.ä¿Aêë᱄¿BAa=newA();ᑣ᱄¿B᪀⌼Âᦪஹ᱄¿B☟᝱Xṹᙽஹ᱄¿BG☟᝱Xṹᙽஹä¿A᪀⌼Âᦪஹä¿A☟᝱Xṹᙽஹä¿AG☟᝱Xṹᙽ᡻Ḅᐜ#ðWÑÒὃçᫀ=᱄¿B☟᝱Xṹᙽ->ä¿A☟᝱Xṹᙽ->᱄¿B᪀⌼Âᦪ->᱄¿BG☟᝱Xṹᙽ->ä¿A᪀⌼Âᦪ-ுä¿AG☟᝱Xṹᙽ

35110.divÁspanÏÐÑ{ᵨ¬html᪗ôᐗḄÛõ$spanᵨ¬ᦻöÛõ111.htmlḄ᪾¦:;Ñhtml᪾¦±ᨵframesetiframe÷᪗ôCDX⊤html᪾¦112.alertø᪵ᣚÑ\r

36113.:;úûᵨHTMLü·$:;úûᵨWEBü·$O`þ÷ὅ᝞Åᨵᦪýᑮserver8rᵨwebcontrol஺ᦔ᳛ᵨhtmlcontrolᙠ6ᡝ8᡻$jᵨhtmlcontrolo

37Ḅ⚗^4JavaScriptᑖ114.JavaScriptḄ.JavaScriptḄObject!ᦪ#Ḅkey-valueḄ$ᔠ&ᨵ()*+JavaḄᨵ"-.ᦪ#/Object0Ḅproperty.12345&JavaScript678ᵨ“new”9:constructorfunctionᩭ<=.᝞newDate(),newObject()?.varbook=newObject();book.name="JavaScriptisCooln;book.author="tom";book.pages=514;HashMap,ᡠ:☢BCḄnamepageDEbookḄḄproperty.ᡃGHIᵨdeleteᩭᑤ◀ObjectḄproperty:Mdeletebook.name;M.◀Object,Date?buildinḄ᜜&ᡃGHIᑏNOḄconstructorfunction,ᯠQRᵨnewDHI67NOḄ•.᝞:☢ḄbookHIᑏᡂfunctionBook(name,author,page){this.name=name;this.author=author;this.page=page;}varabook=newBook("JavaScriptisCool","tom”,514);115.functionḄᵨUᙠJavaScript&functionWᦪ#)X&ᡠᨵḄfunction/YbuildinḄFunctionobjectZ[Ḅ■.ᡠIᙠJavaScriptfunctionHI]^ᦪ_⌴&HI]ObjectḄproperty,aHIb]cᦪdef.functionᙠJavaScriptᨵgWᵨU&Wb]constructor,h☢9:newkeywordᵨᩭ67.,Wb]method,ᐸklᵨ.mnfunctionmethodᙠᦻ0Ḅnpqb&ᙠᨵ.rs0aHI1ᵨ.tᙠ

38JavaScript&uGvᨵᡠwḄ.functionxy8&zb]8{Uk|+8}&Dᡂ8-8Ḅmethod,qb+8WḄ|ឋ.aDmethodq}+,8zsḄ&functionᙠ.34ᡂ8Ḅmethod.functionBook(name,author,page){this.name=name;this.author=author;this.page=page;this.getReader=Book_getReader;}functionBook_getReader(){//....}:☢,ḄBCW&functionBook_getReader()DᡂBookḄ8EgetReaderḄmethod,call஺apply()FunctionobjectḄg8{U&uGaHIR,8function]•8Ḅmethodᩭlᵨᵨ.call()apply()/◤⌕^ᦪ&z8^ᦪDlᵨ&aDbfunctionᑁ=this}&thisᡠᢣḄ.call()apply()Ḅwᙠ+call()HI_⌴n^ᦪ&⌕8^ᦪ}lᵨ.zapplyg8^ᦪ&◤⌕◀lᵨ᜜Ḅᡠᨵ^ᦪᐭ-8ᦪ!.ᓽfunctiongetBooksWithSameAuthor(form,to){varname=this.author;varbooks=...//getbookswrittenbynameandfromyear"from"toyear"to"returnbooks;}varabook=newBook("JavaScriptisCool","tom"&514);varbooks=getBooksWithSameAuthor.call(abook,1990,2005);ᡈ

39varbooks=getBooksWithSameAuthor.apply(abook,[1990,2005]);b8function],8Ḅmethod}&JavaScriptu|+8GlobleObjectḄmethod,-8GlobleObjectᙠBrowserDwindow).ᡠIY-8ᩭ&functionmethodHIᩭ.Functionobjectvᨵ82⌕Ḅproperty:prototype.u8predefinedḄprototypeobject.b8Functionᵨ]Ḅconstructor0'1'protptypepropertyᢵ]ᵨ&ᦻ¢£¤¥X.JavaScriptḄ¦ZD1§functionḄ¥Xᩭ67Ḅ.¨}ᡃGvH.Iᑭᵨprototypeᩭª᝱Ḅᔣ9|ឋ&᝞functionBook(name,author,page){this.name=name;this.author=author;this.page=page;varabook=newBook("JavaScriptisCool",Mtomn,514);Book.prototype.getInfo=getlnfo;functiongetlnfo(){returnthis.name+“writtenby"+this.author+“with"+this.page+"pages";}alert(abook.getlnfo());-0ᨵ8BC&ᵨprototype{Uᩭ<=callback:Function.prototype.andThen=function(g){varf=this;returnfunction(){f();g();});

40functionManager(){this.callback=function(){};//donothingthis.registerCallback=function(callbackFunction){this.callback=(this.callback).andThen(callbackFunction);}}varmanager=newManager();manager.registercallback(sayHi);manager.registercallback(sayBye);manager.callback();116.Ḅ®¯JavaScriptᨵ°W{±²®¯.1.ᑭᵨfunction:functionsuperclass()(this.bye=superBye;this.hello=superHello;}functionsubClass(){this.inheritFrom=superclass;this.inheritFrom();this.bye=subBye;|ᡈὅfunctionsubClass()(superclass.call(this);)

41ᐜµ¶subClassḄinheritFrom{U&·lᵨ-8{U({UE¸¹⌕),ᡈὅºRᵨFunctionObjectḄcall{Uthis»^ᦪ&/HI±²<=YsuperC¼assḄ®¯.mnlᵨsuperclass}Ḅthisᢣᔣ.-8{UDᙠ᡻¾subClassḄcunstructsorfunctionᐜ᡻¾supperClassḄcunstructorfunction.-8{UḄ¿(ᙠ+C)ÀÀᙠNOḄ᪀⌼cᦪ&this]^ᦪlᵨ᱄)Ḅ᪀⌼cᦪ&᪀⌼cᦪÄÅ᱄)ḄᡠᨵÆÄÅC).ᡠI&Ç᱄)ᙠ᪀⌼cᦪÈ᜜(1§prototype)µ¶ḄÆ&C)/ÉU®¯.zÊC)Ḅ᪀⌼cᦪ•µ⌕ᙠµ¶NOḄÆÈhlᵨ᱄)Ḅ᪀⌼cᦪ&ËÌC)Ḅµ¶Í᱄)⌚Ï.Rᵨ-W{UC)aÐÑ⌕Rᵨprototypeᩭµ¶C)ḄÆ&ÒprototypeḄµ¶ᙠC)newḄÈQD᡻¾&ᡠIuµᙠlᵨ᱄)᪀⌼cᦪh&¨᪵ᨵÍ᱄)Ḅµ¶⌚ÏḄᓻ◅.2.ᑭᵨprototype:functionsuperclass(){this.bye=superBye;this.hello=superHello;}functionsubClass(){this.bye=subBye;}subClass.prototype=newsuperClass();subClass.prototype.constructor=superclass;-0•8superclassḄ

42ᵫ+C)ḄpeototypeÞß᱄)Ḅ

43}}this.sayBye=subBye;}ᡠᨵḄ᱄)Æþÿ᱄instanced.117.thisḄᵨ,this⊤Ḅ!"☢$ᑮḄGlobleObject.&!Browser'᛻ḄwindowObject.)function*+,-.Ḅmethodthis⊤/0functionᡠ2Ḅobject.☢/3ṹᨵ6┯89:ᑮthisḄ;ᵨ

44if(!(thisinstanceofEmployee))returnnewEmployee(a);this.name=a;}/᪵ᡃBᓽ;;ᵨoᩭḄq&FG┯D.118.ArrayinJavaScriptArraysObjectwxy!᪵Ḅz!Array◤⌕ᵫindexᩭᐸ@Ḅ2ឋ.index+>=0Ḅ᦮ᦪ.ArrayᨵijbuildinḄq<1.jion()Parray@ḄᡠᨵelementstringḄᙠ<123vara=[1,2,3];s=a.join();//s=="1,2,3”s=a.join(**:n);//s==111:2:3"2.reverse()PArrayḄelementᦪ᎔vara=[1,2,3];a.reverse();s=a.join();//s=="3,2,1”3.sort()᣸ᢥ¢£᣸casesensitive,¤¥¦᣸q.vara=[111,4,33,2];a.sort();//a==[111,2,33,4]a.sort(function(a,b){//a==[2,4,33,111]returna-b;//Returns<00,or>0z!)

454.concat()®¯0Arrayvara=[1,2,3];a.concat(4,5);//return[1,2,3,4,5]a.concat([4,5]);//return[1,2,3,4,5]a.concat([4,5],[6,7])//return[1,2,3,4,5,6,7]a.concat(4,[5,[6,7]})//return[1,2,3,4,5,6,7]5.slice()ArrayḄᑗᱏoArray².vara=[1,2,3,4,5];a.slice(0,3);//Returns[1,2,3)a.slice(3);//Returns[4,5]a.slice(1,-1);//Returns[2,3,4],-1meansthelastindexofthearraya.slice(-3,-2);//Returns[3],fromthethirdlastindextothesecondlastindex6.spliceᔣ0Array@´µᡈᑤ◀element.¹0ºᦪ⊤»¼½¹¾0ºᦪ⊤»ᑤ◀¿ÀÁ☢ÂÿḄºᦪ⊤»ᙠ1ᑤ◀¼½´ÄÅḄelements.vara=[1,2,3,4,5,6,7,8);a.splice(4);//Returns[5,6,7,8];ais[1,2,3,4]a.splice(1,2);//Returns[2,3];ais[1,4]a.splice(1,1);//Returns[4];ais[1]vara=[1,2,3,4,5];a.splice(2,0,1a1,'b');//Returns[];ais[1,2,'a','b',3,4,5Ja.splice(22,[1,2],3);//Returns['a','b']ais[1,2,[1,2],3,3,4,5]/7.push()andpop()ᔣArrayÆÇ´µᡈᑤ◀element8.unshift()andshift()ᔣArrayḄÈᜮ´µᡈᑤ◀eleme

469.ᵨjsÊËÌÍஹÏ᝱ÑÅஹÒÓÔÕஹÒ¢ÖÔÕ.10.ᵨjsÊ×ஹ¾Ø⚓☢ᑵÛஹÜÝ:Ê⚓☢Þß

47à6Ḅ<⚗âÖãsäã?5_Jspåᑖ119.jspᨵçèᑁ½-.?*ᵨᑖë!ìíîJSPᐳᨵ9ðñwᑁ½òÍóôASPḄ6ðᑁåòÍõ-Löᐭ@Aᦻ஺jsp:useBean9DEᡈὅH(ᓄ@AJavaBean0jsp:setProperty9JKJavaBeanḄMឋ஺jsp:getProperty9OAJavaBeanḄMឋ஺jsp:forward9PQᑮ@ASḄ⚓T஺jsp:plugin9᪷VWXᘤZ[\Java]^ᡂOBJECTᡈEMBED᪗a121.JSPb,᝱INCLUDE☟᝱INCLUDEḄe0.,᝱INCLUDEᵨjsp:include,-Hfij1klᡠnᦻbḄoᓄ,〉ᔠᵨsᒹn,᝱⚓☢$uvw5xyᦪ☟᝱INCLUDEᵨinclude{ṹHf$}~kᡠnᦻḄoᓄ$〉ᵨsᒹn☟᝱⚓☢<%0includefile="included.htm"%>

48122.7Qᑖ0123.ᨵ23e0.ᨵ7$ᑖ0\9ὅ⚓☢~QᔣincludeᡠᢣḄ⚓☢$1⚓Ḅ$⚓☢1ᩭḄ⚓1@஺᡻Iᩭ$sᦪᵨ஺uvw5xyᦪ.ὅᐰQᔣS⚓☢$~ᩭ஺sg஺to஺123.᝞᡻@AᐰḄJSP?◤¡¢᝞6ᢣ£<%@pageisThreadSafe=nfalse1,%>124.JSP᝞ᜐᳮHTMLFORMbḄᦪV.¥¦ᑁKḄrequest!§ᓽw$᝞F9<%Stringitem=request.getParameter("item");inthowMany=newInteger(request.getParameter("units1')).intValue();%>125.ᙠJSP᝞ᒹn@A☟᝱ᦻ.☟᝱ᒹn᝞69<%@includefile="copyright.html"%>z¬᝱ᒹn᝞69126.ᙠJSPb᝞ᵨ®¯.⌕ᨵ±b²91஺<%—@%>2o//3஺/****/4o

49127.ᙠJSPb᝞᡻WXµ}ᔣ.ᵨ᝞6ᓽw9response.sendRedirect(nhttp://ybwen.home.chinaren.com/index.htmlM);¶·ᱥᳮᙢᦋoHTTPHEADERMឋ$᝞69<%response.setStatus(HttpServletResponse.SC_MOVED_PERMANENTLY);StringnewLocn=n/newpath/index.html";response.setHeader("Location",newLocn);%>128.᝞■¼ᙠJSPᡈSERVLETbḄ~;BROWSER½¾ᙠCACHEb.P᝞6¿¢ᐭᑮJSPᦻḄÀÁᓽw9<%response.setHeader(nCache-Controln,nno-storen);//HTTP1.1response.setHeader("Pragma**,wno-cachen);//HTTP1.0response.setDateHeader("Expires",0);//preventscachingattheproxyserver%>129.ᙠJSPb᝞JKCOOKIE?COOKIE1-\HTTPHEADERḄ@ᑖ;Â〈Ḅ$᝞6²ᓽwJK9<%Cookiemycookie=newCookie("aName*'*'aValueM);zresponse.addCookie(mycookie);%>130.ᙠJSPb᝞ᑤ◀@ACOOKIE?<%CookiekillMyCookie=newCookie("mycookie",null);killMyCookie.setMaxAge(0);

50killMyCookie.setPath("/");response.addCookie(killMyCookie);%>131.ᙠ@AJSPḄᜐᳮb᝞żJSPḄ᡻᝞6(9<%if(request.getParameter("vzenn)!=null){//dosomething}else{return;}%>132.ᙠJSPb᝞}ƲÇw5}Ʋ$È1Ç~·ÉÊËÌJSPḄᑁK!§$T1¥¦yᦪḄ²ᳮ஺᝞Í.:<%!publicStringhowBadFrom(HttpServletRequestreq){HttpSessionses=req.getSession();returnreq.getRemoteHost();}%><%out.print("ingeneral,laoleeisnotbaddie");%><%=howBadFrom(request)%>᝞BROWSERÐᐵÑÒCOOKIES,ᙠJSPbᡃ᝞ᡭÀSESSIONᩭÕÖᵨURLµᑏᓽw,᝞F:

51hellol.jsp<%@pagesession=ntruen%><%Integernum=newInteger(100);session.putValue("num",num);Stringurl=response.encodeURL(nhello2.jsp*');%>>hello2.jsphello2.jsp<%@pagesession=ntruen%><%Integeri=(Integer)session.getValue("num");out.printIn("Numvalueinsessionis"+i.intValue());%>133.ᙠJSPb·Â〈EMAILᔩw5ᵨSUNḄÙᵨᒹ9sun.net.smtpᒹ஺᝞6¿ᵨSmtpCLientZÂ〈EMAIL஺<%@pageimport=,,sun.net.smtp.SmtpClient,java.io.*n%><%Stringfrom="ybwen@sina.com*';Stringto="hewenjun@yeah.net,lei@who.com.cn";try{SmtpClientclient=newSmtpClient("mail.xxxxx.xxxM);client.from(from);client.to(to);Printstreammessage=client.startMessage();message.printIn("To:"+to);message.printIn("Subject:SendingemailfromJSP!");

52message.printIn("ThiswassentfromaJSPpage!n);message.printin();message.printIn("Cool!message.printin();message.printin("GoodBoy");message.printIn("Imingenius.com");message.printIn();client.closeServer();}catch(lOExceptione){System.out.printin("ERRORSENDINGEMAIL:n+e);)%>134.ᙠSERVLETbᡃ·ᵨ@AJSP┯#⚓ᔩᯠÛÌ⚪$᝞6ÝÒ᝞ᙠ@ASERVLETÞᑴàáᓫᐗᑁᵨ@AJSP┯#⚓☢஺protectedvoidsendErrorRedirect(HttpServletRequestrequest,HttpServletResponseresponse,StringerrorPageURL,Throwablee)throwsServletException,lOException{request.setAttribute(njavax.servlet.jsp.jspException*',e);getServletConfig().getServletContext().getRequestDispatcher(errorPageURL).forward(request,response);}publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse){try(//dosomething

53}catch(Exceptionex){try{sendErrorRedirect(request,response,"/jsp/MyErrorPage.jsp",ex);}catch(Exceptione){e.printStackTrace();}})135.APPLETäJSP᝞¥åw5ᵨURLConnection136.JSP᝞EJBSessionBean¥åÍ☢Ḅæṹç-ÒèéḄ<%@pageimport="javax.naming.*,javax.rmi.PortableRemoteObject,foo.AccountHome,foo.Account*'%><%!஻}Æ@A!SessionBeanHomeÊìH(Ḅᐰí>ᵨAccountHomeaccHome=null;publicvoidjsplnit()(//îïHomeÊìH(Initialcontextcntxt=newInitialcontext();Objectref=cntxt.lookup('•java:comp/env/ejb/AccountEJB");accHome=(AccountHome)PortableRemoteObject.narrow(ref,AccountHome.class);)%><%஻H(ᓄSessionBeanAccountacctaccHome.create();

54//ᵨð²acct.doWhatever//᝞ñòò%>137.ᡃᵨ@Aó<$᝞■¼ôç\”null”ḄôöᙠᡃḄHTMLᐭᦻöb.w5}Æ•AøᓫḄᦪᩭùᑮúḄ$᝞69<%!Stringblanknull(Strings)(return(s==null)?nn:s;}%>ᯠᙠJSPḄFORMb$w5û᪵ᵨ">138.᝞bSERVLETᡈJSP6ý@Aᦻ(᝞9binary,text,executable)?fÿᫀA:ᵨHTTP,BᙠServletContentTypeᵨjava.ioᒹḄStreamᑮ.᝞response.setContentType("application/x-msword");ᯠ!"#ᑏ%&''ᓽ஺139.ᵨuseBean᪗+,-ᓄBEAN/᝞012,-ᓄ3ᦪᵨ᝞5᪗6ᓽ140.ᵨJSP᝞0789ᡝ;<ᘤḄ>?@

55ᵨrequest.VgetHeader(String)141.ABCᵨDEF%᪵CᵨJSPᔩ@IᯠJ,ᵨ142.IᡃMNOᡃḄJSPᵨḄ%PQRJVMSTᵨᡃḄὁCLASS?VPWᨵYZᣚ஺143.<%@includefile="abc.jsp"%>-W\]Ḅ^_U?`,P☟᝱ᒹcd%Pe᝱ᒹc144.JSPḄfg@lohJAVAEFijCkWᨵl''2«VᜧnᦪḄservletopqrᢝconnectionpooling3஺ServletopWᨵ᪗t4oJSPuᐸwxyz{Ḅ|}145.JSPAij⌴Cᵨᔩ@IᯠJ᝞hformḄ|y⚓146.᝞0JSPḄ▭ᓄ@Pᔜ᱐yresourcebundlesឋᦻᓽ147.ᙠJSP᝞0ᑏᦻyᦻ@ᵨPrintwriterhB᝞<%@pageimport="java.io.**'%><%Stringstr="printmen;StringnameOfTextFile=n/usr/anil/imp.txt";try(

56Printwriterpw=newPrintwriter(newFileOutputStream(nameOfTextFile));pw.printin(str);pw.close();}catch(lOExceptione){out.printin(e.getMessage());}%>148.᝞0ᙠJSPᒹhᦻ@ᵨURLConnectionᓽ஺149.ᙠservletsJSP\]AᐳsessionhBᔩ@IᯠJHttpSessionsession=request.getSession(true);session.putValue("variable","value");150.᝞0cookieᙠ%/]@ᵨCookie.setMaxAge(int)151.᝞078I`Ḅsessionsᦪ@JᵨHttpSessionListenersᩭ152.A%&ṹᙠᡃᡠᨵḄJSPᦻ\j@᝞JAᐳᔩ@IᯠJJPḄJSPᦻ¡%¢£:/jsp/=ybwen.genius.myPreprocessingServlet,dJ/jsp/P`¦ḄᦻJᵨ(lightningᫀ??????)153.h%JSP⚓᝞n9ᡝ©ª/«¬wªAᔩ@IᯠA

57154.ᙠjsp:useBeanz®ᵨbeanNameᨵ0lᜐ@beanNameᵨBeans.instantiate(),-ᓄBean155.Iᡃᵨvjsplorward°/ᙠ;<ᘤḄᙢᙬ³Wᨵᦋµ@ᵨresponse.sendRedirect("newURL")156.᝞0¶ᣚJSP0.9᱐yḄᦻᑮJSP1.1?ᵨsed/awk.ᓽ157.ᵨJSP·1ᑮᦪ¸¹·1"#ºḄᨬl®¼QR@1.ᵨJDBC2஺0½ᨵ¾¿ÀḄDriver2.ᵨᨵ¾¿ÀḄApplicationserver3.ÁÂᑏ158.JSPServletᨵÃ&ĪgqªgÅÆ\]ḄὶȼQR@JSP¼ServletᢈÊḄ᡽ÌyͼServletḄÎ᧕ÐÑÒCÓᵨḄ᜜⊤⊤Ö஺JSPNO¼"servlet"oServletJSPᨬØ⌕ḄqªgᙠÚServletḄÓᵨÛܼᙠJavaᦻÝÞßàᐰâ⊤ãäḄHTMLåᑖçèᩭ஺dJSPḄéê¼JavaHTMLJëᔠᡂ%᡽Ì£P.jspḄᦻ஺JSPîMÚïðServletØ⌕ᵨÚñᑴÛÜ஺Ajaxóᑖ159.AJAXḄᐰô¼QR@õö%5AJAXAJAXḄᐰô¼AsynchronousJavaScriptAndXML.AJAX¼2005÷ᵫGoogleùúÞûjúᩭḄNE®AJAXq¼%üḄNEz{ý¼w¼%ᵨþᨵ᪗tḄüḄNEᢈÊ஺ᵨAJAXJÿᵨᡝ☢ḄWebᵨ஺AJAXᢈ

58JavascriptHTTPRequest.16O.Ajax$⌕ᒹ'()*ᢈ+Ajax(AsynchronousJavaScript+XML)Ḅ:;web᪗?(standards-basedpresentation)XHTML+CSSḄ⊤DEFᵨDOM(DocumentObjectModel)KLM᝱ODPQRSFᵨXMLXSLTKLᦪUQᣚPWᐵYZSFᵨXMLHttpRequestKL[\ᦪU]^ஹ`aEFᵨJavaScriptbᡠᨵḄefg:ᙠij°lᦻnoAjaxḄpqὅJes$eJamesGarrettḄuᦻ/uᦻ⚪x(Ajax:ANewApproachtoWebApplications)஺|}DHTMLᡈLAMP,AJAXᢣiᓫiḄᢈᨵᙢᑭᵨ(iᑡWᐵḄᢈ஺i*AJAXḄi/ᔠᡂII(derivative/composite)Ḅᢈᙠq,᝞iAFLAXII<>AJAXḄᵨFᵨᢝᢈḄwebᘤZ¡L¢£஺¤*ᘤx¥ᒹ¦SMozilla.FirefoxஹInternetExplorerஹOperaஹKonquerorPSafario«OperaᢝXSL¬®¯ᢝXSLT஺161.$⌕ḄAjax᪾±²ᨵ)*+*Dojo(dojotoolkit.org)E*PrototypeScriptaculous(www.prototypejs.orgscript.aculo.us)E*DirectWebReporting(getahead.org/dwr)E*Yahoo!UserInterfaceLibrary(developer.yahoo.com/yui)EGoogleWebToolkit(code.google.com/webtoolkit)஺

59¹¬ḄS⚗x»¼½¼86_JQuery¾ᑖ162.ÀÁiÂXMLHttpRequest®ÃÄXMLHttpRequest®WebÅÆÇᕒÉᙠ⚓☢ËÌÍKL⚓☢ḄξÏ஺AJAXÅÐÑLÐGoogleᙠ2005ÒFᵨḄIIGoogleSuggestIIo—GoogleSuggestIIÓFᵨXMLHttpRequest®ᩭÕM᝱ḄWebÖ×SØᵨᡝÅÐÙᐭgoogleḄÛa᪾JavascriptÆ〈ᵨᡝÙᐭḄÝ»ᑮßàᘤᯠÍßàᘤâãiäåᑡ⊤஺XMLHttpRequest®ᙠæE5.0+,Safari1.2,Mozilla1.0/Firefox,Opera8+NetScapt7ÅÐçᢝ஺163.AJAXᵨèéWebᵨᨵêëì+ᙠèéḄJavascript½íî᝞ïðñᑮßàᘤòᦪUóᡈᦻôḄõöᡈὅÆ〈÷ᡝòõöᑮßàᘤ◤⌕ùiäHTMLformᯠÍGETᡈὅPOSTᦪUᑮßàᘤò஺ᵨᡝ◤⌕úûIISubmitIIᢥýᩭÆ〈ᡈὅÖþᦪUõöᯠÍÿᘤ⚓☢஺ᘤḄ⚓☢ᡠḄwebᵨᨵ"#$᠒&'ᵨᡝ)*+,-஺.ᵨAJAXᢈ01".Javascript23XMLHttpRequest45678ᘤ9:)*஺23HTTPRequest,'web⚓☢";〈ᑮwebᘤ>'7?webᘤḄ@A(+ᵨ⚓&)DEFᵨᡝḄGH2•⚓&ᵨᡝJK⚓☢ᑵMN+ᑮᑮJavascriptOP9:Ḅ;〈Q7?஺164.᝞TᵨJQuery9:⊤ᓫWXY".ᵨjQueryḄZ[-jQuery-validate⊤ᓫWXZ[ᩭ9:⊤ᓫWX^_`$(II#formII).validate({஻WXbᑣrules:{

60author:{required:true,//r◤tuvwminlength:2//}~v⁚},email:required:true,email:true//vw[ᙢᙬ},url:{required:false,url:true//vwᙬ},content:{required:true,minlength:4}},஻┯Amessages:{author:{required:_ᵨᡝrᑏminlength:jQuery.formatII{0}v⁚||},email:{required:_rᑏὶ¡¢£email`_¤£+¥¦'},content:{required:_ᙬrᑏ*,

61minlength:jQuery.format(II{0}v⁚II)}},submitHandler:function(form){஻ajax¬)⊤ᓫ◤⌕jQuery.FormZ[$(form).ajaxSubmit({dataType:'jsonsuccess:function(res){if(res.success){$(*.ajaxsubmit*).html(';⊤ᡂ´µ*).addClass(*ok*);$('textarea').val(ll);$('#comments').prepend(res.msg);}else$('.ajaxsubmit').html(res.msg).addClass('fail');}!)¼returnfalse;},errorPlacement:function(error,element){஻¾¿┯¬EAḄElementerror.appendTo(element.parent().find('b*));},errorClass:*fail஻┯A᪵£highlight:function(element,errorClass){//ÂÃÄE┯vw◤⌕jQuery.HighlightZ[$(element).highlightFade({color:'yellowspeed:1000,iterator:'exponential'))}¼

62165.Prototype᝞TÇÈ⚓☢ÉÊËÌᑵY".ᵨPrototypeḄAjax.PeriodicalUpdaterᩭÇÈ⚓☢ḄÉÊᑵ஺Ï᝞᝞Ð⚓☢Ñ◤⌕ËÌᑵḄÊᑖ

Ö×"ᢥ᯿᝞Ú.ÛṹËÌᑵÝÊÞnewAjax.Periodicalupdater('refresh_/your_url(method:_get',insertion:Insertion.Top,frequency:1,decay:2})¼ᐸàḄáᦪfrequency⊤Eã◞Ḅåᦪæḕèéê2஺decay⊤E᝞ÐḄᑁìíî,ᑣïfrequencyḄã◞ÌãðÝñòH1å᝞ÐᑁìíîᑣóôåᯠOöåᯠO÷å.஺஺᝞ÐḄøÐ+᪵Ö×Ýáᦪ1+ùúᵨ166.Prototype᝞T•Ajaxû•áᦪYÛṹ᝞ê`newAjax.Request('/your_ur1',{method:_getparameters:{name:_rainman',limit:12)!)167.AjaxýᐳᨵÿCallback?AjaxᐳᨵCallbackonSuccessonFailureonUninitializedonLoading

63onLoadedonlnteractiveonCompleteonException168.Javascript᝞&'〈)*Ajax+,ṹ.newAjax.Request('/your_url'),(method:_get',onSuccess:function(transport)(varresponse=transport.responseTextII—noresponsetextII;alert(IISuccess!II);},onFailure:function()(alert('failure')}!)D169.AJAXEᨵFGᨵHIJH+1ஹᨬᜧḄ)HP⚓☢SᑵUVᵨᡝḄYZ[\]஺2ஹ`ᵨabcdefgᘤij:ᐹᨵlmnoḄpqrs஺3ஹuvwvx)GfgᘤyzḄ{|}~ᑮᡝVᑭᵨᡝḄrsᩭᜐᳮVfgᘤIḄyzV⁚Iᵨᡂᩈ஺fgᘤḄyzVajaxḄᑣP)ᢥ◤ᦪII,uvᨬᜧḄᑍVIpqfgᘤ⌼ᡂḄyz஺4ஹ£¤᪗¦ᓄḄ¨©ª«ᢝḄᢈ®V¯◤⌕±²³´ᡈὅ·¸஺ajaxḄJH1ஹajax¯«ᢝ¹ºᘤbackᢥ»஺2ஹ¼ᐰ¾⚪AJAXÂ☄ÄefgᘤÅÆḄÇ⁚஺3ஹÈÉÊËḄ«ᢝÌÍÎ஺

644ஹẚÐĸḄa\Ñᑴ஺5ஹ¯Ó᧕ÕÖ஺170.AjaxIjavascriptḄ×Ø+javascriptP)ᙠ¹ºᘤ᡻ÛḄÜÝÞßVAjaxP)àáÅÆdâ⚓qᵨḄã'ᢈ®VäPᑭᵨÄ)åᑡçᐵḄᢈ®ᐸêëᒹíjavascriptoJavascriptPᵫâïðñã'Ḅ)ÜÝÞßVäIsunðñḄjavaÞßPòᨵó&ᐵåḄVäôçõḄö÷øP)Û├úᶍ.ᙠ)üḄwebã'êVjavascriptPᙠ¹ºᘤ᡻ÛḄVᡃôuvᵨjavascriptþᑴ¹ºÿḄᑁ஺

65Ḅ⚗97Servletᑖ171.ServletḄᕜservletᨵḄḄ!ᒹ#$%&'ᓄஹ*+ᓄஹᜐᳮ./012345஺67ᵫjavax.servlet.Servlet9I:Ḅinit,servicedestroy;<⊤>஺Servlet?23ᘤ&'ᓄA!ᘤBᐸinit;EBᐸservice;

66)174.²³¥¦§TᵨdoGet()doPost()?Jsp⚓☢\Ḅform᪗·¸Ḅmethod¹ឋgetETᵨdoGet()»postETᵨdoPost()஺175.servletḄᕜwebᘤ$%servlet»ᕜ»+஺^_TᵨservletḄ;177.⚓☢ÃKÄÅ⌴Ḅ;஺JSPØAx"Úservlet"«ServletJSPᨬÜ⌕Ḅf¿ÉᙠY!ServletḄLᵨÝÞxᙠJavaᦻà\!cH.mᐰ⊤á\ḄHTML¸ᑖâ»ᩭ஺hJSPḄ¥¦xJavaHTMLb0äᔠᡂ7᡽Òæ.jspḄᦻà஺JSPçYèé!ServletÜ⌕ᵨYyᑴÝÞ179.êëgìíîᢈÐgìïᵨðServletsJSP⚓☢ñòpageᔲxô⊤J7⚓☢ÈᐵḄKĹឋ஺7⚓☢ᵫ7ØḄJavaservletÚ(b0ᨵ÷ÀḄincludeᢣù!úxûᨵincludeGï)⊤஺6ýᒹ#servletþᒹ#?ØᡂservletḄJSP⚓☢requestxxô⊤JWeb~ᡝÿḄᐵḄឋ஺⚓☢Web(ᵫforward

67ᢣinclude()Ḅᐵ*)session../⊤1ᵨ3Web6ᡝ8Ḅᵨᡝ9:ᐵḄឋ஺Web;<=>?@;6ᡝ8application../⊤1᦮WebEᵨFGᐵḄឋ஺HIJK.᦮WebEᵨFGᒹM⚓☢ஹ;<ḄᐰP)ᵨQ180.RequestḄR⌕TUsetAttribute(Stringname,Object)^_`abcnameḄrequestḄeᦪggetAttribute(Stringname)^hiᵫnameᢣjḄឋggetAttributeNames()^hIrequestᡠᨵឋḄaboᔠqr.stḄIugetCookies()^hi6ᡝxḄᡠᨵCookieqr.•CookieᦪgetCharacterEncoding()^hi|Ḅb}~ḘTgetContentLength()^hiḄBodyḄgetHeader(Stringname)^HTTPjḄᦻᜮgetHeaders(Stringname)^hḘIᢣjabḄrequestHeaderḄᡠᨵgqr.•stḄIugetHeaderNames()^hiᡠ=requestHeaderḄabqr.•stḄIugetlnputStreamO^hiḄᐭᵨ|ḄᦪgetMethodO^6xᔣᘤx〈ᦪḄTUgetParameter(Stringname)^6ᡝx〈ᘤxḄᨵnameᢣjḄeᦪggetParameterNamesO^6ᡝx〈ᘤxḄᡠᨵeᦪḄabqr.stḄIugetParameterValues(Stringname)^ᨵnameᢣjḄeᦪḄᡠᨵggetProtocolO^6ᡝxᔣᘤx〈ᦪᡠ¡Ḅa¢getQueryString()^¤¥b}¦getRequestURI():b}¦Ḅ6ᡝxᙢᙬgetRemoteAddr()^6ᡝxḄIPᙢᙬgetRemoteHost()^6ᡝxḄabgetSession([Booleancreate])^hiᐵSession

68getServerName()^ᘤḄabgetServletPathO^6ᡝxᡠḄ®¯ᦻḄ°±getServerPort()^ᘤḄx²³removeAttribute(Stringname)^ᑤ◀|Ḅ,ឋ181.ᡃ¸ᙠwebEᵨº»F|?@⍗ᑮ3¾~ṹḄb},᝞iso8859-1Á,᝞Â3¾~ṹḄb}¦ÃPublicStringtranslate(Stringstr){StringtempStr=n";try(tempStr=newString(str.getBytes("ISO-8859-1"),MGBKH);tempStr=tempStr.trim();}catch(Exceptione){System.err.printin(e.getMessage());}returntempStr;}182.Servlet᡻ÅÆÇIÈÉÊTUÃpublicvoidinit(ServletConfigconfig)publicServletConfiggetServletConfig()publicStringgetServletlnfo()publicvoidservice(ServletRequestrequest,ServletResponseresponse)publicvoiddestroy()183.getServletContext()?HgetServletConfig஺ḄËÌgetServletConfig()ᙠservletÍÎᓄÆÐᘤ⌴ÒᩭServletConfigÔÕÖ:ᙠservletIu

69|×ᐕÙÚÛÜ⚗ᑁÐ^ÍÎᓄeᦪServletcontextßὅá@ᵫÐᘤᙠᦻ|ᢣjᐕÙᙠâÅÆᔣsevrlet⌴ᨵᐵãä᝞ågetServletConfig().getænitParameter("debug")çὅcservletèéᨵᐵÐᘤḄ஺êTU=ëservletᙠìÂÆ᎛×î`஺getServletContext()servlet=ïᵨgetServletContext()TUᑮwebEᵨḄservletcontextᓽñïᵨgetServletContextḄòTUᩭògä᝞ågetServletContext().getReaæPath("/")ᩭ*óô°±getServletContext().getResource(MWEB-INF/config.xml'1)xmlᦻḄᑁÐ184.HashtableHashMapHashtableõö÷DictionaryøñHashMap.Javal.2ùÒḄMapinterfaceḄIÈHashMapᐕÙúnull)centryḄkeyᡈὅvalue,ñHashtableüᐕÙýᨵþ.HashMapÿHashtableḄcontainsᣵᦋᡂcontainsvaluecontainsKeyo|A|^Jcontains᧕஺ᨬᜧḄHashtableḄSynchronizeḄHashMapᙠHashtable!◤⌕$%&'Ḅ()*HashMap+,-&./0᜜*஺HashtableHashMap2ᵨḄhash/rehash45ᜧᭆ,᪵ᡠ:ឋ<=ᨵ?ᜧḄ@A஺185.JAVASERVLETAPIBforward()Credirect஺ḄDEFGὅIᘤBKᑴᩗḄNᔣᙠPᡝRSTᘤᙢᙬWB=XYZNᔣ[Ḅᙢᙬ\[ὅᑣ^ᐰḄ`NSTᘤa=bᑮ`NḄᙢᙬdefg〈ijkl஺m᪵nSTᘤḄᙢᙬWBo:pᑮ`N[Ḅklᙢᙬ஺ᡠ:GὅqrsᦔᙠGὅo:uv◤⌕!wxyᵨforward஺dzm᪵{ᨵ|}◚(▭Ḅkl஺ᙠᨵ.᝞◤⌕

70`Nᑮ•ᐸ'ᘤḄᑣ,-yᵨsendRedirect()஺186.ᦪ⌴ᑮ[oᦋmḄឋdoᓄ[Ḅ¡¢m£ᑮ¤¥⌴¦ᵨ⌴F¥⌴஺Java§¨©ªᵫ¥⌴ᦪ஺(¬&ᦪ⌴ᑮB!ᦪḄ¥+Ḅᵨ஺Ḅᑁo:ᙠ¯ᵨḄBᦋ°Ḅᵨ±²=ᦋḄ஺187.CanaJavaThreadbestartedfromServletclass,andwhatwillbetheimplications?Ans:Yes,itispossibletowriteaThreadorstartaThreadfromServlet.InfactaServletcanbestartedonloadofthewebapplicationbydefining—load-on-startupIItagvalueas-1"inthe—web.xmlIIfile.Oneshouldnotstart/createathreadfromaServletthatistobeinvokedbybrowserorJavaclientapplication.ReasonisthatwebcontainerhasThreadsrunningtodelegateeveryclientrequesttoappropriateServletinstance.Ifservletinstancestartsathreadfromeveryrequest,thenitislikeeachthreadspanningmultiplethreads.AsHTTPisstatelessprotocol,andafterresponseissentbacktoclient,jobofservletisover,andwebcontainermanagesthelifecycleoftheservlets,butnotresponsibleforthelifecycleormanagementoftheThreadsthoseServletshavecreated.Ifneedistotosomekindofschedulingoperation,thenitisallowsadvisabletotryforsomegoodSchedulerframeworksavailable.Ifservletinstancestartsathreadfromeveryrequest,thenitislikeeachthreadspanningmultiplethreads.188.WhatisHTTPSessiontrackingandwhyisitimportant?

71Ans:HTTPSessiontrackingisthewayWebserverknowsthattherequestisnotafreshornewrequest,andhasasessionalreadycreatedinthewebcontext.Sowhenarequestreacheswebserver,itlooksforavariablecalledjsessionid,thatshouldbeassociatedwiththerequesteitherinformofcookies,orURLrewriting.IfyoursitevisitorhasblockedallcookiesthenredirecttoanotherJSPorServlet,willnotbeabletocarrythesamesession,andallthedata/objectreferencestoredinHttpSessionis/arelost.ButisthisredirectisdonebyusingencodeURLmethodofHttpServletResponseobject,thensessionidisattachedasapartofURLandwebserverattachesalreadycreatedsessiontothenewrequest.189.Whatissessionmanagement,andhowisitdifferentfromsessiontracking?Ans:HTTPsessionmanagementisrelatedtothemechanism,bywhichapplicationdataorclientstatecanbepassedfromonerequesttoanotherrequest(AsHTTPisstateless).SessionManagementisobviouslycomesaftersessiontracking,aswithoutsessiontracking,clientrequestcannotbehookedontooneandonlyonesession.Butifrequirementistojustpassreasonablysmalldata/variables,fromonerequesttoanother,thenitcanbedone,byHiddenformfield,andcanbetransportedfrombrowsertoserver,eitherbyPOSTorGETasmethodinHTMLFORMtag.190.CanIuseHiddenformfieldtotracksession?Ans:No,asHiddenformfieldsendsitsvalueasarequestparameter,whichisnotsameasURLrewriting(passingjsessionidaspartofURL).191.HowcanIpassmethodasrequestparametertobecalled,insteadof

72defaultdoGetordoPostmethodofHttpServletobject,onsubmitofanURL?Ans:ByoverridingservicemethodofHttpServletobject,andusingreflectiontoinvokethedesiredmethodoftheservletthatispassedasarequestparameter.ItissimilartothedispatchermechanismimplementedinStrutsframeworkfordynamicdispatchingofaction.192.InaarchitecturepatternlikeMVC,itismandatorythatServletshouldbethecontroller,whynotJSP?Ans:AsJSPcannotbeconfiguredasadefaultmappingtobecalledbasedonaURLpatterninweb.xmlfile.Inthatcase,notallrequestgoesthroughaJSPcontroller,andtheverypurposeofcontrollerisnotachieved.AsServletcanbemappedtoaparticularURLinweb.xmllike,(servlet-mappingுSampleController/*193.WhyJSPisusedasViewpartofMVC?Ans:AsJSPiseasilyconfigurableatruntimeandbyusingTaglibrary,XSL,andmanymorescriptinglanguage,productivityincreasesbyusingJSPinsteadofServlet.194.Canadatabaseconnectionpoolbeinstantiatedininitmethodofservletinsteadofserverconnectionpool?Whatwillbetheproblem?Ans:

73ItistruethatconnectionpoolcanbeinstantiatedininitmethodofServletandisavailableforthev/ebapplicationtouse,butgenerallytherecanbemanywebapplicationrequiredtousedatabaseconnectionpool,andmultiplewebapplicationsdonothaveaccessbeyondServletContext.Soitisdesirabletohaveexternalresourcesdefinedatserverlevel,notatanapplicationlevel.Ifyoufeelanyofthequestionand/oranswerisnotcorrectorincomplete,pleasewritetous,yoursuggestionsandafterthoroughreview,itwillbeplacedonthispage.Addyoursuggestionsatbelow.

74³´µḄ¶⚗¸¹º§ºḄ{»ᔠ½ᑖ195.Class.forNameḄᵨF&¿¢⌕ᵨF¯ᵨ:À¹ÁᢣÃÄÅḄÄḄ஺196.Jdo¿¢?JDOJavaᢝÈᓄḄfḄÉ&javadataobjectḄËÌ{ᵨ}ÍÎÏÐᦪÑÒÓBḄḄ᪗ÕᓄAPIoJDO/0Ö×ḄÍØÙÚgᕒᩭÝÍØᦪÑ^ᐰ◤⌕Þ᜜Ḅßṹ(᝞JDBCAPIḄyᵨ)஺mãᳲḄ¬åæçèNéᑮJDOêë/0ᖪíyÚgᕒῃZᩭnïB!ðñòᙠóôõ஺ö᜜JDO?ᮣøÙ&'o:ᙠùúᦪѤûüå஺JDBCª☢ᔣᐵÿᦪ(RDBMS)JD஺ᵨᑮᦪḄ᝞ᐵᦪஹᦻஹXMLᦪ(ODBMS)!!"#$ᵨ%&'ឋ)஺197.ᙠORACLEᜧᦪ./Ḅᑖ⚓2345஺67ᵨ᪘9ID45:ᨵ<=>ᝅ45஺6@ᑖ⚓45<%inti=l;intnumPages=14;Stringpages=request.getParameter("page11);intcurrentPage=1;currentPage=(pages==null)?(1):{Integer.parselnt(pages)}sql="selectcount(*)fromtables1';ResultSetrs=DBLink.executeQuery(sql);while(rs.next())i=rs.getlnt(1);intintPageCount=1;

75intPageCount=(i%numPages==O)?(i/numPages):(i/numPages+1);intnextPage;intupPage;nextPage=currentPage+1;if(nextPage>=intPageCount)nextPage=intPageCount;upPage=currentPage-1;if(upPage<=l)upPage=l;rs.close();sql=Hselect*fromtables',;rs=DBLink.executeQuery(sql);i=0;while((i஻BCᑁE஻BCF⚓GHM-Qif:<%=currentPage%>/<%=intPageCount%>I6⚓">_E-⚓<%for(intj=l;j<=intPageCount;j++){if(currentPage!=j){%>">[<%=j%>]<%}else{out.printin(j);}}%>

76">J-⚓href="List.jsp?page=<%=intPageCount%>">^L⚓198.xmlᨵMN2᪆ᢈQRST

77privateStringinFile="c:\people.xml”×privateStringoutFile="c:\people.xml";publicstaticvoidmain(Stringargs[])(newDOMTest();}publicDOMTest(){try(javax.xml.parsers.DocumentBuilderbuilder=javax.xml.parsers.DocumentBuiIderFactory.newlnstance().newDocumentBuiIder0×org.w3c.dom.Documentdoc=builder.newDocument();org.w3c.dom.Elementroot=doc.createElementὁÙ")×org.w3c.dom.Elementwang=doc.createElement;org.w3c.dom.Elementliu=doc.createElement;wang.appendChild(doc.createTextNode("ᡃ<ÜὁÙ”));root.appendChiId(wang);doc.appendChild(root);javax.xml.transform.Transformertransformer=javax.xml.transform.TransformerFactory.newlnstance().newTransformer();transformer.setOutputProperty(javax.xml.transform.OutputKeys.ENCODING,"gb2312M);transformer.setOutputProperty(javax.xml.transform.OutputKeys.INDENT,"yes1');transformer.transform(newjavax.xml.transform.dom.DOMSource(doc),newjavax.xml.transform.stream.StreamResult(outFile));

78}catch(Exceptione)(System.out.printin(e.getMessage());}}}201.ÖßᵨJAVA2᪆XMLḄ4.ᵨSAX42᪆XML,XMLᦻ᝞/àÜáâ6258113ᵱ1955êëìí95ê¡ᐭîᓭᜧå¡ðSAXHandler.javaimportjava.io.importjava.util.Hashtable;importorg.xml.sax.*;publicclassSAXHandlerextendsHandlerBase(privateHashtabletable=newHashtable();privateStringcurrentElement=null;privateStringcurrentvalue=null;publicvoidsetTable(Hashtabletable)this.table=table;

79)publicHashtablegetTable()(returntable;}publicvoidstartElement(Stringtag,AttributeListattrs)throwsSAXException(currentElement=tag;}publicvoidcharacters(chart]ch,intstart,intlength)throwsSAXException(currentvalue=newString(ch,start,length);}publicvoidendElement(Stringname)throwsSAXException(if(currentElement.equals(name))table.put(currentElement,currentvalue);}}JSPᑁEñò¹ṹSaxXml.j$p:ீTITLEுᒈ᪆XMLᦻpeople.xml<%@pageerrorPage=**ErrPage.jspncontentType="text/html;charset=GB2312"%>

80<%@pageimport="java.io.*"%><%@pageimport=,*java.util.Hashtable"%><%@pageimport="org.v;3c.dom.*"%><%@pageimport="org.xml.sax.*M%><%0pageimport="javax.xml.parsers.SAXParserFactoryn%><%@pageimport="javax.xml.parsers.SAXParser"%><%@pageimport=,,SAXHandlern%>Filefile=newFile(nc:\people.xml");FileReaderreader=newFileReader(file);Parserparser;SAXParserFactoryspf=SAXParserFactory.nevzlnstance();SAXParsersp=spf.newSAXParser();SAXHandlerhandler=newSAXHandler();sp.parse(newInputsource(reader),handler);HashtablehashTable=handler.getTable();out.printin("ᦟÙ®¯⊤");out.println("n+"n+(String)hashTable.get(newString(nnamen))+n");out.printin("^^n+"M+(String)hashTable.get(newString("college"))+Mn);out.printin("ltiS"+"n+(String)hashTable.get(newString("telephone"))+nH);out.printin("ᜓø"+wn+(String)hashTable.get(newString("notes"))+M");out.printin("n);%>

81202.EJB2.0ᨵâBNᑁERᑖTᵨᙠùJVúᔠREJB2.0ûEJB1.1ḄSTRüᑁEᒹþBeanὅ$ᵨßx°ὅEJBEᘤEJBᐹEJBὅᳮᕒ஺☢EJBᘤEJBᡠḄ᪶஺EJBᘤᳮḼEJBḄ!"ᥜ$%&'&(ᦪ*+Ḅ,-../⌕Ḅ᪶1஺JSP,servlet,EJB,JNDI,JDBC,JMS....203.EJB(JAVABEANḄ345JavaBean67ᵨḄ9:;JavaBean<=ᨵ?@ḄAᳮCDEFG•IJavaJK6LIBean஺MNOPQRLᵫTJavaBeanUᘤᡠ!"V᝞TomcatḄᡠJavaBeanXᐹᨵLIYZḄ᪀⌼ᘤ]᜜NOJavaBean_⌕`aSerializable-bᵨT`aBeanḄᢝdឋ஺JavaBean`▭DghTijCOMklmḄnᙢpqᑁCOM9:,tuUvpqwxḄ஺EnterpriseJavaBeanghTDCOM,ᓽᑖ{|9:஺t}TjavaḄ~qᵨVRM1ᢈḄᡠEJB6U~qwxVvpqஹv஺MEJBU{ᙠ᝞WebspereஹWebLogic᪵ḄᘤmEJBᡝu-wxḄEJB9:Nᐸᘤwx஺EJBᘤEJB9:ḄᳮEJB9:ᵫᘤᡠ!"ᳮ஺ᡝNᘤᩭwxḄEJB9:஺204.EJBḄ}ᩈ᪀LIEJBᒹIᑖ¡RemoteInterface-bḄṹpackageBeans;importjavax.ejb.EJBObject;

82importjava.rmi.RemoteException;publicinterfaceAddextendsEJBObject//somemethoddeclare}HomeInterface-bḄṹpackageBeans;importjava.rmi.RemoteException;importjaax.ejb.CreateException;importjavax.ejb.EJBHome;publicinterfaceAddHomeextendsEJBHome|//somemethoddeclare}EJBJḄṹpackageBeans;importjava.rmi.RemoteException;importjavax.ejb.SessionBean;importjavx.ejb.Sessioncontext;publicclassAddBeanImplementsSessionBean|//somemethoddeclare205.MVCḄᔜIᑖKᨵ¤¥ᢈᩭ`a5᝞G`a5MVCModel-View-ControllerḄ¦ᑏ஺"Modeln⊤ḄXᵨḄ©ª«VNJavaBean»EJB9:`a"ViewnXᵨḄ⊤¬☢VᵫJSP⚓☢®¯,"Controller,,XᵨḄᜐᳮq±ᑴVL³IServlet),N´µkl¶Xᵨª«ᜐᳮq·¬ª«ᑖᡂu¹Ḅ9:`a஺

83¥9:6pº»/ᵨ஺206.J2EE¼½5Je22Sun¾¿ÀḄÁÂ(multi-diered),ᑖ{|(distributed)}T9:(component-base)ḄéÄXᵨkl(enterprieseapplicationmodel).ᙠ᪵Ḅ,IXᵨm6ᢥ᯿ÉᑜᑖËu¹Ḅ9:¥9:Ì6ᙠu¹D<ÍᜐTgXḄÂÎ(tier)m஺ᡠÏÂÎᒹᡝÂ(clietntier)9:,webÂ9:BusinessÂ9:éÐÑ(EIS)Â஺207.WEBSERVICEÒÓÔÕ஺JSWDLÖ×ᒹḄØÙ஺JAXPஹJAXMḄÔÕ஺SOAPஹUDDLWSDLÔÕ஺WebServiceÚÛÜÝWSDLSOAPᓽ¦ᓫ;ßwxàá(SimpleObjectAccessProtocol),tᵨTºᣚXMLãṹÐÑḄäåÄàá஺UDDIḄæḄËᵯèᖪ"ê᪗ì¡UDDLᝅ}TWebḄஹᑖ{|ḄஹËWebServiceḄஹÐÑîïmḄ`a᪗ìA¹ðñᒹòL9óéôõöḄWebServiceîïó4Ḅé×aḄwxàáḄ`a᪗ì஺208.STRUTSḄXᵨ(᝞STRUTS᪀)StrutsøᵨJavaServlet/JavaServerPagesᢈÖ×WebXᵨqùḄÖúûṹḄframework஺øᵨStrutsÖ×À}TMVC(Mode-View-Controller)µk|ḄXᵨ᪀஺Strutsᨵ᝞RḄý⌕É¡L.ᒹòLIcontrollerservlet,ôᵨᡝḄþÿ〈ᑮḄAction஺.JSPᵫtagᙠcontrollerservletᐵὶᢝᕒ⊤ᓫ

84ᵨ஺%.'('*ᑡ,ᵨ-XMLᜐᳮஹ12Javaref3ectionAP3s4ᜐᳮJavaBeans5ឋஹ7▭ᓄḄ:;<=஺209.>ᵨᑮ'?@ABC?ᵨᙠEFGᔠIJKC>LM'•KᙠᡃPḄQ᛻STUVḄW⚪ᯠZLM'[W⚪Ḅ\]^ᫀḄ᪶a஺12bc^defgᦪiᙢkᵨ?@lᨵḄ\]^ᫀg◤ᙠopqḄ3r஺s⌕ᵨᑮ'MVCḄABC஺ᵨᩭJSP/ServletᡈὅJ2EEḄᐵᵨ஺xᓫ3ᔆCz஺210.UML^☢᪗}C~UML஺ᵨ☟᝱(ᒹஹ;ᒹ)(ᔠr),V211.᝞᪥ᦪIvarre=/Ad{l,8)$|.d{l,2}5/;varstr=document.forml.all(i).value;varr=str.match(re);if(r==null)(sign=-4;break;}else{document.forml.all(i).value=parseFloat(str);}212.CORBAEFIᵨ⌶EFICORBA᪗}ᐳᳮ᪀(CommonObjectRequestBrokerArchitecture)»

85ᵫᳮ(ObjectManagementGroup,ᑏOMG)᪗}ᓄ஺¡Ḅᡂ£¤¥¦~([DL),~¨¥(binding:©ªὶ«);ᐕᵨ®¯°rḄ±²஺ᐸ´Ḅ-ᵨSqḄ®AB~µᑏᙠSqḄ¶®·SqḄ°r*¸213.ᑏ(K^¹,Vº»Ḅ¼½᝞-¾ᐭabc,¾UcbapublicstaticStringreverse(Strings){intlength=s.length();StringBufferresult=newStringBuffer(length);for(inti=length-l;i>=0;i--)result.append(s.charAt(i));returnresult.toString();}214.ᦪÀÁ¯Ḅ½ᣚ᝞Ãᦪĺ½ᣚᦪ(Integer,Double)᝞Ãᦪ½ᣚº᝞ÅÆᦪÇÈÉÊËÌÍᐭ஺215.᝞ÎÏÐᨴÒÆÓᑖÕDatedat=newDate();dat.getYear();dat.getMonth();dat.getDay();dat.getHours216.᝞ÎÏÖ1970ÐᑮVᙠḄ×Õᦪlongnow=dat.getTime();217.᝞ØᓄÒÙDateFormatedf=DateFormate.getInstance();

86df.Format(dat);218.ᦻÛ;´Ü(I/O)°r᝞ᑡUÝK´ÜÞḄᡠᨵᦻÛ᝞ᑡUÝK´ÜÞḄᡠᨵà´ÜᑨT(KᦻÛᡈ´Üᔲãᙠ᝞äᑏᦻÛ

87åØḄ-⚗´ºç;«çÒèᔠgéᫀêᑖ219.JSPḄWEB.XMLëEFḄIWeb.xml(KJavaḄweb®Ḅs⌕ìíᦻÛ஺ìí®Ḅ(@îïð=;ᦻÛWEBñᘤᙠó4Ó⌕äÎᔜWEB⚗´õ.Ḅweb.xmlᦻÛö᝞÷ø2ùᘤz220.TomcatḄservlet.xmlëEFḄIServlet.Xmlñᘤó4Óú☢ìí'(ᳮ◤⌕÷øḄð=Servlet.Xmlservlet᧜üᦻÛñᘤó4Óú☢ìí'(@◤⌕÷øḄð=221.XML;HTMLýþ?Xml~ÿ<>Htmlᑏᱯxmlᱯᵨ[cdate]᝞ᵨtdd,ᑣxmlᢥ᯿ᩭᑏhtmlᢥ᯿ᐸᑣᩭᑏ஺Xml᡽!᪗#$%&ᐹᨵ)*ឋᡠᐹᨵ&-ḄDOM/0⌕2345ᑏ6ᐸ7ᔠW3cḄ᪗9$%ᑣ:7Ḅᱯ;<᝞=SOAPᦻ᫏HTMLᦻ᫏஺Xml:@ᑖᜧCᑏDḄhtml@ᑖ222.EEᦪGH᪀JḄKL⊤NKO⊤P▭RS:TUSVᦪGWXḄ⊤X☢ᨵZ[\⌕]T^U)*᪷GT`ᑮUb᪷GU`ᑮT223.ᢣeᐗgJḄinclude^hᐗiJḄincludeᨵjk@lNᢣeJḄincludeᙠn[a⚓ᐭᑮq)[b⚓ra⚓☢ḄᑁtᦋvḄw᎛yᐭzb⚓☢Ḅ{[⚓☢|h᝱Ḅ~ᦋv஺hᐗgJḄinclude,ra⚓ᐭᑮb⚓Ḅw᎛a⚓JḄᑁtᦋvwb⚓Ḅᑁtb|a⚓☢Ḅᦋvᦋv

88224.hᐗgJḄforword^response.sendRedirectḄ@lNForwardᙢ<:vrequestX☢ḄU:redirectᙢᙬᦋvrequestX☢ḄUᜫ225.ᙠMVC/JJSPnᦪGᑮServlet,Servlet᪵nBeanᐭᑮq)[JSP⚓☢஺Request.setAttributer;ḄᦪGᑮSESSIONvJᡈὅᐸ7ᔠJᯠrequest.getDispachreuset.response.forword⚓ᙢ1:";226.JSPnᦪGᑮServletw.Servlet┯᪵JSP⚓☢RḄὃᫀ=nᦪGᐭᑮcookiesJ227.¢᪵£)[¤Ḅ3¥¦§w¨©᠒ᙠ3¥«ᵨ¬ᑏ)[w¨ᦪ«ᵨ®ᡂ°ᑏ)[w¨ᦪ±~¬)[w¨228.Linux²ᐵḄ)´µ¶eVi·¸¹ºmore·»¼ºfind·»`ºgrep·½⍝ºcd·zᐭ¿)ÀÁºpwd·ÂÃr¬ÀÁºmkdi5ÄᦻÅᜳºrmdir·ᑤ◀ᦻÅᜳº1s·»¼rᯠÀÁÉᡠᨵᦻź229.ᨵ)[BEAN,◤⌕ᵨSenletnᐸË〈ᑮJSP⚓ᑏZÍ3¥Nrequestsession230.ᑏÂÃ/᝱ÎḄ3¥Nwindow.showmodalialog231.ᙠServletJ᝞ÏPÐÑwÒÓᦪGWNὃᫀ=ÔÕ)[Öפ0Ḅ¤PÐtaskmaskØᙠrun3¥JÒÓᦪGW஺ᯠ°ᑮ--ᢇÚÑwᘤtimeservletJ«ᵨ஺

89232.DB2JÜ⊤J⌱ÞᦪGḄSQL$ß஺Select*fromtableName233.᝞ÏPÐᙠàáᦪâãäåᐸæᳮᨵZÍ3è=3è)=éᵨᦪGWᙠᦪGWJéᵨ)[]countêërᵨᡝíÁwîÄsessionḄw᎛ncountïðᙠsessionJñnᐸ+1,ᐭᦪGW஺3èò:éᵨᦻÅᙠóJîÄ)[ᦻÅ,count.properties,éᵨjava.util.Properties,îÄsessionḄw᎛nᐸᑏᐭᦻÅ234.JSP⚓Jᨵõ´êëö÷äåᐸøù஺Application,ú¶ᕜüḼwebþᵨᙠᙠ#Á᦮ᵨḄᦪsession,ᨵsessionḄᦪ஺request,ᙠ⚓☢Ḅ᎛Ḅ!"#᝞•¶mtername,attribute.requestURI''response,ᕣ1ᵨᡝ*+Ḅ᎛,IḄᦪ-ᐸ/01ᵨᡝpage2345⚓☢Ḅᦪpagecontext,67&89Ḅ:;<=out,ᵨ>?@⚓☢A0exception,⚓☢@B┯DE@FGexception23FG!"pageConfig,236.ᨵUVᦪ⊤ᑖYZὁ\⊤]ὁ\^_ஹabஹcdeஹf⊤]f^_ஹfabஹᡂheஹὁ\fᐵj⊤]ὁ\^_ஹf^_ஹklemn@cdᙠ30opḄὁ\ᡠrfᙠ12opḄḄfᡂhsᙳᑖuA0v&ὁ\Ḅwx!"]ᑏ@SQLyze

90SELECTavg(t.s_score),11.Jname,11.Jage,12.JclassFROMstudentt,s_teachertl,s_relationt2WHEREt.s_id=t2.s_idandtl.t_id=t2.t_idandt.s_age>=12andtl.t_age>=30groupbyt2.t_class,t1.t_name,t1.t_age;237.{ᵨcomputeR|᩵n@ᢣᑡḄᦪ]ᨵᑡ◤⌕eὃᫀselectsumcolumn_namefromtablewherenamelike'compute'238.SocketḄB]ᑏBᑏṹe12ipᙢᙬ_3-;ZO¡'¢4ᑮᩭRᦈ,¥Ḅ<>¦§Ḅ5ᵨ,¥Ḅ¨ᡝHI©!6,¥'¢ª7.ᐵ«239.ᑏ@SQL¬ᩩᨬ89Ḅᦪ*+yz]DML஺Select*from⊤aInsertinto⊤avalues]'b¯17,b¯21......,;Update⊤aseta=/',b=z'whereid=ஹ'±Delete⊤awheretablelD=ஹ'240.²³´COMMIT*+ROLLBACK*+Ḅyµ஺ὃᫀCommit¶ᙠ·¸᡻Iº»R᡻I¼½Ḅ·¸஺¾Ḅ5¼¶¿ÀᙠÁÂ᡻I@┯ḄÃÄż½Ḅ஺᝞Æ@┯»஺Commit¼½஺Rollback¶ᙠÁÂ᡻IÇÈ@BḄ┯DᙠÁÂ᡻IḄ᎛@BFG»ÉÊ᡻IrollbackHI¥Ë஺

91241.᝞ÌÍV⊤ḄᜧÏ(ᎷÒ⊤ᨵ1Óᩩᦪ)ÕÖvV⊤×☢ᨵØb¯b¯ᓰØbÚ242.᝞ÌᙠÛÇÈ᡻I·ÜÕÝᑏÞ஺ὃBegintransßà·Ü஺ᯠRcommin¼½·Ü243.ᦟfᦪãᨵU89⊤f⊤S(S#,SNAME,AGE,SEX),ᐸäឋ⊤0fḄf_ஹæaஹcdឋY⌱è⊤SC(S#,C#,GRADE),ᐸäឋ⊤0fḄf_ஹᡠfèÈḄèÈ_ᡂh±èÈ⊤C(C#,CNAME,TEACHER),ᐸäឋ⊤0èÈ_ஹèÈaéêèᦟ\æa²ᑏ@Åᑡëᐭ*+ḄSQLyzíSC⊤îèÈḄsᙳᡂhëᐭᑮªïᙠḄ⊤SC_C(C#,CNAME,AVG_GRADE)ᐸAVG_GRADEZîèÈḄsᙳᡂh²ᑏ@Åᑡᑤ◀*+ḄSQLyzòSC⊤íWUὁ\Ḅ᝕f⌱èᐗõᑤö஺²ᵨSQLḄ÷øᩭ⊤ùÅᑡº᦮ឋûüý᝕þf⌱ÿLIUὁḄᡂᙠ70ᑖInsertintosc_c(c#,cname,avg__grade)(selectc#,(selecttl.cnamefromctlwheret.c#=tl.c#),avg(t.grade)fromsctgroupbyt.grade);Deletesctwheret.c#in(selecttl.c#fromctlwheretl.teacher=/wur)and11.s#In(selectt2.s#fromSt2wheret2.sex='᝕);Createassertioncheck_c#check(grade>70wheres#in(selects#fromSwheresex='᝕')andc#in(selectc#fromCwhereteacher=,liuz));244.ᡠ⍝ḄJOINḄᵨὃ⇋ᑮឋ#Ḅ$ᓄᨵ'()*+,-./leftjoin⊤on1-./rightjoin⊤onᑁ-./innerjoin⊤onSelect*fromainnerjoinbon...Select*froma,bwhere+a.dd=b.id

92$ᓄ)*/34ᜧ6ᦪ8Ḅhashjoin,96:;join<=>ᐭ@Ḅᦪ86AB⌕┐ESQLserver245.F៉ORMObject-RelationMappingᔩ+IᡠᳮKḄORM஺EMᐵO᧜QRSxmlᢈUᑭᵨWQXᑴḄZ[ᢈU246.\E][ᦪ8^ᨬF៉?ᵨᦪ8^a;b+cᓫefEᦪ8^ḄᳮKMySQLoracleEghijklmᳮnopḄqrstuᩭ247.EᐸxyF៉Ḅᖪ{ᦪ8^Ḅ|K}ᵨb▲.Oracle1b஺racleᦪ8^Z[ᖪ{Ḅᦪ8^nᜐᳮᜧ6ᦪ8nᵨSᜧ{yuḄᙢqoraclenPL/SQLᡂᜐᳮoracleḄᦪ8oracleḄᵨ஺=oracleḄ┝⊤Xᑴᨵ᎛ᵨᓱ¡Ḅ¢£u¤஺MySQLᦪ8^Z[¥Ḅᦪ8^x¦ᢝ¨©ªᑴn«¬ᐰ4¯ᵨcᓫ஺ᵨb▲1.5b248.᝞±²ᦪ8^A³´µᜓ·¸¹+A┐EopᨬF៉ḄµOracle/Impscott/tiger@orclfile=/D:\db.dmpzfull=yExpscott/tigerOorclfile=zD:\db.dmpr249.᝞±⍝Z=⊤ᡈ»¼Ḅ½᪀+DesctableName250.efINNERJOINḄ¿#pᙠ±[¢£ÀᵨINNERJOIN.InnerjoinÁÂᑁ-.ᵨSÃÄ<=⊤EḄ-.ᑡÆḄᦪ8251.᝞±Ç\ḄZ=OÈ#¦ᢝÉ᪀ᦪ8^.\AÊ(᪵ÌÍ+252.efZÀjavaioᒹḄ½᪀}ᜐᳮḄ¹ᳮXᑴ

93ÏÐᦪ8ÑஹÓᑡᓄᦻÕOÈÖ×OÈ>ᐭ>u஺InputstreamØ⊤tÙ⁚>ᐭÑḄᡠᨵØḄÛØÜØᨵFileInputStream,FilterInputStream,InputStream,ObjectInputStream,StringBufferlnputStream253.IefZÀjavaḄcollectionframeworkḄ½᪀}ᑖÝ᝞±ᵨCollectionÞ±EMßᐗáᔜoãäÏåᨵÆæḄᝅᵨèᑣsetlistᵫëìíîïᐗáadd(Objectc)ᑤ◀ᐗáremove(Objectobj)òóretainAôô(Collectionc)254.ᑏZ=Ó.ö÷console>ᐭn=ᦪÙ(ù=ᦪÙ“”◞ý)ᢥ᯿ᦪᜧᑮḄᡭᓺᑮconsole஺ᵨᦔ᳛Ḅ஺ᑈ᣸255.jvm!"classᦻ$Ḅ%ᳮ'ᑴ஺BootclassloadJvm)"classᦻ$ᑖ+,-.1ஹ◚1)".2ᙠ45Ḅ6278ᑮ6new91:ᡂ<=>?◚1@ᵨA)"ᘤ!"

94System.out.printin(cl);ClassLoaderc2=cl.getParent();System.out.printin(c2);}}256.K2LM2ḄNOPQK2RSᨵUQM2?QK2VWXYQ2?Q2ᵫUQ[\]ᡂ஺UQ[\^ᵫUQM2]ᡂ஺257.ᡂᕒ`Lᡂᕒaᦪb!staticḄcᵨP7ᵨᑮstaticᩭe⛲?ᐸcᵨ^ᵨᩭe⛲hQ^iY☟᝱஺lᵨme⛲ne⛲Ḅ,p\ᙠXbA7@ᵨ஺qr\ᙠᐸsA7@ᵨm258.᝞uᜐᳮwxyᩩ{|ᦪ}Pᵨ~ᡂḄ1ᩭᓄ?ᙠᦪ}7ᵨ62ᩭᜐᳮᦪ}259.SessionᨵᜧBUG,!SPS7ᨵK5ூRᦈ'ᑴ?>?sessionᜫ஺RSᵨsateserverᡈsqlserverᦪ}session260.᪀⌼ᘤConstructor^ᔲRoverride?rRS261.{}ᨵQreturn?¡¢£ᙠhQtry¤Ḅfinally஺ḄCoder᡻5,>᎛᡻5?ᙠretuanb§^¤P᡻5?return¨b262.\ᵨforeach©ᔊ«¬Ḅ<=◤⌕®¯°ᡈ±²

95ḄA³஺lEnumerable,GetEnumerator263.abstractḄmethod^ᔲR´>^static,^ᔲR´>^native,^ᔲR´>^synchronized?abstractr\ᵨstatic,r\ᵨnativeµr\ᵨsynchronized264.☢ᔣ<=¸Ḅᱯº?JavaI/O7n¼L⁚¼ḄNOP☢ᔣ<=¸^-¾¿ᱥÁᡂ^-<=?ᵨḄ>᎛RS¯ᵨᐸ7ḄÃឋ?ÃឋµRS^<=A³஺ÅuÆ᜜ÈɼḄᦪ}ÊF6<=ᩭË⌴஺⁚¼^ᨬÎÏḄ஺¼?sRS<ÐÑᦻ$9Òn³Ḅᦻ$K5Óc?Ô^n¼r\?n¼p\<n³ᦻ$Óc265.HashTableLHashMapḄNOPEJBḄ:Õᕜ×PServletḄ:Õᕜ×PHashTable^M2ØᐰḄ?HashMapr^?hashTable7ḄkeyÚr\+Û?Ô^hashMapRS+ÛEJBḄ:Õᕜ×.QInit0PostConstructOPrePassivateQPostActivate©RemoveGPreDestroyServlet:Õᕜ×.init-service--destroy266.HTTPÜÝ^Þ߯§^à߯PRS®Þ߯Là߯?á᯿ãäqå267.MVCḄᭆçLᙠ⚗é7ḄCᵨPM(model)ê³?ëÐ(view)Lìᑴ(controller)MVCê1ḄéḄV^®webḄᑖModel®7Ḅíîïð?FñRSᵨJavaBeanᡈEJBᩭ®ViewòᵨYÆᵨᡝḄÉô?Fñᵨjspᩭ®Controllerò^ModelÆview¨õöFḄ᫑᫡?sRSᑖùᑮᵨᡝḄú{⌱üាXḄëЕᵨYDE

96268.᝞uÿSOCKETḄᑏ,JDK1.4⚪nioᒹ269.ᙠORACLEᦪ⊤ᑤ◀#$%ᔲ'()ᑖ+,ᐸ.⊤,SQLSERVER/0ὃ234270.ᙠORACLEᦪ⊤ᨵ6ᓟ8ᩩᦪ:᪵ᨬᨵᦔḄ'ᐸᑤ◀>Truncate271.ᙠᦪ᝞@ᜐᳮ⊤ḄCᩩᦪ,ᵨ/E>0ὃ2ᵨF᪗272.H〈ᩩJKḄLMNᙠJNDI᝞@OPᓄURLRSᦻ273.UᵨḄVKᢈX>YZBEANḄ[ឋ>]^BEANḄ[ឋ274.STATESESSIONBEAN_STATELESSSESSIONBEANḄ`a275.JMSbcᐹ^MN>efgh>1+ijklᔆ2ஹ+ioḄᙢ3ஹqrjklᔆst4ஹuvjk5ஹwuxZ6ஹqroḄᙢst7ஹᑖawuyzὅst|}~ὅst8ஹᵨyzὅstH〈}ᵨ}~ὅstkᦈ}9ஹᐵ

97276.JAVAᘤᳮefḄef[ឋREQUIRESNEWḄbeanPef277.efᜫḄYZBEANḄOPᓄ0ὃᫀ2@PostConstruct278.WEBLOGICSERVERHJDBCᵨU⍳ḄMNuvjkஹ᡻SQLஹx¡ஹᐵjk279.¢cᨵ£E]¤¥¦§¨>©Mᨵ£E]¤¥¦§¨6EªE¦¡ᡂThread¬ªE¦]¤Runnablek®©M¯E]¤wait,notify,notifyall280.ᚗ±xᦈ²ᑴ᝞@´ᓄcµ?0ὃᫀ2·¸¹⌕u•nullḄ¼¸஺ᡈὅ¿Àᵨgcᦈ¡ᚗ±xᦈ281.ÁÂJAVAḄCollectionFrameWorkÃᒹÄ᝞@ᑏÅÆḄᦪ᪀È>JavaḄ¡ᔠᑖ6Êᑖlist|setListË☢]¤¬ᨵarrayList|vectorÍÍSetS☢]¤¬HashSet|TreeSet✌ᐜ]¤ᦪ᪀ḄÐẠ¦ᦪVarrayLisÒÓ¦ÔᦪVÕᵭ×ᩭ஺ᐸ¿⌕Ḅ]¤Ḅ¦remove,add,next஺᝞⌕]¤ÙÚÛÜÝḄÞ%34ᙠarrayListḄÐẠR]¤,Ù᝞queue|stack282.JavaßUᜐᳮ²ᑴ,eK²ᑴJavaḄßUᑖ6ᜧ¬error|exceptionExceptionᑖRuntimeexception4áexception,sâRuntimeexception¦¹◤⌕ᜐᳮjavaYÅᜐᳮexception4áÅäḄexceptionÓ◤⌕sᐸåtry/catchᡈὅthrowᜐᳮeK²ᑴ2eK¿⌕æ¤swingbcᙠsᢥèᡈὅᦻéêëᡈὅᑤ◀eK¦

9834ᵨaddXXXXListenerᡈὅremoveXXXXListener஺ì⌕êëí¬îḄeKᯠ#ᙠeKḄ]¤ðñḄòóᓽ3஺283.JavaḄõbcᵨJAVASOCKETbcöᑶᘤ£øù|ûᑏᐭéᙢýþ>ᢇLU3284.ᵨJAVA,•᣸JAVAᑡᓄḄ()᝞ᙠCOLLECTION᪾⌕!᪵Ḅ#$285.STRING%STRINGBUFFERḄ&'Ustring(stringbuffer)*+,-.ᦪ0Ḅstring123-.456ᦋ89stringbuffer12-.ᦪ06:ᦋ8᝞;6:᪀⌼>᝱-.ᦪ06:@ᵨstringbuffer286.jspᨵBCᑁEFGHᵨᑖJ*!OutFGᵨKᔣMᡝOPQᦪ0outFGRᵨḄ*printRequesFGS⌕ᵨKMᡝOTUResponseFGᵨKVWMᡝTUXᔣMᡝOPQYZSessionFGᵨᩭ+,ᨵᐵ]^ḄᡠᨵYZApplicationFGᵨKᵨᡝ`aḄᦪ0ᐳcPageContextdeᦻPageHᵨKg⚓9287.ijiServletḄklᕜnopqᘤstuvḄw᎛y]zᵨinito஺oTUᑮ}wstservice()஺Service()~>⍧%TUFWḄdopost()ᡈdoget()ᯠ├Ḅw᎛zᵨdestory()288.ServletAPIforward஺%redirect()Ḅ&JForword⚓☢Ḅw᎛5⍝*BᩭḄᡠ:ᙢᙬḄ5]ᦋ89Redired6:᪷0TUḄjX6:ᦪrequest,session஺⍝ᙢᙬᡠ:ḄᙢᙬḄᙢᙬ]ᦋ8

99289.Class.forNameḄHᵨ!⌕ᵨS⌕ḄHᵨ*uᡃ>¡ᦪ0¢Ḅ£⌕¤¥290.j|do*!¦?ᢇLU4:᯿196⚪291.ᙠORACLEᜧᦪ0¬eḄᑖ⚓®஺j¯ᵨ°±ID²ᨵ*³´µᝅ292.xmlᨵBC᪆ᢈ¹&J*!S⌕ᨵSAXஹDOMSAX*»¼᪆½±jᩩ᪆jᩩDOM*᪛À᪆jឋÂ᦮Äᦻ¼½±᪆293.Åᙠ⚗Çᵨᑮ3xmlᢈ¹ḄBC☢᝞ÈḄYZÉPᦪ0+,஺ᙠᦪ0ÊᣚÌÍÂ5Îᦪ0ÏḄᦪ0ÐÑᡂxml,ÓtÔÕuÖ×ØÙÚÉ〈Ü#Ýὅ஺j¯ß¼àEḄᦪ]ᑭᵨxml+â஺294.ᵨjdom᪆xmlᦻ¼w᝞È®ᦻ⚪᝞È᱐ᢇLU5ὃ200⚪åj-.æ295.ç¡ᵨJAVA᪆XMLḄèJava᪆xmlḄèᨵéj*sax,j*DOM᪆dom᪆*Â᦮Äᦻ¼êᐭᑁ+6:ì⌨sax*î½îᑏ5Îì⌨ᓰᵨᑁ+ñ296.Wᵨpqᘤ%WEBSERVERḄ&JWᵨpqᘤᜐᳮôqõöwebpqᘤᑣS⌕*øMᡝ6:×ØùúᘤÓtWᵨpqᘤweblogictomcat,jboss

100WebserverIIS,Apache297.J2EE*!J2EEᐰüjava2platform.EnterpriseEdition஺J2SEjava᪗þ᱐298.java*ᔲᙠᑁ☄javaᙠᑁ☄⚪javaᦈᑴᦈᨵᵨḄ஺᝞ᡭḄᦪ!"ᡈὅ%&'()*+,299.String-Ḅ./ᔲ12ᦋ4512ᦋ4stringbuffer/6712ᦋ4Ḅ300.toString89Ḅᭆ;toString89<=>?Ḅ.@ᣚᐸCᦔḄEFG⊤IJK301.Object-Ḅᭆ;Object/()Lᐳ-NOP%()-ᡈ/()QឋSTOU5VW/XY-Z[Y\ᵨObject-302.-4_Ḅ`aᓄ`aᓄ/ᢣP%()-deᵭg()4_Ḅhijk`aᓄ303.HastablelHashMapḄmnoHashTable/phqᐰḄHashMap5/hashTablesḄkey.5tu/hashMap2t304.CollectionvCollectionsḄmnConnection/!"ᦪḄ()"w஺ᦪ!"xyḄ()"w஺Collections/hz67Ḅ()᣸zC|Ḅ•)"w஺

101305.GC/XYoXY⌕ᨵGC?GC/ᚗᦈḄ306.Strings=newString஺'xyz");%')StringObject?)307.Math.round(11.5)CoMath.round(-11.5)Co12-11308.shorts1=1;s1=s1+1;ᨵXY┯?shorts1=1;s1+=1;ᨵXY┯?shortsi=1;si=si1ᨵ┯1/intᡠ2/int,◤⌕ᑴ@ᣚshortsi=1;si+=1ᨵ┯3O9.sleep()vwait()ᨵXYmn?sleep()5u/1ᙠS᎛⏨ᩭWait()u/5⏨ᩭ◤⌕ᖔ⏨310.OverloadvOverrideḄmn஺OverloadedḄ89/ᔲ12ᦋ4¢.Ḅ-ZoOverride/ᢣ£-¤¥᱄-Ḅ8989§¨•©ᦋ4u/5ªᦋ¢-Zv«ᐭḄᦪvᦪ-Z5®¯᱄-°Ḅ±²஺overload/ᢣᙠ³-s()89§¨´µᑏu/·´«ᐭḄᦪ5³஺Orverloadᦋ4¢.Ḅ-Z311.Set¸Ḅᐗº/5µ»Ḅ[YᵨXY89ᩭmᑖµ»lᔲᕖo/ᵨ==¿/equals஺oÀᨵmno\ᵨequalsᩭmᑖ==/⊤IᵨCÁ/(ÂÃḄCT5/setᐗº¸☢ḄQឋᦪC஺Equals/¤¥objectḄ891ᙠWÅ-ḄS᎛µᑏequals892Æhashcode89஺ᙠsetsi12§¨Ç'஺

102312.Èᡃ•)Oᨬ²ËᑮḄruntimeexceptionNullpointException313.errorvexceptionᨵXYmnoError(Í/ᵫÏÐÑ,᛻ᡈὅÇÓµḄÔÑ┯ÕÖ×ᕒÙ9ᐸ§¨⊡ᦗÖ×஺Exception,/Ö×ᕒ12§¨⊡ᦗḄ±²314.List,Set,Map/ᔲ¤¥Collection"w?Listvset¤¥map5¤¥315.abstractclassvinterfaceᨵXYmn?ᵭgabstractclass¸☢Ḅᡠᨵ89vQឋÜ/ÝḄ᝞Þ£-¤¥Ý-ᨵ>ߣ-à/ÝḄ"w/Ý-Ḅ4áàᨵᐹáḄ>ß()-12>ß)"w5>ß)Ý-316.abstractḄmethod/ᔲ1³S/static,/ᔲ1³S/native,/ᔲ1³S/synchronized?Abstract512³S/staticvnativevsynchronized317.᪀⌼ᘤConstructor/ᔲ1override?512µᑏ318./ᔲ12¤¥String-o512string/final-Zᡠ2512¤¥à512ªᦋ319.N()ph§ᐭ()Ḅ()synchronized89ᐸph/ᔲ1§ᐭ=Ḅᐸ89o5

10332O.try{}¸ᨵ)returnæç[YèéᙠÁ)tryḄfinally஺¸Ḅcode5᡻¨,XYS᎛᡻¨ᙠreturnë¿/o᡻¨ᙠreturnìë321.).³(x.equals(y)==true),uᓾ1ᨵ5³Ḅhashcode,Áçî5o5ᨵ³Ḅhashcode322.N()N×ᦪ«⌴ᑮ()89=891ᦋ4Á)ḄQឋd1¢4ᓄḄðÞ[YÁ¸ᑮñ/.«⌴¿/ᵨ«⌴o/.«⌴஺Javaòhæóᨵ.«⌴ᦪ஺N()>?×()ᦪ«⌴ᑮ89sSᦪḄ.i/Ḅᵨ஺Ḅᑁô12ᙠõᵨḄ89sᦋ4uḄᵨ/ö÷5ᦋ4Ḅ஺323.swtich/ᔲ×ᵨᙠbyteø/ᔲ×ᵨᙠlong±,/ᔲ×ᵨᙠString±?switch(exprl)sexprl/()᦮ᦪ⊤úK஺=«⌴ÈswitchvcaseæçḄᦪ/int>short>charᡈὅbyte஺long,stringÜ5×ᵨÏswticho324.HashtableHashMapmn஺HashMaplHashTableû⌕ü•:8☢ᩭþ஺(•.ᔊHashtable▰ḄDietionaryḄHashMapJava1.2ḄMapḄ.ឋHashtableᐰḄḄHashMap!"ᐰḄ"Ḅ#.$%ᨵHashMap'()*+,$-.⊤Ḅᩩ1Ḅkeyᡈvalue஺325.4ᑏ678ᘤ:Ḅ!ᙠ<ᡝ:>ᐭ@AᯠCᙠDᑴFGHIJᑮ>ᐭ“END”.L)*ᑏM<ᡝ:Ḅ!NpublicclassClient{Socketsocket;

104BufferedReaderin;Printwriterout;Stringstr;publicclient(){try(socket=newSocket(nxxxx.xxxx.xxxx.xxxxn,888);in=newBufferedReader(nevzInputStreamReader(socket.getInputStream()));out=newPrintwriter(socket.getOutputStreamReader(),true);BufferedReaderline=newBufferedReader(newInputStreamReader(System.in));while(!"end”.equals(str)){str=line.readerLine()();out.print(str);}}catch(lOExceptione){}finally{if(line!=null){line.close();}if(out!=null){out.close();}if(in!=null){in.closeO;}if(socket1=null)(socket.close();

105})}326.ArrayListRVectorḄST,HashMapRHashtableḄSTarraylist"ᐰVWXvectorᐰVWYZ᠒hashtableᐰ"\]ᐭ,$^Hashmap"ᐰ\]ᐭ,$^327.char_`ab\"\]cbᦻe@f.ghf\char_`aᨵ2@⁚16jbᦻe@2@⁚16j328.kᨵlmnopghfᨵlmnopghfk'(ᨵqmno•mstThreaduᑏv☢ḄrunnoxmRunnableuᑏrunno஺ᨵ#mno:wait,notify,notifyall329.JflJAVAm᣸!JAVA!ᑡᓄḄno(m)f᝞ᙠCOLLECTION᪾bYZ⌕gh᪵Ḅf%◤⌕serializable330.44ᑏ@AḄᦪ>ᐭ.@AR@⁚ᦪ>M.ᢥ@⁚Ḅ@A஺⌕e@"᝞“ᡃABC”4,.“ᡃAB”>ᐭ“ᡃABCeDEF”,6,>M.“ᡃABC”"“ᡃABC+eḄ஺publicstaticStringcutData(Stringstr,intnum){byte[]buffer=str.getBytes();if(num>buffer.length||num<=0){returnnull;

106Mapmap=newHashMap

107publicstaticStringprintStr(byte[]buffer,intnum){//numW1byte[]tempBuffer=newbyte[num];for(inti=0;i

108ᜐᳮᙠᑭᵨxml!"ḄḄᔜ%&ᦪ()*ᙠxmlᦻ335.ᵨjdom᪆xmlᦻ-./0ᦻ1⚪3᝞/5m__________________________ᢇ7[LU6]:&ὃ200⚪336.ABᵨJAVA᪆XMLḄ!C.D%!EFdomGsax337.EJB2.0ᨵIBJᑁL3ᑖNᵨᙠOPQᔠ3EJB2.0GEJB1.1ḄSN3338.EJBTJAVABEANḄSN3339.STRUTSḄUᵨV᝞STRUTSW᪀YMVCZC[\]^G_`^ᑖa340.bc(ᵨᑮefJghZC3ᵨᙠOPQᔠ3iᔆZCᓫlZCmᳮZCnoὅZCq341.CORBArOP3ᵨ⌶rOP3CORBArt%u᪀vwxḄyz{ᐵḄ|}~Zᵨ⌶rᑖCh342.ArrayLlst,Vector,LinkedListḄ)ឋGᱯឋarraylistBᐰ|ᦪᐭG◀᠒LinkedListBᐰ|ᦪᐭG◀Vector᠒Bᐰ343.gh4BᐸDB|j1,¡᜜DB|j£¤1஺ᑏB§஺publicclassThread_125{

109publicstaticIntegeri=0;*@paramargspublicstaticvoidmain(String[]args)//TODOAuto-generatedmethodstubThreadltlnewThreadl();Thread2newThread2()¨Thread3t3newThread3();Thread4t4newThread4();11.start();t2.start();t3.start();t4.start();try{11.join()t2.join()t3.join()t4.join()}catch(Exceptione){e.printStackTrace();classThreadlextendsThread{publicvoidrun(){

110while(true){synchronized(Thread_125.i){Thread_125.i++;System.out.printIn("Threadl:i+l===>n+Thread_125.i);}try(Thread.sleep(200);}catch(InterruptedExceptione){e.printStackTrace();}classThread2extendsThread{publicvoidrun(){while(true){synchronized(Thread_125.i){Thread_125.i++;System.out.printin(MThread2:i+l===>M+Thread_125.i);)try{Thread.sleep(200);}catch(InterruptedExceptione){e.printStackTrace();classThread3extendsThread(

111publicvoidrun(){while(true){synchronized(Thread_125.i){Thread©25.i--;System.out.printin("Thread3:i-l===>n+Thread_125.i);try{Thread.sleep(200);}catch(InterruptedExceptione){e.printStackTrace();))}}classThread4extendsThread{publicvoidrun(){while(true){synchronized(Thread_125.i)(Thread_125.i--;System.out.printIn(nThread4:i-l===>"+Thread_125.i);}try(Thread.sleep(200);}catch(InterruptedExceptione)(e.printStackTrace();

112344.ServletḄª«ᕜ®ServletGCGIḄSNinitservicedesctroycgl¯(°±²newtB§³`´ᡂ├·¸rservlet¹rº»¹◤⌕tB³`´ᡂ├·345.EJBr¾¿ÀJᢈÂḄ3®SessionBeanGEn^ityBeanḄSN/ᢇ7LU7F&ὃ979StatefulBeanGStatelessBeanḄSN஺346.EJBᒹÅ(SessionBean,EntityBean)ÇÈḄª◀ᕜÉ᝞/ÊᳮË`Ḅ3ᢇ7LU8&ὃ981347.ᦪº»ÌḄiÍᑴrOP3J2eeÏ`ÐÑ°ÒÓtÔᦪÕḄ̺»®tÖ×ᢝ¤¿ÙᦪÚḄ̺»஺ÛᡝÝB§◤⌕º»ÌÞÑB§°ßà-•ãäᵨḄ̺»®[ᐸ⊤ᦋçè஺᝞éêëìᨵíÌÞÑB§ï²ÒtÔᦪÕḄº»²Òº»ḄᦪÕᨵ&ᦪ0Ô஺êäᵨḄ̺»ðᵨ´ᡂÌÞÑB§[Ùñ»⊤òçíîᐸÇðᵨïäᵨóº»348.ôGuôᨵGuᙠOPõöxᑖNäᵨÇÈ3÷lI஺ôF᝞éᦪ[ᙠBøᐳú᝞ûᙠᑏḄᦪü¡•BýᑮᡈὅûᙠýḄᦪÿᑏᦪ◤⌕᝞ᡃᑏ•!"◤⌕#$%&'()*ᵨᓾ-./01!"23I4556ᵨ7789ᨵᦔ᳛349.?ᡠA⍝ḄDᔠFGᨵHIJ⌕!"IKᵨḄDᔠFLMistNsetListḄᐹPQRᒹTArrayListNvector

113350.U?:WXYA,ᦪZ[\]B,ᵨᡝ[\]C,_ṹ]D,ᦪa⊤]T,cᵨJDBCdef⊤TḄᡠgᦪ351.hi(LkᢇmLU9nὃ898352.p᪗ḄrᵨI᝞sA⍝p᪗tᑮᨬwIx᪍Lᵨz{|}~DḄᑨᐰkETCH_STATUSsᑨLᔲᑮᨬwmLU10(Q00)K-/0Lf┯ᡈᑮᨬw353.ᘤᑖ]hNhwᨵN354.?A⍝ObjectFᨵ!"IEquals();toString();wait();finalize();355.ᙠJdbcᦪa*ᵨ'?K6ᵨk!᡻sqlI]k-ᵨᐸ!ExecuteexecuteUpdateexecuteQuery356.L᝞sXḄIStart!"357.?Ftp¡¢ᔩI᝞~-c¤ᡃ¥¦?Ftp¡¢§¨©ªᦪᒹḄ«᪆!"?ᵨ®&'(ᵨjava¯°apl±{358.?A⍝java²CḄ³Iᔩ?´ᵨ¡¢³I(ᐸQµL¤socret³)socket¡¢359.javaḄ·¸³ᨵ!ᨵkIᨵTCPNUDP³TCPL¹☠Ḅ»¼½ᡠ¾Ḅ»¼-´¿ᜫᒹÁUDPL-¹☠Ḅ»

114¼´fR¿ᒹRÂTCPLÃÄÃḄ³UDP¹LÃÄÃḄ³,µ¹LÆ·³ÇÈ360.Stringa=""Forlimitl=0;l<100000;l++)A=a+“A”ÉÊËÌᡂ“A”»¼100000Î,Ï☢!"-ÑÒcÓᓄÏ☢ÕṹI(6ᵨstringBufferÓᓄ)StringBuffera=newStringBuffer();for(inti=0;i<100000;i++){a.append("A")Ö}361.EJBḄ×*ᵨØcÙÚÛ஺ᢇmLU110362.?ᙠjspᡭᓺL᝞sQRḄIß⌕à?ᵨáâḄᡭᓺ!"µLàᙠJSPãᨵ%®ᑁåÁᡃæ◤⌕ᡭᓺᐸ⊤©L᝞sQRḄInὃçᫀéᵨjavascriptᡭᓺ,window.print();ᡭᓺêëᐸ-.ᐵḄᢥîᡈὅᐗñ◚óæôõ◤⌕ᡭᓺḄ⊤©ᡈὅÆ363.?ᵨjavascrjptö᪛øùᓫᔩû2____________________________________________ᢇm×LU12):364.WEBᘤ◤⌕ᓄḄᜐᳮSstructs᪵ᜐᳮ365.!"ᙠjsp⚓☢&'(ᦻ*ᦻ+ᔩ-./0!Ḅ12-366.!ᙠᦪ4567"78☢9Ḅᦪ4:ᨵ<ᜧ-᝞?ᨵ(⚗A8BᜩᨵDEF᪀HᐰJKḄ⊤(365ᜩᜩᜩ᝞MBE⊤NOᙠ100PᩩR&S◤⌕ᑖ⚓UV᪷4᪵Ḅ⚗FI,Xᵨ!ᵨ"Ḅᑖ⚓Zᳮ[ᔩ-367.!ᵨjava\ᵨ"Ḅ]^"7ᔩ-_•(]^"7ᨵabNOc᪵ᙠjava8ab-

115368.eforacleᨵᡠhifᦪ45Ḅjkel〉kḄno/Iᢇst53wxyzᡠ{Select*fromtableNamewhereRowId!=(selectMax(Rowld)fromTableNamedwheretable.coll=d.collandtable.col2=d.col2);ᑤ◀NOxDeletefromtablewhereRovzld!=(selectmax(Rowld)fromtabledwheretable.coll=d.collandtable.col2=d.col2);U_OᵨᡝḄD¢xSql>showuserᡈὅSQL>selectuserfromdual;ªᑮ_Ḅ¬fxSelectabs(-n)fromdual;¯°±(²³´xConcat¶'abcz,'defg'º;Selectconcat¶'abc'defg'ºfromdual369.ᑡ¼½¾¿À☢ᔣfÂḄ¶CA.CB.PASCALC.C++D.FORTRAN77c370.ᙠWindows9xF,ÃRÄᐭMS-DOS1Æ஺_ᙠDOSÈɳÊᐭ¶BºËÌÍÎ⌨ÐMS-DOS1ÆabᑮWindows1Æ஺A.CLOSEB.EXITC.QUITD.RETURNB371.☢ᕸÀ☢ᔣfÂḄÒ*ᱯឋx¶ABCA<᝱BÖ×CØÙD°ÚABC

116372.ᙠC++8ÝÞ⌕Ä[ßÞᜐᳮ☢àÀßÞᜐᳮÞᵨᑮḄᐵÊkx¶ABCAtryBcatchCthrowDbreakEcontiueABC373.ᦪ45ᢈã8Ḅ“åᦪ4*Àᢣ¶CḄᦪ4஺A.┯èB.baC.éÈêD.éÈêḄëÍìíîc374.TCP/IPÀ½¶A,BA.᪗ðB.ñòC.¾¿D.ó2AB375.☢ᨵᐵôóõöḄ÷08øùúḄÀBAöûüý+Böþÿᳮᑁᘤᳮ᜜ᘤCUNIXDḄᜐᳮᘤஹᑁᵫᳮB376.!"ḄᵨDA$%᡻'()B*+()C,'*ṹ.ᣚD0ᑴ2ᳮD377.3ᑡᘤ5678ᨬ:Ḅ;AAᑁB

117A380.RS⌱⚗5ᔠWḄAXYZ(BC)AJB"B.AOWC.68D.DBC381.Ꮇ]x2yQdouble^ᑣ⊤abx=2,y=x+3/2Ḅc(D)A.3.500000B.3C.2.000000D.3.000000D382.RSᔠWḄdcef(BCD)//InC++,choiceDalsoiscorrect,butinClanguage,Diswrong.A.x=y=100B.d-;C.x+y;D.c=int(a+b);InjavagABC383,ijxஹyᙳQ᦮^mZnx=10y=3,ᑣRSefpprintf(”od,%d

118”,x--py);Ḅqrst(D)A.10,3B.9,3C.9,2D.10,2D384.xஹyஹzu]vQint^mZwxy

119",a[0][3]a[1][2],a[2][1],a[3][0];J

120}A)0650B)1470C)5430D)qrc]A387.RS()Ḅqrst(B)main(){charst[20]=nhello\0\t\\V';printf(%d%d

121",strlen(st),sizeof(st));}A)99B)520C)1320D)2020B388.~ᵨWindowsAPIᦪInvalidateRect,M(A)A:WM_PAINTB:WM_CREATEC:WM_NCHITTESTD:WM_SETFOCUSA389.ᑡ~~'Ḅᦪ|,SQLSERVER,ORACLE,BDE,MicrosoftJeto390.Q~<~5Ḅᡠᨵᦻᦻ(᡽Q.TXT)Ḅᑁᡭᓺqrj}ḄᓫᩩDOSQCOPY*.TXTPRN391.iyint^mZᑏrᑨ£yQ᜻ᦔḄᐵ⊤abpublicbooeanisOdd(inty)(return(y%2==l);}392.UDP☢ᔣ©ª«Ḅ¬ª«(TorF)T393.®ᑡᐜ,°r(TorF)F394.Weblogicᑖ²b³ᵨ´µᘤ(TorF)T

122395.TCP,UDP¶·q¸Ḅ¹º(TorF)T396.»@¼(½ᐳ¿ÀᙢᙬÃÄ(TorF)F397.JAVAÅÆÇḄÈÉÊᐹ(TorF)F398.ᙠWINDOWS5Ì᜜iRᦻḄÍb,'ᳮ(TorF)F399.ÎÏᑁÐ▭ÒÓᙠ<"Ḅ(TorF)T400.OOP?ÔÕÌÖÔ2Ì×ÐØÙÄḄᐵOOP☢ᔣÌ×*(Ô5ᒹÛÍW2ÜឋÍW5ᒹÛÍWÞ஺401,ᨵGᦪA(3,10,6,8,98,22),*(᣸)(ᓣâ)Ḇä),eæ▲,W▲èéêëìW஺ᑈî᣸)publicclassTestDemo(publicstaticvoidmain(String(]args){int[]iArray={3,10,6,8,98,22);intk=0;intcount=0;for(intj=0;jiArray[i+1]){k=iArray[i];iArray[i]=iArray[i+1];iArray[i+1]=k;afalse;

123}count++;)if(a)break;)for(inti=0;i

124ᐳïð"+count+"óô")õ402.ᚗ÷øᦈᑴ᝞ìûᓄ()Õ403.HTTPḄýôþ(ᢇ[MS14]:?1,ÿip2,TCP஺3,ᔣᘤ〈http404.•ᩩᢣḄᡂ•ᨵᢣB!▤#஺Aஹᦪ&Bஹ᡻(ᢣCஹᙢᙬDஹ+〈ᦪ&B405.,-./Ḅ-ᵨ1BC஺Aஹ234567ᡂ8᪗45Bஹ:;<(8=>ᳮCஹ@ᑴ>ᳮ./B3ḄCᵨDஹDEFGHᘤFGBC406.IᑡᦪKᨬMḄᦪ1NO☢Ḅ1<ᑴC஺

125Aஹ(11011001)2Bஹ75Cஹ(75)8D(2A7)16c407.ᙠRSḄT▭VWXK⌕ZWḄ[\Hᙳ^ᵨ(HTTP)abHTTP408,[\HᢣdᒹN_C_ᙢfṹ█ijᢇMS15:opA.ᑁlᙢᙬB.mᙢᙬC.,-ṹD.nlᘤC409.ᙠᑁlKq!rsᓫuvwxyd!zdḄ5O{!5O1_C_஺A.|⁚B.6OC.ᙢᙬD.~c410.[\H᡻(ḄFG1_D_஺A.6FGB.DEFGC.FD.HᘤFGD411.MS-DOS1B,-./ᢇMS16J:opA.ᑖB.C.ᓫᵨᡝD.ᓫᓫᵨᡝB412.ᙠDOS./Kᑁ_D_A.C:B.C.A:D.D413.ᙠDOSA:\IᐭWCGHᘤᓽ᡻(,WCGᦻ¢Ḅᐰ¤◀1WCG.COMᡈWCG.EXE᜜¨©ªߟᢇMS17¬D?A.WCG.PRGB.WCG.SYSC.WCG.DBFD.WCG.BATD

126414.DOS./q!®8=¯!ᱯ±8=“ᐸKᵨᩭµl_1_3_]_//ᢇ[MS18]:op·¸஺A.R8=ḄIE8=B.R8=s¹C.R8=ḄZE8=D.RḄᨬDE8=B415../ºC:\>lK»ᨵᢣ¼ᑣᦻ¢¾l;_C஺A.AB.BC.CD.DC416.⌕ᦋÀRÁÂÃᐭ_A_ÄᢥÆÇᓽ஺ᢇ[MS19]:?A.:B.?C.\D.A417.RA,⌕᡻(C᪷8=IḄᢇᜐᳮᦻ¢A.BATCᵨdA.A.C:\A.BATB.A:\A.BATC.A.BATD.\A.BATA418.ÊRRËÌC:\LX,⌕¾R\A1\C1\BÍËÌIḄF1.Cᦻ¢ÎᑴᑮR8=K,CᵨI☢___C_஺A.COPYF1.CF1.CB.COPY\F1.CC.COPY\A1\C1\B1\F1.CD.COPY\A1\C1\B1\F1.CC:\c419.ᑤ◀AR8=K᡽ª¤.BAKḄᡠᨵᦻ¢Ḅ1_A_஺A.DELA:*.BAKB.RDA:*.BAKC.DEL\A\*.BAKD.RD\A\*.BAKA420.ᑡÓAR8=KÔᦻ¢¤ÕÖ!|×ᡂ,᡽ª¤ØḄᡠᨵᦻ¢ÙᓫCᵨ_B___஺A.A:\>DIR??*.*B.DIRA:???.*C.DIRA:*.???D.DIR*.

127B421.ÚᨵpÛ:chara[]=”xyz",b[]={K'y',N};,IÝÞKßàḄ1:CA)ᦪ×abḄáâãB)aᦪ×áâM;bᦪ×áâC)aᦪ×áâᜧ;bᦪ×áâD)ZÞåævçc

128èéêḄ¬⚗8O6O4qi0Oracleᨵᫀᑖ422.ᵨsqlplusᦪ&ìíîïÓOraclenotavailable┯ñòoracleserver(ᓽóôᡠåḄᦪ&ì)1ᔲö÷ORACLE_SID1ᔲßàÊø஺423.ùÓᕒûḄüK(last_name)ýÖ!|þ1aḄᕒû¤|selectlast_namefroms_empwherelast_namelike'__a%';424.ùÓᕒû¤|KÿᨵaeḄselectfirst_namefroms_empwherefirst_namelike'%a%*andfirst_namelikeselectfirst_namefroms_empwherefirst_namelike,%a%e%,;425.ᡠᨵᨵᡂḄᕒᑡஹஹᢥᑮᜧᡂᑮᜧselectfirst_name,salary,commission_pctfroms_empwherecommission_pctisnotnullorderbysalarydesc,commission_pct;426.ᨵ!"selectdistincttitlefroms_empwheredept_id=42427.◀$Sales&ᨵselectid,name,region__idfroms_deptwherename<>,Sales,428.'ᙠ1000)I1550*+Ḅᕒ,-ஹᢥᜧᑮ᣸/஺selectfirst_name,salaryfroms_empwheresalarynotbetween1000and1550orderbysalarydesc

129429.!"1StockClerkSalesRepresentative,23ᙠ1440017400*+ḄᕒḄ,-ஹ!"ஹ23஺selectfirst_name,title,salary*12ann_salfroms_empwheretitlein('StockClerk','SalesRepresentative'andsalarybetween1200and1450430.45selectid,commission_pctfroms_empwherecommission_pctisnullselectid,commission_pctfroms_empwherecommission_pct=nullIḄ6஺isnullᑨ89ᔲ1;=nullᑨ8<=>9ᔲ?@null,null=nullnull<>nullA1nullo431.selectBCḄ61select*froms_dept;select*froms_emp;select*froms_region;select*froms_customer;432.DEᵨᡝᨵHIJ⊤LᨵHIᩩNO஺select*select*from,||table_nameII*;'fromuser_tables;433.ᑨ8selectfirst_name,deptjdfroms_empwheresalary>'1450'9ᔲP┯1RST◚VᦪXYZ[ᣚ434.ᦋ^NLS_LANGḄ>,`selectto_char(salary*12/L99,999.99')froms_emp6Ḅabᓫ"9¥$setenvNLS_LANG'SIMPLIFIEDCHINESE_CHINA.ZHS16GBK'setenvNLS_LANG'AMERICAN_AMERICA.US7ASCII'

130435.ᑡf=ᕒḄஹg3h(gj18%),ᐗ1ᓫ"lmnopᐭselectfirst_name,salary,round(salary*1.08)froms__emp;436.r9ᨬt⚞vwᢥᜧᑏyVselectupper(first_name)froms_empwheremanager_idisnull;437.BenḄ⚞v9r(BenᔣrP{)஺selectel.first_namefroms_empel,s_empe2wheree2.manager_id=el.idande2.first_name='Ben';438.Ben⚞vr஺(rᔣBenP{)஺selectel.first_namefroms_empel,s_empe2whereel.manager_id=e2.idande2.first_name='Ben439.ᕒḄt@}~ḄᑡᕒḄḄselecte.first_name,e.salary,m.first_name,m.salaryfroms_empe,s_empmwheree.manager_id=m.idande.salary>m.salary;440.ᕒBiri(last_name)selectel.first_namefroms_empel,s_empe2whereel.dept_id=e2.dept_idande2.last_name=1Biri•andel.last_name<>,Biri•;441.ᕒSmith(last_name)᪵!"selectel.first_namefroms_empel,s_empe2whereel.title=e2.titleande2.last_name='Smith1andel.last_name<>1Smith1;

131442.ᕒBiri(last_name)'ᙠ=selectel.first_namefroms_empel,s_empe2whereel.dept__id=e2.dept_id(+)ande2.last_name(+)='Biri*ande2.last_nameisnull;443.ᕒSmith(last_name)'᪵Ḅ!"selectel.first_name,e2.first_namefroms_empel,s_empe2whereel.title(+)=e2.titleande2.last_name(+)='Smith*ande2.last_nameisnull;444.ᨵᡂḄᕒḄ,-ஹᡂஹᡠᙠஹᡠᙠᙢḄselectd.namedname,r.namername,first_name,commission_pctfroms_empe,s_deptd,s_regionrwheree.dept_id=d.idandd.region_id=r.idande.commission_pctisnotnull;445.Operationsᨵ!"selectdistincte.titlefroms_empe,s_deptdwheree.dept_id=d.idandd.name=1Operations,;446.᦮=ᨬtᨬHIselectmax(salary)-min(salary)froms_emp;447.ᡂᜧ@0Ḅᦪselectcount(*)froms_empwherecommission_pct>0;448.᦮=Ḅᨬtஹᨬஹஹᙳᶇᑮ᦮ᦪ"஺selectmax(salary)*min(salary),sum(salary),round(avg(salary))from

132s_emp;449.᦮=ᨵHI=⚞vselectcount(distinctmanager_id)froms_emp;450.ᑡᙠᐭ!t@ᐸ}Ḅᕒஹஹᐭ!Iselectdistinctel.first_name,el.start_date,el.salaryfroms_empel,s_empe2whereel.dept_id=e2.dept_idandel.start_date>e2.start_dateandel.salary>e2.salary;451.ᔜ=ᙳஹᨬᜧஹᨬஹᦪᢥ᯿ᓣ/᣸ᑡselectdept_id,avg(salary)asal,max(salary)asal,min(salary)isal,count(*)entfroms_empgroupbydept_idorderbydept_id;452.ᔜ=ᜧ@1500Ḅᕒᦪselectdept_id,count(*)entfroms_empwheresalary>1500groupbydept_id;453.ᔜ=ᙳᦪᢥ᯿ᓣ/᣸ᑡselectmax(d.name)dname,max(r.name)rname,avg(e.salary)avgsalfroms_empe,s_deptd,s_regionrwheree.dept_id=d.idandd.region_id=r.idgroupbydept_idorderbydname,rname;454.ᑡf=ᨵ᪵ḄᕒḄ¡¢,-ᑡ}£Ḅ

133ᦪselectdept_id,salary,count(*)entfroms_empgroupbydept_id,salaryhavingcount(*)>=2455.¤t@1000Ḅᕒᦪ¥¦§2ᑡ¨ᔠᩩªḄஹᙢselectmax(d.name)dname,max(r.name)rname,count(*)entfroms_empe,s_deptd,s_regionrwheree.dept_id=d.idandd.region_id=r.idande.salary>1000groupbydept_idhavingcount(*)>2;456.ᕒḄt@᦮=ḄᙳᑡᕒḄ«¬/selectfirst_name,salaryfroms_empwheresalary>(selectavg(salary)froms_emp)orderbysalarydesc;457.ᕒḄ®@323333tᙳ*+selectfirst_name,salaryfroms_empwheresalarybetween(selectavg(salary)froms_empwheredept_id=32)and(selectavg(salary)froms_empwheredept_id33);458.ᡠᙠᙳt@1500Ḅᕒselectfirst_name,salaryfroms_empwheredept_idin(selectdept_idfroms_empgroupbydpet_idhavingavg(salary)>1500);459.ᑡᔜ=ᨬtḄᕒḄ,-ஹஹselectfirst_name,salary,dept_idfroms_empwhere(dept_id,salary)

134in(selectdept_id,max(salary)froms_empgroupbydept_id);460.ᨬtḄᙳ>Ḅ9HIselectmax(avg(salary))froms_emp;461.=Ḅᙳ9ᨬtḄᑡஹᙳselectdept_id,avg(salary)froms_empgroupbydept_idhavingavg(salary)(selectmax(avg(salary))froms_emp);462.Ḅᦪ32ḄᦪHselectdept_id,count(*)entfroms_empgroupbydept_idhavingcount(*)>(selectcount(*)froms_empwheredept_id=32);463.BenḄ⚞v9r(¯ᐵὶ²³´)selectfirst_namefroms_empwhereidin(selectmanager_idfroms_empwherefirst_name='Ben');464.Ben⚞vr(¯ᐵὶ²³´)selectfirst_namefroms_empwheremanager_id=(selectidfroms_empwherefirst_name='Ben');465.BenḄ⚞v9r(ᐵὶ²᩵´)selectfirst_namefroms_empowhereexists(select1froms_empiwherefirst_name='Ben'andi.manager_id=o.id);466.Ben⚞vr(ᐵὶ²᩵´)selectfirst_namefroms_empowhereexists(select1froms_emp

135iwherefirst_name=*Ben'andi.id=o.manager_id);467.ᑡᙠᐳᐭ!t@ᐸ}Ḅᕒஹஹᐭ!(ᐵὶ²³´)selectfirst_namefroms_empowhereexists(select1froms_empiwherei.dept_id=o.dept_idando.start_date>i.start_dateando.salary>i.salary);468.ᕒBiri(last_name)'ᙠ=(¯ᐵὶ²³´)selectfirst_namefroms_empwheredept_idnotin(selectdept_idfroms_empwherelast_name='Biri');469.ᕒBiri(last_name)'ᙠ=(ᐵὶ²³´)selectlast_namefroms_empowherenotexists{select1froms_empiwherei.dept_id=o.dept_idandi.last_name=*Biri1);470.Operationsᨵ!"(¯ᐵὶ²³´)selectdistincttitlefroms_empwheredept_idin(selectidfroms_deptwherename=1Operations*);471.Operationsᨵ!"(ᐵὶ²³´)selectdistincttitlefroms_empewhereexists(select1froms_deptdwheree.dept_id=d.idandname='Operations';472.ᙠ1500)3000*+Ḅᕒᔜ·¸Ḅ2▲(nopᐭ¬/)஺ºselectfirsjname,start_date,round(months_between(sysdate,start_date)/12)years

136froms_empwheresalarybetween1500and3000orderbyyearsdesc473.»¼f=ᕒᙠ¸252Ḅ½=ᕜp¿ÀᵭÂ⌨ij´f=ᕒḄÅᜩÇV2010-01-01selectfirst_name,to_char(start_date,*yyyy-mm-dd,),to_char(next_day(add_months(start_date,12*25),'FRIDAY'),*yyyy-mm-dd*)froms_emp474.ᕒḄஹᐭ!ஹᕜÈᐭ!(ᵨÉᦻᐰÌ)Í/ᕜ)ᕜ஺ºselectfirst_name,start_date,to_char(start_date,DAY*)zfroms_emporderbyto_char(start_date-l,*d*)475.ᑏ=sqlÎÏÐÑHÒHᐵÓ(ᨚÕ'ÐÑÖ×)ØÙ⊤ஹÚÛ⊤ஹØÙ⌱Ú⊤ØÙ⊤ᒹÞ᝞à,-ØஹáஹឋãஹÙஹäå☢çÚÛ⊤ᒹÞ᝞à,-ÚÛஹÚÛஹØᑖஹØÕஹØØÙ⌱Ú⊤ᒹÞ᝞à,-ØஹÚÛஹᡂéêëᐭᦪX஺ºcreatetablestudent(idchar(10),namevarchar2(20),genderchar(2),birthdate,partyvarchar(10));createtablecourse(idchar(10),

137namevarchar2(20)zcreditnumber(2,1),periodnumber(3),termnumber(1));createtablest_c(sidchar(10),cidchar(10),gradenumber(3,1));insertintostudentvalues('2006015001'Mary1,'F','15-MAY-1988','A');insertintostudentvalues('2006015002','John1,'M\•05-JAN-1988\'A');insertintostudentvalues('2006015003\'Kitty','F',,23-MAY-19871,'B»);insertintostudentvalues(*2006015004'JTony-Ml'18-MAY-1989','A');insertintostudentvalues(12006015005','Elice''F',,15-MAY-1989*,'B»);rinsertintocoursevalues('MUST200901-Datastructure',4,72,2);insertintocoursevalues('MUST2009021,operatingSystems1,2,54,1)ìinsertintocoursevalues('MUST200903',DesignPattern\4,72,2);rinsertintocoursevalues(•MUST2009041fCoreJava\5,108,1);zinsertintost_cvalues('2006015001\'MUST2009011,85);insertintost_cvalues('2006015001','MUST2009021,90);insertintost_cvalues('2006015001','MUST2009031,85);insertintost_cvalues('2006015002.'MUST200902192);insertintost_cvalues('2006015002'z'MUST2009031,78);insertintost_cvalues(*2006015004,,'MUST200901,,96);insertintost_cvalues('2006015004',,MUST200902,,86);insertintost_cvalues('2006015004''MUST200903,,98);z

138insertintost_cvalues('2006015004','MUST200904,,70);insertintost_cvalues('2006015003',,MUST200904,,67);476.ᙠíî⊤ḄïẠñᡂ³´<=ØÙ⌱$ÚÛ஺ºselects.namestudent_name,c.namecourse_namefromstudents,coursec,st_cscwheres.id=sc.sidandc.id=sc.cidands.name='Mary,Mary⌱$ÚÛSTUDENT_NAMECOURSE_NAMEMaryDatastructureMaryOperatingSystemsMaryDesignPattern477.<=ØÙòó⌱ÚÛ஺selectc.namefromcoursec,(selectcidfromstudents,scwheres.id=sc.sidands.name='Mary*)awherec.id=a.cid(+)anda.cidisnull478.ñᗐsqlÎÏḄí⊤BCᙠõJ⊤ö÷Ö×ØÙ⊤ஹÚÛ⊤ஹØÙ⌱Ú⊤ᙠᦪXᜐᳮúÑûḄᭆý஺º//student_course.sqldroptablelm_student;droptablelm_course;droptablelm_sc;

139createtablelm_student(idchar(10)primarykey,namevarchar2(20)notnull,genderchar(2)default*F*notnull,birthdatenotnull,partyvarchar2(10));createtablelm_course(idchar(10)primarykey,namevarchar2(20)notnull,creditnumber(2,1),periodnumber(3),termnumber(1));createtablelm_sc(sidchar(10)referenceslm_student(id)ondeletecascade,cidchar(10)referenceslm_course(id)ondeletecascade,gradenumber(3,1),primarykey(sid,cid))!insertintolm_studentvalues('2006015001'MaryF15-MAY-1988'A');insertintolm_studentvalues(120060150021,1John1,1M*,105-JAN-1988\,A1);insertintolm_studentvalues(12006015003','Kitty','F1,'23-MAY-l987',1B1);insertintolm_studentvalues(120060150041,'Tony','M*118-MAY-1989*,*A*);rinsertintolm_studentvalues((2006015005','Elice','F-15-MAY-1989','B');insertintolm__coursevalues(1MUST200901,,*Datastructure1,4,72,2);insertintolm_coursevalues(*MUST200902','OperatingSystems',2,54,1);insertintolm_coursevalues(fMUST200903','DesignPattern,,4,12,2);

140insertintolm_coursevalues(*MUST200904','CoreJava,,5,108,1);insertintolm_scvalues('2006015001\'MUST200901',85);intolm_scvalues(12006015001f,'MUST200902,,55);insertintolm_scvalues(120060150011,'MUST200903,,45);insertintolm_scvalues(*2006015002*,*MUST200902,,92);insertintolm_scvalues(120060150021,'MUST200903,,78);insertintolm_scvalues(*20060150041,'MUST200901,,96);insertintolm_.scvalues(12006015004\'MUST200902,,86);insertintolm_scvalues(12006015004*,*MUST200903,,98);intolm_scvalues(12006015004','MUST200904,,70);intolm_scvalues(12006015003','MUST200904,,67);intolm_scvalues(120060150031,'MUST200901,,57);commit;479.:ᦋ<=>?ḄA?BC஺EFupdatelm_studentsetbirth=add_months(birth,2)vzherename=*Tony,;480.:ᦋJ஺EFupdatelm_coursesetperiod=80whereid='MUST2009011;481.ᑤ◀?஺EFdeletefromIm_studentwherename=,Tony1;lm_scḄsidNḄFKOPᡂR0ndeletecascade,oracleᐜᑤTᡂRedeletefromlm_scwheresid=(selectsidfromlm_studentwherename='Tony*);ᡠVdeletelm_studentWVᡂX஺

141482.ᙠ>?⌱H⊤N\]^=_`>?M_aHIMbcdNe஺EFaltertablelm__scadd(snamevarchar2(20),cnamevarchar2(20));updatelm_scscsetsname=(selectnamefromlm_studentswheres.id=sc.sid),cname=(selectnamefromlm_coursecwherec.id=sc.cid);483.fᨵ^GHIḄᡂhij60ᑖlᐸᑤ◀஺EFdeletefromlm_studentwhereidin(selectsidfromlm_scwheregrade<60groupbysidhavingcount(*)>1)deletefromlm_studentswhereid=(selectsidfromstu_scscwheres.id=sc.cidgroupbys.idhavingcount(*)>1);484.n=>?⌱RᡠᨵḄHI஺EFselectid,namefromlm_studentswherenotexists(select*fromlm_coursecwherenotexists(select*fromlm__scwheresid=s.idandcid=c.id))!selectid,max(name)fromlm_studentss,lm_scscwheres.id=sc.sidgroupbys.idhavingcount(cid)=(selectcount(*)fromlm_course);485.⊡ᐙqrᜩḄsqltuvᙠ>?⊤ஹHI⊤ஹ>?⌱H⊤N\]xy஺>?⊤

142ḄzM_`ஹA?BC_`vHI⊤NḄ>ᑖ_`v>?⌱H⊤Ḅᡂh_`஺createindexname_lm_student_idxonlm_student(name);createindexbirth_lm_studnet_idxonlm_student(birth);createindexcredit_lm_course_idxonlm_course(credit);createindexgrade_lm_sc_idxonlm_sc(grade);486.l>?⊤NḄidaHI⊤NḄidᵨsequence|}஺createsequencelm_student_id;createsequencelm_course_id;insertintolm_studentvalues('2006015'IIIpad(lm_student_id.nextval,3,'0'),'Mary','F','15-MAY-1988-A');insertintolm_studentvalues(12006015'IIIpad(lm_student_id.nextval,3,஺'John'M','05-JAN-1988\'A');insertintolm_studentvalues(*2006015'|IIpad(lm_student_id.nextval,3,'0'),*Kitty',*F*,*23-MAY-l987-Bv);insertintolm_studentvalues(*2006015'|IIpad(lm_student_id.nextval,3,10'),rTony*,*M*,'18-MAY-1989','A');insertintolm_studentvalues('20060151IIIpad(lm_student_id.nextval,3,,O'),*Elice','F*,'15-MAY-l989','B');insertintolm_coursevalues('MUST2009'I|Ipad(lm_course_id.nextval,2,'0'),*Datastructure,,4,72,2);insertintolm_course

143values(*MUST2009*I|Ipad(lm_course_id.nextval,2,'0'),'OperatingSystems,v2,54,1);insertintolm_coursevalues(*MUST2009*IIIpad(lm_course_id.nextval,2,•O'),1DesignPattern',4,72,2);insertintolm_coursevalues(*MUST2009*IIIpad(lm_course_id.nextval,2,*0'),*CoreJava1,5,1081);zinsertintolm_scvalues(12006015001',*MUST200901'85);zinsertintolm_scvalues('2006015001'MUST20090255);insertintolm_.scvalues(12006015001','MUST200903,,45);insertintolm_scvalues(12006015002'*MUST200902'92);zzinsertintolm_.scvalues(12006015002','MUST200903,,78);insertintolm_scvalues(12006015004',*MUST200901*96);zinsertintolm_scvalues(12006015004,'MUST200902*Z86);insertintolm_scvalues(12006015004'*MUST200903*98);zzinsertintolm_scvalues(12006015004','MUST200904,,70);insertintolm_scvalues(*2006015003'*MUST200904',67);zinsertintolm_scvalues(120060150031,'MUST200901,,57);commit;487.n~ᙢᨵᕒselectnamefroms_regionwhereidnotin(selectregion_idfroms_empe,s_deptdwheree.dept_id=d.id)selectr.namefroms_regionr,(selectd.region_idfroms_empe,s_deptd

144wheree.dept_id=d.id)awherer.id=a.region_id(+)anda.region_idisnullselectnamefroms_regionrwherenotexists(select1from(selectd.region_idfroms_empe,s_deptdwheree.dept_id=d.id)awherer.id=a.region_id)488.GᕒḄv᳛᝞.F0.00——1999.990.002000.00——3999.990.094000.00——5999.990.206000.00——7999.990.308000.00——9999.990.4010000.00——11999.990.4212000.00——139999.990.44140000.00orgreater0.45ᑖᵨdecodeacasewhen|}஺selectfirst_name,salary,decode(trunc(salary/2000),0,0,1,0.09,2,0.20,3,0.30,4,0.40,

1455,0.42,6,0.44,0.45)froms_empselectfirst_name,salary,(casewhensalarybetween0and1999.99then0.00whensalarybetween2000and3999.99then0.09whensalarybetween4000and5999.99then0.20whensalarybetween6000and7999.99then0.30whensalarybetween8000and9999.99then0.40whensalarybetween10000and11999.99then0.42whensalarybetween12000and13999.99then0.44else0.45end)taxfroms_emp

146489.emp⊤adept⊤Tᡂ᝞Fᔜ=GḄaA᝞FJOBDEP1L10DEPT_20DEPT_30DEPT_40CLERK121SALESMAN4PRESIDENT1MANAGER111ANALYST2selectcount(decode(deptno,10,sal)),count(decode(deptno,20,sal)),count(decode(deptno,30,sal)),count(decode(deptno,40,sal))fromempgroupbyjobselectjob,max(decode(deptno,10,ent))dept_10,max(decode(deptno,20ent))zdeptno_20,max(decode(deptno,30,ent))dept_30,max(decode(deptno,40,ent))deptno_40from(selectjob,deptno,count(sal)entfromempgroupbyjob,deptno)groupbyjob490.ᨵr=ᩗ▲⊤XT_QXMX:(ᩗ▲vᩗ▲Mb)QXXHQXMC1ᦻdᑏ2ᦻ¢ᢇ

1473ᦈᦻdᑏ4ᦈᦻ¢ᢇᩗ▲■¦ᕒ§¨⊤XT_QXRY,᝞©<¦ᨵ<=ᩗ▲vᑣᙠ«⊤ᨵᩩ®(vᩗ▲vᵨᡝMb)XHQXXHYHMC12°±23°±(°±ᨵ^=ᩗ▲vᦻ¢ᢇaᦈᦻdᑏ)ᑏr=:ᑡA°±ᨵn~ᩗ▲vJᑡAᡠᨵḄᩗ▲.´©᝞FQXXHQXMCµᔲᨵ«ᩗ▲1ᦻdᑏfalse2ᦻ¢ᢇtrue3ᦈᦻdᑏtrue4ᦈᦻ¢ᢇfalseselectm.qxxh,m.qxmc,decode(r.yhmc,‘°"I'true*,'false')fromxt_qxmxm,xt_qxryrwherem.qxxh=r.qxxh(+)andr.yhmc(+)='°±’orderbym.qxxh491.ᦪ¼᝞FBC½¾ᡠ᪗ÂNO.(varchar2)12/12ᓅÀ112/12ᓅÀ212/12ᓅÀ312/13Ãᓅ51

14812/13Ãᓅ5212/13Ãᓅ5312/13Ãᓅ6012/13Ãᓅ70A´©᝞FÄ⌕ÆCa½¾ᡠr᪵v᪗ÂÈÉÊË®ᔠcBC½¾ᡠ᪗ÂNO.varchar212/12ᓅÀ1-312/13Ãᓅ51-5312/13Ãᓅ6012/13Ãᓅ70selectb.BC,b.½¾ᡠ,minb.᪗ÂÍmaxb.᪗ÂÍtfromselecta.*,to_numbera.᪗ÂÍ-rownumccfromselect*fromtorderbyBCv½¾ᡠv᪗Âabgroupbyb.BC,b.½¾ᡠ,b.cc492.⚗Ï|ᡊᵨᡝѾÒÓÔiduserjd(FK)ÕᙽÓÔ

149pricingjd(FK)idlab_login_nameᵨᡝÓÔ×ᳮᕒlab_login_passwordnameididlabjpuser_flagnameuser_statusnamelogin_nameenroll_datelogin_nameloginjDasswordclose_datelogin_passowrdstatusphonephoneemailemailenroll_dateenroll_dateclose_dateclose_datepayment_stylecareernationalitygendercompanyÙÓÔaddress

150post_codepricingjd×ᳮᕒᩗ▲⊤admjd(FK)pricing_namemoduleJd(FK)base_feerate_feepricing_desc⚗Ï|ᡊ1.᪷¼VNÛÜÝAE-RÞcßàA⊤´᪀vcßàxy஺2.ᵨDDLâã|}⊤´᪀ஹxyvᐸäåᵨsequence|}ஹ3.Tᡂᦪ¼æç஺t_adm×ᳮᕒ⊤èᵨjéê×ᳮᕒÓÔÍdropsequencet_adm_id;createsequencestartwith10cache100;droptablet_admcascadeconstraints;createtablet_adm(numberprimarykey,—×ᳮᕒæṹnamevarchar2(32),×}ᕒzMlogin_namevarchar2(10)uniquenotnull,—í®Mlogin_passwordvarchar2(32),í®îṹphonevarchar2(32),—ὶðᵯòemailvarchar2(32),rE-Mail

151enroll_datedate,-óôBCclose_datedate-èᵨ_`Í!insertintot_admvalues(0,*tarena*,*tarena',*tarena','62132839','tarena@tarena.com.cn',sysdate,null);insertintot_admvalues(t_adm_id.nextval,'xuehl','hiloo','abcl23','12345678'*xuehl@tarenaz.com.cn*/sysdate,null);insertintot_admvalues(t_adm_id.nextval,'mull*,'hello1,'$Id3a4',*2345671,1hello@gmail.com*,sysdate,nul1)!insertintot_admvalues(t_adm_id.nextval,'xurg*,*bear','asd3211,,3456789,,*bear@hotmail.com*,sysdate,null);insertintot_admvalues(t_adm_id.nextval,'maci','cheese','er34ty',,4567891,,'cheese@vip.sina.com',sysdate,null);commit;t_moduleÕᙽ⊤èᵨjéêÕᙽÓÔÍ

152droptablet_modulecascadeconstraints;createtablet_moduleidnumberprimarykey,--Õᙽænamevarchar232,rÕᙽMbuser_flagcharrõᵨὅ᪗F0---×ᳮᕒF1----ᵨᡝ!!insertintot_modulevalues1,v×ᳮᕒ×ᳮI0;insertintot_modulevalues2,'Ù×ᳮI0;insertintot_modulevalues3,'ᵨᡝ×÷øI0;insertintot_modulevalues4,vù¾I0;insertintot_modulevalues5,vùúûI0;insertintot_modulevalues6,vᵨᡝü“ø¾I1;commit;/*****************************************************t_adm_rights×ᳮᕒᩗ▲⊤èᵨjéê×ᳮᕒ§ÕᙽḄþÿᩗ▲******************************************************/droptablet_adm_rights;createtablet_adm_rightsadm_idnumberreferencest_admid,--ᳮᕒṹmodule_idnumberreferencest_moduleid,--ᙽprimarykeyadm_id,module_idinsertintot_adm_rightsvalues0,1;insertintot_adm_rightsvalues0,2;

153intot_adm_rightsvalues(0,3);intot_adm_rightsvalues(0,4)insertintot_adm_rightsvalues(0,5);insertintot_adm_rightsvalues(10,2);insertintot_adm_rightsvalues(11,4);insertintot_adm_rightsvalues(12,3);insertintot_adm_rightsvalues(13,5);commit;t_pricing⊤******************************************************ydroptablet_pricingcascadeconstraints;createtablet_pricing(pricing_idnumberprimarykey,-ṹpkpricing_namevarchar2(32)notnullunique,—base_feenumber(5,2),—ᨴbase_durationnumber(3),——rate_feenumber(4,2),-ᵨover_feenumber(4/2),—ᑖᵨpricing_descvarchar2(200)—insertintot_pricingvalues(1,120hour',10,20,2.45,0.01,*2.45yuanper20

154hour,over0.01yuanperminute*);insertintot_pricingvalues(2,140hour,,10,40,4.95,0.01,14.95yuanper40hour,over0.01yuanperminute');insertintot_pricingvalues(3,*lOOhour*10,100,9.95,0.01,'9.95yuanper100zhour,over0.01yuanperminute1);insertintot_pricingvalues(4,•200hour,,10,200,19,0.01,*19yuanper200hour,over0.01yuanperminute1);commit;t.usersᵨᡝ⊤ᵨ!"#ᵨᡝ$%&'()*+'(dropsequencet_users_id;createsequencet_users_idcache100;droptablet_userscascadeconstraints;createtablet_users(idnumber(32)primarykey,—45ṹnamevarchar2(32)notnull,--ᵨᡝ6login_namevarchar2(10)unique,—ᵨᡝ$%&login_passv/ordvarchar2(32)notnull,-ᵨᡝ$%&7ṹstatusnumber(2)notnull,--$%&8᝱(0,-.,1,ᨚ0,2,ᑤ◀)phonevarchar2(32),-ὶ;ᵯ=

155emailvarchar2(32),emailenroll_datedate,—-.>?close_datedate,--ᨚ0>?payment_stylenumber(2),—@ABC0,DE,1,FGH&2,IJKA3,ᐸMcareervarchar2(32),-NOnationalityvarchar2(32),-PQ;RSᙠUVWXYḕ[genderchar,—ឋ]0,ᵱ1,᝕2,`acompanyvarchar2(32),-bcaddressvarchar2(32),—ᙢᙬpost_codevarchar2(16)fIcreateindexusers_phone__indont_users(phone);createindexuser_enroll__date_indont_users(enroll_date);createindexuser_careeront_users(career);insertintot_usersvalues(t_users_id.nextval,*zhangsan1'peach1,*qwel341,0,112347835',*zhangs@hotmzail.com',sysdate,null,0,'student'bj0,'xjuniversity','yananroad',830000);insertintot_usersvalues(t_users_id.nextval,*lisi',*deer*,*sdg254*,0,*12297872,,'lisi@sohu.com*,sysdate,null,2,'it',

156*bj1,1,'abccompany*,*abcstreet,,100000);insertintot_usersvalues(t_users_id.nextval,*wangwu*,*brown*,*cfg853',0,*65397811,,*vzangwu@sina.c0mlsysdate,null,0,*finance',1sh1,0,*cbc','cccstreet,,200000);commit;t_users_servicesᵨᡝO%&⊤ᵨ!"#ᵨᡝO%&'(dropsequenceservices_id;createsequenceservices_idcache100;droptablet_user_services;createtabletuserservicesidprimarykey,—45ṹuser_idnumber(32)referencest_users(id),——ᵨᡝ⊤45ṹlab_login_namevarchar2(10)z-ᵨᡝO%&lab_login_passwordvarchar2(32),-ᵨᡝO%&7ṹlab_ipvarchar2(32)notnull,—%ᘤṹuser_statusnumber(2),-O%&8᝱0,1,ᨚ02,ᑤ◀pricing_idnumberreferencest_pricing(pricing_id),

157—ṹenroll_datedate,—-.>?close_datedate,—ᨚ0>?unique(lab_login_name,lab_ip))createindexservices_user_id_indont_user_services(user_id);createindexservices_pricing_idont_user_services(pricing_id);createindexservices_enroll_dateont_user_services(enroll_date);insertintot_user_servicesvalues(services_id.nextval,1,*3090901','w34erl\*192.168.0.26'0,4,sysdate,nullz)insertintot_user_servicesvalues(services_id.nextval,1,*s090901','w34erl‘192.168.0.23',0,1,sysdate,null)insertintot_user_servicesvalues(services_id.nextval,2,,c090612,,'dhe376\,192.168.0.26,0,3,sysdate,null,)insertintot_user_servicesvalues(services_id.nextval,3,*w091021''s8ekfl,,,192.168.0.23,0,2sysdate,nullz//)commit;493.*ᳮᕒᨵᩗ▲?selecta.name,m.namefromt_adma,t_modulem,t_adm_rightsrwherea.id=r.adm_id

158andm.id=r.module_idorderbya.name494.ᳮᕒᨵᡠᨵᩗ▲selecta.namefromt_admawherenotexists(select1fromt_modulemwherem.user_flag=0andnotexists(select1fromt_adm_rightsrwherea.id=r.adm_idandm.id=r.module_i

159496.ᵨᡝ⌱¤¥O%selectu.name,s.lab_ipfromt_usersu,t_user_servicesswhereu.id=s.user_id497.ᵨᡝ⌱¤ḄO%Ḅ¦§᝞©selectu.name,s.lab_ip,p.base_fee,p.base-duration,rate_feeover_feezfromt_usersu,t_user_servicess,t_pricingpwhereu.id=s.user_idands.pricing_id=p.pricing_id

160ª«CḄ,¬ᑣ®¯131-Oracle°±ᫀᑖ498.ORA-01555Ḅ³´Bµ.¶·¸W¹Gfºឋ»¼499.½$ORACLE_HOME¯$ORACLE_BASEḄ¾]ORACLE_BASE¿oracleḄ᪷ÁY¢oracle_home¿oracleḄÂÃÁY500.᝞©ᑨÅᦪÇÈḄ¾selectdbtimezonefromdual;selectsessiontimezonefromdual;//UᙢḄ¾501.ɽGLOBAL_NAMESÊËTRUEḄᵨ⌶ÊÍËtrue⊤ÎÏÐÑÒÓ▮502.©ÕÖ7PL/SjQLÒᵨ2____________________________________________________——ᢇجLU20I,J503.ɽFUNCTION,PROCEDURE¯PACKAGE¾]Function¯procedure¿pl/sqlÝṹḄÞᔠ¢.Ë¥àᡂf*â%஺Procedure`◤⌕æ·â©f*çᙠèfB☢¢package¿Ë¥àᡂf*ᖪOëìḄfífunction¯proceudreḄÞᔠ504.ɽTABLEFunctionḄᵨ⌶tablefunction¿.¶pl/sqlîïæ·fíXY¢ᵨ!ð.Ḅ⊤/òó஺ôõᵨ!pipeline¯etl¶Ò505.ö3÷ÏÐᦈÞthreeadvisorystatisticsᨵBufferCacheadvice.SegmentLevelstatistics,timedstatistics506.Audittrace#ùᙠ*oracleÁYú᪀S

161#ùᙠunix/rdbms/auditwindowstheeventviewer507.ɽmaterializedviewsḄᵨᵨ_ᢇ=[LU21]:508.üᵨᡝ¹Ò┯¢*þÿᳮ509.ᑵmaterializedviews?510.᝞ᑨsessionᙠḄ511.!"#$redologsᵨ&'(ᦪ*ᦋ,Ḅ-.Ḅᱥᳮ012᪀4ᵨᩭ67ᦪ*8512.᝞9:ᑴLOGSWITCH?ALTERSTSTEMSWITCHLOGFILE;513.>?@ᑨDDLᦋ,ḄABLogminerStreams514.CoalescingCD"#$┐FGᐺIᳮḄtablespace9᦮ᳮ4KLMḄNextentsᔠPᡂᓫḄᜧextent515.TEMPORARYtablespace0PERMANENTtablespaceḄTU$516.VWᦪ*8XY,WZḄtablespace[\systemusers517.ᦪ*81,2,3^Ḅᭆ`aᳮbcd^efg7Ḅᑡci^e⌕kᦪ*8⊤mḄn•9pqrsḄ᪗uTᑖw'ᙠxyz4{ឋ}ᐰDxy

162c^e{ឋ&ᐸxឋ518.!oracle9ᘤḄᓄ⊤▲ᑴ⊤Ḅᭆ`0ᵨ▲ᑴ49ᘤ☢F@⊤ᨵ"#▲ᑴ஺519.oracleLX⊤ᨵ஺LX⊤0⊤Ḅx⌕TUᨵ4ᵨLX⊤Ḅx⌕$"#LX⊤$☟᝱Ḅ4◤⌕nᵨḄX᎛VW4LX⊤ᨵᙠᵨᡝ¢▭ᔣ⊤m¥¦ᦪ*X4§¨©ᐸᑖª'«¬4®⊤$VW⊤¯°±ᑖª¬஺©LX⊤ᑖªḄ$LX⊤¬4ᵨLX⊤q²¦ᦪ*8mᦪ*Ḅᮣ´ឋ4µᑤḄᦪ*·¸520.¹#¢º:d¨¼☢᡻9Ḅ¾¿Àᦪᡈᘤ☢pqÂÃḄᐰÄÅḄᦔÇ4PÈ⌕¢º¨¼◞Ê521.aa,bb⊤pᨵ20GË4ÈÌÍᦪÅpÎᜧ4aa,bb⊤ḄXGËw¬z±ᨵÏÐI,ÑᵨSQLᑡ?aa⊤☢'ᙠḄXᙠbb⊤'ᙠḄXḄÒ4Ñᑏ?Ô©ᨬÖḄ×Ø4PbÙ஺522.!SGAx⌕Úᡂ᪀0ᵨ⌶x⌕ᵫedb_cachewÝ'ᦪ*ᙽz4shared_poolwÝ'᡻9ßᑜ4ᦪ*Gᐺáâzlarge_poolMTSã^ஹparallel-,rman⌕ᵨåUjavapooljavaæ᝞sql'«¿ç9X⌕ᵨᑮz523."#$ᑖT⊤!éᑖT0ᑡ⊤ᑖTḄTU4ᑖT⊤Ḅx⌕êëᨵêìe²:qᵨឋஹᙳ⊝I/Oஹᦋᗐðñឋò஺éᑖT$ᢥ᯿ᑡ⊤mḄᑡḄéᩭᑖT஺ᑡ⊤ᑖT$õ&partitionbylistmᢣ÷ḄᑖTyFᑡ⊤9ᑖT஺524.øùeúᦪ*ç9ᙠarchivelog,Èᵨrmanû¿ᐰᜓý0ᦪ*8Ḅþᜓý4ÈᡠᨵḄ᫏ᨵᑴᦻᐰᐸᦻᐰឮᦪ!"#$஺

163525.ᵨrmanᑏ*ᜓ,-./ᜓ,⊤12TSB,level324Ḅ56ᜓ,ᢇ89:;/<626526.ᨵ*⊤a(xnumber(20),ynumber(20))ᵨᨬ>?@ᦔḄSQLᔣ⊤CᐭE1FGḄHIḄ1000JKLMN*OᑡseqᯠRᙠTUVWXYZ*[6t\3seq.nextval,ᯠR]ᵨsqlinsertintoavalues(t,t);_`1000Ja527.bcdᜓ,efᜓ,ḄghijkᔜmḄnidᜓ,/◤⌕qᣵᦪstᜓ,〉ᔠwxyzḄᦪ஺ni{|}ᓫᦪឋ᫏yzḄ஺fᜓ,/┐᫏yzḄᦪᙠᦪ|stᜓ,஺niᙠᜓ,stᦪ{|ᦪឮᑮw2i஺528.:ᑭᵨᜓ,ឮᦪᨵᑴᦻ᝞xb⚪ᕖNᑴᦻᵨbackupcontrolfilemḄrecoverឮᦪ஺529.᝞xᣚinit.oraᑮspfile?createspfilefrompfile530J?Wdatablock,extentesegmentḄ(¡N¢ᵨ£ᦻ¤-)datablockᦪXᨬ¦Ḅ§¨TUᓫᐗªᦪḄ«◤⌕¬ḄᱥᳮTU12HIḄdatablock°±ᡂ³extent<)*ᦪ«´µḄᡠᨵextents·¸3ᦋ«Ḅsegmento531.º»!*¼½⊤¾᪀Ḅ#$yzdesctableNameselect*fromdba_tab_columnswhereovmer=1CCARE'ANDlower(table_name)=1tablename

164532.᪵᩵ÂᦪÃÄḄÅ┯533.ÇtruncateedeletetruncategÈÉ⌨,deleteÈjÉ⌨,truncateᑤ◀?Î>delete᠒534.ÐᵨÑÃḄᳮᵫ3³>?½Ó᣸O535.º»ᙠSTARSCHEMAXḄ!"⊤kÕÖᑖØᨵḄᦪFacttables^11dimensiontables஺facttableᒹØᜧ6ḄÛ⌕ḄÜÝÞdimensinotablesTßfacttableàáâឋḄÜÝ536.FACTTable9◤⌕Nãx"ÑÃäåÑÃ537.º»!"æᐵèéÛêe᜜ê538.᝞xᙠgìíî⊤ḄïðñN*ò⊤ó⊤Ḅ᜜êôᑴõᦔNò⊤ö÷᜜ê539.bc᫏eø᫏yzù2ḄgheÕÖᔜmḄnúi540.᝞xNã*ᜓ,ᑴᦻ541.º»ᦪûüýþᡠÿᔊḄ᝱542.columnᵨᩭV$GV$543.᝞ᡂexplainplan?

165utlxplan.SQLplan⊤┐ᱯḄSQL!"#$ᵨexplanplansetstatement_id=ztstlzintoplan_tableutlxplp.sqlᡈutIxpl.sql544.᝞&'buffercacheḄ()᳛ᙠᦪ-./01#ᵨbuffercacheadvisory2ᐹ#45V$db_ccache_advice஺᝞78ᦋ#ᵨaltersystemsetdb_cache_size545.:;<=>?ᦪ-.ḄᐵA;⊤CDᦪ-ᦻFḄᐵA=>GHIᭆK#ᒹMᑁOP᪀?RS஺ᦪ-1ᱥᳮᭆK#ᒹMOVWXḄᦻF546.varchar2,charYᦪ-Z[ᨵ]^,᝞7.⊤`abcᐭ“ABC”eVᓄgabᦪ-Z[ᑖivarchar2(10,char(10)OVa⁚klmᑁnᨵvarchar2Ḅklo,charḄklpoVarchar2(10)qrᨵsa⁚#Char(10)ᨵ10a⁚#ᨵ7GCat஺547.talbe:pub(pub_codechar(2),pub_namevarchar2(32))book(book_codechar(8),book_namevarhcar2(128),pub_codechar92),author_codechar(4),book_memvarchar2(128))author(author_codechar(4),author_namevarchar2(10),sexchar(1),agenumber(3),dirvarchar2(64))auth_list(auth_datedate,author_codechar(4))ᙠPL/SQL)ᨵuYavv_book_rowbook%rowtype;v_book_codebook.bank_code%type;:;

166548.Tnsnames.ora,LISTENER.ORAYᦻFᵨtnsnames.oraGnetconfigurationassistantᦪ-.#Listener.oraGᘤḄ#listenererᡂ549.:uOVSbeginbeginீ!"1>exceptionwhenothersdbms_output.put_line('┯r)end;beginv!"2>dbms_output.putline('┯2,);end;exceptionwhenothersthendbms_output.put_line("┯3");end;:#ீ!"1>,v!"2>┯1#gOVScat¡ᑖG]^!"1┯ᡭᓺ“┯1”!"2┯ᡭᓺ“┯3஻550.¦“ὅ”.⊤)©ᨵªᙠ“zᝄ¬ᓫ”.⊤)Ḅᡠᨵὅ¯°ḄSQL!"#(±y:$ᵨNOTIN,NOTEXISTS,m᜜´(+)s·¸),¹;<º·¸Gp»ᓄḄ᱐½:᱐½¾ṹchar(2),᱐½¬Àvarchar2(32)ÁÂÁÃÄchar(8),Á¬Àvarchar2(128),᱐½¾ṹchar(2),ὅ¾Ächar(4),ÁÅÆvarchar2(128)ὅÂὅ¾Ächar(4),ὅ¬Àvarchar2(10),ឋcharপ#ÉÊnumber(3),ᦻË·ᔣvarchar2(64)

167zᝄ¬ᓫÂzᝄÍÎdate,zᝄÏᕒchar4select*fromὅwhereὅ¾ÄnotinselectzᝄÏᕒfromzᝄ¬ᓫÑp»ᓄselect*fromὅwhereὅ¾ÄnotexistsselectzᝄÏᕒfromzᝄ¬ᓫÑselecttl.*fromὅtl,zᝄ¬ᓫt2wheretl.ὅ¾Ä=Ó2.zᝄ¬ᓫÔ+andᓃ2.zᝄ¬ᓫisnullp»ᓄ551.:▊×Ø᫏UÚÛÜ?ÝØ᫏ÍÚÛÜḄmᦪ-.ᜓßឮáâḄãäÝØ᫏ÍÚÛÜpâ᡻ὶ⊤CDḄᦻFᜓß#çpâ$ᵨᐜéᙠØ᫏ÍÚÛÜuḄὶ⊤CDḄᦻFᜓß#᝞7◤⌕ᜓßᦪ-.#qâᐵìᦪ-.íâᑴï᦮Ḅᦪ-.ᜓß஺Ø᫏ÛÜðñÍÚḄØ᫏òâ#᝞7pâóWXᜫõᡠö÷Ḅᦪ-.Ḅøùᜫ#ᑣ◤⌕ᑭᵨØ᫏ÍÚÛÜ552.ORACLEᦪ-.⊤METER)OᙠüᑡRowid,:ᑭᵨROWIDᩭÃᑏu!":ÿᑮḄᩩFLAG“Y”.MONTHUSER_NOASSST_NOFLAG2004-7-1100000910A0001N2004-7-1100000910A0001N2004-7-1100000910A0001N553.ᦋᑏᦪcreateorreplacefunctiontwo_number(v_onenumber,v_twonumber)returnnumberisbeginreturnv_one*v_twoend;ᦪᦋᑏ!"ᦪ᝞$%&createorreplaceproceduretow_number(v_oneinnumber,v_twoinnumber,v_threeoutnumber

168AsBeginv_three:=v_one*v_two;Endtow_number;554.()ᵨᡝ,◤⌕/0ᵨᡝ12ᩗ▲5678ὶ:ᦪ;?@ᦪ;ᦻB556.᝞$CDᦪ;ᦻBḄᜧF557.GHVIEWᵨᩭJKᦪ;ᦻBḄᜧFL558.GHVIEWᵨᩭᑨNtablespaceḄᒕPQRdba_free_space559.᝞$ᑨNST⊤>?@VᩩWLAuditing560.᝞$X᪀Z[LALTERINDEXREBUILD561,]^12_Partitioning`ᑖbcd8ḄefPartitioningᜧ⊤gZ[ᑖᒘᡂF᧕klᳮᑖb562.noopqVHPL/SQLPackager_ᨵ┯uv⍝᝞$xyz┯{|LShowerrors563.᝞$}~⊤Ḅᔜ᝱ᦪ;select*fromall_all_tableswheretable_name='TABLENAMEz564.᝞$DSESSIONḄTRACEdbms_session.set_sql_trace

169altersessionsetsql_trace=true;565.IMPORTgSQULOADER2HᐹḄfH_ᵨᩭᦪ;ᐭᦪ;<ḄḄ_importᐹ6ᜐᳮᨵHoracleᐹexportᡂḄᦪ;sql*LoaderᐭḄḄᦪ;566.ᵨkḄ2HᦻBLtnsnames.oragsqlnet.ora567.ᙠMSSQLServerᵨᩭxyᦪ;<{|Ḅg________________1ᢇLU23£"ὃ¥ᫀ£CAsp_dbhelpBsp_dbCsp_helpDsp_helpdb568.SQL§¨ᑤ◀H⊤Ḅ«¬_(B)ADELETEBDROPCCLEARDREMORE569.ᐵᦪ;<¯°_(_BD_)Aஹ᪗³⊤Ḅ´µBஹ()ḄZ[ᐕ·Q!Cஹᐕ·⊤¸¹º)»Dஹᐕ·ᨵ¼H¯°Ḅ570.ᙠTransact-SQL§½SELECT§¾Ḅ¿᦮§½ÁÂᩖrÄÅᒹÇḄÈᑖ(_1_),7ᵨᐵ°¹(2—)ÉXÂÊË̼HKÍÎÏÐÑHÎÏ~ᔠḄÓÔÕ_(3—)᝞ÏᙠSELECT§¾7ᵨÖᔠᦪ,×ᙠØ☢7ᵨ(4—)o

170(1)AஹSELECT,INTOBஹSELECT,FROMCஹSELECT,GROUPDஹÚSELECT(2)AஹDISTINCTBஹUNIONCஹALLCஹTOP(3)AஹJOINBஹUNIONCஹINTOCஹLIKE(4)AஹGROUPBYBஹCOMPUTEBYCஹHAVINGDஹCOMPUTE571.§¾DBCCSHRINKDATABASE(Sample,25)Ḅ25⊤yḄÛ_Aஹ25MBஹᒕPᓰ᦮HQRḄ25%CஹÝᵨQRᓰ᦮HQRḄ25%Dஹ:Þ572.n_Hß◅áâḄᦪ;<ãäåᕒáâḄßᓫ{|ᙠSQLServer2000ᦪ;<n7ᵨèé)»VHêPolicyḄ⊤£CREATETABLEPolicy(PolicyNumberintNOTNULLDEFAULT(0),InsuredLastNamechar(30)NOTNULL,InsuredFirstNamechar(20)NOTNULL,InsuredBirthDatedatetimeNOTNULL,PolicyDatedatetimeNOTNULL,FaceAmountmoneyNOTNULL,CONSTRAINTPK_PolicyPRIMARYKEY(PolicyNumber))ìíáâ├ïzðßᓫPolicy⊤ñ?@ᩩ/0ᐸHḄßᓫónô2õLa.)»HINSTEADOFINSERTöäᘤᩭøHḄßᓫóHßᓫóùᐭᦪ;⊤஺b.)»HINSTEADOFUPDATEöäᘤᩭøHḄßᓫóHßᓫóùᐭᦪ;⊤஺

171c.)»■HAFTERUPDATEöäᘤᩭøHḄßᓫóHßᓫóùᐭᦪ;⊤஺d.ᵨAFTERUPDATEöäᘤüýDEFAULTþÿᩩḄᓫᓫᐭᦪ⊤஺573.ᙠSQL᝞⌕⊤ᒹ"#$%#&஺'()஺*⌕+()Ḅ,-./0800ᐗᨬᔠ〉Ḅ56789:A.ᙠ;⊤<=II()>ḕBoᙠ;⊤<=II()@ABCC஺ᙠ⊤DEᘤDo=⊤ᦪGᐭHᑏJKLMNᑴ574.SelectPᵨᩭST(UVḄU9.A.—+IIB.—&IIC.—1|IID.—|I575.W9X᱐Z[Ḅᦪ\]E^ᕒ`ᱯbḄc%ḄdᜩḄ├ghij᝞kḄlmnJ:CREATEPROCEDUREget_sales_for_titletitlevarchar(80),@ytd_salesintOUTPUTASSELECT@ytd_sales=ytd_salesFROMtitlesWHEREtitle=@titleIF@@ROWCOUNT=0RETURN(-1)ELSERETURN(O)o᜜jqᩈ᡻MlmnJ᝞᡻Mᡂuvw`x0c%ḄdᜩḄ├ghiḄy⊤᝞᡻Mᜫ{vwNoSalesFoundII,|᪵q~A.DECLARE@retvalintDECLARE@ytdint

172EXECget_sales_for_title_NetEtiquette',@ytdIF@retval<0PRINT_Nosalesfound,ELSEPRINT_Yeartodatesales:4+STR(@ytd)GOB.DECLARE@retvalintDECLARE@ytdintEXECget_sales_for_title_NetEtiquette',@ytdOUTPUTIF@retval<0PRINT_Nosalesfound4ELSEPRINT_Yeartodatesales:*+STR(@ytd)GOC.DECLARE@retvalintDECLARE@ytdintEXECget_sales_for_title_NetEtiquette',@retvalOUTPUTIF@retval<0PRINT_Nosalesfound,ELSEPRINT_Yeartodatesales:4+STR(@ytd)GOD.DECLARE@retvalintDECLARE@ytdintEXEC@retval=get_sales_for_title_NetEtiquette4,@ytdOUTPUTIF@retval<0PRINT_Nosalesfound4ELSEPRINT_Yeartodatesales:4+STR(@ytd)GOc576.᝞Ḅ⊤.Uᔠ..—ᦪᑍ____,

173—ᐭᑤ◀஺577.SQL9DDL,____DML________DCL_ᡂ஺578.SQLServerᙠᐰ+ᵨᡝᑖ9_windows¡¢+£,¤ᔠ£O579.¥b¦§ᦪᵫ§ᦪ§ᦪ§ᦪᡂ஺580.ᜓ¢ªᶍḄ¬®¯9ᜓ¢ᜓ¢_____________________ᜓ¢ᡂo°I±I²³581.´µ¶·¸ḄP=,¹º·¸ḄP=,w»·¸ḄP=_______begintransaction|commit|rollback582.⊤ḄdMᙠ⊤9¼Ḅ5½¾0¿᦮ឋÂᑡḄGᐭᨵᦔ¾0¿᦮ឋ.⊤ḄÆᐵÈ(᜜ᐵÈ(ḄᦪxÉ`x¾0___________¿᦮ឋ஺5½ÊË᯿583.ᙠÍÎÏ…nÑÒ9ÓÔ?584.Ö×Ø•kÚ:ÛÜÝḄᑡÚ:⌕ßᦪ\⊤ḄdMàáâ¼Ḅ᪗äåᑖælᙠÈç,¾ឋ¿ᐰèé0ÆÈ585.6ᨵ1├g⊤êëì᪀᝞k:î4ᑖç

174idintî᪗äçcodnochar(7)îᖪðHṹçcodnamevarchar(30)îᖪð%&çspecvarchar(20)îᖪðòóçpricenumeric(10,2)îôóçsellnumintî├gᦪõçdeptnochar(3)îgXᑖöHṹçselldatedatetimeî├g<÷ç⌕ß:ᑏXAø├g<÷)ᙠ2002-2-15ùᑮ2002-4-29û÷ᑖöHṹ901Ḅᡠᨵýþ586.ᑏlmnJ⌕ßÿᐭ⊤⊤Ḅᦪ(ᎷᐭḄ⊤ᙠᦪJLU24ᙠ)CreateorreplaceproceduregetTableRows(tablenameinvarchar2(29),row_countoutnumber)AsBeginRow_count:=selectcount(*)intorow_countfromtablenameEndgetTableRows;587.UPDATEᘤ᝞#$%&ᳮ஺588.)ᵨ+ᩩSQL-./ᑮ12Ḅ3412Ḅ5ᦪᨵ+ᦪ⊤ZD_ks,ᐸᨵ89BM,MC,o<,o,;<=ᙠZD_ksBMᨵ12Ḅ3412Ḅ5ᦪ>ᨵḄ?⌕ᑡ=஺᝞B⊤BMDUPCOUNT00130022589.⊤1studentCDEF⊤IDintCDGHNamevarcharCDI

175SexbitឋKLᵱ஺᝕1ClassintOPGH⊤2scheduleQREF⊤IDintQRGHNamevarcharQRS⊤3GradeᡂUEF⊤IDintVWGHUIDintCDGHSIDintQRGHNumintὃYᡂUaZᔜOḄ\]ᦪbZ1O᝕D^ᵱDḄ_ᙳᡂUযᔜO”ᦪc᪀”LQRSe?4fḄ]ᦪ590.g⚪ᵨᑮB☢jᐵl⊤CARDmnᓱ஺CNOᓱHNAMEICLASSOPBOOKSpn஺BNOnHBNAMEn,AUTHOR%ὅPRICEᓫQUANTITYsᦪBORROWmn஺CNOmnᓱHBNOnHRDATEtnuvᜓx▲z{]{|n}~m+gsᦪmnஹtnᦋ஺⌕Z᝞B15ᜐᳮ1./=mn5gḄὅ=mnᓱH4ᡠmpnsᦪ஺2.;ᨵm”¢⚪£”Ḅὅ=ᐸmnᓱH¤ᢥᓱH¦§᣸§=஺7.©“C01"OªCᡠmpnḄtv«¬+ᕜ஺8.¯BOOKS⊤ᑤ◀²]m▅Ḅpn஺9.ᙠBORROW⊤³´µ+ᘤ¶ᡂ᝞B·~᝞¸ὅm▅Ḅn¹"ᦪᢈ»4¼ᵨ”½©ὅḄm▅¾ᙠBORROW_SAVE⊤LxORROW_SAVE⊤

176c᪀ªBORROW⊤e஺10.´µ+¿pÀÁ“Â01”OCDḄmnEFL}⌕ZÀÁI^ne஺11.;<ªÃmᨵ“"^“ÄᔠᦪC”ÆgnḄὅ=ᐸmnᓱH¤ᢥᓱHᓣ§᣸§=591.SQL-ȹLBḄ-ÈÉ᧕C¢஺A.RᓄB.ÌRᓄC.fÍᓄD.ÎÏÍB592.SQL-ÈḄᦪÐÑ-.ᒹSELECTஹINSERT.UPDATE.DELETEÒ஺ᐸᨬ1⌕ḄÓ¹)ᵨᨬ⚣ÕḄ-.¹LAeoA.SELECTB.INSERTC.UPDATED.DELETE593.ᙠ¿p³?~¶ᡂḄÐ%¹LCoA.Ö׿pB.;

177C.CLEAR0.REMOVEB596.ᙠSQL-ÈḄ¿pVIEW¹ᦪḄ(A)஺A.᜜áÍB.áÍC.ᑁáÍD.ãáÍ7.BᑡḄSQL-.(D)?¹ᦪzØ-.஺A.CREATETABLEB.DROPVIEWC.CREATEVIEWD.GRANTA597.ä⌕å├ᦪçèᙠḄ⊤S,éᵨ(C)஺A.DELETETABLESB.DELETESC.DROPTABLESD.DROPSc598.ä⌕ᙠêg⊤Sëì+ᑡCN(QR)éᵨ(C)஺A.ADDTABLES(CNCHAR(8))B.ADDTABLESALTER(CNCHAR(8))C.ALTERTABLESADD(CNCHAR(8))D.ALTERTABLES(ADDCNCHAR(8))c599.CDᐵláÍS(S#,Sname,Sex,Age),SḄíឋᑖK⊤ÁCDḄCHஹIஹឋKஹïð஺⌕ᙠ⊤Sᑤ◀+íឋ+ïðII,é⌱ᵨḄSQL-.¹(B)oA.DELETEAgefromSB.ALTERTABLESDROPAgeC.UPDATESAgeD.ALTERTABLES_Age,B

178600.ᨵᐵlS(S#,SNAME,SAGE),C(C#,CNAME),SC(S#,C#,GRADE)஺ᐸS#¹CDHSNAME¹CDISAGE¹CDïðC#¹QRHCNAME¹QRS஺⌕;<⌱ò+ACCESSIIQḄïð?óÛ20ḄᐰÜCDIḄSQL-.¹SELECTSNAMEFROMS,C,SCWHEREõ.஺ö÷ḄWHEREõ.Ḅᑁɹ(A)oA.S.S#=SC.S#andC.C#=SC.C#andSAGE>=20andCNAME=_ACCESSlB.S.S#=SC.S#andC.C#=SC.C#andSAGEin>=20andCNAMEin.ACCESS'C.SAGEin>=20andCNAMEin.ACCESS'D.SAGE>=20andCNAME=ACCESS,A601.ᐵlᦪ+⊤SḄc᪀øS(SN,CN,grade),ᐸSNøCDCNøQRùὅᙳø8úgradeøᡂUᦪ3û3ý0—100஺ä⌕þ“ÿḄᓄᡂ80ᑖ”ᣓ\Sᵫᵨ(D)oA.ADDINTOSVALUES(''‘ᓄ‘'80')B.INSERTINTOSVALUES(‘‘ᓄ''80')C.ADDINTOSVALUES(''ᓄ'80)D.INSERTINTOSVALUES(''ᓄS80)D

179602.ᐵᦪ⊤SḄ᪀"S(SN,CN,grade),ᐸSN"$%,CN"'(%ὅᙳ"+,-.grade"ᡂᦪ/-0/20—100஺4⌕678Ḅᓄᡂ"85ᑖᑣᵨ(A)஺A.UPDATESSETgrade=85WHERESN='8'ANDCN='ᓄB.UPDATESSETgrade='85'WHERESN='8'ANDCN='ᓄC.UPDATEgrade=85WHERESN='8'ANDCN='ᓄD.UPDATEgrade='85'WHERESN='8'ANDCN='ᓄA603.ᙠSQL;<=>?@(D)஺A.ABᓫ⊤ᦪ=DḄE?;?;IC.⌱0ᓫ⊤+H=DḄ>?;ID.JᐭᑮM᩵?;IOḄ>?;I604.SQL@P(C);<஺A.QRSTB.UVWXC.ᐵᦪD.Yᦪ-c605.ᨵᐵS(S#,SNAME,SAGE),C(C#,CNAME),SC(S#,C#,GRADE)஺ᐸS#@$[SNAME@$\%SAGE@$]^C#@'([CNAME@'(%_஺⌕>?⌱`ACCESSII'Ḅ]^

180abc20Ḅᐰe$\%ḄSQL;I@SELECTSNAMEFROMS,C,SCWHERETI஺fgḄWHERE=IḄᑁi@(A)oA.S.S#=SC.S#andC.C#=SC.C#andSAGE>=20andCNAME=_ACCESStB.S.S#=SC.S#andC.C#=SC.C#andSAGEin>=20andCNAMEin_ACCESS,C.SAGEin>=20andCNAMEin.ACCESS'D.SAGE>=20andCNAME=ACCESS4A606.jk@lm⊤njk@opnqὅḄrstὶ@jkn607.vwopḄxyopz{|▬~Ḅᐰ஺opz◚ᦪḄᩖឋ஺opᨵ%Ḅ஺opᩭ6ᦋḄᮣឋ6ᦋᡂopḄᡈG⊤Ḅᑁiaᵨ6ᦋᵨ(஺608.ᡠᨵḄop@ᔲz6n"jkna@"ᨵopḄᦪ@q⊤ᡈὅqz•Ḅ⊤YᦪᔠᙠḄᦪ஺609.¡¢op@z6Ḅ¡¢op@a6Ḅnᔜ¤¥¦§¨᝞ᦪ@ªq⊤ᡈG⊤YᦪᡂḄ«aX6ᦪᩭ¬ᓫ⊤ᦪ«z6610.vw®¯៉Ḅ±▭³´op6Ḅµ¶ᐕ¸ᦪᩭ¬ᓫ⊤6611.¹⚪»w¼½ᐵ¾¿S(SNO,SNAME)$ᐵ஺SNO"[SNAME"\%C(CNO.CNAME.CTEACHER)'(ᐵ஺CNO"'([CNAME"'(%CTEACHER"À'ᦟÂSC(SNO,CNO,SCGRADE)⌱'ᐵ஺SCGRADE"ᡂ⌕ñÄ᝞Å5ᜐᳮ1.ÈÉÊᨵ⌱`˧IIὁÂÍᣴ'(Ḅᡠᨵ$\%

181selects.snamefromswheres.snoin(selectsnofromscwheresc.enonotin(selectenofromcwherec.ctecher='˧'))2.ᑡÉᨵÑz(ÒqÑ)aÓÔ'(Ḅ$\%ÓᐸÕᙳᡂselectsname,avgfroms,(selectsno,avg(segrade)avgfromscwherescgrade<60andcount(sno)>=2goupbysno)twheres.sno=t.sno3.ᑡÉÖ1II['(×2II['(Ḅᡠᨵ$\%selectsnamefromswheresnoin(selectsnofromscwherecno=2andsnoin(selectsnofromscwherecno=l))4.ᑡÉ1II['ᡂ¨2II[ØÙÑ'ᡂQḄᡠᨵ$Ḅ[selectsnofromsc,(selectsno,segradefromscwherecno=l)twherecno=2andt.sno=sc.snoandsc.scgrade

1822.ìᵨ᪗îSQLJᝅ;I>?⌱`'(ê["‘C2'Ḅᕒ\%tᡠéᓫÝselectsn,sdfromswheres#in(selects#fromscwherec#='c2')3.ìᵨ᪗îSQLJᝅ;I>?a⌱`'(ê["‘C5’Ḅᕒ\%tᡠéᓫÝselectsn,sdfromswheres#in(selects#fromscwherec!!='C5Z)4.ìᵨ᪗îSQLJᝅ;I᩵?⌱`ᐰô'(Ḅᕒ\%tᡠéᓫÝselectsnsdfromswheres#in(zselects#fromscgroupbys#havingcount(s#)=(selectcount(*)fromc))5.>?⌱`õ'(ḄᕒUᦪselectcount(s#)fromscgroupbys#6.>?⌱`'(ö5ÑḄᕒ[tᡠéᓫÝselects.s#s.sdfroms,(selects#,count(s#)cfromscgroupbys#)sswhererss.s#=s.s#andss.c>5613.⊤table1(Fld,Fclass,Fscore),ᵨᨬQᦔᨬᓫḄSQLᑡÉᔜùᡂᨬQḄᑡ⊤úûùRᡂq+Hselectfclass,max(fscore)fromtablelgroupbyfclass;614.ᨵ⊤tablelᨵq+HFID,Fno,+üýᑏSQL;IᑡÉÙ⊤FID´GaØḄFnoḄÿ஺᝞101a1001

183101a1001102a1002102a1003103a1004104a1005104a1006105a1007105a1007105a1007102a1002102a1003104a1005104a1006selectt1.fid,fnofromtableltl,(selectfid,count(fno)cfrom(selectdistinctfid,fnofromtablel)tgroupbyt.fid)ttwherett.c>landtl.fid=tt.fid615.ᨵᕒ⊤empinfo(Fempnovarchar2(10)notnullpk,Fempnamevarchar2(20)notnull,Fagenumbernotnull,Fsalarynumbernotnull)Ꮇ᝞ᦪᜧ1000ᩩ:ᑏᨬ!ᦔḄSQL,ᵨSQL%&'()*+fsalary>9999andfage>35fsalary>9999andfage<35fsalary<9999andfage>35fsalary<9999andfage<35

184,*ᕒḄᦪ;616⊤A./᝞(monthpersonincomeᨴ1+ᕒᦈᐭ⌕5ᵨSQL6789:;<Ḅᜐᡠᨵ+8?@ᑖ+ᕒ<,ᨴBCᨴD(ᨴḄEᦈᐭ⌕5ᑡ⊤GHᨴ1IᨴᦈᐭCᨴᦈᐭ(ᨴᦈᐭ617⊤BC1c22005-01-0112005-01-0132005-01-025⌕5Ḅᜐᦪ2005-01-0142005-01-025ᔠ%9Kᵨ•Sql67Mᡂ஺618.ᦪO1,2,3QḄᭆSTᳮV஺WQXYZḄᑡW[Q⌕5ᦪO⊤\Ḅ,]^_'`aḄ᪗c@ᑖ8dᙠfg

185ᑖd¡¢£h¤⊤;⊤'¥¦§Cᑖ¢£஺⊤ᑖḄ;⊤¢£h|ᵨ⊤_'¨ᦪO\ᦪḄᮣªឋh«ᑤḄᦪ®¯621.°±:|²}☢᡻]Ḅ´µ¶·ᦪᡈuvᘤ}☢^_'¹ºḄᐰ»xḄᦔh¼½⌕±²£◞¿622.aa,bb⊤^ᨵ20./h½Àᦪ^ᜧhaa,bb⊤ḄX./8r¢

186Channel=dlDatabase;Releasechanneldl;}627.ᨵ⊤a(xnumber(20),ynumber(20))ᵨᨬ,-.ᦔḄSQLᔣ⊤1ᐭ3145Ḅ67Ḅ100089:஺;<ᑡseqᯠ?ᙠABCDEFGH)tI'seq.nextval,ᯠ?Jᵨsqlinsertintoavalues(t,t);LM10008N628.WhichSELECTstatementwillgettheresult'elloworld*fromthestring'HelioWorld'?A.SELECTSUBSTR('HelloWorld',1)FROMdual;B.SELECTINITCAP(TRIM('HelloWorld',1,1))FROMdual;C.SELECTLOWER(SUBSTR('HelloWorld',1,1)FROMdual;D.SELECTLOWER(SUBSTR('HelloWorld',2,1)FROMdual;E.SELECTLOWER(TRIM('H'FROM'HelloWorld'))FROMdual;E629.WhichtwostatementsaretrueregardingtheORDERBYclause?(Choosetwo.)A.Thesortisinascendingorderbydefault.B.Thesortisindescendingorderbydefault.C.TheORDERBYclausemustprecedetheWHEREclause.D.TheORDERBYclauseisexecutedontheclientside.E.TheORDERBYclausecomeslastintheSELECTstatement.F.TheORDERBYclauseisexecutedfirstinthequeryexecution.AE630.WhichtwotaskscanyouperformusingonlytheTO_CHARfunction?(Choosetwo.)

187A.convert10to'TEN'B.convert'10'to10C.convert'10'to'10'D.convert'TEN'to10E.convertadatetoacharacterexpressionF.convertacharacterexpressiontoadateCE631.Whichoperatorcanbeusedwithamultiple-rowsubquery?A.=B.LIKEC.BETWEEND.NOTINE.IsF.<>D632.Whichthreestatementsaboutsubqueriesaretrue?(Choosethree.)A.Asinglerowsubquerycanretrieveonlyonecolumnandonerow.B.AsinglerowsubquerycanretrieveonlyonerowbutmanycolumnsC.Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.D.Amultiplerowsubquerycanbecomparedusingthe">Moperator.E.AsinglerowsubquerycanusetheINoperator.F.Amultiplerowsubquerycanusethe"="operator.CDE633.Basedonthefollowingconditions,whichofthefollowingwillmakeatruecondition?lastnameLIKEMa%

188A.MADNESSB.ManC.MARYD.maryE.MandyD634.WhichofthefollowingSQLstatementscancalculateandreturntheabsolutevalueof-33?A.SELECTABS(-33)"Absolute"FROMDUAL;B.SELECTABS(-33),AbsoluteFROMDUAL;C.SELECTABS(”-33")AbsoluteFROMDUAL;A635.WhatdoesthefollowingSQLscriptdo?SELECTAVG(MAX(salary))FROMemployeesGROUPBYdepartmentjd;A.ithasasyntaxerror,theAVGclauseisnotvalidB.itcalculatestheaverageofthemaximumsalariesofallthedepartmentsC.ithasasyntaxerror,theMAXclauseisnotvalidD.ithasnoerror,buttheGROUPBYclauseisnoteffectiveE.ithasnoerror,buttheAVGclauseisnoteffectiveF.ithasnoerror,buttheMAXclauseisnoteffectiveB636.WhichthreeSELECTstatementsdisplay2000intheformat,,$2,000.00"?(Choosethree.)A.SELECTTO_CHAR(2000,'$#,###.##')FROMdual;B.SELECTTO_CHAR(2000,,$0,000.00')FROMdual;C.SELECTTO_CHAR(2000,,$9,999.00')FROMdual;D.SELECTTO_CHAR(2000,,$9,999.99')FROMdual;E.SELECTTO_CHAR(2000,,$2,000.00')FROMdual;F.SELECTTO_CHAR(2000,'$N,NNN.NN')FROMdual;

189BCD637.PᑏᐰRSᦪf_center(),Tᦪaw_window'windowUVWXYZE஺638.PBE᝞\A]ImageᡈTextUVḄᦪ_`aG஺639.᝞\bcᦪXYdᔲfgᦋ஺Ifdw.deletedcount()>0ordvz.modifiedcount()>0then....640.PᑏᐰRSᦪf_getparentwindow(),Tᦪ1apo_parm'PowerObjectUVTᦪ2aw_parent'windowUViTὃkl⌴ᢕ]apo_parmḄ᱄XY(qrstd᱄XYuv᱄wx)yzaw_parento641.⊤{'tab1ᐸEᨵ}~'code,ᑏᩩSELECTᢥcode3ᑮᜧ᣸<Ḅ10ᩩ9:ᢥcode3ᜧᑮ᣸<(⌱ᡠᨵ}~)selectt.*FROM(selecttl.*FROMtabtlWHEREROWNUM<=*10'ORDERBYtl.code)tORDERBYt.codeDESC;642.ᨵ⊤t_customer,᫏code'Varchar(20),name'Varchar(40),Code'ᑏᩩSQL!"ᑤ◀namecodecodednamewḄᨬᜧIḄ9:஺(▲ᩩSQL!")DELETEt_customertWHEREconcat(t.code,t.name)IN(SELECTconcat(MAX(t2.code),t2.name)FROMt_customert2WHEREt2.nameIN(selecttl.nameFROMt_customertlHAVINGcount(t1.name)>1GROUPBYtl.name)GROUPBYt2.name);643.ᙠ⊤inv_trans_detailᘤ1ᐭ¡ᧇ£¤;Ainv_current_stock<,lnv_trans_detailḄ¥᧕ᦪ)'qty_trans,§¨k'operationjype,©]“+“U”¬I᝞'"+"ᑣ(¯A᝞'

190ᑣ°±A᝞'“U”ᑣ(¯A²᪷QtyjransḄ´µ¶▭(¯/°±A¹஺lnv_current_stockḄAᦪ)'qty_current«⊤ipart_no6º»ᩭ஺644.ᙠMSSQLSERVER7ḄMRPIIᦪ²ᡈSybaseAdaptiveServerAnywhereḄEASDemoDBV3ᦪ¹ABCDᢕ]ᦪEᡠᨵ⊤½¾¿ÀABCD{'usp_getusertable,ᙠPBEᵨusp_getusertableÁᦪÂᦪXYwx⚜Äᦪ஺1.ÅÆÇᨵ14ᙽ73GḄÅÆᦪ'200GᜧᒹÊËÌᦻ᝞\ÀÍÅƲ⌕GÏ14ÅÆdÐÑᵨḄ¹Ò2.ᨵÓÔᘤÕÖᑖØ'nodel½node2Ùᙠ⌕ᡭwin200ÛÜ⊡Þᡭß?⌕;àZ᝞\ᡭ⊡ÞáâãᵨᡝWᵨ²⌕ᵨÕÖḄå!æçG¹஺3.ᨵAᦪᑖØᑴᑮB½CB⌕èéNᦪ¤;꣤;Céᜩ¤;Nìí᝞\ᑴîᑴïᶍñ4.ᨵorder⊤ᨵ90}~20òó15ᔠòóᐸEᨵ3òó}~õC10᝞\öí÷ᓄ64^5.ᨵᦪ200Gᜧ,éᜩ(¯50Mᐕûᵨᡝü£ýþᑴîᜓïᶍ²æ*----'Ḅ⚗஺ᳮ50ᦪᦪᔲ"ᡂ$%᝞'"ᡂ(⚗^----*Ḅ⚗+,-./012ᦪ3456Ḅ789:9:;<=>?ᵨ/012ᦪ9:;<=..TḄB⍝ᑮ>?ᵨ3456

191------©Ḅ⚗116S2.8,_FGFUNCTION,PROCEDUREPACKAGE78______ªḄ⚗«1¬65&HIJKᑡḄMNOḄPL/SQLPQR:ᑏ+seq.currval.—IḄ⚗654.9.ORACLEᦪTUVORACLEᵨᡝḄᐵY+10.Z[ᦪ\/][^Ḅtablespace_`+System11.Z[ᵨᡝ\◤⌕cdeᵨᡝ9:ᩗ▲h?ijk-ᦪ+connect12.lmtruncatedeleteno+truncatepqr⌨deleteqtr⌨truncateᑤ◀wxydelete᠒13.IMPORTSQL*LOADER(2JᐹḄp|}+.ߟ..Ḅ:H65al4.~BᦪḄᐵ?.᜜—(Ḅ⚔¬°ḄVᵨ+ᑖ..ᵨywᦪ------TḄ:⚗◀HIJḄᨬ3JḄ2ᦪ9:+substr(str,-3)-------Ḅ⚗H6627.HMNY\}(pᒹᨴ)ḄSQLᑏR᪵Ḅ+selectto_char(sysdate,,DDHH24:MI:SSr)fromdual;.—[Ḅ⚗]66&⌹_£rᜧ¥¦¥NḄᨬ§᦮ᦪO+19.µ᪷·ᣚ¹º»ᑣ1A'·ᣚ'ᵱ\B'·ᣚ'᝕,,ᐸ·ᣚ‘ÄÅ’Çᵨ.JSQLPQᑏB஺

192Selectdecode(sex,'A','ᵱ᝕ÄÅ')______”Ḅ⚗áâᔆ66&20.᝞'ÈBNNᩩÊË+Select*fromuserwhererownum>N;-..*Ḅ⚗II66&2L_᝞'ÈBÌNbMᩩÊË+.Ḅ⚗667.22.R᪵ᵨSQLPQTÍÎ.ᑡÏḄÌNᜧO+--1Ḅ⚗66&ᳫSQLServer3456VÑÒᘤḄᵨVÔÕ}«.---Ḅ⚗⃭æ66324.᪗×ḄSQLVT-SQLḄ78+ᑏB4JSQLno3JT6QLno+Ḅ⚗67825.ᦪ⊤userpkIDintName(char)Age(int)Sex(bit)(1)sex=0,age=20ḄnameÙKSelect*fromuserwheresex=0andage=20orderbynamedesc;(2)Msex=1\,age+1updateusersetage=age+1wheresex=1;(3)ᑤ◀ᡠᨵ᜻ᦪ(4)Ýage>20ḄJᦪSelectcount(*)fromuserwhereage>20(5)ÞᨬᜧḄßḄ_Selectnamefromuserwhereage=(selectmax(age)fromuser)26.3456ÔÕ}

当前文档最多预览五页，下载文档查看全文

此文档下载收益归作者所有

当前文档最多预览五页，下载文档查看全文
温馨提示：
1. 部分包含数学公式或PPT动画的文件，查看预览时可能会显示错乱或异常，文件下载后无此问题，请放心下载。
2. 本文档由用户上传，版权归属用户，天天文库负责整理代发布。如果您对本文档版权有争议请及时联系客服。
3. 下载前请仔细阅读文档内容，确认文档内容符合您的需求后进行下载，若出现内容与标题不符可向本站投诉处理。
4. 下载文档时可能由于网络波动等原因无法下载或下载错误，付费完成后未能成功下载的用户请联系客服处理。
最近更新
更多
大家都在看
近期热门
相关标签

首页

分享

客服

关闭