五.通用支持」」spring中使用MyBatis

3.MyBatis支持

3-1 POM配置

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
</dependency>

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>2.0.3</version>
</dependency>

3-2 配置文件

1.UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="dao.UserDao">
    <sql id="userColumn">
        id,
        username,
        password,
        phone,
        address
    </sql>
<!-- 
	Spring中通过扫包设置了别名
	resultType中可以直接写别名就可以 
	如果没有设置需要写相对路径Entity.User
-->
    <select id="selectAll" resultType="User">
        select <include refid="userColumn"></include>
        from t_user
    </select>

    <insert id="insertUser" parameterType="User">
        insert into
        t_user
          (username,password,phone,address)
        values
          (#{username},#{password},#{phone},#{address})
    </insert>
    
</mapper>

2.mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--
sqlSessionFactory中整合了mybatis-config的配置
但是mybatis-config的插件任然可以被使用
-->
    <typeAliases></typeAliases>
    <mappers></mappers>

</configuration>

3.spring.xml

<?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:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
  
	<!-- 读取propert配置文件 -->
    <context:property-placeholder location="classpath:dataSource.properties"/>
	<!-- 设置数据源 -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!-- sqlSessionFactory中整合了mybatis-config的配置 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 注入数据源 -->
        <property name="dataSource" ref="dataSource"/>
      
        <!-- 配置别名  扫包,在mapper中都可以直接使用类名-->
        <property name="typeAliasesPackage" value="entity"/>
      
        <!-- 注册mapper -->
        <property name="mapperLocations">
            <list>
                <!--<value>classpath:mapper/UserMapper.xml</value>-->
                <!-- 支持通配符 -->
                <value>classpath:mapper/*.xml</value>
            </list>
        </property>
        <!-- 访问config配置 -->
        <!--<property name="configLocation" value="classpath:mybatis-config.xml"/>-->
    </bean>

    <!-- 配置UserDao -->
    <!-- 方式一:使用MapperFactoryBean生产对应的Mapper -->
    <!--<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">-->
        <!--&lt;!&ndash; 注入SqlSessionFactory &ndash;&gt;-->
        <!--<property name="sqlSessionFactory" ref="sqlSessionFactory"/>-->
        <!--&lt;!&ndash; 配置需要生产的接口是谁 &ndash;&gt;-->
        <!--<property name="mapperInterface" value="dao.UserDao"/>-->
    <!--</bean>-->

    <!--
        方式二:使用扫包的方式创建指定包下所有的Mapper
        使用后处理bean对当前的工程做整体的操作
        会自动扫描指定包下所有的接口
        实现对这些接口的Mapper生产
        生产出来的所有的Mapper其bean的id即为当前类名,首字母小写
     -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="dao"/>
    </bean>

    <!-- 事务配置 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!-- 注入数据源 -->
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- AOP2.X注解事务 -->
    <tx:annotation-driven transaction-manager="transactionManager"/>

    <context:component-scan base-package="service"/>

</beans>

3-3 测试

package test;

import entity.User;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import service.UserService;

/**
 * Author:shixiaojun@itany.com
 * Date:2020/7/3-9:29
 */
public class Test {

    public static void main(String[] args) {
        ApplicationContext ac = new ClassPathXmlApplicationContext("classpath:spring.xml");


        // 方式一:使用MyBatis原始方式
//        SqlSessionFactory factory = (SqlSessionFactory) ac.getBean("sqlSessionFactory");
//        SqlSession session = factory.openSession();
//        UserDao userDao = session.getMapper(UserDao.class);

        // 方式二:使用MapperFactoryBean获取对应的Mapper
//        UserDao userDao = (UserDao) ac.getBean("userDao");

        // 方式三:使用扫包方式进行操作,bean的id为类名首字母小写
//        UserDao userDao = (UserDao) ac.getBean("userDao");
//        List<User> users = userDao.selectAll();
//        for(User user : users){
//            System.out.println(user);
//        }

        User user = new User();
        user.setUsername("test4");
        user.setPassword("666666");
        user.setPhone("13945121238");
        user.setAddress("江苏-南京");
//
//        userDao.insertUser(user);


        UserService userService = (UserService) ac.getBean("userServiceImpl");
        System.out.println(userService);
        userService.regist(user);

    }

}