hibernate动态表名

hibernate动态表名

项目上有需求，分表设计，根据公司分表，需要统计每个公司下的短信访问次数，表名规则如下：zdy_{公司id}_sms，因为公司用到orm框架是hibernate,所以就想到了能不能动态的映射表名，这样方便后面的检索和查询。废话不多说，贴上代码。

实体类appsms

public class AppSms implements Serializable{
    private static final long serialVersionUID = 1L;

    private Long id;
    private String tel;
    private String content;
    private Integer tepid;//
    private Long sentTime;//发送时间
    private String ip;
    private Integer state;// 1:使用 2：未使用

    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getTel() {
        return tel;
    }
    public void setTel(String tel) {
        this.tel = tel;
    }
    public String getContent() {
        return content;
    }
    public void setContent(String content) {
        this.content = content;
    }
    public Integer getTepid() {
        return tepid;
    }
    public void setTepid(Integer tepId) {
        this.tepid = tepId;
    }
    public Long getSentTime() {
        return sentTime;
    }
    public void setSentTime(Long senTime) {
        this.sentTime = senTime;
    }
    public String getIp() {
        return ip;
    }
    public void setIp(String ip) {
        this.ip = ip;
    }
    public Integer getState() {
        return state;
    }
    public void setState(Integer state) {
        this.state = state;
    }
}

ORM映射文件

<class name="com.xy.admx.entity.AppSms" dynamic-insert="true"
    dynamic-update="true">
    <id name="id" type="java.lang.Long">
        <column name="id" />
        <generator class="native" />
    </id>
    <property name="tel" type="java.lang.String">
        <column name="tel" />
    </property>
    <property name="content" type="java.lang.String">
        <column name="content" />
    </property>
    <property name="tepid" type="java.lang.Integer">
        <column name="tepl_id" />
    </property>
    <property name="sentTime" type="java.lang.Long">
        <column name="sent_time" />
    </property>
    <property name="ip" type="java.lang.String">
        <column name="Ip" />
    </property>
    <property name="state" type="java.lang.Integer">
        <column name="state" />
    </property>
</class>

说明：此块没有配置table

hibernate配置文件

    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="namingStrategy">
        <bean class="com.xy.cms.common.hibernate.AutoBindProjNamingStrategy">
            <property name="include">
                <list>
                    <value>AppSms</value>
                </list>
            </property>
        </bean>
    </property>

    <property name="entityInterceptor">
        <bean class="com.xy.cms.common.hibernate.AutoBindProjInterceptor"></bean>
    </property>

此块用到了hibernate命名的策略，自己重写了其默认的命名策略，贴上代码

public class AutoBindProjNamingStrategy extends DefaultNamingStrategy {
private List<String> include;// 需要动态映射的类名

/**
 * 
 */
private static final long serialVersionUID = 321L;

    public static final AutoBindProjNamingStrategy INSTANCE = new AutoBindProjNamingStrategy();

    @Override
    public String classToTableName(String className) {
        System.out.println("---className:" + className);
        System.out.println("--:" + StringHelper.unqualify(className));
            if(include.contains(StringHelper.unqualify(className))){
            String tname = "zdy_{projid}_" + super.classToTableName(className);
            tname = tname.toLowerCase();
            return tname;
        }
        return super.classToTableName(className);
    }

    public List<String> getInclude() {
        return include;
    }

    public void setInclude(List<String> include) {
        this.include = include;
    }
 }

调用super.classToTableName(className)，动态的设置表名，表名规则为。相当于在orm配置中写入table=”zdy_{project}_appsms”,此块考虑后期可扩展性，采用重写其命名策略的方式实现。
好了，表名配置好了，那么查询的时候，难道直接 select * from zdy_{project}_appsms吗？当然是不行的，所以我们需要用到hibernate拦截器。

    <property name="entityInterceptor">
        <bean class="com.xy.cms.common.hibernate.AutoBindProjInterceptor"></bean>
    </property>


    public class AutoBindProjInterceptor extends EmptyInterceptor {
@Override
    public String onPrepareStatement(String sql) {
        //System.out.println("old sql:" + sql);
        if(sql.indexOf("{projid}") > -1 && ContextHolder.getProjId() != null){
            sql = sql.replace("{projid}", ContextHolder.getProjId().toString());
            System.out.println(sql);
        }
        return super.onPrepareStatement(sql);
    }

}
ContextHolder.getProjId().toString()，此块就是需要动态的名称，这一块是加上了过滤器，用到了threadLocal实现的。登录之后，session中存入companyId，然后在过滤器中，将company放入threadLocal变量中。