-
һ·ҪÇóͦ¶àµÄJAVAÌâ
Ò»µÀÒªÇóͦ¶àµÄJAVAÌâimportjava.util.Scanner;publicclassTutorialMark{publicstaticvoidmain(String[]args){ finaldoubleIN_TUTE_PERCENT=0.7; finaldoubleOUT_TUTE_PERCENT=0.3; finalintONE_HUNDRED=100; intbeforeTut...
84
ÈÈ¶È -
µÈ¿¼µÄһ·ÌâÇó½â´ð
µÈ¿¼µÄÒ»µÀÌâÇó½â´ðÊý¾Ý¿âÖÐÓÐѧÉú±íStudent(Sno,Sname,Ssex,Sage,Sdept)¸÷ÊôÐÔ·Ö±ð±íʾΪѧºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣬ËùÔÚϵ£»Ñ§ÉúÑ¡¿Î±íSC£¨Sno,Cno,Grade£©£¬¸÷ÊôÐÔ·Ö±ð±íʾΪѧºÅ£¬¿Î³ÌºÅÒÔ¼°³É¼¨;¿Î³Ì±íCourse(Cno,Cname,Cpno,Ccredit)¸÷ÊôÐÔΪ¿Î³ÌºÅ£¬¿Î³ÌÃû£¬ÏÈÐпΣ¬Ñ§·Ö¡££¨ÏÈÐпεÄÒâ˼ÊÇ£¬±ÈÈç¿Î³ÌºÅ1ÓÐÏÈÐпÎ5£¬ËµÃ÷Ҫѡ¿Î³Ì1£¬¾Í±Ø...
68
ÈÈ¶È -
һ·SQL²éÑ¯ÃæÊÔÌ⣬Çó½â
Ò»µÀSQL²éÑ¯ÃæÊÔÌ⣬Çó½âǰ²»¾Ã²Î¼ÓÁËÒ»¸öÃæÊÔ£¬ÒòΪ±ÊÊÔSQL²»¹ý¹Øµ¼ÖÂË¢ÁËÏÂÀ´¡£Óöµ½ÕâÑùÒ»¸öÎÊÌ⣬¸Ð¾õºÜ¼òµ¥µ«ÊÇûÏëµ½·½·¨£¬´ó¼Ò°ïæ¿´¿´£¬Ó¦¸ÃÊÇÓëgroupbyÓйء£rqshengfu2005-05-09ʤ2005-05-09ʤ2005-05-09¸º2005-05-09¸º2005-05-10ʤ2005-05-10¸º2005-05-10¸ºÈç¹ûÒªÉú³ÉÏÂÁнá¹û,¸ÃÈçºÎдsqlÓï¾ä?rqʤ¸º2005-0...
9
ÈÈ¶È -
ÎÒÔÚ³ÌÐòѧϰÖÐÃÔÁË·
¶¥Ò»¸ö¶à½»Á÷»áºÃһЩ color='#FF8000'>----------------½â¾ö·½°¸-------------------------------------------------------- ÎҲŸÕѧC£¬µ«¹óÔÚ¼á³Ö£¬ÐËȤÊǶ¯Á¦ËùÔÚ¡£¶¥Ò»¸ö color='#FF8000'>------...
108
ÈÈ¶È -
ÐÂÊÖÉÏ·¡£Â·ÄÑ×ߣ¬Çë½Ì
ͬÒâ4Â¥ ³ÌÐòÔËÐÐÍê±Ïºó¾ÍÂíÉϹرմ°¿Ú.ÄãÀ´²»¼°¿´ÔËÐнá¹û. ¼ÓÉÏgetchar()ºó,»áµÈÄãÊäÈëÒ»¸ö×Ö·ûºó¹Ø±Õ. color='#FF8000'>----------------½â¾ö·½°¸--------------------------------------------------------
88
ÈÈ¶È -
±à³ÌµÄ·ÏÂСµÜÎÒÃÔãÁË£¬ÇóÖ¸µã
±à³ÌµÄ·ÉÏÎÒÃÔãÁË£¬ÇóÖ¸µãѧÁ˼¸Äê¼ÆËã»úÁË£¬Ñ§Á˺ö඼ÊÇÎÒÈÏΪ¼òµ¥µÄ£¬µ«ÎÒϲ»¶±à³Ì£¬ËùÒÔѧÁËÈí¼þ¹¤³Ì£¬ÏÖÔÚ¸Õ¸ÕѧCÓïÑÔ£¬µ«ËùÓÐÓïÑÔ¶¼ÊÇÏàͨµÄ£¬ÎÒѧ¹ývf£¬Ï²»¶vbµÄ½çÃæ·ç¸ñ£¬ËùÒÔ×ÔѧÁËÒ×ÓïÑÔ£¬ËùÓеĻù´¡ÖªÊ¶»ù±¾É϶¼Äܶ®¡£µ«ÎÒºÜÃÔ㣬µ½ÏÖÔÚÒ»Ö±»¹ÊÇÍ£ÁôÔÚÕâÀï²»Äܵõ½ÌáÉý£¬¿´µ½Ò»¸öÈËдµÄѧ¼¼ÊõÏÈѧ×öÈË£¬Ò²ÐíÎÒ¾ÍÊÇÀïÃæËùµÄÓöµ½Æ¿¾±ÁË£¬ËùÒÔÇó¸ßÊÖÖ¸µã£¬Ôõô²ÅÄܵõ½ÌáÉýÄØ£¿£¿Èç¹ûÊǼÆËã»úרҵµÄÓ¦¸ÃºÜÈÝÒ×ÕÒµ½...
273
ÈÈ¶È -
Çóһ·ÐÂÊÖ»ã±àÌ⣬mulÖ¸Áî
ÇóÒ»µÀÐÂÊÖ»ã±àÌ⣬mulÖ¸Áîmovdh,8movdl,3ÏÖÔÚdxÖеÄÊý¾ÝÒѾ¸æËß³öÀ´ÁË£¬Ïë°ÑdhÖеÄÊý¾ÝÏȼõ1ÔÙ³Ë160£¬£¬È»ºó±£´æµ½bx£¬È»ºó¼ÓÉÏÔdl*2µÄÖµ£¬ÏÖÔÚcx²»ÄÜÓã¬ÒÔÉÏÊý¾Ý¶¼ÊÇ10Êý½ø£¬£¬£¬½á¹ûÏ£Íû±£´æµ½bxÖУ¬ÒòΪ160ת»»³ÉÊ®Áù½øÖÆÎª0a0h,ºÃÏñÒªÓÃ16λ¼Ä´æÆ÷£¬½á¹û¾ÍÊÇ32λµÄ£¬ÓÖÒª·Åµ½16λÖУ¬£¬ËùÒÔÎÒ¾À½áÁË£¬Çó¸ßÊÖÖ¸½Ìһϣ¬£¬£¬color='#e78608'>-----...
573
ÈÈ¶È -
һ·ӢÎÄ¿¼ÊÔÌ⣬alter table
Ò»µÀÓ¢ÎÄ¿¼ÊÔÌ⣬altertablealtertableCustomerADD(FaxNumberVarchar(12)notnull)ExplainwhythefollowingsqlcommandwillberejectedbytheDBMS,andsayhowtherequiredeffectcanbeachieved:Õâ¸öÊÇ˵¸ÃsqlÖ¸Áî»á±»DBMS¾Ü¾ø£¬¿ÉÊÇÎÒÓÃaccessûÓб»¾Ü¾ø°¢£¬...
9735
ÈÈ¶È -
ÓÐһ·having×Ó¾äµÄÀýÌⲻ̫¶®
ÓÐÒ»µÀhaving×Ó¾äµÄÀýÌⲻ̫¶®±¾Ìû×îºóÓÉbvxtnoelÓÚ2015-02-2415:34:20±à¼¾ÝÎÒÀí½â£¬HAVING×Ó¾äÊÇÕâÑùµÄ£ºWHERE¹Ø¼ü×ÖÔÚʹÓþۼ¯º¯Êýʱ²»ÄÜʹÓã¬ËùÒÔÔÚ¾Û¼¯º¯ÊýÖмÓÉÏÁËHAVINGÀ´Æðµ½²âÊÔ²éѯ½á¹ûÊÇ·ñ·ûºÏÌõ¼þµÄ×÷Óᣵ«ÊÇ2)HAVING×Ó¾äÏÂÃæµÄÄǾä¼ÙÈç¡¡ÎÒû¿´¶®£¬Çë½âÊÍ¡£»¹ÓÐÄǸöÀýÌâµÄQty¶¼ÊÇÉϰٵÄÊý£¬Ôõôƽ¾ùһϾͳÉÁË5»ò7ÁË£¿²éѯÓï¾äSELECTJno...
30
ÈÈ¶È -
³öһ·ССµÄsqlÌâÄ¿
³öÒ»µÀССµÄsqlÌâĿһλͬÊÂÎÊÎÒ£¬ÓÐÒ»ÕÅ±í£¬Ö»ÓÐÒ»¸ö×ֶΣ¬intÐÍ£¬ºÜ´óºÜ´ó£¬ÎÊÈçºÎ×ö²ÅÄÜÔÚ²éѯÀýÈç1-3,1-300Ö®ÀàµÄcount¸öÊý£¬´ïµ½ËÙ¶È×î¿ì£¬Ð»Ð»¡£ÎÒ˵×öË÷Òý£¬È»ºóselectcount(*)fromtablewhere×Ö¶Î>Nand×Ö¶Î<M£¬Ëû˵ËûÒ²ÊÇÕâÑùÏëµÄ£¬Ö»ÊDz»Çå³þÕâÊDz»ÊÇ×îºÃµÄ·½·¨¡£ÏÖÔÚŪÉÏÀ´ÎÊÎÊ´ó¼Ò¡£color='#FF8000'>------½â¾ö·½°¸----...
81
ÈÈ¶È -
һ·Êý¾Ý¿âÉè¼ÆÌâ
Ò»µÀÊý¾Ý¿âÉè¼ÆÌâÊý¾Ý¿âÉè¼Æ£ºuser,role,permision£¬ÒªÇóÒ»¸öÓû§¶à¸örole,Ò»¸örole¶à¸öȨÏÞÕÒ³öÕÅÈýÕâ¸öÈ˵ÄËùÓеÄȨÏÞÕÒ³öÓµÓÐ3¸öȨÏÞÒÔÉϵÄËùÓеÄÓû§ÄǸöºÃÐÄÈ˰ï°ïÎÒ°¡color='#FF8000'>------½â¾ö˼·----------------------²»ÒªÖظ´·¢Ìû£¬·¢Ò»¸ö×ÓÂÛ̳Õû°æ¶¼¿´µÃµ½µÄ¡£
110
ÈÈ¶È -
һ·OCPÌâ¡£ÄÄλ´ó¸ç¿´¿´»á×ö²»
Ò»µÀOCPÌâ¡£¡£ÄÄλ´ó¸ç¿´¿´»á×ö²»113.EvaluatetheSQLstatements:CREATETABLEnew_order(ordernoNUMBER(4),booking_dateTIMESTAMPWITHLOCALTIMEZONE)?ThedatabaseislocatedinSanFranciscowherethetimezoneis8:00.TheuserislocatedinN...
326
ÈÈ¶È -
һ·Êý¾Ý¿âÑ¡ÔñÌâ
Ò»µÀÊý¾Ý¿âÑ¡ÔñÌâÒ»£ºÏÂÃæ¹ØÓÚhaving×Ó¾äÃèÊöÕýÈ·µÄÊÇA,HAVING×Ӿ䱨ÐëÓÚgroupby×Ó¾äͬʱʹÓ㬲»Äܵ¥¶ÀʹÓÃB£¬Ê¹ÓÃHAVINGµÄͬʱ²»ÄÜʹÓÃWHERE×Ó¾äC£¬Ê¹ÓÃHAVING×Ó¾äµÄ×÷ÓÃÊÇÏÞ¶¨·Ö×éÌõ¼þD£¬HAVING×Ó¾äÖÐÌõ¼þ×Ö¶ÎÎÞ·¨Ó¦ÓÃË÷Òýcolor='#FF8000'>------½â¾ö·½°¸--------------------aÔÚsqlserverÖÐÊÇ´íÎóµÄ£¬¿ÉÒÔµ¥¶ÀʹÓÃhav...
42
ÈÈ¶È -
һ·sqlÃæÊÔÌ⣬Çó½â´ð
Ò»µÀsqlÃæÊÔÌ⣬Çó½â´ðtableA(µØÇø±í)colA£¨µØÇøid£©colB£¨Éϼ¶µØÇøid£©colC£¨µØÇøÃû³Æ£©tableB£¨ÈËÔ±Çé¿ö±í£©colD£¨ÈËÔ±ic£©colE£¨ÈËÔ±Ãû³Æ£©colA£¨ËùÊôµØÇø£©colG£¨ÈËÔ±³É±¾£©colH£¨ÐÔ±ð£©1.È«¹úËùÓÐÈËÔ±³É±¾×î¸ßµÄµÚ10Ãûµ½µÚ20Ãû¡£2.ËùÓÐÈËÔ±³É±¾×ܺʹóÓÚ2000µÄÊУ¬°´Õճɱ¾ºÏ¼ÆÓɸߵ½µÍ˳Ðò¡£3.ÊäÈëÒ»¸öµØÇøid£¬ÔÚsqlÖÐʹÓã¿´úÌæ£¬²éѯÕâ¸öµØÇøËù...
90
ÈÈ¶È -
һ·javaÌ⣬Ϊʲô´ð°¸ÕâÑù¹îÒì
Ò»µÀjavaÌ⣬Ϊʲô´ð°¸ÕâÑù¹îÒìAssemblycode£¨7£©¹ØÓÚÒÔÏÂapplicationµÄ˵Ã÷£¬ÕýÈ·µÄÊÇ£¨£©1£®classStaticStuff2£®{3£® staticintx=10£»4£®...
229
ÈÈ¶È -
Ò»Â·ÃæÊÔÌâ Çó½â´ð
Ò»µÀÃæÊÔÌâÇó½â´ðJavacodepublicclassExample{Stringstr=newString("good");char[]ch={'a','b','c'};publicvoidstaticmain(String[]args){Exampleex=newExample();ex.change(ex.str,ex.ch);System.out.print(ex.st...
181
ÈÈ¶È -
SCJPÖеÄһ·СÌâ²»¶®
SCJPÖеÄÒ»µÀСÌâ²»¶®.classSuper{publicinti=0;publicSuper(Stringtext){i=1;}}publicclassSubextendsSuper{publicSub(Stringtext){i=2;}publicstaticvoidmain(Stringargs[]){Subsub=newSub("Hello");System.out....
97
ÈÈ¶È -
һ·Ï̵߳ÄÌâÄ¿£¬Í·Í´¡£
Ò»µÀÏ̵߳ÄÌâÄ¿£¬Í·Í´¡£¡£¡£classNameList{privateListnames=newArrayList();publicsynchronizedvoidadd(Stringname){names.add(name);}publicsynchronizedvoidprintAll(){for(inti=0;i<names.size();i++){System.out.print(na...
228
ÈÈ¶È -
SCJPÖеÄһ·Ìâ,´ó¼Ò̽ÌÖ
SCJPÖеÄÒ»µÀÌâ,´ó¼Ò̽ÌÖ!classValue{inti;}publicclassEqualsMethod2{publicstaticvoidmain(String[]args){Valuev1=newValue();Valuev2=newValue();v1.i=v2.i=100;System.out.println(v1.equals(v2));}}˵˵Á½¸öÎÊÌâ:1.Êä³ö½á¹û;2.Êä³ö½á¹û...
65
ÈÈ¶È -
һ·¹ØÓÚµ¥ÀýģʽµÄÌâ
Ò»µÀ¹ØÓÚµ¥ÀýģʽµÄÌâ±¾Ìû×îºóÓÉdaituzhangÓÚ2013-09-0507:37:33±à¼ÎÒÊÇjavaÁã»ù´¡Õߣ¬¿¿googleºÍbaiduÔÚ½âÕâµÀÌ⣬Èç¹ûÓеͼ¶´íÎóÍû¸÷λ´óÉñ³é´òÒòΪÌâÄ¿ÔÎÄÊÇÓ¢ÎÄ£¬ÎÒ·Òë¿ÉÄÜÓе㲻׼ȷ£º1£©½¨Á¢Ò»¸ö½Ð×öOrganizationµÄÀ࣬Ëü²»Äܱ»ÊµÀý»¯³¬¹ýÒ»´Îµ«ÊÇ¿ÉÒÔÌṩ¸øÈ«¾Ö¡£Ëü°üº¬½öÒ»¸ö½Ð×ögetMembersµÄpublicmethod£¬·µ»ØÒ»¸öcollectio...
2
ÈȶÈ