sql²éѯµÄÎÊÌâ - Java / Java SE
select count(*) from Order ºÍselect count(o) from Order µÄÇø±ð£¿ ÔÚд³ÌÐòʱ£¬ÓÐЩÇé¿ö£¬µÚ¶þÖÖ²éѯÎÞ·¨Íê³É»ñÈ¡ÊýÁ¿
Ó¦¸ÃÊǵڶþÖÖÇé¿ö½«ÄãËùcountµÄ×Ö¶ÎÖеĿÕÖµºöÂÔÁË Ö§³Ö1Â¥!!! ÎÒÔÚ´úÂëÖÐÊÇÓà select count(*) from Order! select count(o) from Order Êý¾Ý¿âÖÐÓÐÖµ£¬»¹ÊdzöÏÖ´íÎó Â¥Ö÷ÄãµÄ±íÖÐÓÐ"o"Õâ¸ö×Ö¶Îô.....£¿ select count(*) from Order; Ö¸µÄÊDzéѯOrder±íÖÐËùÓеļǼÊý. select count(o) from Order; ×÷ÓÃÊDzéѯOrder±íÖÐ"o"×ֶβ»Îª¿ÕÖµµÄËùÓмǼÊý. ¶ÔÓÚcount(o),±íÖÐÒªÓÐoÕâ¸ö×ֶΣ¬²»È»count(o)ûÓеϰ£¬ÎÞ·¨²éѯ£¬±¨´í· select count(o) from Order; ²éѯOrder±íÖÐ×Ö¶ÎΪ¡°o¡±µÄ£¬ÇÒ²»Îª¿ÕµÄ¼Ç¼ÊýÄ¿·ÒýÓà ¥Ö÷ÄãµÄ±íÖÐÓÐ"o"Õâ¸ö×Ö¶Îô.....£¿ select count(*) from Order; Ö¸µÄÊDzéѯOrder±íÖÐËùÓеļǼÊý. select count(o) from Order; ×÷ÓÃÊDzéѯOrder±íÖÐ"o"×ֶβ»Îª¿ÕÖµµÄËùÓмǼÊý. up ÒýÓà 5 Â¥ annchaling µÄ»Ø¸´: Â¥Ö÷ÄãµÄ±íÖÐÓÐ"o"Õâ¸ö×Ö¶Îô.....£¿ select count(*) from Order; Ö¸µÄÊDzéѯOrder±íÖÐËùÓеļǼÊý. select count(o) from Order; ×÷ÓÃÊDzéѯOrder±íÖÐ"o"×ֶβ»Îª¿ÕÖµµÄËùÓмǼÊý. ¶¥ Ö§³Ö1Â¥!!! ÒÔǰûÓÐÌý˵¹ýselect count(o) from Order; ѧϰÁË¡£ select count(id) from Order!ÕâÑùÓ¦¸ÃÒ²¿ÉÒÔ select count(*) from Order ºÍselect count(o) from Order
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥ JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet ÒªÇóÈçÏÂ; 1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£ ´Ê¿âÔõôÉú³ÉÄØ£¿ ²»»á¡£ ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ ÕÒ±¾×Öµä ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ Êý¾Ý¿â ºÇºÇ ÓÃ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 ......
ÔÚJSPÒ³ÃæÓÐÒ»¸ö<input type="hidden" name="index" value="0">/>¿Ø¼þ µ±ÎÒÓÃÏÂÃæµÄJavaScriptº¯Êý¸Ä±äÆävalueµÄÖµµÄʱºò Èç¹ûÂú×ãÌõ¼þ£¨¼´i>=3µÄʱºò£©ÎªÊ²Ã´valueµÄ ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë ¼òµ¥µã¾Íµ÷ÓÃwindow.print() ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ: <html> <head> <title> ......