@Test
public void testConnection() throws Exception {
Driver driver = new com.mysql.jdbc.Driver();
String url = "jdbc:mysql://localhost:3306/java";
Properties properties = new Properties();
properties.put("user", "root");
properties.put("password", "");
Connection connection = driver.connect(url, properties);
System.out.println(connection);
}
jdbc.properties 文件
driver=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/java
user=root
password=
@Test
public void testDriverManager() throws Exception {
String driverClass = null;
String jdbcUrl = null;
String user = null;
String password = null;
// 输入流
InputStream inputStream = getClass().getClassLoader().getResourceAsStream("jdbc.properties");
// 获取文件属性值
Properties properties = new Properties();
properties.load(inputStream);
driverClass = properties.getProperty("driver");
jdbcUrl = properties.getProperty("jdbcUrl");
user = properties.getProperty("user");
password = properties.getProperty("password");
// 加载驱动程序
Class.forName(driverClass);
Connection connection = DriverManager.getConnection(jdbcUrl, user, password);
System.out.println(connection);
}