spring与mybatis四种整合方法

快来打我* 2022-08-08 19:59 129阅读 0赞

这篇文章介绍的也不错：[http://haohaoxuexi.iteye.com/blog/1843309][http_haohaoxuexi.iteye.com_blog_1843309]

**1、采用数据映射器（MapperFactoryBean）的方式，不用写mybatis映射文件，采用注解方式提供相应的sql语句和输入参数。**  
  （1）Spring配置文件：

<context:property-placeholder location="jdbc.properties"/>
          
          <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
            <property name="driverClassName" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${username}"/>
            <property name="password" value="${password}"/>
            <property name="initialSize" value="${initialSize}"/>
            <property name="maxActive" value="${maxActive}"/>
            <property name="maxIdle" value="${maxIdle}"/>
            <property name="minIdle" value="${minIdle}"/>
          </bean>
          
          <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
          <property name="dataSource" ref="dataSource" /> 
          </bean>
          
          <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"> 
          <property name="mapperInterface" value="com.xxt.ibatis.dbcp.dao.UserMapper" />
          <property name="sqlSessionFactory" ref="sqlSessionFactory" /> 
          </bean>
          <bean id="userDaoImpl2" class="com.xxt.ibatis.dbcp.dao.impl.UserDaoImpl2">
          <property name="userMapper" ref="userMapper"/>
     </bean>

（2）数据映射器UserMapper,代码如下:

public interface UserMapper {
            @Select("SELECT * FROM user WHERE id = #{userId}") 
            User getUser(@Param("userId") long id); 
      }

(3) dao接口类UserDao，代码如下：

public interface UserDao {
           public User getUserById(User user);
       }

(4)dao实现类UserDaoImpl2,，代码如下:

public class UserDaoImpl2 implements UserDao {
           private UserMapper userMapper;
           public void setUserMapper(UserMapper userMapper) { 
               this.userMapper = userMapper; 
           } 
           public User getUserById(User user) {
              return userMapper.getUser(user.getId()); 
           }
       }

** 2、采用接口org.apache.ibatis.session.SqlSession的实现类org.mybatis.spring.SqlSessionTemplate**。  
    mybatis中, sessionFactory可由SqlSessionFactoryBuilder.来创建。MyBatis- Spring 中，使用了SqlSessionFactoryBean来替代。SqlSessionFactoryBean有一个必须属性 dataSource，另外其还有一个通用属性configLocation（用来指定mybatis的xml配置文件路径）。  
   （1）Spring配置文件：

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
          <property name="dataSource" ref="dataSource" /> 
          
          <property  name="configLocation"  value="classpath:sqlMapConfig.xml"/>
          
          <!- - <property  name="mapperLocations"  value="classpath*:com/xxt/ibatis/dbcp/**/*.xml"/>  -->
       </bean>
    <bean id="sqlSession"     class="org.mybatis.spring.SqlSessionTemplate"> 
          <constructor-arg index="0" ref="sqlSessionFactory" /> 
    </bean>
    <bean id="UserDaoImpl " class="com.xxt.ibatis.dbcp.dao.impl.UserDaoImpl">
       
       <property name="sqlSessionTemplate" ref="sqlSession" />
    -->
    </bean>

(2)mybatis总配置文件sqlMapConfig.xml：

(3)实体类映射文件user.map.xml:

<mapper namespace="com.xxt.ibatis.dbcp.domain.User">
         <resultMap type="User" id="userMap">
            <id property="id" column="id" />
            <result property="name" column="name" />
            <result property="password" column="password" />
            <result property="createTime" column="createtime" />
         </resultMap>
         <select id="getUser" parameterType="User" resultMap="userMap">
           select * from user where id = #{id}
         </select>
    <mapper/>

(4)dao层接口实现类UserDaoImpl：

public class UserDaoImpl implements  UserDao  {
         public SqlSessionTemplate sqlSession;
         public User getUserById(User user) {
             return (User)sqlSession.selectOne("com.xxt.ibatis.dbcp.domain.User.getUser", user);
         }
         public void setSqlSession(SqlSessionTemplate sqlSession) {
              this.sqlSession = sqlSession;
         }
       }

** 3、采用抽象类org.mybatis.spring.support.SqlSessionDaoSupport提供SqlSession。**  
   (1)spring配置文件:

(2) dao层接口实现类UserDaoImpl3：

public class UserDaoImpl3 extends SqlSessionDaoSupport implements UserDao {   
      public User getUserById(User user) {   
         return (User) getSqlSession().selectOne("com.xxt.ibatis.dbcp.domain.User.getUser", user);  
      }   
    }

** 4、采用org.mybatis.spring.mapper.MapperFactoryBean或者org.mybatis.spring.mapper.MapperScannerConfigurer**

<beans:bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <beans:property name="dataSource" ref="simpleDataSource" />
            <beans:property name="configLocation"
                value="classpath:conf/core/mybatis-config.xml" />
        </beans:bean>
    
        <beans:bean id="sqlSessionFactory_contact" class="org.mybatis.spring.SqlSessionFactoryBean">
            <beans:property name="dataSource" ref="simpleDataSource_contact" />
            <beans:property name="configLocation"
                value="classpath:conf/core/mybatis-config-contact.xml" />
        </beans:bean>
    
        <beans:bean id="transactionManager"
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <beans:property name="dataSource" ref="simpleDataSource" />
        </beans:bean>
    
        <beans:bean id="transactionManager_contact"
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <beans:property name="dataSource" ref="simpleDataSource_contact" />
        </beans:bean>
        
    
           
    <bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
            <property name="mapperInterface" value="com.mybatis.UserDao"></property>
            <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
        </bean>
    
        <bean id="userService" class="com.mybatis.UserServiceImpl">
            <property name="userDao" ref="userDao"></property>
        </bean>
    
        
        <beans:bean name="mapperScannerConfigurer"
            class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <beans:property name="basePackage" value="com.elong.hotel.crm.data.mapper" />
            <beans:property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></beans:property>
        </beans:bean>
        <beans:bean name="mapperScannerConfigurer_contact"
            class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <beans:property name="basePackage"
                value="com.elong.hotel.crm.data.contact.mapper" />
            <beans:property name="sqlSessionFactoryBeanName" value="sqlSessionFactory_contact"></beans:property>
        </beans:bean>
    
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                
                <tx:method name="save*" propagation="REQUIRED" />
                <tx:method name="insert*" propagation="REQUIRED" />
                <tx:method name="add*" propagation="REQUIRED" />
                <tx:method name="del*" />
                <tx:method name="update*" />
                <tx:method name="find*" read-only="true" />
                <tx:method name="get*" read-only="true" />
                <tx:method name="search*" read-only="true" />
            </tx:attributes>
        </tx:advice>
        
        <tx:advice id="txAdvice_contact" transaction-manager="transactionManager_contact">
            <tx:attributes>
                
                <tx:method name="save*" propagation="REQUIRED" />
                <tx:method name="insert*" propagation="REQUIRED" />
                <tx:method name="add*" propagation="REQUIRED" />
                <tx:method name="del*" />
                <tx:method name="update*" />
                <tx:method name="find*" read-only="true" />
                <tx:method name="get*" read-only="true" />
                <tx:method name="search*" read-only="true" />
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            <aop:pointcut expression="execution(* com.elong.hotel.crm.service..*.*(..))"
                id="pointcut" />
            <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut" />
            <aop:advisor advice-ref="txAdvice_contact" pointcut-ref="pointcut" />
        </aop:config>

[http_haohaoxuexi.iteye.com_blog_1843309]: http://haohaoxuexi.iteye.com/blog/1843309