-
(ת)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
ÈȶÈ