12.1 Spring整合Hibernate

一般用某ORM框架时，会在原有ORM API基础上编写封装类方便使用。很多工作Spring替我们做了。

混合使用：
一般的CRUD使用Hibernate，数据查询用iBaits或 Spring JDBC

原来典型的Hibernate配置文件

<!-- hibernate.cfg.xml  -->

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="dialect">
            org.hibernate.dialect.MySQLDialect</property>       <!-- 数据库方言 -->
        <property name="connection.url">
            jdbc:mysql://localhost:3306/db_examsystem</property><!-- 数据库连接URL -->
        <property name="connection.username">root</property>    <!-- 数据库用户名 -->
        <property name="connection.password">hehe</property>    <!-- 数据库用户密码 -->
        <property name="connection.driver_class">               <!-- 数据库驱动类 -->
            com.mysql.jdbc.Driver</property>

        <property name="show_sql">true</property>
        <mapping resource="com/sanqing/po/Student.hbm.xml"/>
        <mapping resource="com/sanqing/po/Teacher.hbm.xml"/>
        <mapping resource="com/sanqing/po/Subject.hbm.xml"/>    
    </session-factory>
</hibernate-configuration>

在Spring中指定配置文件：
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" 
p:configLocation="classpath:hibernate.cfg.xml" />

抛弃hibernate.cfg.xml

实体类及类的配置文件：
例如 Forum.java   Forum.hbm.xml
见下面具体的写法。。

Dao层：
基类Dao  BaseDao.java
public class BaseDao {

    @Autowired
    private HibernateTemplate hibernateTemplate;
    //  set、get 
}

ForumHibernateDao.java

@Repository
public class ForumHibernateDao extends BaseDao{

    public void addForum(Forum forum) {
        // 配置文件里的hibernateTemplate传递给BaseDao,正好此处可以获取
        getHibernateTemplate().save(forum);
    }
    public void updateForum(Forum forum) {
        getHibernateTemplate().update(forum);
    }

    public Forum getForum(int forumId) {
        return getHibernateTemplate().get(Forum.class, forumId);
    }
    public long getForumNum() {
        Object obj = getHibernateTemplate().iterate(
                "select count(f.forumId) from Forum f").next();
        return (Long) obj;
    }
    //  特殊！！
    public long getForumNum2() {
        Long forumNum = getHibernateTemplate().execute(
                new HibernateCallback<Long>() {
                    public Long doInHibernate(Session session)
                            throws HibernateException {
                        Object obj = session.createQuery("select count(f.forumId) from Forum f")
                                .list()
                                .iterator()
                                .next();
                        return (Long) obj;
                    }
                });
        return forumNum;
    }


    public List<Forum> findForumByName(String forumName) {
        return (List<Forum>) getHibernateTemplate().find(
                "from Forum f where f.forumName like ?", forumName + "%");
    }
}

配置文件 application_hibernate.xml ：

    <context:component-scan base-package="chapter12"/>  
    <context:property-placeholder location="classpath:jdbc.properties" />

    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
        destroy-method="close"
        p:driverClassName="${jdbc.driverClassName}"
        p:url="${jdbc.url}"
        p:username="${jdbc.username}"
        p:password="${jdbc.password}"/>

    <!-- 为了处理BLOB/CLOB型数据  -->
    <bean id="lobHandler" 
           class="org.springframework.jdbc.support.lob.DefaultLobHandler"
           lazy-init="true" />

     <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
        p:dataSource-ref="dataSource"
        p:mappingDirectoryLocations="classpath:/chapter12/domain"
        p:lobHandler-ref="lobHandler">
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.MySQLDialect
                </prop>
                <prop key="hibernate.show_sql">
                    true
                </prop>
            </props>
        </property>  
     </bean>   

     <!-- 配置 HibernateTemplate-->
     <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"
        p:sessionFactory-ref="sessionFactory"></bean>  
     <!-- 配置 Hibernate的事务管理器  -->   
     <bean id="transactionManager"
        class="org.springframework.orm.hibernate3.HibernateTransactionManager"
        p:sessionFactory-ref="sessionFactory" /> 

    <tx:annotation-driven transaction-manager="transactionManager"/>

处理LOB类型数据

在org.springframework.orm.hibernate3.support包中，可以处理LOB数据的类有：

实体类及配置文件

--   Forum.java
@Entity
@Table(name="T_FORUM")
public class Forum implements Serializable{
    @Id
    @Column(name = "FORUM_ID")
    private int forumId;

    @Column(name = "FORUM_NAME")
    private String forumName;

    @Column(name = "FORUM_DESC")
    private String forumDesc;

    public String toString(){
        return ToStringBuilder.reflectionToString(this);
    }
    //  get  set
}

-- Forum.hbm.xml
<hibernate-mapping auto-import="true" default-lazy="false">
    <class name="chapter12.domain.Forum" table="t_forum">
        <id name="forumId" column="forum_id">
            <generator class="assigned" />
        </id>
        <property name="forumName" column="forum_name" />
        <property name="forumDesc" column="forum_desc" />
    </class>
</hibernate-mapping>


-- Topic.java
@Entity
@Table(name="T_TOPIC")
public class Topic implements Serializable {
    private static final long serialVersionUID = 1L; 
    @Id
    @Column(name = "TOPIC_ID")
    private int topicId;

    @Column(name = "USER_ID")
    private int userId;

    @Column(name = "TOPIC_TITLE")
    private String topicTitle;

    @Column(name = "TOPIC_TIME")
    private Date topicTime;
    // 多个Topic对应一个Forum，JoinColumn表示的是表与表之间关联的那个字段，name属性如果不写，默认是：关联表的名称+“_”+ 关联表主键的字段名
    @ManyToOne
    @JoinColumn(name = "FORUM_ID")
    private Forum forum;


    @Column(name = "TOPIC_VIEWS")
    private int topicViews;
    // 一个Topic对应多个Post
    @OneToMany(mappedBy = "topic", cascade = CascadeType.ALL)
    private List<Post> posts;

    private int topicReplies;

    // get  set
}

-- Topic.hbm.xml
特别的部分：
对应
    @ManyToOne
    @JoinColumn(name = "FORUM_ID")
    private Forum forum;
的   
<many-to-one name="forum" column="forum_id"
            class="chapter12.domain.Forum" />
对应private List<Post> posts;部分的配置不会写！！

-- Post.java
@Entity
@Table(name="T_POST")
public class Post implements Serializable {
    @Id
    @Column(name = "POST_ID")
    private int postId;

    @Column(name = "USER_ID")
    private int userId;

    @ManyToOne
    @JoinColumn(name = "TOPIC_ID")
    private Topic topic;

    @Lob
    @Column(name = "POST_TEXT")
    private String postText;

    @Lob
    @Column(name = "POST_ATTACH")
    private byte[] postAttach;

    @Column(name = "POST_TIME")
    private Date postTime;

    // get && set
    public String toString(){
        return ToStringBuilder.reflectionToString(this);
    }
}

-- Post.hbm.xml
特殊部分：
        <property name="postText" column="post_text"        type="org.springframework.orm.hibernate3.support.ClobStringType"/>
        <property name="postAttach" column="post_attach"         type="org.springframework.orm.hibernate3.support.BlobByteArrayType"/>
        <many-to-one name="topic" column="topic_id"
                     class="com.baobaotao.domain.Topic" />