ado·ÃÎÊÔ¶³ÌÊý¾Ý¿â(Ô¶³Ì·ÃÎÊsqlserver)
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§¶ËÕâ±ßÎÒÉÏÓÃACESSS\vbaÀ´×ö³ÌÐò£¬ÒªÔõô²ÅÄÜÁ¬½Ó·ÃÎʵ½ÎÒ·þÎñÆ÷ÀïÃæµÄÁ½¸öÊý¾Ý¿âµÄÊý¾ÝÄØ£¿Ð»Ð»
http://hi.baidu.com/jjg0513/blog/item/23174d551c795ecdb745aef5.html
²Î¿¼ÏÂ
Ò»´ÎÖ»ÄÜÒ»¸ö.
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2
ÄãÓÃADOÁ¬½ÓÖ±½Ó·ÃÎÊÄãµÄ·þÎñÆ÷
ΪʲôҪÊÇACCESSµÄ
Â¥ÉÏÄãÌ«¸ãЦÁË°É¡£ÄãµÄÒâ˼ÊÇSQLÖ»Äܽ¨Ò»¸öÊý¾Ý¿âà¶
ÎÚ¹êµÄÒâ˼ÊÇÒ»´ÎÖ»ÄÜÁ¬½ÓÒ»¸öÊý¾Ý¿â
ÓÃÁ½¸öÁ¬½ÓÀ´Á¬
Ôõô¸öÁ¬½Ó·¨£¬Ëµ¾ßÌåÒ»µãß¹¡£¡£¸ßÊÖÃÇ
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
xp(sp3)ϵͳ°²×°ÁËsqlserver2000£¬sp3£¬sp4²¹¶¡¶¼´òÁË¡£¶øÇÒ±¾»úÒ²ÄÜÁ¬½Ó·ÃÎÊ¡£
ÎÊÌâÊÇ£º
±¾»útelnet ip 1433 ×ÜÊÇÌáʾÁ¬½Óʧ°Ü£¬
¶øÇÒnetstat -naʱ£¬¿´²»µ½1433¶Ë¿Ú±»Õ¼ÓÃ
(¿Ï¶¨µÄÊÇ£º¶Ë¿ÚÊÇ1433£¬¿ªÆ ......
package com.tongying.www.until;
public class Resource {
// MySQlÊý¾Ý¿âµÄ×ÊÔ´
/* public static final String DRIVER="com.mysql.jdbc.Driver";
public static final String URL=&qu ......
ÎÒ´Ó΢Èí¹ÙÍøÏÂÔصÄdriverÔõôÊǸöhtmlÎļþ˸øÖ¸Õýһϣ¬ÔÚÄÄÀïÏ£¬¾ßÌå·¾¶¼°²Ù×÷²½Öè
Ò»°ã¹ÜÍøÏÂÔض¼ÒªÒ»²½Ò»²½×ßÏÂÈ¥£¬Èç¹ûÄã¹ýÔçÁí´æΪµÄ»°£¬µÃµ½µÄÍùÍùÊÇlicenseÄÇÒ»Ò³¡£
ÎҼǵĺÃÏëÔÚ£ºÄãϵÄÄǸöHTMLÎļ ......