| | |
| | | select |
| | | yes.id,yes.name,yes.full_name,yes.type,yes.main_func,yes.lng,yes.lat,yes.pre_level, |
| | | yes.capacity,yes.remark,yes.firm_id,yes.image_url,ST_AsGeoJSON(yes.geom) as geom,yes.ele, |
| | | ifnull(yfi.name,'瑞昌工业园') as firmName, |
| | | ifnull(yfi.name,'安义工业园') as firmName, |
| | | bdb.dict_value as emergencySpaceType |
| | | from yw_emergency_space yes |
| | | left join blade_dict_biz bdb on bdb.dict_key = yes.type and bdb.code = 'emergency_space_type' |
| | |
| | | host: 127.0.0.1 |
| | | port: 6379 |
| | | password: |
| | | database: 11 |
| | | database: 13 |
| | | ssl: false |
| | | ##redis 集群环境配置 |
| | | #cluster: |
| | |
| | | # commandTimeout: 5000 |
| | | datasource: |
| | | # MySql |
| | | url: jdbc:mysql://139.196.74.78:3306/zhyq_rc_dev?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true |
| | | url: jdbc:mysql://139.196.74.78:3306/zhyq_ay_dev?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true |
| | | username: root |
| | | password: jxpskj_2018 |
| | | # PostgreSQL |
| | |
| | | # nodes: 127.0.0.1:7001,127.0.0.1:7002,127.0.0.1:7003 |
| | | # commandTimeout: 5000 |
| | | datasource: |
| | | url: jdbc:mysql://127.0.0.1:3306/zhyq_rc_dev?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true |
| | | url: jdbc:mysql://127.0.0.1:3306/zhyq_ay_dev?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true |
| | | username: root |
| | | password: jxpskj_2018 |
| | | |
| | |
| | | #服务器配置 |
| | | server: |
| | | port: 15872 |
| | | port: 15873 |
| | | undertow: |
| | | threads: |
| | | # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程 |