»òÐíÊÇSqlServer°²×°ÎÊÌâ..... Çó½Ì£¡
SqlServer°²×°µÄ¹ý³ÌÖУ¬ÊDz»ÊÇÓÐÒ»¸öÓòµÄÅäÖ㬷þÎñÆ÷Ãû³ÆÊ¹Óñ¾»ú¼ÆËã»úÃû³Æ£¿
ÊÇÕâÑùµÄ£¬ÓиöÓ¦ÓóÌÐò£¬½øÈëµÄʱºò¾ÍÌáʾ ÕÒ²»µ½·þÎñÆ÷£¬ ÎÒ¿´ÁËÆäËûµÄÅäÖ㬳ýÁËSqlServerµÄ°æ±¾²»Ò»ÑùÍ⣬¾ÍÊÇ·þÎñÆ÷µÄÃû³Æ£¬ÎÒÔÚ°²×°µÄ¹ý³ÌÖÐʹÓõÄÊÇĬÈÏ(local)£¬¶øÁ¬½Ó·þÎñÆ÷µÄÃû³ÆÊDZ¾»úµÄÃû³Æ¡£ÊÔÎÊÈçºÎÄܹ»Ð޸ĸÃSqlµÄ·þÎñÆ÷Ãû³Æ£¿
»¹ÊÇÓÐÆäËûµÄ·½ÃæµÄ´íÎó£¿ Ð»Ð»£¡£¡£¡
Ò»頭霧Ë®£¬幫頂¡£
Â¥Ö÷¸ø³öÊý¾Ý¿âÁ¬½Ó×Ö·û´®»¹ÓзþÎñÆ÷Ãû
ÔÚSQL server°²×°ÖÐÓÐÑ¡ÔñÊDzÉÓÃÓòÓû§»¹ÊDZ¾µØ·½Ê½£¬Ò»°ã¶¼ÊÇÑ¡±¾µØµÄ
ÏÈPING·þÎñÆ÷¿´¿´Äܲ»ÄÜPINGͨ£¬ÔÙ¼ì²éÁ¬½Ó×Ö·û´®£¬ÔÙ²»Ðоͳ¢ÊÔ´ò²¹¶¡£¬ÔÙ²»Ðоͱ¸·ÝÒ»ÏÂÖØ×°Ò»±é¡£
SQL code:
ÅäÖÃÎļþ²»¶Ô...
¿´ÆðÀ´£¬ÄãÊÇ×ö¹ýÀàËÆµÄ²Ù×÷£¬
˵À´ÌýÌý£¬ÅäÖÃÎļþÎÒÒ²×öÁË£¬¾ø¶ÔûÓÐÎÊÌ⣡£¡£
Ïà¹ØÎÊ´ð£º
ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ
Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
1¡£sql2000µÄά»¤¼Æ»®ÔõôÊÖ¶¯Ö´Ðа¡£¬ºÃÏñ²»Ïñ2005ÄǸöÓиö¡°Ö´ÐС±Ñ¡ÏÎÒÏëÏÖÔÚ¾ÍÊÖ¶¯±¸·Ý£¬ÄÇÓ¦¸ÃÔõô×ö²ÅÐÐÄØ
2¡£sql2005Ôõôָ¶¨±¸·ÝÈÕÖ¾ÎļþµÄÈÎÎñÄØ£¬ºÃÏñÔÚ¡°±¸·ÝÊý¾Ý¿âÈÎÎñ¡±ÀïûÓп´µ½
»òÕߣ¬ ......
ÎÒ¿´µÄÊǰ²×°Officeʱ×Ô´øµÄMicrosoft ActiveXÊý¾Ý¶ÔÏó2.5£¨ADO£©ÆäÖеÄÄÚÈݗĿ¼ÈçÏ£º
ADO³ÌÐòÔ±²Î¿¼
->ADOX API²Î¿¼
->ADOX´úÂë·¶Àý
-> ......