javaweb jdbc获取mysql连接的四种方式

我这里总结了jdbc连接数据库的四种方式，建议用最后一种

package com.alex.jdbc;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

import org.junit.Test;


public class TextConnection2  {
	
	//方式一
	@Test
	public void test01() throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		
		String url = "jdbc:mysql:///girls?user=root&password=root";
		Connection connection = DriverManager.getConnection(url);
		System.out.println(connection);
	}
	//方式二
	@Test
	public void test02() throws Exception{
		Class.forName("com.mysql.jdbc.Driver");
		
		String url = "jdbc:mysql://localhost:3306/girls";
		String username = "root";
		String password = "root";
		Connection connection = DriverManager.getConnection(url, username, password);	
		
		System.out.println(connection);
	}
	//方式三
	@Test
	public void test03() throws Exception{
Class.forName("com.mysql.jdbc.Driver");
		
		Properties properties = new Properties();
		properties.load(new FileInputStream("resource/db.properties"));
		String url = "jdbc:mysql://localhost:3306/girls";
		Connection connection = DriverManager.getConnection(url, properties);
		System.out.println(connection);

	}
	//方式四
	@Test
	public void test04() throws Exception {

		//读取配置文件
		Properties properties = new Properties();
		properties.load(new FileInputStream("resource/db.properties"));
		
		String driverClass = properties.getProperty("driverClass");
		String url = properties.getProperty("url");
		String user = properties.getProperty("username");
		String password = properties.getProperty("password");
		
		Class.forName(driverClass);
		
		Connection connection = DriverManager.getConnection(url, user, password);
		System.out.println("Test04 " + connection);
	}

}

使用的db.properties文件：

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql:///girls?rewriteBatchedStatements=true&useServerPrepStmts=false
username=root
password=root