Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÁË»¹ * £¿

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


Ïà¹ØÎÊ´ð£º

javaÈÕÆÚ´¦Àí - Java / Java SE

µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910

È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)  
......

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

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

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

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


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

²»»á¡£

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

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

ÓÃmap ¼üÖµ¶ÔÓ¦

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

java swing ³ÌÐòÈçºÎ´ò°ü - Java / JavaÏà¹Ø

java swing ³ÌÐòÈçºÎ´ò°ü³Éjar£¬È»ºó¿ÉÒÔͨ¹ýÅú´¦ÀíÎļþbatÖ±½ÓÔËÐУ¬ÓÐûÓÐʲô¹¤¾ßÖ±½Ó¿ÉÒÔÍê³ÉÕâÁ½¸ö¹¤×÷£¿
ÓÃjar´ò°ü£¬°ÑÔËÐÐÐèÒªµÄjar¿½±´µ½Ò»¸öĿ¼£¬Åú´¦ÀíÓà start javaw -cp .;ÆäËû°ü·¾¶ ÔËÐÐ

ÓÃzip ......

javaÖеÄ×¢½â¿ÉÒÔÓÐÄÄЩ£¿ - Java / Java EE

È磺 @superwaring("unchecked");
Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£

¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ