Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLÓï·¨³ö´í£¿ - Java / Java EE

¸÷λ´óÉñ ÎÒÔÚ±àдÔËÐзÖÒ³µÄʱºò Ôõô˵ÎÒµÄSQLÓï·¨´íÎó

´úÂëÊÇ
rs = st.executeQuery("select top "+pageSize+" *from users where userId not in (select top "+pageSize*(pageNow-1)+" userId from users) ");
´íÎóÌù³öÀ´É¹É¹°¡¡£»¹ÓÐÄãÓõÄÊý¾Ý¿âÊÇʲôÊý¾Ý¿â°¡£¬Ó¦¸ÃÊÇOracleµÄ°É

*from ÖмäûÓпոñ

Êǰ¡£¬ÄãµÃ°Ñ¾ßÌå´íÎóÌù³öÀ´¿´ÏÂ,»¹ÓÐÓõÄÊÇʲôÊý¾Ý¿â°¡¡£


* from

ni de ÊÇʲôÊý¾Ý·°¡

*from ÖмäûÓпոñ

ÒýÓÃ
*from ÖмäûÓпոñ


right
 

......³öÀàËÆµÄ´íÎó¿ÉÒÔ°ÑÉú³ÉµÄÓï¾ä·Åµ½²éѯ·ÖÎöÆ÷Àï Ëû»áºÜÃ÷È·µÄ¸æËßÄãÊÇÄÄÀï³öÁË´íÎó

ÒýÓÃ

......³öÀàËÆµÄ´íÎó¿ÉÒÔ°ÑÉú³ÉµÄÓï¾ä·Åµ½²éѯ·ÖÎöÆ÷Àï Ëû»áºÜÃ÷È·µÄ¸æËßÄãÊÇÄÄÀï³öÁË´íÎó

Ҫѧ»á×Ô¼º·ÖÎöÎÊÌâ

show sql ;¿´´íÎó, *from ÖмäûÓпոñºÃÏñÒ²ÄÜÔËÐÐ,

ÎÒ˵´ó¸çÃÇ
ËûÓõÄÊÇsql server Êý¾Ý¿â°Í


ÒýÓÃ

´íÎóÌù³öÀ´É¹É¹°¡¡£»¹ÓÐÄãÓõÄÊý¾Ý¿âÊÇʲôÊý¾Ý¿â°¡£¬Ó¦¸ÃÊÇOracleµÄ°É
YES

ÒýÓÃ
show sql ;¿´´íÎó, *from ÖмäûÓпոñºÃÏñÒ²ÄÜÔËÐÐ,


1.´òÓ¡ÄãµÄsql Óï¾ä£¬ÔÚ³ÌÐòÖÐ..
2.*from ÎÒÔÚoracleÉϲâÊÔ,ÊÇ¿ÉÒÔ²éѯµÄ...

sqlÓï¾äÔÚ³ÌÐòÖÐдʱҪעÒâ¿Õ¸ñ£¬»¹ÓÐÈç¹ûÓÐ×Ö·ûÐÎʽµÄ²»ÒªÍüÁ˼Ó''

* from

topÊÇ×ֶΰɣ¬select top ÁË»¹ * £¿

²¹³äÒ»¾ä£¬°Ñ´íÎóÌù³öÀ´°¡


Ïà¹ØÎÊ´ð£º

JSP ½ÓÊÕ FORM Ìá½» - Java / Web ¿ª·¢

Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼ 
È» ......

JAVAµç×Ӵʵ䣿 - Java / Java SE

¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£


´Ê¿âÔõôÉú³ÉÄØ£¿

²»»á¡£

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ

ÓÃmap ¼üÖµ¶ÔÓ¦

Èç¹ûÓÃÊý¾Ý¿ ......

java´òÓ¡ - Java / Java EE

ÓÐË­ÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë
¼òµ¥µã¾Íµ÷ÓÃwindow.print()
ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ:
<html>
 <head>
  <title> ......

Çó½ÌJSPÏîÄ¿ÖÐÔËÓÃÄ£°åµÄ¼¼Êõ - Java / Web ¿ª·¢

ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ!
×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ......


Èç¹ûÖ±½ÓÒýÓýøÈ¥

¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö

лл¸÷λÁË£¬¿´À´Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ