druid框架

druid框架的创建环境,读取编写java文件的src文件下面的druid.properties文件得到连接需要用到的数据和创建连接池的大小.

/**
 * @author zw
 * @date 2022-03-12.
 */

import com.alibaba.druid.pool.DruidDataSourceFactory;

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

public class JDBC {
    private static DataSource source;
    static {
        try {
            Properties pros = new Properties();
            InputStream is = JDBC.class.getClassLoader().getResourceAsStream("druid.properties");
            pros.load(is);
            source = DruidDataSourceFactory.createDataSource(pros);
        }catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection() throws Exception {
        Connection conn = source.getConnection();
        return conn;
    }
    
}

druid.properties文件

driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/app?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
username=zw
password=jsna55555

initialSize=5
maxActive=10
maxWait=3000