美文网首页
springboot集成mybaits和druid

springboot集成mybaits和druid

作者: 子暄_5f17 | 来源:发表于2019-10-03 22:43 被阅读0次

    参考的文章(https://blog.csdn.net/qq_28410283/article/details/86700635
    )https://blog.csdn.net/Mr_OOO/article/details/84898890
    后续再慢慢深入理解这些东西
    添加依赖:

    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>1.1.10</version>
    </dependency>
    

    配置文件:

    server.port=8888
    mybatis.config-location=classpath:mybatis/mybatis.cfg.xml
    mybatis.type-aliases-package=com.lover.bean
    mybatis.mapper-locations:classpath:mybatis/mapper/*.xml
    
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    spring.datasource.url=jdbc:mysql://localhost:3306/lover?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8
    spring.datasource.username=root
    spring.datasource.password=900809
    spring.datasource.druid.max-active=20
    spring.datasource.druid.initial-size=1
    spring.datasource.druid.max-wait=60000
    spring.datasource.druid.pool-prepared-statements=true
    spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
    spring.datasource.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
    spring.datasource.druid.min-idle=1
    spring.datasource.druid.time-between-eviction-runs-millis=60000
    spring.datasource.druid.min-evictable-idle-time-millis=300000
    spring.datasource.druid.validation-query=select 1 from dual
    spring.datasource.druid.test-while-idle=true
    spring.datasource.druid.test-on-borrow=true
    spring.datasource.druid.test-on-return=true
    spring.datasource.druid.web-stat-filter.enabled=true
    spring.datasource.druid.web-stat-filter.url-pattern=/*
    spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*
    spring.datasource.druid.web-stat-filter.session-stat-enable=true
    spring.datasource.druid.web-stat-filter.session-stat-max-count=1000
    spring.datasource.druid.stat-view-servlet.enabled= true
    spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*
    spring.datasource.druid.stat-view-servlet.reset-enable=true
    spring.datasource.druid.stat-view-servlet.login-username=druid
    spring.datasource.druid.stat-view-servlet.login-password=123456
    spring.datasource.druid.stat-view-servlet.allow=127.0.0.1
    spring.datasource.druid.stat-view-servlet.deny=192.168.0.19
    
    

    相关文章

      网友评论

          本文标题:springboot集成mybaits和druid

          本文链接:https://www.haomeiwen.com/subject/pkrjpctx.html