package jdbcTest;

import java.sql.Connection;
import java.sql.DriverManager;

public class JdbcTest {

?
?public static void main(String[] args) {
??// TODO Auto-generated method stub
??String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
??String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=.";
??String userName="***";
??String userPwd="";
??try
??{
??Class.forName(driverName);
??System.out.println("加載驅(qū)動成功！");
??}catch(Exception e){
??e.printStackTrace();
??System.out.println("加載驅(qū)動失??！");
??}
??try{
??Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
??System.out.println("連接數(shù)據(jù)庫成功！");
??}catch(Exception e)
??{
??e.printStackTrace();
??System.out.print("SQL Server連接失敗！");
??}
??
?}

}

/*加載驅(qū)動成功！
com.microsoft.sqlserver.jdbc.SQLServerException: 通過端口 1433 連接到主機 localhost 的 TCP/IP 連接失敗。錯誤:“Connection refused: connect。請驗證連接屬性。確保 SQL Server 的實例正在主機上運行，且在此端口接受 TCP/IP 連接，還要確保防火墻沒有阻止到此端口的 TCP 連接?！?。
?at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
?at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
?at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
?at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
?at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
?at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
?at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
?at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
?at java.sql.DriverManager.getConnection(DriverManager.java:582)
?at java.sql.DriverManager.getConnection(DriverManager.java:185)
?at jdbcTest.JdbcTest.main(JdbcTest.java:24)
SQL Server連接失敗！*/