本篇内容介绍了“mybatis-Plus动态表名如何使用”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!MyBatis-Plus实现动态表名M
本篇内容介绍了“mybatis-Plus动态表名如何使用”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!
MyBatis-Plus实现动态表名
MyBatis实现方法如下现在要用MyBatis-Plus 实现
<select id="getList" resultType="com.wys.entity.User"> SELECT * FROM ${tableName} </select>
MyBatis-Plus官网说明
添加MyBatis-Plus依赖
<dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.5.1</version></dependency>
添加MyBatis-Plus配置,利用拦截器获取到表名给替换
@Configurationpublic class MybatisPlusConfig { static List<String> tableList(){ List<String> tables = new ArrayList<>(); //伪表名 可以为任意字符串 建议设置复杂度 避免重复 tables.add("C55EA8171877E962E08DFF63AA3678841"); tables.add("TestUser"); return tables; }//拦截器,获取到表名给替换 @Bean public MybatisPlusInterceptor dynamicTableNameInnerInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); DynamicTableNameInnerInterceptor dynamicTableNameInnerInterceptor = new DynamicTableNameInnerInterceptor(); dynamicTableNameInnerInterceptor.setTableNameHandler((sql, tableName) -> { String newTable = null; for (String table : tableList()) { newTable = RequestDataHelper.getRequestData(table); if (table.equals(tableName) && newTable!=null){ tableName = newTable; break; } } return tableName; }); interceptor.addInnerInterceptor(dynamicTableNameInnerInterceptor); return interceptor; }}
如果上面的拦截器不生效可以使用下面这个https://www.yisu.com/article/280321.htm
@Configuration@AutoConfigureAfter(PageHelperAutoConfiguration.class)public class MybatisPlusConfig { static List<String> tableList(){ List<String> tables = new ArrayList<>(); //表名 tables.add("C55EA8171877E962E08DFF63AA3678841"); return tables; } //拦截器,获取到表名给替换// @Bean// public MybatisPlusInterceptor dynamicTableNameInnerInterceptor() {// MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();// DynamicTableNameInnerInterceptor dynamicTableNameInnerInterceptor = new DynamicTableNameInnerInterceptor();// dynamicTableNameInnerInterceptor.setTableNameHandler((sql, tableName) -> {// String newTable = null;// for (String table : tableList()) {// newTable = RequestDataHelper.getRequestData(table);// if (table.equals(tableName) && newTable!=null){// tableName = newTable;// break;// }// }// return tableName;// });// interceptor.addInnerInterceptor(dynamicTableNameInnerInterceptor);// return interceptor;// } @Autowired private List<SqlSessionFactory> sqlSessionFactoryList; @PostConstruct public void addMyInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); DynamicTableNameInnerInterceptor dynamicTableNameInnerInterceptor = new DynamicTableNameInnerInterceptor(); dynamicTableNameInnerInterceptor.setTableNameHandler((sql, tableName) -> { String newTable = null; for (String table : tableList()) { newTable = RequestDataHelper.getRequestData(table); if (table.equals(tableName) && newTable!=null){ tableName = newTable; break; } } return tableName; }); interceptor.addInnerInterceptor(dynamicTableNameInnerInterceptor); for (SqlSessionFactory sqlSessionFactory : sqlSessionFactoryList) { sqlSessionFactory.getConfiguration().addInterceptor(interceptor); } }}
创建请求参数传递辅助类
public class RequestDataHelper { private static final ThreadLocal<Map<String, Object>> REQUEST_DATA = new ThreadLocal<>(); public static void setRequestData(Map<String, Object> requestData) { REQUEST_DATA.set(requestData); } public static <T> T getRequestData(String param) { Map<String, Object> dataMap = getRequestData(); if (CollectionUtils.isNotEmpty(dataMap)) { return (T) dataMap.get(param); } return null; } public static Map<String, Object> getRequestData() { return REQUEST_DATA.get(); }}
在程序中使用,注意如果实际表名与实体类与不同,可先在实体类类注明表名@TableName(“TestUser”)
@GetMapping("/listUser") public void listUser(){ RequestDataHelper.setRequestData(new HashMap<String, Object>() {{ put("kfafkasfaskfasjfkasf", "user_2018"); }}); Integer age=2018; User user=new User(); List list = userMapper.getList(user); // User user_2019 = userMapper.findById("user_2019", 2019); System.out.println(list); System.out.println("-------------"); // System.out.println(user_2019); RequestDataHelper.setRequestData(new HashMap<String, Object>() {{ put("kfafkasfaskfasjfkasf", "user_2019"); }}); List lis2 = userMapper.getList(user); System.out.println(lis2); System.out.println("-------------"); }
结果:
“MyBatis-Plus动态表名如何使用”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注编程网网站,小编将为大家输出更多高质量的实用文章!
--结束END--
本文标题: MyBatis-Plus动态表名如何使用
本文链接: https://www.lsjlt.com/news/355881.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0