若依框架 多数据库类型分页

# 数据源配置
spring:
    datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        druid:
            # 主库数据源
            master:
                url: jdbc:mysql://xxx:3306/xxx?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
                username: xxx
                password: xxx
                driverClassName: com.mysql.cj.jdbc.Driver
            # 从库数据源
            slave:
                enabled: true
                url: jdbc:sqlserver://xxx:1433;DatabaseName=xxx
                username: xxx
                password: xxx
                driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
            # 初始连接数
            initialSize: 5
# PageHelper分页插件
pagehelper:
  helperDialect: mysql
  supportMethodsArguments: true
  params: count=countSql
  auto-dialect: true
  auto-runtime-dialect: true

https://blog.csdn.net/weixin_41625929/article/details/123836686

posted @ 2022-04-13 16:06  dafengchui  阅读(599)  评论(0)    收藏  举报