DBCPUtils配置

1：导入jar包

2：配置properties文件

3：写入java代码：

package DBCP连接池Demo.DBCPUtils;

import org.apache.commons.dbcp2.BasicDataSourceFactory;

import javax.sql.DataSource;
import java.io.*;
import java.sql.Connection;
import java.util.Properties;

public class DBCPUtils {
    private static Connection con=null;
    private static DataSource dataSource=null;
    static {
        try {
            InputStream pptFile = new FileInputStream(new File("F:\\黑马JAVA学习\\WEB\\src\\DBCP连接池Demo\\DBCP.properties"));
//读取配置文件
            Properties proper=new Properties();
            try {
                proper.load(pptFile);
                try {
                    dataSource=BasicDataSourceFactory.createDataSource(proper);
                    //解析配置文件
                    con=dataSource.getConnection();
                    //获取数据库连接对象,将用于返回给调用的工具类
                } catch (Exception e) {
                    throw new RuntimeException("解析配置文件错误："+e);
                }
            } catch (IOException e) {
                throw new RuntimeException("加载配置文件错误："+e);
            }
        } catch (FileNotFoundException e) {
            throw new RuntimeException("读取配置文件错误:"+e);
        }
    }
    public static Connection getConnection(){
        return con;
    }
    public static DataSource getDataSource(){
        return dataSource;
    }
}

 

转载于:https://my.oschina.net/u/4043761/blog/3008329