TangCheng
2025-03-10 4510a9b0d7c22fbcb3a8b7cc99b948e262e6a759
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
spring:
  # 环境 debug|release
  #profiles:
  #  active: gismap
  main:
    allow-bean-definition-overriding: true
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: org.postgresql.Driver
    username: postgres
 
    #url: jdbc:postgresql://127.0.0.1:15432/huishui_ai?ApplicationName=huishui_ai_web
    #password: p@ssw0rd
 
    url: jdbc:postgresql://192.168.123.74:5432/huishui_ai?ApplicationName=huishui_ai_web
    password: p@ssw0rd
 
    #url: jdbc:postgresql://192.168.123.43:5432/hswater_supply?ApplicationName=WaterNetWeb
    #password: p@ssw0rd
    
    #url: jdbc:postgresql://1.tcp.cpolar.cn:20521/hswater_gm
    #password: password 
 
    #url: jdbc:postgresql://127.0.0.1:5432/hswater_v4
    #password: p@ssw0rd
 
    #url: jdbc:postgresql://192.168.123.108:5433/hswater_gm
    #password: password 
 
    #url: jdbc:postgresql://192.168.123.15:5433/hswater_v4
    #password: 123 
 
    # 连接池配置
    druid:
      # 初始化大小,最小,最大
      initial-size: 0
      min-idle: 10
      max-active: 1024
      # 配置获取连接等待超时的时间
      max-wait: 60000
      # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位毫秒
      time-between-eviction-runs-millis: 60000
      # 配置一个连接在池中最小生存时间
      min-evictable-idle-time-millis: 200000
      max-evictable-idle-time-millis: 300000
      validation-query: SELECT 1
      test-while-idle: true
      test-on-borrow: true
      test-on-return: true
      # 打开 PSCache,并且指定每个连接上 PSCache 的大小
      pool-prepared-statements: false
      max-pool-prepared-statement-per-connection-size: 20
      # 配置监控统计拦截的 Filter,去掉后监控界面 SQL 无法统计,wall 用于防火墙
      filters: stat,wall,log4j2
      # 通过 connection-properties 属性打开 mergeSql 功能;慢 SQL 记录
      connection-properties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
      # 配置 DruidStatFilter
      #web-stat-filter:
      #  enabled: true
      #  url-pattern: /*
      #  exclusions: .js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*
      # 配置 DruidStatViewServlet
      #stat-view-servlet:
      #  url-pattern: /druid/*
      #  # IP 白名单,没有配置或者为空,则允许所有访问
      #  allow: 127.0.0.1
      #  # IP 黑名单,若白名单也存在,则优先使用
      #  deny: 192.168.31.253
      #  # 禁用 HTML 中 Reset All 按钮
      #  reset-enable: false
      #  # 登录用户名/密码
      #  login-username: root
      #  login-password: 123   
  servlet:
    multipart:
      max-file-size: 10GB
      max-request-size: 10GB 
  cache:
    ehcache:
      config: classpath:ehcache.xml
  session:
    store-type: hazelcast
    #timeout: 1800
    timeout: 1800
#    redis:
#      namespace: redis:session  
#  redis:
#    database: 0
#    host: 127.0.0.1
#    port: 6379
server:
  address: 0.0.0.0
  port: 8080
  compression:
    enabled: true
    min-response-size: 1024
    mime-types:
    - application/json
  tomcat:
    max-http-form-post-size: -1
 
mybatis:
  config-location: classpath:MyBatisConfiguration.xml
  mapper-locations: classpath*:mybatismap/*Mapper.xml
  
wiai:
  debug_mode: false 
  table_data_source: ai_data_source
 
  
hswater:
  tables:
    global_config: app_global_config
  session:
    header: true
    cookie: true
    trace : false
    hostid: WEB_HOST
  logger:
    sql: false
    llm: true
  path:
    dll:
    jar: