mybatis plus 的動(dòng)態(tài)表名的配置詳解
mybatis plus簡(jiǎn)介
詳見(jiàn)mybatis plus的官網(wǎng)
業(yè)務(wù)要求
業(yè)務(wù)上要求存儲(chǔ)數(shù)據(jù)的時(shí)候根據(jù)某個(gè)字段動(dòng)態(tài)的選擇數(shù)據(jù)要存儲(chǔ)的表. 如根據(jù)code字段: code->[1001,1002]來(lái)進(jìn)行選擇存儲(chǔ)的表: 經(jīng)過(guò)下面的配置實(shí)現(xiàn)動(dòng)態(tài)表名如 --> table1_1001,table_1002的效果.以此動(dòng)態(tài)生成表名的效果.具體實(shí)現(xiàn)
MPConfig.java
import com.alibaba.fastjson.JSON;import com.alibaba.fastjson.JSONObject;import com.baomidou.mybatisplus.extension.parsers.DynamicTableNameParser;import com.baomidou.mybatisplus.extension.parsers.ITableNameHandler;import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;import org.apache.ibatis.reflection.MetaObject;import org.mybatis.spring.annotation.MapperScan;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import java.util.Collections;import java.util.HashMap;import java.util.List;/** * @Author: xuzz * @Description: * @Date: Created in 上午11:22 19-10-12 * @Modified By: */@Configuration@MapperScan('com.dao')public class MPConfig { @Autowired private Tables tableNames; /** * @Author: xuzz * @Date: 上午11:46 19-10-12 * 動(dòng)態(tài)表名 */ @Bean public PaginationInterceptor paginationInterceptor(){ PaginationInterceptor paginationInterceptor = new PaginationInterceptor(); DynamicTableNameParser dynamicTableNameParser = new DynamicTableNameParser(); dynamicTableNameParser.setTableNameHandlerMap(new HashMap<String, ITableNameHandler>(2){{ //涉及表集合 List<String> tables = tableNames.getTableNames(); //動(dòng)態(tài)表規(guī)則 初始表名+_+code tables.forEach(tableTitle -> put(tableTitle,(metaObject, sql, tableName) -> tableName + '_' + String.valueOf(getParamValue('關(guān)鍵字段名',metaObject)))); }}); paginationInterceptor.setSqlParserList(Collections.singletonList(dynamicTableNameParser)); return paginationInterceptor; } /** * @Author: xuzz * @Date: 下午2:55 19-10-12 * 獲取參數(shù)值 */ private Object getParamValue(String title, MetaObject metaObject){ //獲取參數(shù) Object originalObject = metaObject.getOriginalObject(); JSONObject originalObjectJSON = JSON.parseObject(JSON.toJSONString(originalObject)); JSONObject boundSql = originalObjectJSON.getJSONObject('boundSql'); JSONObject parameterObject = boundSql.getJSONObject('parameterObject'); return parameterObject.get(title); }
Tables.java 表頭列表類
@Configuration@ConfigurationProperties('mp')public class Tables { private List<String> tableNames; public List<String> getTableNames() { return tableNames; } public void setTableNames(List<String> tableNames) { this.tableNames = tableNames; }}
application.yml
mp: tableNames: #表頭列表 - table1 - table2 - table3
其他基礎(chǔ)配置的無(wú)異
到此這篇關(guān)于mybatis plus 的動(dòng)態(tài)表名的配置詳解的文章就介紹到這了,更多相關(guān)mybatis plus 動(dòng)態(tài)表名配置內(nèi)容請(qǐng)搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!
相關(guān)文章:
1. Mybatis如何自動(dòng)生成數(shù)據(jù)庫(kù)表的實(shí)體類2. mybatis配置對(duì)象包含對(duì)象以及List的方式3. SQLite3 命令行操作指南4. SQLite教程(二):C/C++接口簡(jiǎn)介5. 解決db2事務(wù)日志已滿及日志磁盤空間已滿問(wèn)題辦法詳解6. gearman中worker常駐后臺(tái),導(dǎo)致MySQL server has gone away的解決方法7. 用shell抽取,更新db2的數(shù)據(jù)8. MongoDB快速入門筆記(八)之MongoDB的java驅(qū)動(dòng)操作代碼講解9. SQL Server數(shù)據(jù)庫(kù)判斷最近一次的備份執(zhí)行結(jié)果(最新推薦)10. Mybatis 中Mapper使用package方式配置報(bào)錯(cuò)的解決方案
