Mybatis和Spring的整合

于 2017-02-12 19:52:13 发布
阅读量454 收藏 1
点赞数
分类专栏： spring全家桶系列
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yuchao2015/article/details/55003646
版权

目录结构：



①.引入依赖pom.xml

<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/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>cn.zto.parent</groupId>
	<artifactId>zto-parent</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	</parent>
	<groupId>cn.zto.mybatis</groupId>
	<artifactId>zto-mybatis-spring</artifactId>
	<version>1.0.0-SNAPSHOT</version>


	<dependencies>
		<!-- 单元测试 -->
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<scope>test</scope>
		</dependency>
		<!-- Mybatis -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
		</dependency>
		<!-- MySql -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
		</dependency>
		<dependency>
			<groupId>cglib</groupId>
			<artifactId>cglib</artifactId>
			<version>3.1</version>
		</dependency>
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper</artifactId>
			<version>3.7.5</version>
		</dependency>
		<dependency>
			<groupId>com.github.jsqlparser</groupId>
			<artifactId>jsqlparser</artifactId>
			<version>0.9.1</version>
		</dependency>

		<!-- 整合 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
		</dependency>

		<!-- 连接池 -->
		<dependency>
			<groupId>com.jolbox</groupId>
			<artifactId>bonecp-spring</artifactId>
			<version>0.8.0.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aspects</artifactId>
		</dependency>
	</dependencies>
</project>
②.编写实体User、Mapper接口、Mapper映射文件

User.java

package cn.zto.mybatis.pojo;

import java.util.Date;

public class User implements java.io.Serializable{

    private static final long serialVersionUID = -5846970261372764303L;

    private Long id;

    // 用户名
    private String userName;

    // 密码
    private String password;

    // 姓名
    private String name;

    // 年龄
    private Integer age;

    // 性别，1男性，2女性
    private Integer sex;

    // 出生日期
    private Date birthday;

    // 创建时间
    private Date created;

    // 更新时间
    private Date updated;

   //getter and setter

    @Override
    public String toString() {
        return "User [id=" + id + ", userName=" + userName + ", password=" + password + ", name=" + name
                + ", age=" + age + ", sex=" + sex + ", birthday=" + birthday + ", created=" + created
                + ", updated=" + updated + "]";
    }

}

UserMapper.java 

package cn.zto.mybatis.mapper;

import org.apache.ibatis.annotations.Param;

import cn.zto.mybatis.pojo.User;

public interface UserMapper {

    /**
     * 根据id查询用户信息
     * 
     * @param id
     * @return
     */
    public User queryUserById(@Param("id") Long id);

}

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="cn.zto.mybatis.mapper.UserMapper">

	<select id="queryUserById" parameterType="Long" resultType="User">
		SELECT * FROM tb_user WHERE id = #{id}
	</select>
	
</mapper>

③.配置数据源

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/mybatis?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true
jdbc.username=root
jdbc.password=123456

applicationContext.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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<!-- 使用spring自带的占位符替换功能 -->
	<bean
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<!-- 允许JVM参数覆盖 -->
		<property name="systemPropertiesModeName" value="SYSTEM_PROPERTIES_MODE_OVERRIDE" />
		<!-- 忽略没有找到的资源文件 -->
		<property name="ignoreResourceNotFound" value="true" />
		<!-- 配置资源文件 -->
		<property name="locations">
			<list>
				<value>classpath:jdbc.properties</value>
			</list>
		</property>
	</bean>

	<bean id="dataSource" class="com.jolbox.bonecp.BoneCPDataSource"
		destroy-method="close">
		<!-- 数据库驱动 -->
		<property name="driverClass" value="${jdbc.driver}" />
		<!-- 相应驱动的jdbcUrl -->
		<property name="jdbcUrl" value="${jdbc.url}" />
		<!-- 数据库的用户名 -->
		<property name="username" value="${jdbc.username}" />
		<!-- 数据库的密码 -->
		<property name="password" value="${jdbc.password}" />
		<!-- 检查数据库连接池中空闲连接的间隔时间，单位是分，默认值：240，如果要取消则设置为0 -->
		<property name="idleConnectionTestPeriod" value="60" />
		<!-- 连接池中未使用的链接最大存活时间，单位是分，默认值：60，如果要永远存活设置为0 -->
		<property name="idleMaxAge" value="30" />
		<!-- 每个分区最大的连接数 -->
		<property name="maxConnectionsPerPartition" value="150" />
		<!-- 每个分区最小的连接数 -->
		<property name="minConnectionsPerPartition" value="5" />
	</bean>

</beans>

④.配置SqlSessionFactory

这里使用的并不是SqlSessionFactoryBuilder，而是使用的Mybatis-spring整合jar中的org.mybatis.spring.SqlSessionFactoryBean，并且通过configLocation配置Mybatis的配置文件。

<?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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<!-- 定义Mybatis的SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 定义数据源 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 指定mybatis全局配置文件 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	</bean>


</beans>

⑤.配置mybatis全局文件

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>

	
	<settings>
		<!-- 开启驼峰映射 -->
		<setting name="mapUnderscoreToCamelCase" value="true"/>
	</settings>
	
	<typeAliases>
		<!-- <typeAlias type="cn.zto.mybatis.pojo.User" alias="User"/> -->
		<!-- 
			配置扫描包，更适合企业开发
		 -->
		<package name="cn.zto.mybatis.pojo"/>
	</typeAliases>
	
	
	<mappers>
		<mapper resource="UserMapper.xml" />
	</mappers>

</configuration>

⑥.添加日志

log4j.properties

log4j.rootLogger=DEBUG,A1
log4j.logger.org.mybatis = DEBUG
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%t] [%c]-[%p] %m%n


⑦.测试： 

package cn.zto.mybatis.mapper;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import cn.zto.mybatis.pojo.User;

public class UserMapperTest {

    private UserMapper userMapper;

    /**
     * @throws Exception
     */
    @Before
    public void setUp() throws Exception {
        // 初始化SPring容器
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml",
                "applicationContext-mybatis.xml");
        // 从容器中获取SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = applicationContext.getBean(SqlSessionFactory.class);

        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        this.userMapper = sqlSession.getMapper(UserMapper.class);
    }

    @Test
    public void testQueryUserById() {
        User user = this.userMapper.queryUserById(1L);
        System.out.println(user);
    }

}

结果：



ok，mybatis已经和spring整合起来了。

但是发现 每次还是要先获取SqlSessionFactory，然后获取到session，之后从session中获取Mapper

如果能从容器中直接获取到Mapper就更好了


定义Mapper

在applicationContext-mybatis.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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<!-- 定义Mybatis的SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 定义数据源 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 指定mybatis全局配置文件 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	</bean>

 	<!-- 定义Mapper -->
	<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		<!-- 指定Mapper接口的地址 -->
		<property name="mapperInterface" value="cn.zto.mybatis.mapper.UserMapper" />
		<!-- sqlSessionFactory依赖 -->
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean>
	

</beans>



测试：

package cn.zto.mybatis.mapper;

import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import cn.zto.mybatis.pojo.User;

public class UserMapperTest {

    private UserMapper userMapper;

    /**
     * @throws Exception
     */
    @Before
    public void setUp() throws Exception {
        // 初始化SPring容器
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml",
                "applicationContext-mybatis.xml");
        // 从容器中获取SqlSessionFactory
        // SqlSessionFactory sqlSessionFactory =
        // applicationContext.getBean(SqlSessionFactory.class);

        // SqlSession sqlSession = sqlSessionFactory.openSession(true);
        // this.userMapper = sqlSession.getMapper(UserMapper.class);
        this.userMapper = applicationContext.getBean(UserMapper.class);
    }

    @Test
    public void testQueryUserById() {
        User user = this.userMapper.queryUserById(1L);
        System.out.println(user);
    }

}

上面还是有点问题，如果有多个Mapper映射文件，是不是要配置多个MapperFactotyBean呢？

这里可以配置Mapper接口的自动扫描器

配置Mapper接口的自动扫描器

我们没有必要一个一个的在spring配置文件中配置Mapper接口，Mybatis的Spring整合包中提供了更高级的方式，mapper接口扫描器，org.mybatis.spring.mapper.MapperScannerConfigurer

在applicationContext-mybatis.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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<!-- 定义Mybatis的SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 定义数据源 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 指定mybatis全局配置文件 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	</bean>

	<!-- 定义Mapper -->
	<!-- <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		指定Mapper接口的地址
		<property name="mapperInterface" value="cn.zto.mybatis.mapper.UserMapper" />
		sqlSessionFactory依赖
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean> -->
	
	<!-- 定义Mapper接口扫描器 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	     <property name="basePackage" value="cn.zto.mybatis.mapper" />
	</bean> 

</beans>

问题？多个包怎么配置？

参考源码可以用分隔符分割





使用通配符配置mapper.xml文件

<!-- 定义Mybatis的SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<!-- 定义数据源 -->
	<property name="dataSource" ref="dataSource" />
	<!-- 指定mybatis全局配置文件 -->
	<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	
	<!-- 扫描mappers目录以及子目录下的所有xml文件 -->
 	<property name="mapperLocations" value="classpath:mappers/**/*.xml" />
 		
</bean>

使用mapperLocations扫描到mapper文件下的所有xml，同时移除mybatis全局配置文件中的mapper配置



继续简化Mybatis全局配置文件，将别名包配置到也配置到spring中，同时将全局配置文件中的别名配置移除

<!-- 定义Mybatis的SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<!-- 定义数据源 -->
	<property name="dataSource" ref="dataSource" />
	<!-- 指定mybatis全局配置文件 -->
	<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	
	<!-- 扫描mappers目录以及子目录下的所有xml文件 -->
 	<property name="mapperLocations" value="classpath:mappers/**/*.xml" />
 		
 	<!-- 别名扫描包 -->
 	<property name="typeAliasesPackage" value="cn.zto.mybatis.pojo"/>
</bean>



最终mybatis全局配置文件下剩下驼峰配置了 

<?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>

	
	<settings>
		<!-- 开启驼峰映射 -->
		<setting name="mapUnderscoreToCamelCase" value="true"/>
	</settings>
	
	<!-- <typeAliases>
		<typeAlias type="cn.zto.mybatis.pojo.User" alias="User"/>
		
			配置扫描包，更适合企业开发
		
		<package name="cn.zto.mybatis.pojo"/>
	</typeAliases> -->
	
	
	<!-- <mappers>
		<mapper resource="UserMapper.xml" />
	</mappers> -->

</configuration>

applicationContext-mybatis.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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<!-- 定义Mybatis的SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 定义数据源 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 指定mybatis全局配置文件 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
		
		<!-- 扫描mappers目录以及子目录下的所有xml文件 -->
  		<property name="mapperLocations" value="classpath:mappers/**/*.xml" />
  		
  		<!-- 别名扫描包 -->
  		<property name="typeAliasesPackage" value="cn.zto.mybatis.pojo"/>
	</bean>

	<!-- 定义Mapper -->
	<!-- <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		指定Mapper接口的地址
		<property name="mapperInterface" value="cn.zto.mybatis.mapper.UserMapper" />
		sqlSessionFactory依赖
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean> -->
	
	<!-- 定义Mapper接口扫描器 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	     <property name="basePackage" value="cn.zto.mybatis.mapper" />
	</bean> 

</beans>


事务管理

Mybatis和spring整合后的事务管理是由Spring管理的，事务管理器依然使用jdbc的事务管理器，org.springframework.jdbc.datasource.DataSourceTransactionManager。


A天道酬勤
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值