Fetch the repository succeeded.
This action will force synchronization from 许剑锋/mybatis-subtable, which will overwrite any changes that you have made since you forked the repository, and can not be recovered!!!
Synchronous operation will process in the background and will refresh the page when finishing processing. Please be patient.
MyBatis分表插件，对MyBatis代码无侵入，不改变对MyBatis的使用习惯。
1、mybatis-config.xml配置文件添加插件
<plugins>
<plugin interceptor="org.jwxa.mybatis.subtable.plugin.SubTablePlugin" />
</plugins>2、需要分表的Mapper/Dao类添加@SubTable注解，使用strategyClass指定分表策略类
// LongStrategy：自定义分表策略类
@SubTable(strategyClass=LongStrategy.class)3、不需要分表的方法添加@SubTableIgnore注解
@SubTableIgnore
List<User> getList();org.jwxa.mybatis.subtable.strategy.Strategy接口，实现getFinalTable获取最终表名方法。StrategyUtil工具类提供常用分表策略方法。**使用示例：**使用Long类型id分表，10张分表
// 10张表，用id进行分表
public class LongStrategy implements Strategy {
@Override
public String getFinalTable(String baseTableName, Object params) {
Long flag = -1l;
if(params instanceof User) {
flag = ((User)params).getId();
}else if(params instanceof Long) {
flag = (Long) params;
}
return StrategyUtil.getHashTable(baseTableName, "_", flag, 10);
}
}src/test/resources/initsql.sql初始化数据库mybatis-config.xml数据库配置信息，测试类：org.jwxa.mybatis.subtable.test.DeviceDaoTest
jdbc.properties数据库配置信息，测试类：org.jwxa.mybatis.subtable.test.spring.UserDaoTest
Sign in for post a comment
Comments ( 0 )