tk.mapper 通用 mapper 动态表名查询

秒速五厘米 2022-01-16 12:17 730阅读 0赞

1.在实体上使用@Table 注解 默认不加使用驼峰转下划线匹配

@Table(name="table_name")
    public class Entity{
    
    }

2.实现 IDynamicTableName 接口

public class Entity   implements IDynamicTableName{
    
    @Override
    public String getDynamicTableName() {
    
        return “tableName”;
    }
    }
    
    可以直接添加一个非数据库字段 使用 @Transient 注解  外部直接设置表名
    
     @Transient 
        private String tableName;
    
    @Override
    public String getDynamicTableName() {
    
        return  tableName;
    }
    
    IDynamicTableName 源码定义：
    /*

*  The MIT License (MIT)
 *  
 *  Copyright (c) 2014-2017 abel533@gmail.com
 *  
 *  Permission is hereby granted, free of charge, to any person obtaining a copy
 *  of this software and associated documentation files (the "Software"), to deal
 *  in the Software without restriction, including without limitation the rights
 *  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 *  copies of the Software, and to permit persons to whom the Software is
 *  furnished to do so, subject to the following conditions:
 *  
 *  The above copyright notice and this permission notice shall be included in
 *  all copies or substantial portions of the Software.
 *  
 *  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 *  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 *  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 *  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 *  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 *  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 *  THE SOFTWARE.  
    \*/

package tk.mybatis.mapper.entity;

/\*\*

*  实现动态表名时，实体类需要实现该接口
 *  
 *  @author liuzh
 *  @since 2015-10-28 22:20  
    \*/  
    public interface IDynamicTableName \{
    
    /\*\*
    
     *  获取动态表名 - 只要有返回值，不是null和''，就会用返回值作为表名
     *  
     *  @return  
        \*/  
        String getDynamicTableName();  
        \}

转载于:https://blog.51cto.com/5013162/2384719