application-orm-local.yml 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
  1. ### 多数据源开关
  2. orm:
  3. multi-datasource-enable: true
  4. ################## Alibaba Druid 配置 ##################
  5. spring:
  6. datasource:
  7. type: com.alibaba.druid.pool.DruidDataSource
  8. druid:
  9. stat-view-servlet:
  10. enabled: true
  11. login-username: root
  12. login-password: root
  13. reset-enable: false
  14. ############ 以下是关闭多数据源时使用的默认数据源 ############
  15. username: root
  16. password: root
  17. url: jdbc:mysql://127.0.0.1:3306/archives_sys?useUnicode=true&characterEncoding=utf-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull
  18. driver-class-name: com.mysql.jdbc.Driver
  19. test-on-borrow: false
  20. test-on-return: false
  21. test-while-idle: true
  22. validation-query: SELECT 1
  23. async-init: false
  24. name: system
  25. filters: logback,log4j,wall,mergeStat
  26. keep-alive: false
  27. initial-size: 5
  28. min-idle: 5
  29. max-active: 20
  30. time-between-eviction-runs-millis: 60000
  31. min-evictable-idle-time-millis: 30000
  32. ################## 数据源 配置 ##################
  33. datasource:
  34. sys:
  35. name: system
  36. url: jdbc:mysql://127.0.0.1:3306/archives_sys?useUnicode=true&characterEncoding=utf-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull
  37. driver-class-name: com.mysql.jdbc.Driver
  38. username: root
  39. password: root
  40. test-on-borrow: false
  41. test-on-return: false
  42. test-while-idle: true
  43. validation-query: SELECT 1
  44. async-init: false
  45. name: sys
  46. filters: logback,log4j,wall,mergeStat
  47. keep-alive: false
  48. initial-size: 5
  49. min-idle: 5
  50. max-active: 20
  51. time-between-eviction-runs-millis: 60000
  52. min-evictable-idle-time-millis: 30000
  53. bus:
  54. name: business
  55. url: jdbc:mysql://127.0.0.1:3306/archives_mgr?useUnicode=true&characterEncoding=utf-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull
  56. driver-class-name: com.mysql.jdbc.Driver
  57. username: root
  58. password: root
  59. test-on-borrow: false
  60. test-on-return: false
  61. test-while-idle: true
  62. validation-query: SELECT 1
  63. async-init: false
  64. name: sys
  65. filters: logback,log4j,wall,mergeStat
  66. keep-alive: false
  67. initial-size: 5
  68. min-idle: 5
  69. max-active: 20
  70. time-between-eviction-runs-millis: 60000
  71. min-evictable-idle-time-millis: 30000
  72. ################### mybatis-plus配置 ###################
  73. mybatis-plus:
  74. mapper-locations: classpath*:mapping/**/*.xml
  75. type-aliases-package: com.gxzc.zen.api.bus.mapper,com.gxzc.zen.api.sys.mapper
  76. global-config:
  77. id-type: 0 #0:数据库ID自增 1:用户输入id 2:全局唯一id(IdWorker) 3:全局唯一ID(uuid)
  78. db-column-underline: true
  79. refresh-mapper: true
  80. # logic-delete-value: 0
  81. # logic-not-delete-value: 1
  82. sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjector
  83. meta-object-handler: com.gxzc.zen.orm.CustomMetaObjectHandler
  84. configuration:
  85. map-underscore-to-camel-case: true
  86. cache-enabled: true #配置的缓存的全局开关
  87. lazyLoadingEnabled: true #延时加载的开关
  88. multipleResultSetsEnabled: true #延时加载一个属性时会加载该对象全部属性,否则按需加载属性
  89. interceptors: com.baomidou.mybatisplus.plugins.OptimisticLockerInterceptor
  90. # log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #打印sql语句,调试用
  91. ##sharding-jdbc
  92. #sharding:
  93. # jdbc:
  94. # datasource:
  95. # names: ds_sys,ds_rec
  96. # ds_sys:
  97. # type: com.alibaba.druid.pool.DruidDataSource
  98. # driver-class-name: com.mysql.jdbc.Driver
  99. # url: jdbc:mysql://127.0.0.1:3306/archives_sys?useUnicode=true&characterEncoding=utf-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull
  100. # username: root
  101. # password: root
  102. # maxActive: 20
  103. # ds_rec:
  104. # type: com.alibaba.druid.pool.DruidDataSource
  105. # driver-class-name: com.mysql.jdbc.Driver
  106. # url: jdbc:mysql://127.0.0.1:3306/archives_rec?useUnicode=true&characterEncoding=utf-8&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&zeroDateTimeBehavior=convertToNull
  107. # username: root
  108. # password: root
  109. # maxActive: 20
  110. # config:
  111. # sharding:
  112. # tables:
  113. # sys_dept:
  114. # actualDataNodes: 'ds_sys
  115. # sys_dic:
  116. # sys_param: