java jdbc:odbc 连接MS SQL 2008

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConnection {
	static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	static final String URL = "jdbc:sqlserver://127.0.0.1:1433;databaseName=testDb";
	static final String USER = "sa";
	static final String PWD = "123456";

	public static Connection getConnection() {		
		Connection con=null;
		try{
			Class.forName(DRIVER);
			con = DriverManager.getConnection(URL, USER,PWD);
			
		}catch(Exception e){
			System.out.println(e.getMessage());
		}
		return con;
	}
}

以上是贴出一个连接的方法，获取Connection

当中要用到的jar 包：sqljdbc4.jar，可以去点击 资源下载