关于Spring整合mybatis的实现方法

下面是官方文档

xmybatis-spring –

        在初学mybatis时，我们通常需要建立一个mybatisUtils工具类来获取SqlSession，而在spring，我们使用SqlSessionTemplate去处理SqlSession。

方式一

编写一个接口实现类，去处理接口功能。

package com.mybatis.mapper;

import com.mybatis.pojo.User;
import org.mybatis.spring.SqlSessionTemplate;

import java.util.List;

public class UserMapperImpl implements UserMapper{

    //在原来我们的所有操作，都使用sqlSession来执行，现在都使用SqlSessionTemplate；
    private SqlSessionTemplate sqlSession;

    public void setSqlSession(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }

    @Override
    public List<User> selectUser() {
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        return mapper.selectUser();
    }
}

spring-dao.xml

1.配置了数据源，将之前mybatis连接数据库替换成了spring的数据源（c3p0 dbcp druid）

2.配置好SqlSessionFactory注入到SqlSessionTemplate中

 <!--sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!--绑定Mybatis配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--mapper注册映射器-->
        <property name="mapperLocations" value="classpath:com/mybatis/mapper/*.xml"/>
    </bean>

    <!--SqlSessionTemplate:就是我们使用的sqlSession-->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <!--只能使用构造器注入sqlSessionFactory，因为它没有set方法-->
        <constructor-arg index="0" ref="sqlSessionFactory"/>
    </bean>

applicationContext.xml

将配置好的SqlSessionTemplate注入到接口实现类中

    <import resource="spring-dao.xml"></import>

    <!--将UserMapperImpl注入到bean中-->
    <bean id="userMapper" class="com.mybatis.mapper.UserMapperImpl">
        <property name="sqlSession" ref="sqlSession"></property>
    </bean>

 测试代码

    @Test
    public void test1(){
        ApplicationContext context =
                new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = context.getBean("userMapper",UserMapper.class);
        for (com.mybatis.pojo.User user : userMapper.selectUser()) {
            System.out.println(user);
        }
    }

方式二

接口实现类，去继承SqlSessionDaoSupport

package com.mybatis.mapper;

import com.mybatis.pojo.User;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import java.util.List;

public class UserMapperImpl2 extends SqlSessionDaoSupport implements UserMapper{
    @Override
    public List<User> selectUser() {
        return getSqlSession().getMapper(UserMapper.class).selectUser();
    }
}

spring-dao.xml

只需要实现SqlSessionFactoryBean

   <!--sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!--绑定Mybatis配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--mapper注册映射器-->
        <property name="mapperLocations" value="classpath:com/mybatis/mapper/*.xml"/>
    </bean>

applicationContext.xml

将注册好的SqlSessionFactory注入到UserMapperImpl2方法中

    <!--将UserMapperImpl注入到bean中-->
    <bean id="userMapper2" class="com.mybatis.mapper.UserMapperImpl2">
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
    </bean>

测试代码

  @Test
    public void test1(){
        ApplicationContext context =
                new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = context.getBean("userMapper2",UserMapper.class);
        for (com.mybatis.pojo.User user : userMapper.selectUser()) {
            System.out.println(user);
        }
    }