2014年3月3日 星期一

連sql sever(本機端)

import java.sql.*;

public class connDB {
  private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  private static String sourceURL = "jdbc:sqlserver://localhost:1433;DatabaseName=master";
  
  
  private static String user = "(帳號)";
  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;
  }
}

沒有留言:

張貼留言