Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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)  
......

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

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


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

²»»á¡£

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

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

ÓÃmap ¼üÖµ¶ÔÓ¦

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

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

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

ÓÃzip ......

java windows7 MSSQL - Java / Java SE

ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïenglish-unitedstates
ΨһÇø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......

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

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

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