java DB: 链接MSSQL 数据库

代码：

public class MSSQLDB {
 
 private static final String DB_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
 
 private static final String DB_URL = "jdbc:sqlserver://10.50.130.22:2008;databasename=montana_mig";
 
 private static final String USER_NAME = "montana_mig";
 
 private static final String PASS_WORD = "montana_mig";
 
 public static Connection connection() {
  Connection connection = null;
  
  try {
   Class.forName(DB_DRIVER).newInstance();
   connection = DriverManager.getConnection(DB_URL,USER_NAME,PASS_WORD);
   
  } catch (InstantiationException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
   
  return connection;
 }
 
 public static void close(Connection connection) {
  if(connection != null) {
   try {
    connection.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
 }
 
 public static List<String> getReleaseVersion(Connection connection) {
  List<String> list = new ArrayList<String> ();
  String sql = "SELECT DISTINCT RELEASE_VERSION FROM UPGRADE_SCRIPTS ORDER BY RELEASE_VERSION";
  try {
   Statement statement = connection.createStatement();
   ResultSet rs = statement.executeQuery(sql);
   while(rs.next()) {
    String version = rs.getString("RELEASE_VERSION");
    list.add(version);
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
  return list;
 }
 
 public static void main(String args[]) {
  Connection connection = connection();
  System.out.println("Connection Successfully!");
  List<String> list = getReleaseVersion(connection);
  close(connection);
  for(String version: list) {
   System.out.println("version:===" + version);
  }
 }
}