µ±Ç°Î»Ö㺠´úÂëÃÔ >> ��ĸ��СдµÄ½â¾ö·½°¸
 
  • (ת)SQLÓÅ»¯×¼Ôò

    (ת)SQLÓÅ»¯Ô­ÔòÒ»¡¢ÎÊÌâµÄÌá³öÔÚÓ¦ÓÃϵͳ¿ª·¢³õÆÚ£¬ÓÉÓÚ¿ª·¢Êý¾Ý¿âÊý¾Ý±È½ÏÉÙ£¬¶ÔÓÚ²éѯSQLÓï¾ä£¬¸´ÔÓÊÓͼµÄµÄ±àдµÈÌå»á²»³öSQLÓï¾ä¸÷ÖÖд·¨µÄÐÔÄÜÓÅÁÓ£¬µ«ÊÇÈç¹û½«Ó¦ÓÃϵͳÌύʵ¼ÊÓ¦Óúó£¬Ëæ×ÅÊý¾Ý¿âÖÐÊý¾ÝµÄÔö¼Ó£¬ÏµÍ³µÄÏìÓ¦ËٶȾͳÉΪĿǰϵͳÐèÒª½â¾öµÄ×îÖ÷ÒªµÄÎÊÌâÖ®Ò»¡£ÏµÍ³ÓÅ»¯ÖÐÒ»¸öºÜÖØÒªµÄ·½Ãæ¾ÍÊÇSQLÓï¾äµÄÓÅ»¯¡£¶ÔÓÚº£Á¿Êý¾Ý£¬ÁÓÖÊSQLÓï¾äºÍÓÅÖÊSQLÓï¾äÖ®¼äµÄËٶȲî±ð¿ÉÒÔ´ïµ½ÉÏ°Ù±¶£¬¿É¼û¶ÔÓÚ...

    50
    ÈȶÈ
  • (ת)SQL ÓÅ»¯×¼Ôò£¨¾«£©

    (ת)SQLÓÅ»¯Ô­Ôò£¨¾«£©(ת)SQLÓÅ»¯Ô­ÔòÒ»¡¢ÎÊÌâµÄÌá³öÔÚÓ¦ÓÃϵͳ¿ª·¢³õÆÚ£¬ÓÉÓÚ¿ª·¢Êý¾Ý¿âÊý¾Ý±È½ÏÉÙ£¬¶ÔÓÚ²éѯSQLÓï¾ä£¬¸´ÔÓÊÓͼµÄµÄ±àдµÈÌå»á²»³öSQLÓï¾ä¸÷ÖÖд·¨µÄÐÔÄÜÓÅÁÓ£¬µ«ÊÇÈç¹û½«Ó¦ÓÃϵͳÌύʵ¼ÊÓ¦Óúó£¬Ëæ×ÅÊý¾Ý¿âÖÐÊý¾ÝµÄÔö¼Ó£¬ÏµÍ³µÄÏìÓ¦ËٶȾͳÉΪĿǰϵͳÐèÒª½â¾öµÄ×îÖ÷ÒªµÄÎÊÌâÖ®Ò»¡£ÏµÍ³ÓÅ»¯ÖÐÒ»¸öºÜÖØÒªµÄ·½Ãæ¾ÍÊÇSQLÓï¾äµÄÓÅ»¯¡£¶ÔÓÚº£Á¿Êý¾Ý£¬ÁÓÖÊSQLÓï¾äºÍÓÅÖÊSQLÓï¾äÖ®¼äµÄËٶȲî...

    67
    ÈȶÈ
  • (ת)ORACLEÄÚ²¿º¯Êý´óÈ«ÒÔ¼°ÓëSQLSERVERµÄ²î±ð

    (ת)ORACLEÄÚ²¿º¯Êý´óÈ«ÒÔ¼°ÓëSQLSERVERµÄÇø±ðÏÂÃæÊÇOracleÖ§³ÖµÄ×Ö·ûº¯ÊýºÍËüÃǵÄMicrosoftSQLServerµÈ¼Ûº¯Êý¡£º¯ÊýOracleMicrosoftSQLServer?°Ñ×Ö·ûת»»ÎªASCII:ASCIIASCII?×Ö´®Á¬½Ó:CONCAT--------------(expression+expression)?°ÑASCIIת»»Îª×Ö·ûCHR,CHAR?·µ»Ø×Ö·û´®ÖеĿª...

    12
    ÈȶÈ
  • SQLÌõ¼þ²éѯ(2)

    SQLÌõ¼þ²éѯ(¶þ)SQLÌõ¼þ²éѯ1.Ìõ¼þ²éѯSELECT*|{[DISTINCT]column|expression[alias],...}FROM???table[WHERE??????condition(s)];Condition(s)ҪʹÓõ½±È½ÏÔËËã·û³£ÓõıȽÏÔËËã·ûÈçÏÂ:²Ù×÷·ûº¬Òå=µÈÓÚ>?´óÓÚ>=´óÓÚµÈÓÚ<?СÓÚ<=СÓÚµÈÓÚ<>?²»µÈÓÚµÈЧÓÚ!=ÆäËü...

    80
    ÈȶÈ
  • PL/SQLÔý¼Ç

    PL/SQL±Ê¼ÇPL/SQLÊÇOracleÔÚ±ê×¼SQLÓïÑÔÉϵĹý³ÌÐÔÀ©Õ¹¡£PL/SQL²»½öÔÊÐíǶÈëSQLÓï¾ä£¬¶øÇÒÔÊÐí¶¨Òå±äÁ¿ºÍ³£Á¿£¬ÔÊÐíʹÓÃÌõ¼þÓï¾äºÍÑ­»·Óï¾ä£¬ÔÊÐíʹÓÃÒì³£´¦Àí¸÷ÖÖ´íÎ󣬴ӶøÌṩÁ˸üÇ¿´óµÄ¹¦ÄÜ¡£?SQLÓïÑÔ·ÖÀࣺÊý¾Ý²éѯÓïÑÔ£ºSELECTÊý¾Ý²Ù×ÝÓïÑÔ£¨DataManipulationLanguage£¬DML£©£ºINSERT¡¢UPDATE¡¢DELETEÊý¾Ý¶¨ÒåÓïÑÔ£¨DataDefi...

    102
    ÈȶÈ
  • MySQL Tutorial(Ò»)

    MySQLTutorial(1)MySQLTutorialÄ¿Ç°µÄÇé¿öÊÇÒ»±ßѧJava£¬Ò»±ßѧϰMySQL¡£¿´µÄÊÇMySQLÌṩµÄÎĵµ£¬Õâƪ²©ÎÄÊÇѧϰµÄ×ܽᡣ£¨2016-4-3£©±¾ÎÄ×îºó¸üÐÂʱ¼ä£º2016-4-5NOTE£º¹ØÓÚMySQLµÄ°²×°ÎĵµÔÚÕâÀï3.1-Á¬½ÓºÍ¶Ï¿ªMySQL·þÎñ1.²é¿´helpÐÅÏ¢shell>mysql--help2.Á¬½Óµ½MySQL·þÎñ³ÌÐòshell>mysql-...

    261
    ÈȶÈ
  • SQL»°ÓïÈ«½âÎö

    SQLÓï¾äÈ«½âÎöÒ»¡¢»ù±¾µÄ½¨¿â¡¢½¨±í²Ù×÷£¨Ôöɾ¸Ä²éÂÔÈ¥²»½²£©--´´½¨Êý¾Ý¿âSchoolCreatedatabaseSchool--ʹÓÃÊý¾Ý¿âUseSchool--´´½¨Ñ§Éú±í£¨SIDΪ×ÔÔöÖ÷¼ü£¬SsexÓÐCheckÔ¼Êø£¬ÇÒËùÓÐ×ֶΣ¬¾ù²»Îª¿Õ£©createtableStudent(SIDintidentitynotnullprimarykey,Snamenvarchar(30)notnull,Sage...

    44
    ÈȶÈ
  • SharePoint·þÎñÆ÷¶Ë¶ÔÏóÄ£ÐÍ Ö® ʹÓÃCAML¿ªÕ¹Êý¾Ý²éѯ£¨Part 2£©

    SharePoint·þÎñÆ÷¶Ë¶ÔÏóÄ£ÐÍ֮ʹÓÃCAML½øÐÐÊý¾Ý²éѯ£¨Part2£©£¨Èý£©Ê¹ÓÃSPQuery½øÐÐÁбí²éѯ1¡¢¸ÅÊöÁбí²éѯÖ÷ÒªÊÇÖ¸ÔÚÒ»¸öÖ¸¶¨µÄÁÐ±í£¨»òÎĵµ¿â£©Öа´ÕÕijЩɸѡ¡¢ÅÅÐòÌõ¼þ½øÐвéѯ¡£Áбí²éѯÖ÷ҪʹÓÃSPQuery¶ÔÏó£¬ÒÔ¼°SPListµÄGetItems·½·¨£¬½«SPQuery×÷Ϊ²ÎÊý´«µÝ£¬·µ»Ø²éѯµ½µÄÁбíÌõÄ¿¼¯ºÏ£¬¼´SPListItemCollectionÀàÐÍ¡£ÔÚʹÓÃSPQuery½ø...

    365
    ÈȶÈ
  • С½á

    sqlº¯Êý˵Ã÷´óÈ«£¨×ªÔØ£©×ª×Ô£ºhttp://www.cnblogs.com/moss_tan_jun/archive/2010/08/23/1806861.htmlÒ»µ©³É¹¦µØ´Ó±íÖмìË÷³öÊý¾Ý£¬¾ÍÐèÒª½øÒ»²½²Ù×ÝÕâЩÊý¾Ý£¬ÒÔ»ñµÃÓÐÓûòÓÐÒâÒåµÄ½á¹û¡£ÕâЩҪÇó°üÀ¨£ºÖ´ÐмÆËãÓëÊýѧÔËË㡢ת»»Êý¾Ý¡¢½âÎöÊýÖµ¡¢×éºÏÖµºÍ¾ÛºÏÒ»¸ö·¶Î§ÄÚµÄÖµµÈ¡£Ï±í¸ø³öÁËT-SQLº¯ÊýµÄÀà±ðºÍÃèÊö¡£º¯ÊýÀà±ð×÷ÓþۺϺ¯ÊýÖ´ÐеIJÙ×÷ÊÇ...

    95
    ÈȶÈ
  • MySQL²ËÄñÈëÃŽ̳Ì

    MySQL³õѧÕßÈëÃŽ̳Ì1¡¢MySQL°²×°(Window7°²×°)ÔÚÈκΰ汾µÄWindowsĬÈÏ°²×°ÊÇÏÖÔÚ±ÈÒÔÇ°ÒªÈÝÒ׵ö࣬MySQLÇÉÃîµØ´ò°ü°²×°³ÌÐò¡£Ö»ÐèÏÂÔØ°²×°°ü£¬ËæµØ°ÑËü½âѹËõ£¬²¢ÔËÐÐmysql.exe.ÏÂÔصØÖ·£ºhttp://dev.mysql.com/downloads/Ò³ÃæÈçÏÂͼËùʾ£ºÕâÀïµã»÷£ºDOWNLOADÁ´½Ó£¬½øÈëÒ»ÏÂÒ³Ã棺ÕâÀïµã»÷£ºDOWNLOADÁ´½Ó£¬½øÈëÒ»ÏÂÒ³Ã棺ÕâÀïÒªÇó×¢...

    103
    ÈȶÈ
  • myeclipseÓ¦Ó㨼¼ÊõºÍ¿ì½Ý¼ü£©

    myeclipseʹÓ㨼¼ÊõºÍ¿ì½Ý¼ü£©//////////////////////////ѧϰ±à³Ì¿ª·¢ÊǼþÐèÒª³ÖÖ®ÒÔºãµÄÊÇ£¬´ó¼Ò¼ÓÓͺúÃŬÁ¦£¬ÔçÈÕ³ÉΪ±ä³É¾«Ó¢¡£//////////////////////////µÚÒ»²¿·ÖMyEclipseµÄ»ù±¾Ê¹ÓÃÒ»£®Ìáʾ£ºMyEclipseµÄ͸ÊÓͼ°´Å¥£º¿ÉÒÔÇл»²»Í¬µÄ͸ÊÓͼ£¨Î»ÓÚÓÒÉϽǣ©1.½¨Á¢Ò»¸ö¹¤³Ì----File¡ªnew¡ªproject---Ñ¡ÏÓÐJav...

    54
    ÈȶÈ
  • ÎÞÍ´ SQL Schema µÄÊ® Ìõ¾ü¹æ

    ÎÞÍ´SQLSchemaµÄ10Ìõ¾ü¹æÔ­ÎÄhttp://blog.jobbole.com/90187/1.ֻʹÓÃСд×Öĸ£¬Êý×ÖºÍÏ»®Ïß²»ÒªÔÚÊý¾Ý¿â¡¢Ä£Ê½¡¢±í¸ñ»òÕßÁÐÃûÉÏʹÓõ㡢¿Õ¸ñ»òÕßÆÆÕۺš£ÒòΪµãºÅÊÇÓÃÀ´Ê¶±ð¶ÔÏóµÄ£¬Í¨³£Ö»ÔÚ?database.schema.table.column?ÕâÖÖÇé¿öÏÂʹÓá£ÔÚ¶ÔÏóµÄÃû×ÖÖÐÒ²°üº¬µãºÅ»á´øÀ´À§ÈÅ¡£Í¬ÑùµØ£¬ÔÚ¶ÔÏóÃûÖÐʹÓÿոñ½«ÆÈʹÄã¸ø²éѯ¼ÓÈëÒ»¶Ñ²»±ØÒªµÄÒýºÅ£º12...

    354
    ÈȶÈ
  • Ê·ÉÏ×îÈ«µÄMSSQLÎÂÏ°±Ê¼Ç

    Ê·ÉÏ×îÈ«µÄMSSQL¸´Ï°±Ê¼Ç1.ʲôÊÇSQLÓï¾äsqlÓïÑÔ£º½á¹¹»¯µÄ²éѯÓïÑÔ¡££¨StructuredQueryLanguage£©£¬ÊǹØϵÊý¾Ý¿â¹ÜÀíϵͳµÄ±ê×¼ÓïÑÔ¡£ËüÊÇÒ»ÖÖ½âÊÍÓïÑÔ£ºÐ´Ò»¾äÖ´ÐÐÒ»¾ä£¬²»ÐèÒªÕûÌå±àÒëÖ´ÐС£Óï·¨Ìص㣺1.ûÓГ”£¬×Ö·û´®Ê¹ÓÑ’°üº¬2.ûÓÐÂß¼­ÏàµÈ£¬¸³ÖµºÍÂß¼­ÏàµÈ¶¼ÊÇ=3.ÀàÐͲ»ÔÙÊÇ×îÑϸñµÄ¡£ÈκÎÊý¾Ý¶¼¿ÉÒÔ°üº¬ÔÚ&lsquo...

    94
    ÈȶÈ
  • mysqlÎÂÏ°±Ê¼Ç

    mysql¸´Ï°±Ê¼ÇÔĶÁĿ¼1.ʲôÊÇSQLÓï¾ä2.ʹÓÃsqlÓï¾ä´´½¨Êý¾Ý¿âºÍ±í3.´´½¨Êý¾Ý±í4.Êý¾ÝÍêÕûÐÔÔ¼Êø5.ËÄÖлù±¾×Ö·ûÀàÐÍ˵Ã÷6.SQL»ù±¾Óï¾ä7.ÀàÐÍת»»º¯Êý8.ÈÕÆÚº¯Êý9.Êýѧº¯Êý10.×Ö·û´®º¯Êý11.ÁªºÏ½á¹û¼¯union12.CASEº¯ÊýÓ÷¨13.IFELSEÓï·¨14.WHILEÑ­»·Óï·¨15.×Ó²éѯ16.±íÁ¬½ÓJoin17.ÊÂÎñ18.ÊÓͼ19.´¥·¢Æ÷20.´æ´¢¹ý³Ì21.·ÖÒ³´æ´¢¹ý³Ì2...

    73
    ÈȶÈ
  • MySQLÏê½â£¨Î壩-º¯Êý³¬È«×ܽá

    MySQLÏê½â£¨5£©-----------º¯Êý³¬È«×ܽámysqlº¯Êý´óÈ«¶ÔÓÚÕë¶Ô×Ö·û´®Î»ÖõIJÙ×÷£¬µÚÒ»¸öλÖñ»±ê¼ÇΪ1¡£ASCII(str)·µ»Ø×Ö·û´®strµÄ×î×óÃæ×Ö·ûµÄASCII´úÂë值¡£Èç¹ûstrÊÇ¿Õ×Ö·û´®£¬·µ»Ø0¡£Èç¹ûstrÊÇNULL£¬·µ»ØNULL¡£mysql>selectASCII('2');->50mysql>selectASCII(2);->50my...

    42
    ÈȶÈ
  • VelocityÓï·¨¸úʹÓÃʾÀý

    VelocityÓï·¨ºÍʹÓÃʾÀý VelocityÓï·¨ 1.?????±äÁ¿ (1)±äÁ¿µÄ¶¨Ò壺 #set($name="hello")??????˵Ã÷£ºvelocityÖбäÁ¿ÊÇÈõÀàÐ͵ġ£ µ±Ê¹ÓÃ#set?Ö¸Áîʱ£¬À¨ÔÚË«ÒýºÅÖеÄ×ÖÃæ×Ö·û´®½«½âÎöºÍÖØнâÊÍ£¬ÈçÏÂËùʾ£º #set($directoryRoot="www") #set($templateName="index.vm") #set($tem...

    826
    ÈȶÈ
  • Android¿ª·¢ÍøÉϵÄһЩÖ÷Ҫ֪ʶµã[¾­Ñé·ÖÏí]

    Android¿ª·¢ÍøÉϵÄһЩÖØҪ֪ʶµã[¾­Ñé·ÖÏí]http://aiwgame.comhttp://developer.aiwgame.com1.androidµ¥ÊµÀýÔËÐз½·¨ÎÒÃǶ¼ÖªµÀAndroidƽ̨ûÓÐÈÎÎñ¹ÜÀíÆ÷£¬¶øÄÚ²¿Appά»¤ÕßÒ»¸öActivityhistorystackÀ´ÊµÏÖ´°¿ÚÏÔʾºÍÏú»Ù£¬¶ÔÓÚ³£¹æ´Ó¿ì½Ý·½Ê½ÔËÐÐÀ´¿´¶¼ÊÇstartActivity¿ÉÄÜ»áʹÓÃFLAG_ACTIVITY_NE...

    92
    ÈȶÈ
  • Android4¿ª·¢ÈëÞ­µä Ö® µÚ¶þÒ»²¿·Ö£ºAndroidÓ¦ÓõĺËÐÄ»ù´¡

    Android4¿ª·¢ÈëÞ­µäÖ®µÚ¶þ²¿·Ö£ºAndroidÓ¦ÓõĺËÐÄ»ù´¡AndroidÓ¦ÓÃÖеÄ×é¼þApplicationComponentsAndroidÓ¦ÓÃÖÐ×îÖ÷ÒªµÄ×é¼þÊÇ£º1£ºActivity£º»î¶¯£¬»î¶¯ÊÇ×î»ù±¾µÄAndoridÓ¦ÓóÌÐò×é¼þ£¬Ó¦ÓóÌÐòÖУ¬Ò»¸ö»î¶¯Í¨³£¾ÍÊÇÒ»¸öµ¥¶ÀµÄÆÁÄ»¡£2£ºService£º·þÎñ£¬·þÎñÊÇÔËÐÐÔÚºǫ́µÄ£¬Í¨³£ÊǾßÓÐÒ»¶Î½Ï³¤ÉúÃüÖÜÆÚÇÒûÓÐÓû§½çÃæµÄ³ÌÐò¡£±È½ÏºÃµÄÒ»¸öÀý×Ó¾ÍÊÇ...

    95
    ÈȶÈ
  • MVC5 ÍøÕ¾¿ª·¢Ö®7 Óû§¹¦ÄÜ 2 Óû§Ìí¼ÓºÍä¯ÀÀ

    MVC5ÍøÕ¾¿ª·¢Ö®ÆßÓû§¹¦ÄÜ2Óû§Ìí¼ÓºÍä¯ÀÀÒ»¡¢Êý¾Ý´æ´¢²ã1¡¢²éÕÒ·ÖÒ³ÁбíÔÚдÓû§ÁбíʱÓöµ½ÁËÎÊÌ⣬¿¼Âǵ½Óû§¿ÉÄÜ»á½Ï¶àµÄÇé¿öÐèÒª·ÖÒ³£¬ÔÚÊý¾Ý´æ´¢²ãдµÄ·½·¨ÊÇpublicIQueryable<T>FindPageList<TKey>(intpageSize,intpageIndex,outinttotalNumber,Expression<Func<T,bool...

    579
    ÈȶÈ
  • JSÊÊÓôúÂë

    JSʵÓôúÂë ʼþÔ´¶ÔÏóevent.srcElement.tagNameevent.srcElement.type²¶»ñÊÍ·Åevent.srcElement.setCapture();?event.srcElement.releaseCapture();??ʼþ°´¼üevent.keyCodeevent.shiftKeyevent.altKeyevent.ctrlKeyʼþ·µ»ØÖµevent.retur...

    485
    ÈȶÈ