Java³ÌÐòÁ¬½ÓSQL Server
µÚÒ»£ºÒªÉèÖÃSQL ServerµÄTCP/IP·þÎñ
1) ´ò¿ªSQL Server Configuration Manager”,Ë«»÷“SQL Server 2005ÍøÂçÅäÖÔ£¬µã»÷“*** µÄÐÒé” (×¢Ò⣺***´ú±íʵÀýÃüÃû£¬ÀýÈ磺accpDBµÄÐÒé)
2) Ñ¡ÔñÓұߴ°¿ÚÖеēTCP/IP”ÐÒ飬ÓÒ¼üµ¥»÷Ñ¡Ôñ“Æô¶¯”¡£
3) Ë«»÷“TCP/IP”½øÈëÊôÐÔÉèÖã¬ÔÚ“IP µØÖ·”À¿ÉÒÔÅäÖÓIPAll”ÖеēTCP ¶Ë¿Ú”£¬Ä¬ÈÏΪ1433£¬½«IPµØÖ·ÖеēÒÑÆôÓÔÉèΪ“ÊÇ”¡£
4) ÖØÐÂÆô¶¯SQL Server
µÚ¶þ£ºÁ½ÖÖÁ¬½Ó·½Ê½
µÚÒ»ÖÖ£ºodbc·½Ê½£º
»ù±¾²½ÖèºÍÁ¬½ÓSQL 2000Ïàͬ£¬ÓÐÒÔÏÂÇø±ðµã£º
µÚ¶þÖÖ£º´¿Á¬½Ó·½Ê½
SQL Server2000·½Ê½£ºµ¼Èëmsbase.jar¡¢mssqlserver.jar¡¢msutil.jar
Çý¶¯×Ö·û´®£ºcom.microsoft.jdbc.sqlserver.SQLServerDriver
URL×Ö·û´®£º
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Êý¾Ý¿âÃû
SQL Server2005·½Ê½£ºµ¼Èësqljdbc.jarr
Çý¶¯×Ö·û´®£ºcom.microsoft.sqlserver.jdbc.SQLServerDriver
URL×Ö·û´®£º
jdbc:sqlserver://localhost:1433;DatabaseName=Êý¾Ý¿âÃû
Ïà¹ØÎĵµ£º
Java ÐòÁл¯¼ò½é
Java ¶ÔÏóÐòÁл¯ÊÇ JDK 1.1 ÖÐÒýÈëµÄÒ»×鿪´´ÐÔÌØÐÔÖ®Ò»£¬ÓÃÓÚ×÷ΪһÖÖ½« Java ¶ÔÏóµÄ״̬ת»»Îª×Ö½ÚÊý×飬ÒÔ±ã´æ´¢»ò´«ÊäµÄ»úÖÆ£¬ÒÔºó£¬ÈÔ¿ÉÒÔ½«×Ö½ÚÊý×éת»»»Ø Java ¶ÔÏóÔÓеÄ״̬¡£
ʵ¼ÊÉÏ£¬ÐòÁл¯µÄ˼ÏëÊÇ “¶³½á” ¶ÔÏó״̬£¬´«Êä¶ÔÏó״̬£¨Ð´µ½´ÅÅÌ¡¢Í¨¹ýÍøÂç´«ÊäµÈµÈ£©£¬È»ºó “½ ......
ʹÓÃJava·¢ËÍGET¡¢POSTÇëÇó
——½ÚÑ¡×Ô¡¶·è¿ñJava½²Òå¡·
URLµÄopenConnection()·½·¨½«·µ»ØÒ»¸öURLConnection¶ÔÏ󣬸öÔÏó±íʾӦÓóÌÐòºÍ URL Ö®¼äµÄͨÐÅÁ´½Ó¡£³ÌÐò¿ÉÒÔͨ¹ýURLConnectionʵÀýÏò¸ÃURL·¢ËÍÇëÇó¡¢¶ÁÈ¡URLÒýÓõÄ×ÊÔ´¡£
ͨ³£´´½¨Ò»¸öºÍ URL µÄÁ¬½Ó£¬²¢·¢ËÍÇëÇó¡¢¶ÁÈ¡´Ë URL ÒýÓõÄ×ÊÔ´ÐèÒªÈçϼ¸¸ö² ......
1.Çëд³öÏÂÁÐJava´úÂëµÄÊä³ö½á¹û
package test;
public class FatherClass()
{ public FatherClass()
&n ......