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

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½øÈ¥¸øSQL°É£¡

ÁíÍâ˵µÄOracle·ÖÒ³£¬ÊDz»ÊÇOracle±¾ÉíÒ²ÄÜ·ÖÒ³£¬ÔÚÓ¦ÓóÌÐòÖÐÒ²ÊDz»ÐèÒª½èÖúÆäËüµÄÄØ£¿
sqlÓï¾ä¿Ï¶¨ÊÇͨ¹ý³ÌÐò´«½øÈ¥µÄÈö£¬Õâ¸öÊÇ¿ÉÒÔÆ´³öÀ´µÄ

java·ÖÒ³ÊÇɶ°¡£¿Ä㻹ûŪÃ÷°×·ÖÒ³º¬Ò壬·ÖÒ³Î޷ǾÍÊÇÄã²éѯ³öÀ´µÄÊý¾Ý°´ÕÕÒ³ÂëÀ´ÏÔʾ£¬Èç¹û²éѯ³öÀ´Êý¾ÝºÜ¶àÒ»°ã²ÅÐèÒª·ÖÒ³£¬Êý¾Ý²»¶àÒ»°ã²»ÐèÒª·ÖÒ³£¬·Öҳʱ¿ÉÒÔÓÐÁ½ÖÖ·½Ê½£º
£¨1£©£ºÒ»´ÎÐÔ²éѯ³öÀ´£¬È»ºó¸ù¾Ý²»Í¬Ò³ÂëÀ´ÏÔʾ³öÏàÓ¦½á¹û(select * from table )
£¨2£©£ºÃ¿´ÎÖ»²éѯÄãÐèÒªÏÔʾµÄÌõÊý£¬È»ºó¸ù¾ÝÄãÌṩµÄÒ³ÂëÏÔʾÏàÓ¦µÄ¼Ç¼Êý£¬Õâʱһ°ãÓÃsqlÀ´²éѯ£¬±ÈÈçÿҳÏÔʾ5Ìõ£¬ÏÖÔÚÊǵڶþÒ³£¬ÄÇôÎҾͲéÊý¾ÝÖÐ5-10Ìõ£¬¾ßÌåsql¾Í²»Ð´ÁË¡£(ÍøÉϲéϺܼòµ¥)

Õâ¸ö»áŶ£¬Ö»ÊÇÓиöÈËÎÊÎÒ »á²»»ásql·ÖÒ³ºÍorale·ÖÒ³


ûÔõôÓùýSQl serverÊý¾Ý¿â¡£ÎÒÒ»°ãÓÃOracle¡¢Mysql×ö·ÖÒ³£¬ÆäʵÿÖÖÊý¾Ý¿â¶¼ÓÐ×Ô¼ºµÄ·ÖÒ³·½·¨£¬¶øÎÒÃdz£ÓõÄHibernate·ÖÒ³·½·¨¾ÍÊǶÔOracle¡¢MySQL µÈÊý¾Ý¿âµÄ·ÖÒ³·½·¨½øÐÐÁË·â×°£¬Oracle·ÖÒ³²ÉÓÃrownum£¨OracleµÄ×ֶΣ¬³ÆΪαÁÓ£¬²»Ã÷°×µÄ¿ÉÒÔÉÏÍø²éѯ)ʵÏÖ£¬MysQL²ÉÓÃlimit£¨ÍøÉÏ¿ÉÒÔ²éѯ£©ÊµÏÖ£¬¿ÉÒÔ˵ÎÒÃÇÖ»Òª´«ÈëÒ³Âëµ½·ÖÒ³·½·¨Öм´¿ÉʵÏÖ·ÖÒ³

ÄãÓÃµÄ SQL Server ÊÇʲô°æ±¾µÄ£¿Èç¹ûÊÇ 2000 »òÕß֮ǰµÄ»°ÄǵÃʹÓÃÂé·³µÄ TOP ×Ӿ䣬Èç¹ûÊÇ 2005 »òÕßÊÇÒÔºóµÄ°æ±¾¿ÉÒÔʹÓÃÓë Oracle Ò»ÑùÓï·¨µÄ row_number() ·ÖÎöº¯Êý¡£

ÒýÓÃ
Õâ¸ö»áŶ£¬Ö»ÊÇÓиöÈËÎÊÎÒ »á²»»ásql·ÖÒ³ºÍorale·ÖÒ³


Ïà¹ØÎÊ´ð£º

JSP/Servlet½»»¥ - Java / Web ¿ª·¢

JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
  JSPÒ³Ã潫²ÎÊýPOST¸øservlet
  
  ÒªÇóÈçÏÂ;
  1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......

java socket email ÎÊÌâ - Java / Java SE

ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:

package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......

FCKÉÏ´«Îļþµ½linux·þÎñÆ÷ÎÊÌâ - Java / Java EE

ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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ºÍtomcatÎÊÌ⣬¿ì·èÁË - Java / Java EE

ÎÒдÁ˸öjspÒ³Ã棬Ȼºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³Ãæʱ£¬ËÀ»î¶¼ÊÇÔ­À´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØв¿ÊðÕâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ