数据库连接池

//数据库连接池
public class JDBC6 {
	public static void main(String[] args) throws Exception {
		Properties properties=new Properties();
		//
		InputStream in=new FileInputStream("D:/eclipsejava/com.JDBC/src/druid.properties");
		properties.load(in);
		System.out.println(properties);
		//加载属性文件,不适用那个文件的方法
//		properties.put("username", "root");
//		properties.put("url", "jdbc:mysql://localhost:3306/jdbc?characterEncoding=UTF8&serverTimezone=UTC");
//		properties.put("password", "123456");
//		properties.put("driverClassName", "com.mysql.cj.jdbc.Driver");
		
		DataSource datasource=DruidDataSourceFactory.createDataSource(properties);
		Connection conn=datasource.getConnection();
		
		conn.close();//此处只是将该conn对象交还给连接池
		
	}

}

配置属性文件 druid.properties

#属性文件
#基本配置：
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/jdbc?characterEncding=UTF-8&serverTimezone=UTC
username=root
password=123456