Druid德鲁伊_数据库连接池技术

【druid-1.1.21.jar】【druid-1.1.21-sources.jar】

---

步骤一:在src下新建druid.properties文件

url=jdbc:mysql:///data
username=root
password=123456
driverClassName=com.mysql.jdbc.Driver

initialSize=10
maxActive=10

步骤二:获取数据库连接和关闭数据库

package com.druid;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import javax.sql.DataSource;

import org.junit.Test;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;

public class TestDruid {

//	获取数据库连接
	public void getConnection() throws Exception {

		Properties pros = new Properties();

		InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
		pros.load(is);

		DataSource source = DruidDataSourceFactory.createDataSource(pros);
		Connection conn = s