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();
............
}
Ïà¹ØÎĵµ£º
¶ÔÓÚÎÒÃÇÕâЩ½öÓõ½sql¼òµ¥²éѯ¿ª·¢ÈËÔ±À´Ëµ£¬¿ÉÄÜÖ»Á˽âһЩ»ù±¾µÄsqlº¯ÊýºÍ<>=ÕâÑùµÄÌõ¼þÓï¾ä£¬½ñÌìÒ»¸öÅóÓÑÎÊÆð£ºÄ¬ÈϵÄjoinÊÇouter»¹ÊÇinner¡£¡£¡£¡£
ÌصØÊÕ¼¯ÁËһЩ¶«Î÷£¬Ò²Ìù³öÀ´ºÍ´ó¼Ò·ÖÏíÏ£º
joinleft outer join=left join , right outer join=right join, inner jo ......
SQL Native Client ODBC Driver
±ê×¼°²È«Á¬½Ó
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ÄúÊÇ·ñÔÚʹÓÃSQL Server 2005 Express ÇëÔÚ“Server”Ñ¡ÏîʹÓÃÁ¬½Ó±í´ïʽ“Ö÷»úÃû³Æ\SQLEXPRESS”¡£
ÊÜÐŵÄÁ¬½Ó
Driver={SQL Native ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice disk, testBack, c:mssql7backupMyNwind_1.dat
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ë ......
ÔÚ¶ÔSQL ServerϵͳִÐÐÈëÇÖ²âÊÔ»òÕ߸ü¸ß¼¶±ðµÄ°²È«Éó¼Æʱ£¬ÓÐÒ»ÖÖ²âÊÔ²»Ó¦¸Ã±»ºöÂÔ£¬ÄǾÍÊÇSQL ServerÃÜÂë²âÊÔ¡£ÕâÒ»µã¿´ÆðÀ´ÏÔ¶øÒ×¼û£¬µ«ÊǺܶàÈ˶¼»áºöÂÔËü¡£
¡¡¡¡ÃÜÂë²âÊÔ¿ÉÒÔ°ïÖú¼ì²é¶ñÒâÈëÇÖÕß»òÕßÍⲿ¹¥»÷Õߣ¬²âÊÔËûÃÇҪǿÐнøÈëÊý¾Ý¿âÓжàÈÝÒ×£¬¶øÇÒ»¹¿ÉÒÔÈ·±£SQL ServerÓû§¶ÔËûÃǵÄÕ˺ŸºÔð¡£´ËÍ⣬²âÊÔÃÜÂëµÄ© ......