You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by Sheng Wu <wu...@gmail.com> on 2019/06/21 00:28:30 UTC
Re: 多数据源的情况下，会找不到数据源。
Hi
English discussion is required here. Please translate the question.
Sheng Wu
Apache Skywalking, ShardingSphere, Zipkin
> 在 2019年6月20日，下午12:16，余杰 <ch...@163.com> 写道：
>
> 现在系统1个数据源master，连接另一个系统的32个库（iss）。
> 一个业务逻辑中，先查询master、31个库（iss），再插入master。
> 查询可以找到数据源，但是插入找不到数据源。
> 我这配置有问题？官网文档没有这种例子。
>
>
> sharding.jdbc.datasource.names = master0,wms0,iss0,iss1,iss2,iss3,iss4,iss5,iss6,iss7,iss8,iss9,iss10,iss11,iss12,iss13,iss14,iss15,iss16,iss17,iss18,iss19,iss20,iss21,iss22,iss23,iss24,iss25,iss26,iss27,iss28,iss29,iss30,iss31
> sharding.jdbc.datasource.master0.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.master0.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.master0.url = jdbc:mysql://10.79.1.15:33007/fas?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.master0.username = root
> sharding.jdbc.datasource.master0.password = 123456
>
>
> #sharding.default-data-source-name = master0
>
>
> # 最大连接池数量
> sharding.jdbc.datasource.master0.maxActive = 200
> # 初始化时建立物理连接的个数
> sharding.jdbc.datasource.master0.initialSize = 100
> # 最小连接池数量
> sharding.jdbc.datasource.master0.minIdle = 100
> # 获取连接时最大等待时间，单位毫秒
> sharding.jdbc.datasource.master0.maxWait = 60000
> # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
> sharding.jdbc.datasource.master0.timeBetweenEvictionRunsMillis = 60000
> # 连接保持空闲而不被驱逐的最小时间
> sharding.jdbc.datasource.master0.minEvictableIdleTimeMillis = 300000
> # 用来检测连接是否有效的sql，要求是一个查询语句
> sharding.jdbc.datasource.master0.validationQuery = SELECT 1 FROM DUAL
> # 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。
> sharding.jdbc.datasource.master0.testWhileIdle = true
> # 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。
> sharding.jdbc.datasource.master0.testOnBorrow = false
> # 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。
> sharding.jdbc.datasource.master0.testOnReturn = false
> # 是否缓存preparedStatement，也就是PSCache。PSCache对支持游标的数据库性能提升巨大，比如说oracle。在mysql下建议关闭。
> sharding.jdbc.datasource.master0.poolPreparedStatements = false
> # 要启用PSCache，必须配置大于0，当大于0时，poolPreparedStatements自动触发修改为true。
> sharding.jdbc.datasource.master0.maxPoolPreparedStatementPerConnectionSize = 50
>
>
> ## wms
> sharding.jdbc.datasource.wms0.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.wms0.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.wms0.url = jdbc:mysql://10.4.6.92:3306/newerp?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.wms0.username = wms_select
> sharding.jdbc.datasource.wms0.password = oserfYh5
>
>
>
>
> ## iss
> sharding.jdbc.datasource.iss0.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss0.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss0.url = jdbc:mysql://10.4.4.43:3307/iss_0?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss0.username = iss_select
> sharding.jdbc.datasource.iss0.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss1.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss1.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss1.url = jdbc:mysql://10.4.4.43:3307/iss_1?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss1.username = iss_select
> sharding.jdbc.datasource.iss1.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss2.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss2.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss2.url = jdbc:mysql://10.4.4.43:3307/iss_2?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss2.username = iss_select
> sharding.jdbc.datasource.iss2.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss3.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss3.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss3.url = jdbc:mysql://10.4.4.43:3307/iss_3?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss3.username = iss_select
> sharding.jdbc.datasource.iss3.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss4.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss4.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss4.url = jdbc:mysql://10.4.4.43:3307/iss_4?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss4.username = iss_select
> sharding.jdbc.datasource.iss4.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss5.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss5.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss5.url = jdbc:mysql://10.4.4.43:3307/iss_5?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss5.username = iss_select
> sharding.jdbc.datasource.iss5.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss6.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss6.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss6.url = jdbc:mysql://10.4.4.43:3307/iss_6?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss6.username = iss_select
> sharding.jdbc.datasource.iss6.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss7.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss7.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss7.url = jdbc:mysql://10.4.4.43:3307/iss_7?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss7.username = iss_select
> sharding.jdbc.datasource.iss7.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss8.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss8.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss8.url = jdbc:mysql://10.4.4.43:3307/iss_8?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss8.username = iss_select
> sharding.jdbc.datasource.iss8.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss9.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss9.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss9.url = jdbc:mysql://10.4.4.43:3307/iss_9?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss9.username = iss_select
> sharding.jdbc.datasource.iss9.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss10.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss10.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss10.url = jdbc:mysql://10.4.4.43:3307/iss_10?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss10.username = iss_select
> sharding.jdbc.datasource.iss10.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss11.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss11.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss11.url = jdbc:mysql://10.4.4.43:3307/iss_11?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss11.username = iss_select
> sharding.jdbc.datasource.iss11.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss12.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss12.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss12.url = jdbc:mysql://10.4.4.43:3307/iss_12?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss12.username = iss_select
> sharding.jdbc.datasource.iss12.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss13.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss13.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss13.url = jdbc:mysql://10.4.4.43:3307/iss_13?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss13.username = iss_select
> sharding.jdbc.datasource.iss13.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss14.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss14.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss14.url = jdbc:mysql://10.4.4.43:3307/iss_14?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss14.username = iss_select
> sharding.jdbc.datasource.iss14.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss15.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss15.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss15.url = jdbc:mysql://10.4.4.43:3307/iss_15?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss15.username = iss_select
> sharding.jdbc.datasource.iss15.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss16.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss16.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss16.url = jdbc:mysql://10.4.4.43:3307/iss_16?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss16.username = iss_select
> sharding.jdbc.datasource.iss16.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss17.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss17.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss17.url = jdbc:mysql://10.4.4.43:3307/iss_17?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss17.username = iss_select
> sharding.jdbc.datasource.iss17.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss18.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss18.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss18.url = jdbc:mysql://10.4.4.43:3307/iss_18?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss18.username = iss_select
> sharding.jdbc.datasource.iss18.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss19.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss19.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss19.url = jdbc:mysql://10.4.4.43:3307/iss_19?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss19.username = iss_select
> sharding.jdbc.datasource.iss19.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss20.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss20.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss20.url = jdbc:mysql://10.4.4.43:3307/iss_20?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss20.username = iss_select
> sharding.jdbc.datasource.iss20.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss21.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss21.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss21.url = jdbc:mysql://10.4.4.43:3307/iss_21?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss21.username = iss_select
> sharding.jdbc.datasource.iss21.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss22.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss22.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss22.url = jdbc:mysql://10.4.4.43:3307/iss_22?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss22.username = iss_select
> sharding.jdbc.datasource.iss22.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss23.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss23.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss23.url = jdbc:mysql://10.4.4.43:3307/iss_23?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss23.username = iss_select
> sharding.jdbc.datasource.iss23.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss24.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss24.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss24.url = jdbc:mysql://10.4.4.43:3307/iss_24?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss24.username = iss_select
> sharding.jdbc.datasource.iss24.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss25.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss25.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss25.url = jdbc:mysql://10.4.4.43:3307/iss_25?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss25.username = iss_select
> sharding.jdbc.datasource.iss25.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss26.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss26.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss26.url = jdbc:mysql://10.4.4.43:3307/iss_26?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss26.username = iss_select
> sharding.jdbc.datasource.iss26.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss27.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss27.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss27.url = jdbc:mysql://10.4.4.43:3307/iss_27?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss27.username = iss_select
> sharding.jdbc.datasource.iss27.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss28.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss28.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss28.url = jdbc:mysql://10.4.4.43:3307/iss_28?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss28.username = iss_select
> sharding.jdbc.datasource.iss28.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss29.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss29.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss29.url = jdbc:mysql://10.4.4.43:3307/iss_29?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss29.username = iss_select
> sharding.jdbc.datasource.iss29.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss30.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss30.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss30.url = jdbc:mysql://10.4.4.43:3307/iss_30?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss30.username = iss_select
> sharding.jdbc.datasource.iss30.password = BVoyMWAdpCM=
>
>
> sharding.jdbc.datasource.iss31.type = com.alibaba.druid.pool.DruidDataSource
> sharding.jdbc.datasource.iss31.driver-class-name = com.mysql.jdbc.Driver
> sharding.jdbc.datasource.iss31.url = jdbc:mysql://10.4.4.43:3307/iss_31?useUnicode=true&characterEncoding=utf-8&useSSL=false
> sharding.jdbc.datasource.iss31.username = iss_select
> sharding.jdbc.datasource.iss31.password = BVoyMWAdpCM=
>
>
> # iss根据sku分库
> sharding.jdbc.config.sharding.tables.stock_info.actual-data-nodes = iss$->{0..31}.stock_info
> sharding.jdbc.config.sharding.tables.stock_info.database-strategy.standard.sharding-column = sku
> sharding.jdbc.config.sharding.tables.stock_info.database-strategy.standard.precise-algorithm-class-name = com.hqyg.fas.common.sharding.third.IssSkuPreciseShardingAlgorithm
>
>
> #spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column = id
> #spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression = master0
>
>
>
>
> # cb_stock_batch_inout 根据sku分表
> sharding.jdbc.config.sharding.tables.cb_stock_batch_inout.actual-data-nodes = master0.cb_stock_batch_inout_$->{0..127}
> sharding.jdbc.config.sharding.tables.cb_stock_batch_inout.table-strategy.standard.sharding-column = sku
> sharding.jdbc.config.sharding.tables.cb_stock_batch_inout.table-strategy.standard.precise-algorithm-class-name = com.hqyg.fas.common.sharding.SkuPreciseShardingAlgorithm
> # cb_stock_batch_inout_time 根据operation_time按月分表
> sharding.jdbc.config.sharding.tables.cb_stock_batch_inout_time.actual-data-nodes = master0.cb_stock_batch_inout_time_$->{2019}$->{['05','06','07','08','09','10','11','12']}
> sharding.jdbc.config.sharding.tables.cb_stock_batch_inout_time.table-strategy.standard.sharding-column = operation_time
> sharding.jdbc.config.sharding.tables.cb_stock_batch_inout_time.table-strategy.standard.precise-algorithm-class-name = com.hqyg.fas.common.sharding.DateTimePreciseShardingAlgorithm
> # cb_track 根据batch_no分表
> sharding.jdbc.config.sharding.tables.cb_track.actual-data-nodes = master0.cb_track_$->{0..127}
> sharding.jdbc.config.sharding.tables.cb_track.table-strategy.standard.sharding-column = batch_no
> sharding.jdbc.config.sharding.tables.cb_track.table-strategy.standard.precise-algorithm-class-name = com.hqyg.fas.common.sharding.BatchNOPreciseShardingAlgorithm
> # cb_psi 根据ym分表
> sharding.jdbc.config.sharding.tables.cb_psi.actual-data-nodes = master0.cb_psi_$->{2019}$->{['05','06','07','08','09','10','11','12']}
> sharding.jdbc.config.sharding.tables.cb_psi.table-strategy.standard.sharding-column = ym
> sharding.jdbc.config.sharding.tables.cb_psi.table-strategy.standard.precise-algorithm-class-name = com.hqyg.fas.common.sharding.YMPreciseShardingAlgorithm
> # cb_psi_detail 根据ym分表
> sharding.jdbc.config.sharding.tables.cb_psi_detail.actual-data-nodes = master0.cb_psi_detail_$->{2019}$->{['05','06','07','08','09','10','11','12']}
> sharding.jdbc.config.sharding.tables.cb_psi_detail.table-strategy.standard.sharding-column = ym
> sharding.jdbc.config.sharding.tables.cb_psi_detail.table-strategy.standard.precise-algorithm-class-name = com.hqyg.fas.common.sharding.YMPreciseShardingAlgorithm
> #是否开启SQL显示，默认值: false
> sharding.jdbc.config.props.sql.show = false
>
>
> #sharding.jdbc.config.sharding.master-slave-rules.master0.master-data-source-name = master0
> #sharding.jdbc.config.sharding.master-slave-rules.master0.slave-data-source-names = iss0,iss1,iss2,iss3,iss4,iss5,iss6,iss7,iss8,iss9,iss10,iss11,iss12,iss13,iss14,iss15,iss16,iss17,iss18,iss19,iss20,iss21,iss22,iss23,iss24,iss25,iss26,iss27,iss28,iss29,iss30,iss31
>
>
> #mybatis config
> mybatis.type-aliases-package = com.hqyg.fas.job.**.entity
> mybatis.mapper-locations = classpath*:mybatis/mapper/**/*Mapper.xml
> pagehelper.helperDialect = mysql
> pagehelper.reasonable = false
> pagehelper.supportMethodsArguments = true
> pagehelper.params = count=countSql
>
>
>
>
>
>
>