123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 |
- # 数据源配置
- spring:
- datasource:
- type: com.alibaba.druid.pool.DruidDataSource
- driverClassName: com.mysql.cj.jdbc.Driver
- druid:
- # 主库数据源
- master:
- url: jdbc:mysql://47.100.220.92:3306/warewms_dongfangtaiye?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
- username: warewms
- password: warewms123
- # 从库数据源
- 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
- # 日志配置
- logging:
- config: classpath:logback-test.xml
- level:
- com.ruoyi: info
- org.springframework: info
- # 是否开启服务
- init-task:
- autosend: true # 自动下发任务
- aciservice: false # ndc通讯
- # plc连接配置
- plc:
- plcList[0]:
- ip: 192.168.1.131
- enable: false
- name: packingMachine_1Plc
- ePlcType: S1200
- heartbeat: DB5000.2
- confirmTheStatus:
- plcList[1]:
- ip: 192.168.1.132
- enable: false
- name: packingMachine_2Plc
- ePlcType: S1200
- heartbeat: DB5000.2
- confirmTheStatus:
- plcList[2]:
- ip: 192.168.1.133
- enable: false
- name: packingMachine_3Plc
- ePlcType: S1200
- heartbeat: DB5000.2
- confirmTheStatus:
- plcList[3]:
- ip: 192.168.1.134
- enable: false
- name: stackingMachinePlc
- ePlcType: S1200
- heartbeat: DB5000.2
- confirmTheStatus:
|