|  |  | 
 |  |  | # 数据源配置 | 
 |  |  | spring: | 
 |  |  |     datasource: | 
 |  |  |         type: com.alibaba.druid.pool.DruidDataSource | 
 |  |  |         driverClassName: com.mysql.cj.jdbc.Driver | 
 |  |  |         druid: | 
 |  |  |             # 主库数据源 | 
 |  |  |             master: | 
 |  |  |                 #url: jdbc:mysql://129.88.242.37:3308/opo?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 | 
 |  |  |                 #username: JQ | 
 |  |  |                 #password: Jqserver88 | 
 |  |  |   datasource: | 
 |  |  |     type: com.alibaba.druid.pool.DruidDataSource | 
 |  |  |     driverClassName: com.mysql.cj.jdbc.Driver | 
 |  |  |     druid: | 
 |  |  |       # 主库数据源 | 
 |  |  |       master: | 
 |  |  |         # 开发环境 | 
 |  |  |         #        url: jdbc:mysql://116.62.18.175:6002/opo?allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8 | 
 |  |  |         #        username: opo | 
 |  |  |         #        password: Smartor.2023 | 
 |  |  |         url: jdbc:mysql://192.168.100.10:3306/opo?allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8 | 
 |  |  |         username: smartor | 
 |  |  |         password: Smartor.2023 | 
 |  |  |  | 
 |  |  |                 url: jdbc:mysql://116.62.18.175:6002/lihuopo?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8 | 
 |  |  |                 username: opo | 
 |  |  |                 password: opo@2022 | 
 |  |  |       # 从库数据源 | 
 |  |  |       slave: | 
 |  |  |         # 从数据源开关/默认关闭 | 
 |  |  |         enabled: false | 
 |  |  |         url: | 
 |  |  |         username: | 
 |  |  |         password: | 
 |  |  |       # 初始连接数 | 
 |  |  |       initialSize: 5 | 
 |  |  |       # 最小连接池数量 | 
 |  |  |       minIdle: 10 | 
 |  |  |       # 最大连接池数量 | 
 |  |  |       maxActive: 20 | 
 |  |  |       # 配置获取连接等待超时的时间 | 
 |  |  |       maxWait: 60000 | 
 |  |  |       # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 | 
 |  |  |       timeBetweenEvictionRunsMillis: 60000 | 
 |  |  |       # 配置一个连接在池中最小生存的时间,单位是毫秒 | 
 |  |  |       minEvictableIdleTimeMillis: 300000 | 
 |  |  |       # 配置一个连接在池中最大生存的时间,单位是毫秒 | 
 |  |  |       maxEvictableIdleTimeMillis: 900000 | 
 |  |  |       # 配置检测连接是否有效 | 
 |  |  |       validationQuery: SELECT 1 FROM DUAL | 
 |  |  |       testWhileIdle: true | 
 |  |  |       testOnBorrow: false | 
 |  |  |       testOnReturn: false | 
 |  |  |       webStatFilter: | 
 |  |  |         enabled: true | 
 |  |  |       statViewServlet: | 
 |  |  |         # 开关 | 
 |  |  |         enabled: false | 
 |  |  |         # 设置白名单,不填则允许所有访问 | 
 |  |  |         allow: | 
 |  |  |         url-pattern: /druid/* | 
 |  |  |         # 控制台管理用户名和密码 | 
 |  |  |         login-username: lihu | 
 |  |  |         login-password: Lihu.7647Sa89.94 | 
 |  |  |       filter: | 
 |  |  |         stat: | 
 |  |  |           enabled: true | 
 |  |  |           # 慢SQL记录 | 
 |  |  |           log-slow-sql: true | 
 |  |  |           slow-sql-millis: 1000 | 
 |  |  |           merge-sql: true | 
 |  |  |         wall: | 
 |  |  |           config: | 
 |  |  |             multi-statement-allow: true | 
 |  |  |   redis: | 
 |  |  |     # 地址、密码、端口(默认为6379):开发环境 | 
 |  |  |     host: 127.0.0.1 | 
 |  |  |     password: Smartor | 
 |  |  |     port: 6020 | 
 |  |  |  | 
 |  |  |             # 从库数据源 | 
 |  |  |             slave: | 
 |  |  |                 # 从数据源开关/默认关闭 | 
 |  |  |                 enabled: false | 
 |  |  |                 url:  | 
 |  |  |                 username:  | 
 |  |  |                 password:  | 
 |  |  |             # 初始连接数 | 
 |  |  |             initialSize: 5 | 
 |  |  |             # 最小连接池数量 | 
 |  |  |             minIdle: 10 | 
 |  |  |             # 最大连接池数量 | 
 |  |  |             maxActive: 20 | 
 |  |  |             # 配置获取连接等待超时的时间 | 
 |  |  |             maxWait: 60000 | 
 |  |  |             # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 | 
 |  |  |             timeBetweenEvictionRunsMillis: 60000 | 
 |  |  |             # 配置一个连接在池中最小生存的时间,单位是毫秒 | 
 |  |  |             minEvictableIdleTimeMillis: 300000 | 
 |  |  |             # 配置一个连接在池中最大生存的时间,单位是毫秒 | 
 |  |  |             maxEvictableIdleTimeMillis: 900000 | 
 |  |  |             # 配置检测连接是否有效 | 
 |  |  |             validationQuery: SELECT 1 FROM DUAL | 
 |  |  |             testWhileIdle: true | 
 |  |  |             testOnBorrow: false | 
 |  |  |             testOnReturn: false | 
 |  |  |             webStatFilter:  | 
 |  |  |                 enabled: true | 
 |  |  |             statViewServlet: | 
 |  |  |                 enabled: true | 
 |  |  |                 # 设置白名单,不填则允许所有访问 | 
 |  |  |                 allow: | 
 |  |  |                 url-pattern: /druid/* | 
 |  |  |                 # 控制台管理用户名和密码 | 
 |  |  |                 login-username: ruoyi | 
 |  |  |                 login-password: 123456 | 
 |  |  |             filter: | 
 |  |  |                 stat: | 
 |  |  |                     enabled: true | 
 |  |  |                     # 慢SQL记录 | 
 |  |  |                     log-slow-sql: true | 
 |  |  |                     slow-sql-millis: 1000 | 
 |  |  |                     merge-sql: true | 
 |  |  |                 wall: | 
 |  |  |                     config: | 
 |  |  |                         multi-statement-allow: true | 
 |  |  |     # 数据库索引 | 
 |  |  |     database: 0 | 
 |  |  |     # 连接超时时间 | 
 |  |  |     timeout: 10s | 
 |  |  |     lettuce: | 
 |  |  |       pool: | 
 |  |  |         # 连接池中的最小空闲连接 | 
 |  |  |         min-idle: 0 | 
 |  |  |         # 连接池中的最大空闲连接 | 
 |  |  |         max-idle: 8 | 
 |  |  |         # 连接池的最大数据库连接数 | 
 |  |  |         max-active: 8 | 
 |  |  |         # #连接池最大阻塞等待时间(使用负值表示没有限制) | 
 |  |  |         max-wait: -1ms | 
 |  |  |  | 
 |  |  | ##钉钉的密钥(公司) | 
 |  |  | agentId: 1779052814 | 
 |  |  | dingAppid: dingn8iip5ubj7clrrsv | 
 |  |  | dingAppSecret: qlEK8D3oOVwGPOTiBQIBYTqQVlAfy9S_qQizEQFjJdSScwemWFryg4gbneu-NqWD |