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动态表名查询
分享网址：http://njwzjz.com/article/ghsijg.html