[sql server] 連sql server (非本機端架設)

●連線code

在 sql server 2000 中的語法是
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://ip:1433;DatabaseName=sample","user","pawd";

而 sql server 2005 則為
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://ip:1433;DatabaseName=sample","user","pawd";

這樣子就大功告成，如果是要方便往後的系統沿用，可以包成公用物件.jar，程式需要連到sql資料庫時下 connection會比較簡便。

package test;

import java.sql.*;

public class connDB {
  private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  private static String sourceURL = "jdbc:sqlserver://ip:1433;DatabaseName=name";
  private static String user = "test";
  private static String password = "(密碼)";
  private static Connection conn = null;


  public connDB() {
    try{
      Class.forName(driver);
      conn = DriverManager.getConnection(sourceURL,user,password);
    }
    catch(Exception ex)
    {
      System.out.println(ex.getMessage());
    }
  }
  public static Connection getConn()
  {
    return conn;
  }
}