1銆佷笅杞絊QL Server 2000 driver for JDBC
SQL Server 2000 Driver For JDBC Downloads
璇ラ┍鍔ㄦ埅姝㈢洰鍓嶆湁鍥涗釜鐗堟湰錛屽緩璁笅杞芥渶鏂扮殑SP3鐗堛?
璇ラ┍鍔ㄥ畨瑁呮垚鍔熷悗錛岃灝嗗畨瑁呯洰褰曚笅鐨刲ib鐩綍涓嬬殑涓変釜.jar鏂囦歡鍔犲埌CLASSPATH涓紱濡傛灉浣犱嬌鐢ㄧ殑鏄疛Builder鎴朎clipse錛屽皢榪欎笁涓枃浠舵牴鎹甀DE鐨勬彁紺哄姞鍒板伐紼嬩腑涔熷彲銆?
2銆佸崌綰т綘鐨凷QL Server 2000錛屼負鍏舵墦涓婃渶鏂扮殑琛ヤ竵銆?
榪欎竴姝ュ彲鑳戒笉鏄繀闇鐨勶紝鍥犳搷浣滅郴緇熺幆澧冭屽畾錛屽湪涓嶆墦琛ヤ竵鐨勬儏鍐碉紝鏈夋椂鍙互姝e父榪炴帴錛屾湁鏃跺嵈涓嶈兘錛屾墍浠ュ緩璁繕鏄畨瑁呮渶鏂扮殑SQL Server 2000琛ヤ竵錛圫P4錛夊拰JDBC椹卞姩錛圫P3錛夈?
濡傛灉浣犵殑紼嬪簭鍦ㄨ繍琛屾椂鎻愮ず錛欵rror establishing socket錛屼竴鑸儏鍐典笅錛屾墦涓奡QL Server 2000鐨勮ˉ涓佸氨鍙В鍐熾?
3銆侀┍鍔ㄧ殑鍔犺澆鏂規(guī)硶
鍦ㄥ緩绔嬭繛鎺ヤ箣鍓嶏紝瑕佸厛鍔犺澆SQL Server 2000 JDBC鐨勯┍鍔紝浠g爜褰㈠紡濡備笅錛?
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
鍦ㄦ娉ㄦ剰錛宖orName鏂規(guī)硶鐨勫弬鏁板瓧絎︿覆蹇呴』瀹屽叏鐩稿悓浜庝互涓婂唴瀹癸紝澶у皬鍐欐槸鍖哄垎鐨勶紝鍏跺疄榪欎釜涓插氨鏄┍鍔ㄧ被鐨勫畬鏁村悕縐幫細鍖呭悕+綾誨悕銆?
4銆佽幏寰椾竴涓繛鎺?
鍦?a decor-unline"="" target="_blank" rel="nofollow" data-word="1" style="color: #2d64b3;">鎿嶄綔鏁?/a>鎹簱涔嬪墠錛岃鍏堣幏寰椾笌鏁版嵁搴撶殑涓涓繛鎺ワ紝浣跨敤濡備笅浠g爜鏍煎紡錛?
DriverManager.getConnection(榪炴帴瀛楃涓? 鐧誨綍鐢ㄦ埛鍚? 鐧誨綍瀵嗙爜);
渚嬶細
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs", "sa", "");
鍦ㄦ澶勫叧閿殑鏄繛鎺ュ瓧絎︿覆鐨勫唴瀹癸紝localhost閮ㄥ垎鍗蟲湇鍔″櫒鐨勫悕瀛楋紝鍙互鏇存敼錛?433閮ㄥ垎涓篠QL Server浣跨敤鐨?a decor-unline"="" target="_blank" rel="nofollow" data-word="0" style="color: #2d64b3;">绔彛鍙?/a>錛屾牴鎹疄闄呮儏鍐典慨鏀瑰嵆鍙紱DatabaseName鍗充負瑕佽繛鎺ョ殑鏁版嵁搴撶殑鍚嶅瓧錛屽湪姝ゆ敞鎰廌atabaseName涔嬪墠鐨勬槸鍒嗗彿錛岃屼笉鏄?a decor-unline"="" target="_blank" rel="nofollow" data-word="2" style="color: #2d64b3;">鍐掑彿銆?
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 dbConn
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
}
Catch (Exception e) {
e.printStackTrace();
}
}
}
6銆佸彲鑳藉嚭鐜扮殑闂
濡傛灉浠ヤ笂鐨勪唬鐮佽繍琛屽悗錛岃緭鍑?Connection Successful!"錛岄偅灝變唬琛ㄤ竴鍒囨甯革紝榪炴帴鏁版嵁搴撴垚鍔燂紝浣犲彲浠ヨ繘琛孲tatement銆丷esultSet鐨勬搷浣滀簡錛涘弽涔嬬殑璇濓紝涓瀹氭槸鍑虹幇浜嗙浉搴旂殑寮傚父銆?
濡傛灉鎻愮ず閿欒"Error establishing socket"錛岃鏍規(guī)嵁涔嬪墠鐨勮鏄庡畨瑁呯浉搴旂殑SQL Server 2000琛ヤ竵鍗沖彲銆?
濡傛灉鎻愮ず"ClassNotFoundException"錛岄偅涓瀹氭槸 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 璇ユ浠g爜鎷煎啓鏈夎錛屾垨鑰呮槸SQL Server 2000 Driver For JDBC Lib鐩綍涓嬬殑涓変釜.jar鏂囦歡鏈姞鍏ュ埌CLASSPATH涓?/pre>

]]>