历年真题真题答案

《历年真题真题答案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

ᔊ
⚪ᫀ2006
1ᦪAᔁஹᓫ⚗⌱⚪!"⚪1ᑖ$ᐳ20ᑖ12345678910ABCCAABBBA11121314151617181920BCDADDDCCA/ஹ0⚗⌱⚪!"⚪1ᑖ$ᐳ10ᑖ$┯⌱ஹ2⌱$ᙳ45ᑖ1ABE6ABDE2BE7BC3ABDE8ABC4CDE9ADE5ACE10BDE7ஹᑨ9:⚪᝞<=$⌱᝞┯>$⌱;X஺!$ஹ⚪1ᑖ$ᐳ10ᑖ12345678910VVXVXVXXXXCஹDE⚪!E2ᑖ$ᐳ20ᑖজ“*”ঝthisform.textl.value#thisform.text2.valueঞUSEstock994INTvalde/2ঠSKIP©SFGZ,TAXঢREPLACErsWITHTAXণENDCASEতJ=1TO9থK=1TOJ|ஹ}ᑏ:!"⚪4ᑖ$ᐳ20ᑖ1.11235813212.19990130010160186.0-6062378.0-6010175.0~3.200856884.᪥ὃ2006ὃ5.eᡂ99012Cᑡᳮ6599012C70

1ஹ⚪(20ᑖ)ὃᫀsettalkoffselect1USExbselect2usexaindexondetoibhselect1setrelaTOdeINTOBgotopdowhile.not.eof(1)sele2if.not.eof(2)ifA—¨᪗ªrepl«¬with«¬+a-ுᦪ¬elserepl«¬with«¬-a-¨ᦪ¬endifendifSELE1skipenddocloseallreturn

22007-01ὃᫀᑖ᪗ஹᓫ⌱⚪(30ᑖ$!"⚪1ᑖ)1234567891011121314151617181920ACDDCBADBDBACCDCCBDA21222324252627282930ADADCBCCBC/ஹᑨ¯°⚪(10ᑖ$4±"⚪1ᑖ)12345678910VXJXVXXXVJ7ஹDE⚪(20ᑖ$!E2ᑖ)1.(1)min(²³)(2)“ᦟᣴ"$¸¹ᡈ¸¹="ᦟᣴ"0R¸¹="»ᦟᣴ"(3)>=502.(4)date()(5)Endcase(6)coth3.(7)withᦪ$ᦻ,zf(8)skip4.(9)avg(ᡂ)(10)groupbyÀeCஹᑖ᪆(20ᑖ$!"⚪5ᑖ)1.ឋÃÄÅᑖÆ⃫᝕1Ä5202.1+1+2+1+2+3+1+2+3+4+1+2+3+4+5+=353.2030401002004020344.8|ஹ(20ᑖ)(1)8ᑖ$Éᑖ᪗ÊËÌÍ4ᑖ$ÎÏ3ᑖ$Ð1ᑖclears=lforn=lto5s=s*nendfor?”5Ḅ▤ÏÔ”$sreturn(2)12ᑖ$Éᑖ᪗ÊÕÖ4ᑖ$×Øᐵὶ4ᑖ$ÛÅÜÐ4ᑖclearselect1userxsreplaceall⃩Þßwithᦪ¬*ᓫàselect2useyyyindexon⃩Þᕒâṹtagdmselectrxssetrelationto⃩Þᕒâṹintoyyyaccept"Ðᐭ⃩Þᕒâṹ"todm?”âṹ”+dmlocatefor⃩Þᕒâṹ=dm?“”+yyy.+“å”+yyy.ឋÃListæ,⃩Þßfor⃩Þᕒâṹ=dmoffsum⃩Þßtox1for⃩Þᕒâṹ;dmr⃩Þß”,xiCloseallreturn

307-2ὃᫀஹᓫ⌱⚪1234567891011121314151617181920cBABBBBBDCcDACBDCBBC21222324252627282930DDABCBAABC/ஹᑨç⚪1-5XJXXX6-10VXVVV7ஹDE⚪1(1)'ᦟᣴ'$¸¹(2)min(²³)(3)
éு/50or²³/D2(4)exit(5)delete3(6)├ëà*├ë¬(7)and(8)2(ᡈὅ├ë¬)4(9)notឋÃ(10)t=t+lCஹᑖ᪆1.72135492.5222203.íîïðᙠ4.123ul75456u2110789u3300|ஹ(1)Éᑖ᪗ÊËÌÍ4ò$Îó3ᑖ$Ð1ᑖCLEARS=0FOR1=1TO100STEP2S=S+IENDFOR?”100ôᑁḄ᜻ᦪÜÔ”$SRETURNফÉᑖ᪗ÊËÌÐᐭ4ᑖ$×Øᐵὶ4ᑖ$Ð4ᑖøù1ᑭᵨVFPüýCLEARSETSAFETYOFFCLEARALLSELE1USEXSDAINDEXONeTAGXHSELE2

4USEXSCJSETRELATIONTOeINTOXSDADOWHILE.T.ACCEPT"ÿᐭḄ”TOXHIFLEN(ALLTRIM(XII))=0EXITENDIF?”!"ᡂ$”SCANFOR'XH?XSDA.)XSDA.)!")ᡂ$ENDSCANENDDOCLOSEALLSETSAFETYONRETURN,-2ᑭᵨSQL2345CLEARALLDOWHILE.T.ACCEPT“9ᐭḄ”TOXHIFLEN(ALLTRIM(XII))=0EXITENDIFSELECT))!")ᡂ$:FROMXSCJ,XSDAWHEREXSDA.'XHANDXSCJ.'XSDA.TOSCREENENDDO

52008-01=>?ὃAᫀCஹᓫ⚗⌱H⚪1-5CCBDA6-10ADCAC11-15BBDCB16-20BABAD21-25BDCBD26-30BCCDB'ஹᑨQ⚪1-5JJJXX6-10XXJXJRஹST⚪l(l)x%800(2)n=n+12(3)thisform.textl.value(4)thisform.text2.valuer(5)thisform.release3(6)tagi(7)noteof()(8)BH,KI,K2,K3,K1+K2+K34(9)at(si,m)=0(10)return.t.mஹn"o1.752.010᝕893.***************4.1020302430423rஹ"ost1.CLEARINPUT஻9ᐭNḄv஻TONS=0T=1DOWHILET<=NS=S+TT=T+1ENDDO?஻l+2+3+....+N஻)S2.CLEARCLEARALLSETSAFEOFFSETTALKOFFSELECT1USEXS

6INDEXONTAGXHSELECT2USEKCINDEXON!"TAGKCHSELECT3USECJSETRELATIONTOINTOXSSETRELATIONTO!"INTOKCADDITIVEACCEPT”ᐭ!""TOKCHLOCATEFOR!"=KCH?”⌱{Ḅ!""+KCH+”!"”+KC.!"?”ᡂ$”DOWHILENOTEOF()?XS.)ὃ>ᡂ$CONTINUEENDDOCALCULATEAVG(ὃ>ᡂ$))MAX(ὃ>ᡂ$))MIN(ὃ>ᡂ$)TOPJF,ZGF,ZDFFOR!"=KQI?”}ᙳᑖ”,STR(PJF,5,1),“ᨬᑖ”,STR(ZGF,5,1),"ᨬᑖ”,STR(ZDF,5,1)CLOSEALLSETTALKONSETSAFEONRETURN

7ᔊ>⚪?ὃAᫀ2007ὃVFPᦪὃὃᫀ1ᝅ1.ᐳ40ᑖᜧ⚪?ὃAᫀ஺ᑖ᪗᝞12⊤Ḅᦪ᪀⊤᪀st20ᑖ2ᦪ15ᑖ3ᐵὶ5ᑖ2.ᐳ30ᑖ¢£⚪10ᑖ஺?ὃAᫀ᝞¤஺1VFP¥¦USECJREPLACEALLᡂ$ᔠ¨ᔲWITH.T.FOR=>ᡂ$ª=60ANDᡂ$="«¨”0Rᡂ$=“¬”SQL¥¦UPDATECJSETᡂ$ᔠ¨ᔲ=.T.WHERE=>ᡂ$ª=60ANDᡂ$="«¨”0Rᡂ$=“¬”2VFP¥¦SELECT1USEXSINDEXONὃTAGKHSELECT2USECJSETRELATIONTOὃINTOXSLISTὃ,XS.)=>ᡂ$,ᡂ$FORᡂ$ᔠ¨ᔲ=.T.SQL¥¦SELECTXS.ὃ))=>ᡂ$)ᡂ$FROMXS,CJWHEREXS.ὃ=஺.ὃANDᡂ$ᔠ¨ᔲ=.T.3VFP¥¦:USECJDELETEFORᡂ$=“®ὃ”SQL¥¦DELETEFROMCJWHEREᡂ$=“®ὃ”3.ᐳ30ᑖ¯☢st10ᑖ±⌕³ឋஹµ¶·ṹ1textlஹtext2¹text3Ḅvalue³ឋvᙳº05ᑖ2“t»”ᢥ½ḄClickµ¶·ṹ10ᑖxl=thisform.textl.valuex2=thisform.text2.valuethisform.text3.value=roundxl+x2/2,13FormlḄDblClickµ¶·ṹ:thisform.release5ᑖ

82007ὃVFPᦪὃὃᫀ2ᝅ1.ᐳ40ᑖᜧ⚪?ὃAᫀ஺ᑖ᪗᝞¤12⊤Ḅᦪ᪀⊤᪀st20ᑖ2ᦪ15ᑖ3ᐵὶ5ᑖ2.ᐳ30ᑖ¢£⚪10ᑖ஺?ὃAᫀ᝞¤஺1VFP¥¦USEGZBREPLACEALL4ÃÄÅWITHÆÄÅ+ÇÈ+ᝄÊ-ËÌÊSQL¥¦UPDATEGZBSET4ÃÄÅ=ÆÄÅ+ÇÈ+ᝄÊ-ËÌÊ2VFP¥¦SELECT1USEZGBINDEXONÍÄTAGZGHSELECT2USEGZBSETRELATIONTOÍÄINTOZGBLISTÍÄ,ZGB.)ÆÄÅ)4ÃÄÅFORNOTZGB.ÎᔲCLOSEALLSQL¥¦SELECTGZB.ÍÄ))ÆÄÅ)4ÃÄÅFROMZGB,GZBWHEREZGB.ÍÄ=628.ÍÄANDNOTZGB.Îᔲ3VFP¥¦USEGZBCALCULATEAVGᝄÊ)SUM4ÃÄÅTOA,B?”}ᙳᝄÊ”)A,”4ÃÄÅÏД)BSQL¥¦SELECTAVGᝄÊAS}ᙳᝄÊ,SUM4ÃÄÅAS4ÃÄÅÏÐFROMGZB3.ᐳ30ᑖ¯☢st10ᑖ±⌕³ឋஹµ¶·ṹ1textl>text2¹text3Ḅvalue³ឋvᙳº05ᑖ2text2ḄGotFocusµ¶·ṹ5ᑖxl=thisform.textl.valuethis.value=round3.14159*xl2,23text3ḄGotFocusµ¶·ṹ5ᑖx2=thisform.textl.valuethis.value=round2*3.14159*x2,24“ᐵÒ"ᢥ½ḄClickµ¶·ṹ:thisform.release5ᑖ

92007ὃVFPᦪὃὃᫀ3ᝅ1.ᐳ40ᑖᜧ⚪?ὃAᫀ஺ᑖ᪗᝞¤12⊤Ḅᦪ᪀⊤᪀st20ᑖ2ᦪ15ᑖ3ᐵὶ5ᑖ2.ᐳ30ᑖ¢£⚪10ᑖ஺?ὃAᫀ᝞¤஺1VFP¥¦USEYDCJREPLACEALLÏᡂ$WITHÓ+ÔÕ+ᐸ×SQL¥¦UPDATEYDCJSETÏᡂ$=Ó+ÔÕ+ᐸ×2VFP¥¦USEYDCJINDEXONÏᡂ$TAGZCJDESCLISTi)Ïᡂ$SQL¥¦SELECTi)Ïᡂ$FROMYDCJORDERBYÏᡂ$DESC3VFP¥¦SELECT1USEJBBINDEXONiTAGZGIISELECT2USEYDCJSETRELATIONTOiINTOZGBLISTi,JBB.)Ïᡂ$FORJBB.ØÙ="ᐵ”SQL¥¦SELECTJBB.i))Ïᡂ$FROMJBB,YDCJWHEREJBB.i=YDCJ.iANDØÙ="ᐵ”3.ᐳ30ᑖ¯☢st10ᑖ±⌕³ឋஹµ¶·ṹ1textlஹtext2¹text3Ḅvalue³ឋvᙳº05ᑖ2“ÚÛᜧ£”ᢥ½ḄClickµ¶·ṹ10ᑖxl=thisform.textl.valuex2=thisform.text2.valueifxl>x2thisform.text3.value=xlelsethisform.text3.value=x2endif3"⌨Ý"ᢥ½ḄClickµ¶·ṹthisform.release5ᑖ

100702ὃ>?ὃAᫀÞCᝅ1.ᐳ40ᑖᜧ⚪?ὃAᫀ஺ᑖ᪗᝞¤12⊤Ḅᦪ᪀⊤᪀st20ᑖ2ᦪ15ᑖ3ᐵὶ5ᑖ21usexsreplaceallᨵᦔãwith'2008T2'forsubstrICᓱ,4,1<4replaceallᨵᦔãwith'2009-7'forsubstrICᓱ,4,1>=42sele1usexfindexonICᓱtagkhsele2usexssetrelatoICᓱintoxflistfor'‘èé}'fieldsICᓱ,xf.êë)xf.ìí)xf.ÊÐ3usexfindexonêëtagshijiantotaltohzonêëfieldsÊÐforyearêë=2007andmonthêë=11usehzlist3¯☢st10ᑖ±⌕³ឋ)µ¶·ṹᦻ᪾textlḄvalue³ឋvº05ᑖ⊤ᓫḄ஻load஻µ¶15ᑖpublics,ns=0n=0஻óô஻ᢥ½Ḅ஻click஻µ¶:s=s+thisform.textl.valuen=n+lthisform.labell.caption=strsthisform.Iabel2.caption=strn⊤ᓫḄ“dblclick"µ¶Thisform.release

110702ὃ>?ὃAᫀÞ'ᝅ1.ᐳ40ᑖᜧ⚪?ὃAᫀ஺ᑖ᪗᝞¤42⊤Ḅᦪ᪀⊤᪀st20ᑖ5ᦪ15ᑖ6ᐵὶ5ᑖ2.sele1usejyindexonõtagshsele2usetujsetrelatoõintojylistforᨵᦔãᜩ÷=30fieldsõ)õ)jy.øÝùã)jy.ᨵᦔãᜩ)jy.ø▅û2usetujindexonÞCüὅtagzztotaltohzonÞCüὅfieldsᓫþusehzlist3usejydeleforøÝùã+ᨵᦔãᜩª{^2007-10-15}3.☢10ᑖ⌕ឋṹᦻ᪾textlḄvalueឋ&'05ᑖ⊤ᓫḄ஻load஻15ᑖpublics,ns=0n=0஻67ᙳ஻ᢥ:Ḅ஻click஻s=s+thisform.textl.valuen=n+lthisform.labell.caption=strs/nthisform.Iabel2.caption=strn⊤ᓫḄ"dblclick"Thisform.release

120702EFὃHIὃJᫀLMᝅ1.ᐳ40ᑖᜧ⚪RSIὃJᫀ஺Uᑖ᪗W᝞Y7Z[\]2^⊤Ḅᦪ`a᪀⊤a᪀Z[20ᑖ8ᦪ`Z[15ᑖ9cdᐵὶZ[5ᑖ21uselogoreplaceallᦪ`ghwithVALLEFTaijk2*3600+VALRIGHTaijk*60;-VALLEFTlmjk2*3600-VALRIGHTlmjk*60WHEREaijk<>஻0NLINE஻replaceallᦪ`ghwith16*3600-.VALLEFTlmjk,2*3600-VALRIGHTlmjk*60WHEREaijkp஻ONLINE"2select1uselogoindexonIPᙢᙬtagaddressselect2usewordssetrelationtoIPᙢᙬintologolistforIPᙢᙬ='202.202.0.12'fieldsIPᙢᙬtulogo.vwlogo.lmjklogo.ᦪ`gh3uselogoindexonIPᙢᙬtagaddresstotaltohzonIPᙢᙬfieldsᦪ`ghusehzlist3☢10ᑖ⌕ឋṹ᪗xlabel1ylabel2Ḅcaptionឋ&'z5ᑖ”|“ᢥ:Ḅ஻click஻s=alltrimthisform.text,valuethisform.labell.caption=strlensthisform.Iabel2.caption=uppers⊤ᓫḄ஻dblclick஻Thisform.release

130801EFὃHIὃJᫀL~ᝅ1.ᐳ40ᑖᜧ⚪RSIὃJᫀ஺Uᑖ᪗W᝞Y4Z[\]2^⊤Ḅᦪ`a᪀⊤a᪀Z[20ᑖ5ᦪ`Z[15ᑖ6cdᐵὶZ[5ᑖ2.DSelecttop1xs.⃩├ᕒ,yx.;fromyxinnerjoinxsonxs.├ᕒpyx.⃩├ᕒorderbyᦪhdesc2selectyx.,ᦪh*ᓫas├├ᨴfromyxinnerjoinxsonxs.⃩├ᕒpyx.⃩├ᕒwherexs.⃩├ᕒpanyselectyx.⃩├ᕒfromyxwhere='’3selectᦪh*ᓫas├├ᨴformxs;groupby├ᨴ3.☢10⌕ឋஹṹtextl.valid15ᑖn=valthisform.textl.valueifn<0orn>12waitwindows,ᨴ┯!!!’return.f.endifdocasecasen>=3andn<=5thisform.Iabel2.caption='᧡'casen>=6andn<=8thisform.Iabel2.caption='£'casen>=9andn<=llthisform.Iabel2.caption='¥'casen=12orn=lorn=2thisform.Iabel2.caption='¦'endcaseform.dblclick5ᑖthisform.release

140801EFὃHIὃJᫀLpᝅ1.ᐳ40ᑖᜧ⚪RSIὃJᫀ஺Uᑖ᪗W᝞Y1Z[\]2^⊤Ḅᦪ`a᪀⊤a᪀Z[20ᑖ2ᦪ`Z[15ᑖ3cdᐵὶZ[5ᑖ2.1sele1usegkindexon§¨tagbhsele2usexfsetrelato§¨intogkreplace©ª«ᑖwith©ª/2fornot¬ᔲ®ᕒreplace©ª«ᑖwith©ªfor¬ᔲ®ᕒ2usegkaccept஻¯°ᐭ§¨Ḅ஻toxmlocateforpxmbhp§¨usexflist²³ᖪ©ª©ª«ᑖfor§¨pbh3usexfindexon§¨tagbhtotalon§¨tohzusehzindexon©ª«ᑖtagjfdesclist3☢10ᑖ⌕ឋṹᦻ᪾textl>text2ytext3Ḅvalueឋ&'05ᑖ“¶·”¸¹ᢥ:Ḅ஻click஻15ᑖx=thisform.textl.valuey=thisform.text2.valuez=thisform.text3.valuethisform.text4.value=strmaxx,y,z