mybatis3.2.8 与 hibernate4.3.6 混用

来源：互联网发布：mac caj 复制粘贴编辑：程序博客网时间：2024/06/06 00:36

混用是混合在一起使用,可以复用公共的配置。例如

a) mybatis与hibernate的sessionFactory，共用同一个dataSource
b) 事务管理共用hibernate的事务管理。

而不是使用mybatis和hibernate两个配置文件,使用mybatis就使用mybatis的配置文件里的配置,使用hibernate时就使用hibernate对应的配置。

原文链接:http://www.cnblogs.com/yjmyzz/p/4047823.html

为了防止原作者博客链接失效,复制一份原博。

mybatis、hibernate这二个框架各有特色，对于复杂的查询，利用mybatis直接手写sql控制起来更灵活，而一般的insert/update，hibernate比较方便。同一个项目中，这二个框架可以和谐共存，下面是一些步骤：

一、版本要求

Spring 4.11 + hibernate 4.3.6 + mybatis 3.2.8 + struts 2.3.16.3 (这是目前各框架的最新版本)

建议：如果用hibernate 4.x ，Spring最好也是4.x系列，否则getCurrentSession()容易报错。

二、pom.xml依赖项

<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>infosky</groupId>    <artifactId>struts2-rest-ex</artifactId>    <packaging>war</packaging>    <version>1.0</version>    <properties>        <java-version>1.6</java-version>        <struts2.version>2.3.16.3</struts2.version>        <spring.version>4.1.1.RELEASE</spring.version>        <mybatis.version>3.2.8</mybatis.version>        <hibernate.version>4.3.6.Final</hibernate.version>    </properties>    <dependencies>        <dependency>            <groupId>commons-dbcp</groupId>            <artifactId>commons-dbcp</artifactId>            <version>1.4</version>        </dependency>        <!-- oracle -->        <dependency>            <groupId>com.oracle</groupId>            <artifactId>ojdbc6</artifactId>            <version>11.2.0.3</version>        </dependency>        <dependency>            <groupId>asm</groupId>            <artifactId>asm</artifactId>            <version>3.3.1</version>        </dependency>        <dependency>            <groupId>asm</groupId>            <artifactId>asm-commons</artifactId>            <version>3.3.1</version>        </dependency>        <dependency>            <groupId>asm</groupId>            <artifactId>asm-tree</artifactId>            <version>3.3.1</version>        </dependency>        <dependency>            <groupId>commons-beanutils</groupId>            <artifactId>commons-beanutils</artifactId>            <version>1.8.3</version>        </dependency>        <dependency>            <groupId>commons-collections</groupId>            <artifactId>commons-collections</artifactId>            <version>3.2.1</version>        </dependency>        <dependency>            <groupId>commons-fileupload</groupId>            <artifactId>commons-fileupload</artifactId>            <version>1.3</version>        </dependency>        <dependency>            <groupId>commons-io</groupId>            <artifactId>commons-io</artifactId>            <version>2.2</version>        </dependency>        <dependency>            <groupId>org.apache.commons</groupId>            <artifactId>commons-lang3</artifactId>            <version>3.1</version>        </dependency>        <dependency>            <groupId>javassist</groupId>            <artifactId>javassist</artifactId>            <version>3.12.1.GA</version>        </dependency>        <dependency>            <groupId>ognl</groupId>            <artifactId>ognl</artifactId>            <version>3.0.6</version>        </dependency>        <!-- log -->        <dependency>            <groupId>org.apache.logging.log4j</groupId>            <artifactId>log4j-api</artifactId>            <version>2.0.2</version>        </dependency>        <dependency>            <groupId>org.apache.logging.log4j</groupId>            <artifactId>log4j-core</artifactId>            <version>2.0.2</version>        </dependency>        <dependency>            <groupId>org.apache.logging.log4j</groupId>            <artifactId>log4j-web</artifactId>            <version>2.0.2</version>        </dependency>        <dependency>            <groupId>org.slf4j</groupId>            <artifactId>slf4j-api</artifactId>            <version>1.7.7</version>        </dependency>        <dependency>            <groupId>net.sf.ezmorph</groupId>            <artifactId>ezmorph</artifactId>            <version>1.0.6</version>        </dependency>        <dependency>            <groupId>org.freemarker</groupId>            <artifactId>freemarker</artifactId>            <version>2.3.19</version>        </dependency>        <dependency>            <groupId>org.codehaus.jackson</groupId>            <artifactId>jackson-core-asl</artifactId>            <version>1.9.10</version>        </dependency>        <dependency>            <groupId>org.codehaus.jackson</groupId>            <artifactId>jackson-mapper-asl</artifactId>            <version>1.9.10</version>        </dependency>        <dependency>            <groupId>net.sf.json-lib</groupId>            <artifactId>json-lib</artifactId>            <version>2.4</version>            <classifier>jdk15</classifier>        </dependency>        <dependency>            <groupId>org.apache.struts</groupId>            <artifactId>struts2-convention-plugin</artifactId>            <version>2.3.16</version>        </dependency>        <dependency>            <groupId>org.apache.struts</groupId>            <artifactId>struts2-config-browser-plugin</artifactId>            <version>2.3.16</version>        </dependency>        <dependency>            <groupId>org.apache.struts</groupId>            <artifactId>struts2-core</artifactId>            <version>${struts2.version}</version>        </dependency>        <dependency>            <groupId>org.apache.struts</groupId>            <artifactId>struts2-rest-plugin</artifactId>            <version>2.3.16</version>        </dependency>        <dependency>            <groupId>com.thoughtworks.xstream</groupId>            <artifactId>xstream</artifactId>            <version>1.4.3</version>        </dependency>        <dependency>            <groupId>org.apache.struts.xwork</groupId>            <artifactId>xwork-core</artifactId>            <version>${struts2.version}</version>        </dependency>        <!-- Servlet -->        <dependency>            <groupId>javax.servlet</groupId>            <artifactId>servlet-api</artifactId>            <version>2.5</version>            <scope>provided</scope>        </dependency>        <!-- spring -->        <dependency>            <groupId>org.apache.struts</groupId>            <artifactId>struts2-spring-plugin</artifactId>            <version>${struts2.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-context</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-orm</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-beans</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-core</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-web</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-context</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-context-support</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-expression</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-jdbc</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-tx</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-aop</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.aspectj</groupId>            <artifactId>aspectjweaver</artifactId>            <version>1.7.3</version>        </dependency>        <dependency>            <groupId>aopalliance</groupId>            <artifactId>aopalliance</artifactId>            <version>1.0</version>        </dependency>        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>4.11</version>        </dependency>        <!-- mybatis -->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis-spring</artifactId>            <version>1.2.2</version>        </dependency>        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>${mybatis.version}</version>        </dependency>        <dependency>            <groupId>com.github.miemiedev</groupId>            <artifactId>mybatis-paginator</artifactId>            <version>1.2.15</version>        </dependency>        <!-- hibernate -->        <dependency>            <groupId>org.hibernate</groupId>            <artifactId>hibernate-core</artifactId>            <version>${hibernate.version}</version>        </dependency>        <dependency>            <groupId>xml-apis</groupId>            <artifactId>xml-apis</artifactId>            <version>1.0.b2</version>            <scope>provided</scope>        </dependency>    </dependencies>    <profiles>        <profile>            <!-- 开发环境 -->            <id>dev</id>            <properties>                <db-url>jdbc:oracle:thin:@172.21.129.51:1521:orcl</db-url>                <db-username>***</db-username>                <db-password>***</db-password>            </properties>            <!-- 默认激活本环境 -->            <activation>                <activeByDefault>true</activeByDefault>            </activation>        </profile>        <profile>            <!-- 测试环境 -->            <id>test</id>            <properties>                <db-url>jdbc:oracle:thin:@172.21.129.51:1521:orcl</db-url>                <db-username>***</db-username>                <db-password>***</db-password>            </properties>        </profile>    </profiles>    <build>        <finalName>struts2-rest-ex</finalName>        <resources>            <resource>                <directory>src/main/resources</directory>                <filtering>true</filtering>            </resource>        </resources>        <plugins>            <plugin>                <groupId>org.apache.maven.plugins</groupId>                <artifactId>maven-compiler-plugin</artifactId>                <version>2.5.1</version>                <configuration>                    <source>1.6</source>                    <target>1.6</target>                    <encoding>utf-8</encoding>                </configuration>            </plugin>            <plugin>                <artifactId>maven-source-plugin</artifactId>                <version>2.1.2</version>                <executions>                    <execution>                        <phase>package</phase>                        <goals>                            <goal>jar-no-fork</goal>                        </goals>                    </execution>                </executions>            </plugin>            <plugin>                <groupId>org.apache.maven.plugins</groupId>                <artifactId>maven-surefire-plugin</artifactId>                <version>2.16</version>                <configuration>                    <forkMode>once</forkMode>                    <argLine>-Dfile.encoding=UTF-8</argLine>                </configuration>            </plugin>        </plugins>    </build>    <organization>        <name>yjmyzz</name>        <url>http://yjmyzz.cnblogs.com/</url>    </organization></project>

最终打包后，WEB-INF/lib下的jar文件列表为：

antlr-2.7.7.jar

aopalliance-1.0.jar
asm-3.3.1.jar
asm-commons-3.3.1.jar
asm-tree-3.3.1.jar
aspectjweaver-1.7.3.jar
commons-beanutils-1.8.3.jar
commons-collections-3.2.1.jar
commons-dbcp-1.4.jar
commons-fileupload-1.3.jar
commons-io-2.2.jar
commons-lang-2.3.jar
commons-lang3-3.1.jar
commons-logging-1.1.1.jar
commons-pool-1.5.4.jar
dom4j-1.6.1.jar
ezmorph-1.0.6.jar
freemarker-2.3.19.jar
hamcrest-core-1.3.jar
hibernate-commons-annotations-4.0.5.Final.jar
hibernate-core-4.3.6.Final.jar
hibernate-jpa-2.1-api-1.0.0.Final.jar
jackson-core-asl-1.9.10.jar
jackson-mapper-asl-1.9.10.jar
jandex-1.1.0.Final.jar
javassist-3.12.1.GA.jar
javassist-3.18.1-GA.jar
jboss-logging-3.1.3.GA.jar
jboss-logging-annotations-1.2.0.Beta1.jar
jboss-transaction-api_1.2_spec-1.0.0.Final.jar
json-lib-2.4-jdk15.jar
junit-4.11.jar
log4j-api-2.0.2.jar
log4j-core-2.0.2.jar
log4j-web-2.0.2.jar
mybatis-3.2.8.jar
mybatis-paginator-1.2.15.jar
mybatis-spring-1.2.2.jar
ognl-3.0.6.jar
ojdbc6-11.2.0.3.jar
slf4j-api-1.7.7.jar
spring-aop-4.1.1.RELEASE.jar
spring-beans-4.1.1.RELEASE.jar
spring-context-4.1.1.RELEASE.jar
spring-context-support-4.1.1.RELEASE.jar
spring-core-4.1.1.RELEASE.jar
spring-expression-4.1.1.RELEASE.jar
spring-jdbc-4.1.1.RELEASE.jar
spring-orm-4.1.1.RELEASE.jar
spring-tx-4.1.1.RELEASE.jar
spring-web-4.1.1.RELEASE.jar
struts2-config-browser-plugin-2.3.16.jar
struts2-convention-plugin-2.3.16.jar
struts2-core-2.3.16.3.jar
struts2-rest-plugin-2.3.16.jar
struts2-spring-plugin-2.3.16.3.jar
xmlpull-1.1.3.1.jar
xpp3_min-1.1.4c.jar
xstream-1.4.3.jar
xwork-core-2.3.16.3.jar

三、Spring配置（关键）

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jdbc="http://www.springframework.org/schema/jdbc"    xmlns:context="http://www.springframework.org/schema/context"    xsi:schemaLocation="     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd     http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd     http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd     http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd"    default-autowire="byName">    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"        destroy-method="close">        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />        <property name="url" value="jdbc:oracle:thin:@172.21.129.**:1521:orcl" />        <property name="username" value="***" />        <property name="password" value="***" />        <property name="defaultAutoCommit" value="false" />        <property name="initialSize" value="2" />        <property name="maxActive" value="10" />        <property name="maxWait" value="60000" />    </bean>    <bean id="sessionFactory"        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">        <property name="dataSource" ref="dataSource" />        <property name="packagesToScan">            <list>                <value>com.cnblogs.yjmyzz.entity</value>            </list>        </property>        <property name="mappingLocations">            <list>                <value>classpath*:hibernate/**/*.hbm.xml</value>            </list>        </property>        <property name="hibernateProperties">            <props>                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>                <!-- <prop key="current_session_context_class">thread</prop> -->                <prop key="hibernate.format_sql">false</prop>                <prop key="hibernate.show_sql">true</prop>                <prop key="hibernate.use_sql_comments">true</prop>                <prop key="hibernate.max_fetch_depth">3</prop>                <prop key="hibernate.jdbc.batch_size">20</prop>                <prop key="hibernate.jdbc.fetch_size">20</prop>                <prop key="hibernate.cache.use_second_level_cache">false</prop>            </props>        </property>    </bean>    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource" />        <property name="configLocation" value="classpath:mybatis-config.xml"></property>        <property name="typeAliasesPackage" value="com.cnblogs.yjmyzz.entity"></property>        <property name="mapperLocations" value="classpath:mybatis/**/*.xml"></property>        <property name="plugins">            <list>                <bean                    class="com.github.miemiedev.mybatis.paginator.OffsetLimitInterceptor">                    <property name="dialectClass"                        value="com.github.miemiedev.mybatis.paginator.dialect.OracleDialect"></property>                </bean>            </list>        </property>    </bean>    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="com.cnblogs.yjmyzz.mybatis.mapper" />    </bean>    <bean id="transactionManager"        class="org.springframework.orm.hibernate4.HibernateTransactionManager">        <property name="sessionFactory">            <ref local="sessionFactory" />        </property>    </bean>    <tx:advice id="txAdvice" transaction-manager="transactionManager">        <tx:attributes>            <tx:method name="do*" read-only="false" rollback-for="java.lang.Exception" />            <tx:method name="*" propagation="SUPPORTS" read-only="true" />        </tx:attributes>    </tx:advice>    <aop:config>        <aop:pointcut id="pc"            expression="execution(* com.cnblogs.yjmyzz.service.*.*(..))" />        <aop:advisor pointcut-ref="pc" advice-ref="txAdvice" />    </aop:config></beans>

有几个关键点：

a) mybatis与hibernate的sessionFactory，共用同一个dataSource

b) 事务管理共用hibernate的事务管理

四、web.xml配置

<?xml version="1.0" encoding="UTF-8"?><web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">    <display-name>struts2-app-sample</display-name>    <listener>        <listener-class>org.apache.logging.log4j.web.Log4jServletContextListener</listener-class>    </listener>    <filter>        <filter-name>log4jServletFilter</filter-name>        <filter-class>org.apache.logging.log4j.web.Log4jServletFilter</filter-class>    </filter>    <filter-mapping>        <filter-name>log4jServletFilter</filter-name>        <url-pattern>/*</url-pattern>        <dispatcher>REQUEST</dispatcher>        <dispatcher>FORWARD</dispatcher>        <dispatcher>INCLUDE</dispatcher>        <dispatcher>ERROR</dispatcher>    </filter-mapping>    <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classpath:spring.xml</param-value>    </context-param>    <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener>    <filter>        <filter-name>struts2</filter-name>        <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>        <init-param>            <param-name>loggerFactory</param-name>            <param-value>com.opensymphony.xwork2.util.logging.slf4j.Slf4jLoggerFactory</param-value>        </init-param>    </filter>    <filter>        <filter-name>openSessionInViewFilter</filter-name>        <filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>        <init-param>            <param-name>singleSession</param-name>            <param-value>true</param-value>        </init-param>    </filter>    <filter-mapping>        <filter-name>struts2</filter-name>        <url-pattern>/*</url-pattern>    </filter-mapping>    <welcome-file-list>        <welcome-file>index.html</welcome-file>    </welcome-file-list></web-app>

五、代码调用

5.1 服务层基类

package com.cnblogs.yjmyzz.service.support;
import java.io.Serializable;
import javax.annotation.Resource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.StatelessSession;


public class BaseServiceImpl implements Serializable {

    private static final long serialVersionUID = -33988360094493502L;

    /**
     * hibernate入口
     */
    @Resource(name = "sessionFactory")
    protected SessionFactory hibernateSessionFactory;


    /**
     * mybatis入口
     */
    @Resource(name = "sqlSessionFactory")
    protected SqlSessionFactory mybatisSessionFactory;


    protected Session openSession() {
        return hibernateSessionFactory.openSession();
    }


    protected StatelessSession openStatelessSession() {
        return hibernateSessionFactory.openStatelessSession();
    }


    protected Session getCurrentSession() {
        return hibernateSessionFactory.getCurrentSession();
    }


}

其它各业务服务实现类，都继承自它。当然，也可以弄一个BaseDAO，对hibernate做些封装

package com.cnblogs.yjmyzz.dao;import java.io.Serializable;import java.util.List;/** * 基础数据库操作类 *  * @author ss *  */public interface BaseDAO<T> {    /**     * 保存一个对象     *      * @param o     * @return     */    public Serializable save(T o);    /**     * 删除一个对象     *      * @param o     */    public void delete(T o);    /**     * 更新一个对象     *      * @param o     */    public void update(T o);    /**     * 保存或更新对象     *      * @param o     */    public void saveOrUpdate(T o);    /**     * 查询     *      * @param hql     * @return     */    public List<T> find(String hql);    /**     * 查询集合     *      * @param hql     * @param param     * @return     */    public List<T> find(String hql, Object[] param);    /**     * 查询集合     *      * @param hql     * @param param     * @return     */    public List<T> find(String hql, List<Object> param);    /**     * 查询集合(带分页)     *      * @param hql     * @param param     * @param page     *            查询第几页     * @param rows     *            每页显示几条记录     * @return     */    public List<T> find(String hql, Object[] param, Integer page, Integer rows);    /**     * 查询集合(带分页)     *      * @param hql     * @param param     * @param page     * @param rows     * @return     */    public List<T> find(String hql, List<Object> param, Integer page,            Integer rows);    /**     * 获得一个对象     *      * @param c     *            对象类型     * @param id     * @return Object     */    public T get(Class<T> c, Serializable id);    /**     * 获得一个对象     *      * @param hql     * @param param     * @return Object     */    public T get(String hql, Object[] param);    /**     * 获得一个对象     *      * @param hql     * @param param     * @return     */    public T get(String hql, List<Object> param);    /**     * select count(*) from 类     *      * @param hql     * @return     */    public Long count(String hql);    /**     * select count(*) from 类     *      * @param hql     * @param param     * @return     */    public Long count(String hql, Object[] param);    /**     * select count(*) from 类     *      * @param hql     * @param param     * @return     */    public Long count(String hql, List<Object> param);    /**     * 执行HQL语句     *      * @param hql     * @return 响应数目     */    public Integer executeHql(String hql);    /**     * 执行HQL语句     *      * @param hql     * @param param     * @return 响应数目     */    public Integer executeHql(String hql, Object[] param);    /**     * 执行HQL语句     *      * @param hql     * @param param     * @return     */    public Integer executeHql(String hql, List<Object> param);}

package com.cnblogs.yjmyzz.dao.impl;import com.cnblogs.yjmyzz.dao.BaseDAO;import java.io.Serializable;import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Component;import org.springframework.stereotype.Repository;@Component("baseDAO")@SuppressWarnings("all")public class BaseDAOImpl<T> implements BaseDAO<T> {    private SessionFactory sessionFactory;    public SessionFactory getSessionFactory() {        return sessionFactory;    }    @Autowired    public void setSessionFactory(SessionFactory sessionFactory) {        this.sessionFactory = sessionFactory;    }    private Session getCurrentSession() {        return sessionFactory.getCurrentSession();    }    public Serializable save(T o) {        return this.getCurrentSession().save(o);    }    public void delete(T o) {        this.getCurrentSession().delete(o);    }    public void update(T o) {        this.getCurrentSession().update(o);    }    public void saveOrUpdate(T o) {        this.getCurrentSession().saveOrUpdate(o);    }    public List<T> find(String hql) {        return this.getCurrentSession().createQuery(hql).list();    }    public List<T> find(String hql, Object[] param) {        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.length > 0) {            for (int i = 0; i < param.length; i++) {                q.setParameter(i, param[i]);            }        }        return q.list();    }    public List<T> find(String hql, List<Object> param) {        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.size() > 0) {            for (int i = 0; i < param.size(); i++) {                q.setParameter(i, param.get(i));            }        }        return q.list();    }    public List<T> find(String hql, Object[] param, Integer page, Integer rows) {        if (page == null || page < 1) {            page = 1;        }        if (rows == null || rows < 1) {            rows = 10;        }        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.length > 0) {            for (int i = 0; i < param.length; i++) {                q.setParameter(i, param[i]);            }        }        return q.setFirstResult((page - 1) * rows).setMaxResults(rows).list();    }    public List<T> find(String hql, List<Object> param, Integer page,            Integer rows) {        if (page == null || page < 1) {            page = 1;        }        if (rows == null || rows < 1) {            rows = 10;        }        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.size() > 0) {            for (int i = 0; i < param.size(); i++) {                q.setParameter(i, param.get(i));            }        }        return q.setFirstResult((page - 1) * rows).setMaxResults(rows).list();    }    public T get(Class<T> c, Serializable id) {        return (T) this.getCurrentSession().get(c, id);    }    public T get(String hql, Object[] param) {        List<T> l = this.find(hql, param);        if (l != null && l.size() > 0) {            return l.get(0);        } else {            return null;        }    }    public T get(String hql, List<Object> param) {        List<T> l = this.find(hql, param);        if (l != null && l.size() > 0) {            return l.get(0);        } else {            return null;        }    }    public Long count(String hql) {        return (Long) this.getCurrentSession().createQuery(hql).uniqueResult();    }    public Long count(String hql, Object[] param) {        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.length > 0) {            for (int i = 0; i < param.length; i++) {                q.setParameter(i, param[i]);            }        }        return (Long) q.uniqueResult();    }    public Long count(String hql, List<Object> param) {        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.size() > 0) {            for (int i = 0; i < param.size(); i++) {                q.setParameter(i, param.get(i));            }        }        return (Long) q.uniqueResult();    }    public Integer executeHql(String hql) {        return this.getCurrentSession().createQuery(hql).executeUpdate();    }    public Integer executeHql(String hql, Object[] param) {        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.length > 0) {            for (int i = 0; i < param.length; i++) {                q.setParameter(i, param[i]);            }        }        return q.executeUpdate();    }    public Integer executeHql(String hql, List<Object> param) {        Query q = this.getCurrentSession().createQuery(hql);        if (param != null && param.size() > 0) {            for (int i = 0; i < param.size(); i++) {                q.setParameter(i, param.get(i));            }        }        return q.executeUpdate();    }}

至于mybatis，就没必要封装了，因为各xxxMapper接口，注入后可以直接拿来调

5.2 调用示例

package com.cnblogs.yjmyzz.service.support;import java.math.BigDecimal;import java.util.*;import javax.annotation.Resource;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.cnblogs.yjmyzz.convertor.OrderConverter;import com.cnblogs.yjmyzz.dao.BaseDAO;import com.cnblogs.yjmyzz.dto.Order;import com.cnblogs.yjmyzz.entity.TOrder;import com.cnblogs.yjmyzz.mybatis.mapper.OrderMapper;import com.cnblogs.yjmyzz.service.OrderService;@Servicepublic class OrdersServiceImpl extends BaseServiceImpl implements OrderService {    @Autowired    OrderMapper orderMapper;    @Resource    BaseDAO<TOrder> tOrderDAO;    private static final long serialVersionUID = 1513133416493770048L;    @Override    public Order get(String id) {        // hibernate实现        // return OrderConverter.toDto((TOrder) getCurrentSession().get(        // TOrder.class, new BigDecimal(Integer.parseInt(id))));        return OrderConverter.toDto(tOrderDAO.get(TOrder.class, new BigDecimal(                Integer.parseInt(id))));        // mybatis实现        // return        // OrderConverter.toDto(orderMapper.getOrder(Integer.parseInt(id)));    }    @Override    public List<Order> getAll() {        List<TOrder> entities = orderMapper.getAllOrder();        List<Order> orders = new ArrayList<Order>();        for (TOrder entity : entities) {            orders.add(OrderConverter.toDto(entity));        }        return orders;    }    @Override    public void doSave(Order order) {        // hibernate        TOrder entity = OrderConverter.toEntity(order);        if (entity.getId() != null) {            entity = (TOrder) getCurrentSession().get(TOrder.class,                    entity.getId());            // update fields            entity.setClientname(order.getClientName());            entity.setAmount(new BigDecimal(order.getAmount()));        }        getCurrentSession().saveOrUpdate(entity);    }    @Override    public void doRemove(String id) {        // mybatis        orderMapper.deleteOrder(Integer.parseInt(id));    }}

其它注意事项：

hibernate 4.x以后，entity类上的注解，最好改成@Entity("TABLE_NAME")，而非以前的@Table(xxx)，参考：

@Entity(name = "T_ORDER")public class TOrder implements java.io.Serializable {

示例代码下载：struts-hibernate-mybatis-rest.zip

阅读全文

0 0