数据库连接池--druid--基本使用

黑马程序员

数据库连接池–druid–基本使用

druid.properties

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/salary
username=root
password=jia5211314
#初始化连接数量
initialSize=5
#最大连接数
maxActive=10
#最大等待时间
maxWait=3000

package cn.itcast.dataSource.druid;

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

import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;

public class Druid_Demo1 {

    public static void main(String[] args) throws IOException {

        Properties properties = new Properties();

        ClassLoader classLoader = Druid_Demo1.class.getClassLoader();

        InputStream resourceAsStream = classLoader.getResourceAsStream("druid.properties");

        properties.load(resourceAsStream);

        try {
            DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
            Connection connection = dataSource.getConnection();
            System.out.println(connection);
        } catch (Exception e) {
            e.printStackTrace();
        }


    }
}