java jdbc 连接数据库

@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);
}