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

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µÄjoin

¶ÔÓÚÎÒÃÇÕâЩ½öÓõ½sql¼òµ¥²éѯ¿ª·¢ÈËÔ±À´Ëµ£¬¿ÉÄÜÖ»Á˽âһЩ»ù±¾µÄsqlº¯ÊýºÍ<>=ÕâÑùµÄÌõ¼þÓï¾ä£¬½ñÌìÒ»¸öÅóÓÑÎÊÆð£ºÄ¬ÈϵÄjoinÊÇouter»¹ÊÇinner¡£¡£¡£¡£
ÌصØÊÕ¼¯ÁËһЩ¶«Î÷£¬Ò²Ìù³öÀ´ºÍ´ó¼Ò·ÖÏíÏ£º
joinleft outer join=left join ,   right outer join=right join,     inner jo ......

SQL Server 2005 Á¬½Ó×Ö·û´®´úÂë


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 ......

Êý¾Ý¿â»ù±¾ SQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
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ÃÜÂë²âÊÔ¡£ÕâÒ»µã¿´ÆðÀ´ÏÔ¶øÒ×¼û£¬µ«ÊǺܶàÈ˶¼»áºöÂÔËü¡£
¡¡¡¡ÃÜÂë²âÊÔ¿ÉÒÔ°ïÖú¼ì²é¶ñÒâÈëÇÖÕß»òÕßÍⲿ¹¥»÷Õߣ¬²âÊÔËûÃÇҪǿÐнøÈëÊý¾Ý¿âÓжàÈÝÒ×£¬¶øÇÒ»¹¿ÉÒÔÈ·±£SQL ServerÓû§¶ÔËûÃǵÄÕ˺ŸºÔð¡£´ËÍ⣬²âÊÔÃÜÂëµÄ© ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ