数据库连接池-Druid的使用

 

 

 

package druid;

/*
*druid 数据连接池

  • */

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.FileReader;
import java.sql.Connection;
import java.util.Properties;

public class DruidDemo {
public static void main(String[] args) throws Exception {
//1. 导入 jar 包

    </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">2.定义配置文件

    </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">3.加载配置文件</span>
    Properties prop = <span style="color: rgba(0, 0, 255, 1)">new</span><span style="color: rgba(0, 0, 0, 1)"> Properties();
    </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">获取数据库的位置信息,加载数据库</span>
    prop.load(<span style="color: rgba(0, 0, 255, 1)">new</span> FileInputStream("F:\\Develop\\code\\Demo2\\src\\druid.txt"<span style="color: rgba(0, 0, 0, 1)">));

    </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">4.获取连接池对象</span>
    DataSource dataSource =<span style="color: rgba(0, 0, 0, 1)"> DruidDataSourceFactory.createDataSource(prop);

    </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">5.获取数据库连接Connection</span>
    Connection connection =<span style="color: rgba(0, 0, 0, 1)"> dataSource.getConnection();

    System.out.println(connection);

}

}