在java程序中用JDBC連接SQLServer的示例代碼

代碼如下，不多做解析：

import java.sql.*;

public class DBConnectionManager {
    //SQLServer 
    private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//加載驅動程序
    private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master";//設置數據庫連接串
    private String user = "sa";//數據庫登錄用戶名
    private String password = "root";//數據庫登錄密碼
    private static String message = "恭喜，數據庫連接正常！";
    public void setDriverName(String newDriverName) {
        driverName = newDriverName;
    }
    public String getDriverName() {
        return driverName;
    }

public void setUrl(String newUrl) {
    url = newUrl;
}
public String getUrl() {
    return url;
}
public void setUser(String newUser) {
    user = newUser;
}
public String getUser() {
    return user;
}
public void setPassword(String newPassword) {
    password = newPassword;
}
public String getPassword() {
    return password;
}
public Connection getConnection() {
    try {
        Class.forName(driverName);
        return DriverManager.getConnection(url, user, password);
    } catch (Exception e) {
        e.printStackTrace();
        message = "數據庫連接失敗！";
        return null;
    }
}
public static void main(String[] args) {
    try{
        DBConnectionManager dcm = new DBConnectionManager();
        Connection  conn = dcm.getConnection();
        System.out.println(message);
    }catch(Exception e){
        e.printStackTrace();
    }
}

}</pre>來自：http://xp9802.iteye.com/blog/1254698