JavaÁ¬½ÓSQL Server 2000
Êý¾Ý¿â²Ù×÷ÏÖÔÚÊÇÏîÄ¿¿ª·¢µÄ¸ù±¾£¬Ñ§Ï°JavaÊ×ÏÈÓ¦¸Ãѧ»áÔõôÑùÁ¬½ÓÊý¾Ý¿â£¬ÓÃJavaÁ¬½ÓÊý¾Ý¿â¿É²»ÏñÓÃDelphiÕâÀ๤¾ßÄÇÑùÉ輸¸öÊôÐÔ¾ÍOK£¬Ëµ¼òµ¥Ò²¼òµ¥£¬Ëµ¸´ÔÓ£¬ÆäʵҲͦ¸´Ôӵ쬶øÇÒºÜÂé·³£¬Èç¹ûÊdzõѧ£¬¸ù±¾²»Äܱ£Ö¤µÚÒ»´Î¾ÍÁ¬½Ó³É¹¦£¬ÏÂÃæÒÔSQL Server 2000ΪÀý£¬ËµËµJavaÁ¬½ÓÊý¾Ý¿âµÄ»ù±¾·½·¨£¬Ò²¼Ç¼һÏÂÐĵá£
1¡¢ÏÂÔØSQL Server 2000 driver for JDBC
SQL Server 2000 Driver For JDBC Downloads
¸ÃÇý¶¯½ØÖ¹Ä¿Ç°ÓÐËĸö°æ±¾£¬½¨ÒéÏÂÔØ×îеÄSP3°æ¡£
¸ÃÇý¶¯°²×°³É¹¦ºó£¬Ç뽫°²×°Ä¿Â¼ÏµÄlibĿ¼ÏµÄÈý¸ö.jarÎļþ¼Óµ½CLASSPATHÖУ»Èç¹ûÄãʹÓõÄÊÇJBuilder»òEclipse£¬½«ÕâÈý¸öÎļþ¸ù¾ÝIDEµÄÌáʾ¼Óµ½¹¤³ÌÖÐÒ²¿É¡£
2¡¢Éý¼¶ÄãµÄSQL Server 2000£¬ÎªÆä´òÉÏ×îеIJ¹¶¡¡£
ÕâÒ»²½¿ÉÄܲ»ÊDZØÐèµÄ£¬Òò²Ù×÷ϵͳ»·¾³¶ø¶¨£¬ÔÚ²»´ò²¹¶¡µÄÇé¿ö£¬ÓÐʱ¿ÉÒÔÕý³£Á¬½Ó£¬ÓÐʱȴ²»ÄÜ£¬ËùÒÔ½¨Ò黹Êǰ²×°×îеÄSQL Server 2000²¹¶¡£¨SP4£©ºÍJDBCÇý¶¯£¨SP3£©¡£
Èç¹ûÄãµÄ³ÌÐòÔÚÔËÐÐʱÌáʾ£ºError establishing socket£¬Ò»°ãÇé¿öÏ£¬´òÉÏSQL Server 2000µÄ²¹¶¡¾Í¿É½â¾ö¡£
3¡¢Çý¶¯µÄ¼ÓÔØ·½·¨
ÔÚ½¨Á¢Á¬½Ó֮ǰ£¬ÒªÏȼÓÔØSQL Server 2000 JDBCµÄÇý¶¯£¬´úÂëÐÎʽÈçÏ£º
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ÔÚ´Ë×¢Ò⣬forName·½·¨µÄ²ÎÊý×Ö·û´®±ØÐëÍêÈ«ÏàͬÓÚÒÔÉÏÄÚÈÝ£¬´óСдÊÇÇø·ÖµÄ£¬ÆäʵÕâ¸ö´®¾ÍÊÇÇý¶¯ÀàµÄÍêÕûÃû³Æ£º°üÃû+ÀàÃû¡£
4¡¢»ñµÃÒ»¸öÁ¬½Ó
ÔÚ²Ù×÷Êý¾Ý¿â֮ǰ£¬ÒªÏÈ»ñµÃÓëÊý¾Ý¿âµÄÒ»¸öÁ¬½Ó£¬Ê¹ÓÃÈçÏ´úÂë¸ñʽ£º
DriverManager.getConnection(Á¬½Ó×Ö·û´®, µÇ¼Óû§Ãû, µÇ¼ÃÜÂë);
Àý£º
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs", "sa", "");
ÔÚ´Ë´¦¹Ø¼üµÄÊÇÁ¬½Ó×Ö·û´®µÄÄÚÈÝ£¬localhost²¿·Ö¼´·þÎñÆ÷µÄÃû×Ö£¬¿ÉÒÔ¸ü¸Ä£»1433²¿·ÖΪSQL ServerʹÓõĶ˿ںţ¬¸ù¾Ýʵ¼ÊÇé¿öÐ޸ļ´¿É£»DatabaseName¼´ÎªÒªÁ¬½ÓµÄÊý¾Ý¿âµÄÃû×Ö£¬ÔÚ´Ë×¢ÒâDatabaseName֮ǰµÄÊǷֺţ¬¶ø²»ÊÇðºÅ¡£
5¡¢´úÂëʵÀý
// µ¼ÈëJava SQL°ü£¬Á¬½ÓÊý¾Ý¿â±ØÐ裻
import java.sql.*;
public class TestDB {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs";
String userName = "sa";
String userPwd = "";
Connection dbCo
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Ò»£º×¼±¸ www.savarese.org download
1. rocksaw-1.0.0-src.tar.gz
2. vserv-tcpip-0.9.2-src.tar.gz
¶þ£º±àÒëÔ´ÎļþµÃµ½jar°ü ʹÓÃAnt
1. build vserv-tcpip-0.9.2-src
ÔÚvserv-tcpip-0.9.2Ŀ¼ÏÂÃæ½¨Ò»¸ötestsĿ¼£¬È»ºóÔÚcmd´°¿ÚϽøÈë ......
SunÔÚJava5ÖУ¬¶ÔJavaÏ̵߳ÄÀà¿â×öÁË´óÁ¿µÄÀ©Õ¹£¬ÆäÖÐÏ̳߳ؾÍÊÇJava5µÄÐÂÌØÕ÷Ö®Ò»£¬³ýÁËÏ̳߳ØÖ®Í⣬»¹Óкܶà¶àÏß³ÌÏà¹ØµÄÄÚÈÝ£¬Îª¶àÏ̵߳ıà³Ì´øÀ´Á˼«´ó±ãÀû¡£ÎªÁ˱àд¸ßЧÎȶ¨¿É¿¿µÄ¶àÏ̳߳ÌÐò£¬Ï̲߳¿·ÖµÄÐÂÔöÄÚÈÝÏÔµÃÓÈÎªÖØÒª¡£
ÓйØJava5Ïß³ÌÐÂÌØÕ÷µÄÄÚÈÝÈ«²¿ÔÚjava.util.concurrentÏÂÃæ£¬ÀïÃæ°üº¬ÊýÄ¿ÖÚ¶à ......
javaÖеÄÐÞÊηû
static ±íʾ¾²Ì¬£¬Ëü¿ÉÒÔÐÞÊÎÊôÐÔ£¬·½·¨ºÍ´úÂë¿é¡£
1£¬staticÐÞÊÎÊôÐÔ£¨Àà±äÁ¿£©£¬ÄÇôÕâ¸öÊôÐԾͿÉÒÔÓà ÀàÃû.ÊôÐÔÃû À´·ÃÎÊ£¬Ò²¾ÍÊÇʹÕâ¸öÊôÐÔ³ÉΪ±¾ÀàµÄÀà±äÁ¿£¬Îª±¾Àà¶ÔÏóËù¹²ÓС£Õâ¸öÊôÐÔ¾ÍÊÇÈ«À๫ÓС££¨¹²ÓеÄÀà±äÁ¿Óë¶ÔÏóÎ޹أ¬Ö»ºÍÀàÓйأ©¡£
Àà¼ÓÔØµÄ¹ý³Ì£¬Àà±¾ÉíÒ²ÊDZ£´æÔÚÎļþÖУ¨×Ö½ÚÂëÎļþ± ......
1 JAVAµÄ·´Éä,Æäʵ¾ÍÊÇͨ¹ýÒ»¸öʵÀý»¯µÄ¶ÔÏó·´¹ýÀ´È¥ÕÒµ½Ò»¸öÀàµÄÍêÕûÐÅÏ¢,±ÈÈç¶ÔÓÚÈçϵÄÐÎʽ:
X x=new X();
x.getClass().getName();
ÕâÀï¾Í»áÊä³öÕâ¸öÀàËùÔÚµÄÍêÕûÐÅÏ¢,¼´"°üÃû.ÀàÃû";
×î³£ÓõÄÈýÖÖʵÀý»¯CLASSÀà¶ÔÏó
Class<?> c1 = null ; // Ö¸¶¨·ºÐÍ
C ......