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

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

创新互联长期为千余家客户提供的网站建设服务,团队从业经验10年,关注不同地域、不同群体,并针对不同对象提供差异化的产品和服务;打造开放共赢平台,与合作伙伴共同营造健康的互联网生态环境。为东宝企业提供专业的成都做网站、网站建设,东宝网站改版等技术服务。拥有10年丰富建站经验和众多成功案例,为您定制开发。

@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();
      }

分享文章:tk.mapper通用mapper动态表名查询
当前URL:http://myzitong.com/article/ghsijg.html