三、springboot + jpa配置druid

落日映苍穹つ 2022-03-30 10:30 324阅读 0赞

application.properties直接配置

# DataSource
    spring.datasource.druid.url=jdbc:postgresql://localhost:5432/firstproject
    spring.datasource.druid.username=postgres
    spring.datasource.druid.password=123456
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    
    # 初始化大小，最小，最大
    spring.datasource.druid.initial-size=5
    spring.datasource.druid.min-idle=5
    spring.datasource.druid.max-active=20
    # 配置获取连接等待超时的时间
    spring.datasource.druid.max-wait=60000
    # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
    spring.datasource.druid.time-between-eviction-runs-millis=60000
    # 配置一个连接在池中最小生存的时间，单位是毫秒
    spring.datasource.druid.min-evictable-idle-time-millis=300000
    #检测连接是否有效的sql,要求是一个查询语句，常用select 'x'.如果validationQuery为null,testOnBorrow,testOnBorrow,testOnReturn,testWhileIdle都不会起作用。这个可以不配置
    spring.datasource.druid.validation-query=SELECT 'x'
    #检测连接是否有效的超时时间。
    spring.datasource.druid.validation-query-timeout=60000
    spring.datasource.druid.test-while-idle=true
    spring.datasource.druid.test-on-borrow=false
    spring.datasource.druid.test-on-return=false
    # 打开PSCache，并且指定每个连接上PSCache的大小
    spring.datasource.druid.pool-prepared-statements=true
    spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
    # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙，#别名方式，扩展插件，监控统计用的filter:stat，日志用的filter:log4j，防御sql注入的filter:wall
    spring.datasource.druid.filters=stat,wall,slf4j
    
    # JPA Configuration
    spring.jpa.database-platform = org.hibernate.dialect.PostgreSQL95Dialect
    spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults=false
    spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true
    spring.jpa.show-sql=true
    spring.jpa.properties.hibernate.hbm2ddl.auto=update

一、导入包build.gradle引入

implementation group:'com.alibaba', name: 'druid', version: '1.1.6'

二、配置文件application.yml中配置

server:
      port: 8083
    spring:
      datasource:
        driver-class-name: org.postgresql.Driver
        url: jdbc:postgresql://localhost:5432/firstproject
        username: postgres
        password: 123456
        type: com.alibaba.druid.pool.DruidDataSource
        # 下面为连接池的补充设置，应用到上面所有数据源中
        # 初始化大小，最小，最大
        initialSize: 1
        minIdle: 3
        maxActive: 20
        # 配置获取连接等待超时的时间
        maxWait: 60000
        # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
        timeBetweenEvictionRunsMillis: 60000
        # 配置一个连接在池中最小生存的时间，单位是毫秒
        minEvictableIdleTimeMillis: 30000
        validationQuery: select 'x'
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        # 打开PSCache，并且指定每个连接上PSCache的大小
        poolPreparedStatements: true
        maxPoolPreparedStatementPerConnectionSize: 20
        # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
        filters: stat,slf4j
        # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
        connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
        platform: postgresql
        # 合并多个DruidDataSource的监控数据
        #useGlobalDataSourceStat: true
        packages.to.scan: com.zz.firstproject

三、添加配置文件DruidConfig.java

import com.alibaba.druid.pool.DruidDataSource;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.context.annotation.Primary;
    
    import javax.sql.DataSource;
    import java.sql.SQLException;
    
    /**
     * Druid数据源连接池配置
     */
    @Configuration
    public class DruidConfig {
    
        private static final String DB_PREFIX = "spring.datasource";
    
        @ConfigurationProperties(prefix = DB_PREFIX)
        class IDataSourceProperties {
            private String url;
            private String username;
            private String password;
            private String driverClassName;
            private int initialSize;
            private int minIdle;
            private int maxActive;
            private int maxWait;
            private int timeBetweenEvictionRunsMillis;
            private int minEvictableIdleTimeMillis;
            private String validationQuery;
            private boolean testWhileIdle;
            private boolean testOnBorrow;
            private boolean testOnReturn;
            private boolean poolPreparedStatements;
            private int maxPoolPreparedStatementPerConnectionSize;
            private String filters;
            private String connectionProperties;
    
            @Bean     //声明其为Bean实例
            @Primary  //在同样的DataSource中，首先使用被标注的DataSource
            public DataSource dataSource() {
                DruidDataSource datasource = new DruidDataSource();
                datasource.setUrl(url);
                datasource.setUsername(username);
                datasource.setPassword(password);
                datasource.setDriverClassName(driverClassName);
    
                //configuration
                datasource.setInitialSize(initialSize);
                datasource.setMinIdle(minIdle);
                datasource.setMaxActive(maxActive);
                datasource.setMaxWait(maxWait);
                datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
                datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
                datasource.setValidationQuery(validationQuery);
                datasource.setTestWhileIdle(testWhileIdle);
                datasource.setTestOnBorrow(testOnBorrow);
                datasource.setTestOnReturn(testOnReturn);
                datasource.setPoolPreparedStatements(poolPreparedStatements);
                datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
                try {
                    datasource.setFilters(filters);
                } catch (SQLException e) {
                    System.err.println("druid configuration initialization filter: " + e);
                }
                datasource.setConnectionProperties(connectionProperties);
                return datasource;
            }
    
        get()/set()方法在此省略，手动添加
        }
    }

四、配置项目启动类，激活自己配置的信息

@SpringBootApplication(exclude = QuartzAutoConfiguration.class)
    public class FirstprojectApplication extends SpringBootServletInitializer {
    
    	/**
    	 * 所有配置信息的入口
    	 * @param builder
    	 * @return
    	 */
    	@Override
    	protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
    		//  激活配置信息
    		return builder.sources(FirstprojectApplication.class);
    	}
    
    	/**
    	 * 启动应用程序
    	 * @param args
    	 */
    	public static void main(String[] args) {
    		SpringApplication.run(FirstprojectApplication.class, args);
    	}
    
    }