Statement µÄ execute(sql) ·½·¨µÄ·µ»ØÖµ
Statement µÄ execute(sql) ·½·¨µÄ·µ»ØÖµ
true if the first result is a ResultSet object;
false if it is an update count or there are no resultsTop
// Èç¹û executeµÄ·µ»ØÖµÊÇ ResultSetÔò·µ»Ø true
boolean sta=stmt.execute(sql);
if(sta){ // ·µ»ØÖµÊÇ ResultSet
ResultSet rs=stmt.getResultSet();
..............
}
else{//
int x=stmt.getUpdateCount();
............
}
Ïà¹ØÎĵµ£º
Ò»¡¢¹ØÓÚ»ù´¡±í
Oc_COJ^c680758
rd-A6z\&[1R1] H680758
Oracle
10G֮ǰ£¬ÆôÓÃAUTOTRACE¹¦ÄÜÐèÒªÊÖ¹¤´´½¨plan_table±í£¬´´½¨½Å±¾Îª$ORACLE_HOME/rdbms/admin
/utlxplan.sql¡£µ«ÔÚ10gÖУ¬ÒѾĬÈÏ´´½¨ÁËPLAN_TABLE$µÄ»ù±í£¬²¢ÒÔpublicÓû§´´½¨ÁËÏàÓ¦µÄͬÒå´ÊPUBLIC¡£ITPUB¸öÈ˿ռäDR#IlHrT
ITPUB¸ ......
¶ÔÓÚÎÒÃÇÕâЩ½öÓõ½sql¼òµ¥²éѯ¿ª·¢ÈËÔ±À´Ëµ£¬¿ÉÄÜÖ»Á˽âһЩ»ù±¾µÄsqlº¯ÊýºÍ<>=ÕâÑùµÄÌõ¼þÓï¾ä£¬½ñÌìÒ»¸öÅóÓÑÎÊÆð£ºÄ¬ÈϵÄjoinÊÇouter»¹ÊÇinner¡£¡£¡£¡£
ÌØµØÊÕ¼¯ÁËһЩ¶«Î÷£¬Ò²Ìù³öÀ´ºÍ´ó¼Ò·ÖÏíÏ£º
joinleft outer join=left join , right outer join=right join, inner jo ......
IN
È·¶¨¸ø¶¨µÄÖµÊÇ·ñÓë×Ó²éѯ»òÁбíÖеÄÖµÏàÆ¥Åä¡£
EXISTS
Ö¸¶¨Ò»¸ö×Ó²éѯ£¬¼ì²âÐеĴæÔÚ¡£
±È½ÏʹÓà EXISTS ºÍ IN µÄ²éѯ
Õâ¸öÀý×ӱȽÏÁËÁ½¸öÓïÒåÀàËÆµÄ²éѯ¡£µÚÒ»¸ö²éѯʹÓà EXISTS ¶øµÚ¶þ¸ö²éѯʹÓà IN¡£×¢ÒâÁ½¸ö²éѯ·µ»ØÏàͬµÄÐÅÏ¢¡£
USE pubs
GO
SELECT DISTINCT pub_name
from publishers
WHERE ......
¶ÔÓÚSQL ServerÊý¾Ý¿â¹ÜÀíÔ±À´½²£¬ÒÑÂúÊÂÎñÈÕÖ¾ÊÇÒ»¸öËöËéµÄ£¬µ«Óֺܳ£¼ûµÄÎÊÌâ¡£ËüÄÜÒý·¢ÊÂÎñµÄÌáǰÖÕÖ¹£¬ÉõÖÁͨ¹ý×èÖ¹ËùÓÐÊÂÎñµÄÒýÈ룬´Ó¶øÒýÆðϵͳµÄ±ÀÀ£¡£¶ÔÓÚÊý¾Ý¿â¹ÜÀíÔ±À´Ëµ£¬¹Ø¼üÊÇÀí½â½«Òª·¢ÉúµÄÇé¿ö£¬ÒÔ±ãËûÃÇ¿ÉÒÔ×·×ÙÒýÆðÎÊÌâµÄÔÒò¡£ ÊÂÎñÈÕÖ¾Ìî³ä·½Ê½
¡¡¡¡ÒÔÏÂÊÇһЩ¿ÉÄÜÒýÆðÊÂÎñÈÕÖ¾ÌîÂúµÄÔÒò£º
¡¡¡¡ÌîÂúµ ......
SQL Server 2008ÖÐ×îеÄÎļþÁ÷¹¦ÄÜʹµÃÄã¿ÉÒÔÅäÖÆÒ»¸öÊý¾ÝÀàÐÍΪvarbinary(max)µÄÁУ¬ÒԱ㽫ʵ¼ÊÊý¾Ý´æ´¢ÔÚÎļþϵͳÖУ¬¶ø·ÇÔÚÊý¾Ý¿âÖС£Ö»ÒªÔ¸Ò⣬ÄãÈÔ¿ÉÒÔ×÷Ϊһ¸ö³£¹æµÄ¶þ½øÖÆÁÐÀ´²éѯ´ËÁУ¬¼´Ê¹Êý¾Ý×ÔÉí´æ´¢ÔÚÍⲿ¡£
¡¡¡¡ÎļþÁ÷ÌØÐÔͨ¹ý½«¶þ½øÖÆ´ó×Ö¶ÎÊý¾Ý´æ´¢ÔÚ±¾µØÎļþϵͳÖÐ,´Ó¶ø½«Windowsм¼ÊõÎļþϵͳ(NTFS)ºÍS ......