1.创建Maven项目
2.导入SQL server依赖
低版本的SQL server无法直接用maven仓库导入,需要使用新版依赖。
com.microsoft.sqlserver
mssql-jdbc
6.1.0.jre8
3.将jdbc.properties文件放入resources文件夹下
配置文件代码: user=sa password=Zd@123 url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=DD driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
4.连接测试代码
public class ConnectionTest {
@Test
public void testConnection() throws Exception {
//1.读取配置文件中的4个基本信息
InputStream is = ConnectionTest.class.getClassLoader().getResourceAsStream("jdbc.properties");
Properties properties = new Properties();
properties.load(is);
String user = properties.getProperty("user");
String password = properties.getProperty("password");
String url = properties.getProperty("url");
String driverClass = properties.getProperty("driverClass");
System.out.println(user+password+url+driverClass);
//2.加载驱动
Class.forName(driverClass);
//3.获取连接
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println(conn);
}
}
5.获取连接测试
|