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();
............
}
Ïà¹ØÎĵµ£º
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DATABASE database ......
Ò»¡¢»ù´¡
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¡¢Ë ......
¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL Server±íµ¼ÈëÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬Äã¿ÉÒÔÔÚT-SQL(Transact-SQL£¬Î¢Èí¶ÔSQLµÄÀ©Õ¹)ÖÐÓÃOPENROWSETº¯Êý¸øÊý¾ÝÔ´´«ÈëÒ»¸öÁ¬½Ó´®ºÍ²éѯÀ´ÌáÈ¡ÐèÒªµÄÊý¾Ý¡£
¡¡¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL ......
Ãæ¶ÔÏÖʵ°É£¬ËäÈ»Äã´ÓÀ´Ã»ÓдòËã³ÉΪһÃûSQL Serverר¼Ò£¬µ«ÊÇËæ×ÅÊý¾Ý¿âÒýÇæÖÖÀàºÍ°æ±¾µÄÔö¼Ó£¬Õâ¾ÍÒªÇóһЩÈËÀ´×¨ÃÅ´Óʲ¢¹Ø×¢Õâ·½ÃæµÄÄÚÈÝ¡£×÷Ϊ“΢ÈíÈË”(»òÕß³ÆÎªGal),ÎÞÂÛÄãÊDz»ÊÇÔ¸Ò⣬Äã¶¼±»Ñ¡ÖÐÁË¡£ÕâһϵÁеÄÎÄÕÂÈ«¶¼ÊǹØÓÚ°ïÖú×÷Ϊ¹ÜÀíÔ±¶ø·Ç³ÌÐòÔ±µÄÄãÔÚʹÓÃSQL Serverʱ¸ü¼Ó¸ßЧ¡£
¡¡¡¡ÔÚʵ¼ÊÖ´ÐÐ ......