页面条件查询

YYC

2025-08-29 b7eec5ee6770cc531dd57a4eca940f6886224aff

 src/main/resources/application-dev.yml

@@ -6,44 +6,52 @@
    #主数据源
    primary:
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5016?useUnicode=true&useSSL=false&characterEncoding=utf-8     #大湾区
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5303?useUnicode=true&useSSL=false&characterEncoding=utf-8     #上海嘉定
      url: jdbc:mysql://127.0.0.1:3306/igds_api_5306?useUnicode=true&useSSL=false&characterEncoding=utf-8     #宁夏石嘴山
      url: jdbc:mysql://127.0.0.1:3306/igds_api_5303?useUnicode=true&useSSL=false&characterEncoding=utf-8     #上海嘉定
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5306?useUnicode=true&useSSL=false&characterEncoding=utf-8     #宁夏石嘴山
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5311?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广澳
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317?useUnicode=true&useSSL=false&characterEncoding=utf-8     #潮阳库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_002?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳分库-濠江区租赁库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_1?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-港口新仓
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_2?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-关埠老仓
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_3?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-直属仓库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_4?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-西胪-新仓粮库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_4_2?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-西胪-东凤粮库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_5?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-金灶一所粮库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_6?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-金灶二所粮库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_7?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-粮油转运站
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_8?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-河溪粮所
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_9?useUnicode=true&useSSL=false&characterEncoding=utf-8   #潮阳-海门粮所
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_10?useUnicode=true&useSSL=false&characterEncoding=utf-8  #潮阳-和平粮所
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_001_gkxc?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-港口新仓 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_002_lcck?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-老仓仓库 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_003_jzys?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-金灶一所 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_004_jzes?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-金灶二所 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_005_xcck?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-西胪新仓仓库 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_006_dfck?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-西胪东凤仓库 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_007_zsck?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-直属仓库 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_008_lyzyz?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-粮油转运站 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_009_hxls?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-河溪粮食管理所 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_010_hpls?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-和平粮食管理所 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_011_hmls?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-海门粮食管理所 1
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_012_hsmy?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳-恒生米业
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5317_201?useUnicode=true&useSSL=false&characterEncoding=utf-8 #潮阳库 - 大米代储抚州市
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5320?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广东台山
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5321?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广东韶关
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5322?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广东徐闻
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5326?useUnicode=true&useSSL=false&characterEncoding=utf-8     #惠州惠新
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5327?useUnicode=true&useSSL=false&characterEncoding=utf-8     #武汉黄陂军粮
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5329?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广东佛山禅城区
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5348?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广东汕头潮南
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5349_sx?useUnicode=true&useSSL=false&characterEncoding=utf-8  #陕西柞水县
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5352?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广东增城冷链-天润增城库
#      url: jdbc:mysql://127.0.0.1:3306/igds_api_5354?useUnicode=true&useSSL=false&characterEncoding=utf-8     #广东增城冷链-天润增城库
      username: root
      password: Abc123..
      driver-class-name: com.mysql.jdbc.Driver
    #次数据源
    secondary:
#      url: jdbc:mysql://127.0.0.1:3306/igds_3.5_5016?useUnicode=true&useSSL=false&characterEncoding=utf-8  #大湾区
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5303?useUnicode=true&useSSL=false&characterEncoding=utf-8  #上海嘉定
      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5306?useUnicode=true&useSSL=false&characterEncoding=utf-8  #宁夏石嘴山
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5016?useUnicode=true&useSSL=false&characterEncoding=utf-8  #大湾区
      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5303?useUnicode=true&useSSL=false&characterEncoding=utf-8  #上海嘉定
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5306?useUnicode=true&useSSL=false&characterEncoding=utf-8  #宁夏石嘴山
#      url: jdbc:mysql://127.0.0.1:3306/igds_3.5_5311?useUnicode=true&useSSL=false&characterEncoding=utf-8  #广澳
#      url: jdbc:mysql://127.0.0.1:3306/igds_3.5_5317?useUnicode=true&useSSL=false&characterEncoding=utf-8  #潮阳库
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5317?useUnicode=true&useSSL=false&characterEncoding=utf-8  #潮阳库
#      url: jdbc:mysql://127.0.0.1:3306/igds_3.5_5320?useUnicode=true&useSSL=false&characterEncoding=utf-8
#      url: jdbc:mysql://127.0.0.1:3306/igds_3.5_5321?useUnicode=true&useSSL=false&characterEncoding=utf-8
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5322?useUnicode=true&useSSL=false&characterEncoding=utf-8  #广东徐闻
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5326?useUnicode=true&useSSL=false&characterEncoding=utf-8  #惠州惠新
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5327?useUnicode=true&useSSL=false&characterEncoding=utf-8  #武汉黄陂军粮
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5329?useUnicode=true&useSSL=false&characterEncoding=utf-8  #广东佛山禅城区
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5348?useUnicode=true&useSSL=false&characterEncoding=utf-8  #广东汕头潮南
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5349?useUnicode=true&useSSL=false&characterEncoding=utf-8  #陕西柞水县
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5352?useUnicode=true&useSSL=false&characterEncoding=utf-8  #广东增城冷链-天润增城库
#      url: jdbc:mysql://127.0.0.1:3306/igds_4.0_5354?useUnicode=true&useSSL=false&characterEncoding=utf-8  #广东增城-东部粮油中心库
      username: root
      password: Abc123..
      driver-class-name: com.mysql.jdbc.Driver
@@ -66,7 +74,7 @@
          dialect: org.hibernate.dialect.MySQL5InnoDBDialect
  # Redis相关配置
  redis:
    database: 9
    database: 15
    host: 127.0.0.1
    port: 6379
    password: Abc123..