JDK版本1.8
- Microsoft SQL Server JDBC 驱动程序 6.0
下载地址:
http://www.microsoft.com/zh-cn/download/details.aspx?id=11774 - 安装完成,在任意盘中创建一个文件夹SQLServer,找到sqljdbc_6.0\chs\jre8将文件 sqljdbc42.jar 复制到SQLServer文件夹中,复制该文件夹的路径
- 配置环境变量:
在CLASSPATH中追加写入路径,无CLASSPATH则新建CLASSPATH写入 - 将 sqljdbc42.jar 复制到\jre\lib\ext下(安装JDK时的路径)
- 测试
public class DBUtils {
private static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=mydb1";//严格区分大小写
private static String username = "sa";
private static String password = "123456";
private static String driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//严格区分大小写
static {
try {
Class.forName(driverClass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, username, password);
}
public static void close(Connection con, Statement sm, ResultSet rs) {
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (sm != null) {
try {
sm.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public class Test01 {
public static void main(String[] args) throws SQLException {
Connection con = DBUtils.getConnection();
System.out.println("连接成功");
DBUtils.close(con, null, null);
}
}