¸ß¼¶sqlÓï¾ä²éѯ Çó½â - Java / Java EE
ÈÕÆÚ ÊÇ·ñ 2010-03-09 ÊÇ 2010-03-09 ÊÇ 2010-03-09 ·ñ 2010-03-09 ·ñ 2010-03-10 ÊÇ 2010-03-09 ·ñ 2010-03-09 ·ñ ²éѯ»ØÀ´µÄ½á¹û ÈÕÆÚ ÊÇ ·ñ 2010-03-09 2 2 2010-03-09 1 2 Ï£ÍûÇ××ÔÊÔÑéºóÔÚ¸øÓÚ´ð¸´...ÖØÒªµÄÊÇÂß¼...²»ÊÇС¼¼ÇÉ..Thank youÃÇ....
- - ÈÕÆÚ ÊÇ ·ñ 2010-03-09 2 2 2010-03-09 1 2 ¿´²»¶®ÁË ²»Ã÷°×lzµÄÎÊÌâ ×îºó 2010-03-10 ÊÇ 2010-03-09 ·ñ 2010-03-09 ·ñ Ó¦¸Ã¶¼ÊÇ2010-03-10¾ÍÃ÷°×ÌâÄ¿µÄÒâ˼ÁË ´ó¼Ò¶¼¿´²»Ã÷°×¡£¡£¡£¡£ ¿´ÁËÄãÒÔǰµÄÌù×Ó·¢ÏÖÕâ¸öÈËÓÐ벡ÒýÓà select ÈÕÆÚ£¬ count(case ÊÇ·ñ when 'ÊÇ' THEN ÊÇ·ñ else null end), count(case ÊÇ·ñ when '·ñ' then ÊÇ·ñ else null end) from table group by ÈÕÆÚ lz¿ÉÒÔÉÏÍø²éһϽ»²æ±íÏà¹ØµÄ¶«Î÷£¬ÎÒÖ»ÊÇд¸öʾÀý Èç¹ûʵÔÚ²»Ðеϰ¿ÉÒÔÓÃ×Ó²éѯ ÔÚ³ÌÐòÀï´¦Àí²»ÊǸüºÃ int sign=´ÓÊý¾Ý¿âµÃµ½µÄÖµ=="ÊÇ"?1:2;
Ïà¹ØÎÊ´ð£º
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£ ´Ê¿âÔõôÉú³ÉÄØ£¿ ²»»á¡£ ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ ÕÒ±¾×Öµä ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ Êý¾Ý¿â ºÇºÇ ÓÃmap ¼üÖµ¶ÔÓ¦ Èç¹ûÓÃÊý¾Ý¿ ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 52 in the jsp file: /vip_info.jsp ÕË cannot be resolved 49: <table border="1& ......
È磺 @superwaring("unchecked"); Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡ ûÓùý¡£¡£ ¿´jeeµÄapi javax.persistenceÀï @superwaring("unchecked");Ö»ÊǺöÂÔ ......
ÏÖÔÚ²»ÏëÓÃ<a> </a> ±êÇ© £¬ÒòΪµã»÷ºó»á³öÏÖÒ³ÃæÖØ¶¨Î»£¬¸øÎÄ×Ö¼ÓÉÏcssÑùʽ¾Í¿ÉÒÔ¿´ÆðÀ´ ÊÇhrefÔõôʵÏÖÕâÑùµÄcss text-decoration:underline; cursor:hand; ÒýÓà text-decoration:underline; cur ......