JDBCÁ¬½Ómicrosoft sqlserverÒªÔõôÁ¬°¡
ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè
Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´
Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....
netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶Ë¿Ú
°²×°sqlserver
´ò²¹¶¡
Æô¶¯·þÎñ
µ¼ÈëÇý¶¯°ü
sqlserver ´ò²¹¶¡µ½sp4 ÊÇ×îºÃµÄ£¡
ÏÂÀ´Êǵ¼ÈëÇý¶¯°ü£¡
дÁ´½ÓÀà ´¦ÀíÒì³£
²âÊÔ£¡
Â¥Ö÷°ÑÄãµÄ´úÂëÌù³öÀ´¿´¿´£¬»òÕß±¨´í£¬lsµÄ·½·¨¿ÉÒÔ´¦Àí
¶àÊÇδ°²×°sqlserverµÄ²¹¶¡°ü£¬½¨Òé¶àGOOGLE
Â¥Ö÷ÉϰٶȻòÕßgoogle¿´¿´°É£¡
Òª¿´ÄãÁ¬½ÓµÄÊÇsqlserver2000£¬»¹ÊÇsqlserver2005.
ÕâÁ½¸öÓõÄJDBC°üÊDz»Í¬µÄ¡£
sqlserver2000ÓÃmsbase.jar,mssqlserver.jar,msutil.jarÈý¸ö°ü
sqlserver2005ÓÃsqljdbc.jarÒ»¸ö°ü
°ÑÏàÓ¦µÄ°ü·ÅÈëclasspath,È»ºóÉ趨TCP¶Ë¿Ú£¬2005µÄ»°»¹ÒªÉ趨SQLServerBrowser£¬
×îºóÔÚ³ÌÐòÖÐÓÃÒÔÏ´úÂëÁ¬
Driver d =
(Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "userName", "password");
×¢Òâ
2000ÓÃcom.microsoft.jdbc.sqlserver.SQLServerDriverºÍ
jdbc:microsoft:sqlserver://localhost:1433", "userName", "password"
2005ÓÃcom.microsoft.sqlserver.jdbc.SQLServerDriverºÍ
jdbc:sqlserver://localhost:1433", "userName"
Ïà¹ØÎÊ´ð£º
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã
²»Ã÷°×~~~
Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â
Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ûÁ¬½ÓÍøÏߣ¬ÎÒÔÚ±¾»úÉϰ²×°µÄsqlserver2008¾Í½ø²»È¥ÁË¡£Ôõô½â¾öÄØ£¿
±¾µØ²»ÄܵǼÂð£¿.......
ÒýÓÃ
±¾µØ²»ÄܵǼÂð£¿.......
ÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄ
Óà windowsÉí·ÝÒ²²»ÄܵǼÂð£¿
ÄãÁ¬½Óµ ......
Sqlserver±í½á¹¹
Create table test
(
int parentID primary key identity(1,1),
int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
1   ......
ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯ ......