MyBatis和Spring整合

1. 我是在MyBatis的基础上再整合Spring进来的
2. 第一步：删除SqlMapConfig.xml里的环境配置
3. 第二步：在beans.xml里加入mybatis-spring整合配置内容
4. 第三步：改写service层里实现类及增删改查方法，详见代码
5. 第四步：测试，尤其测试一下事务管理是否受影响
6. 另外需要的jar包：mybatis-spring.jar
   SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
	<typeAliases>
		<typeAlias type="com.entity.Person" alias="Person"/>
	</typeAliases>

	<mappers>
		<mapper resource="com/entity/Person.xml"/>
	</mappers>
</configuration>

beans.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:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
">

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test"/>
    <property name="username" value="root"/>
    <property name="password" value="root1205"/>
    <property name="defaultAutoCommit" value="true"/>
</bean>

<!-- spring和mybatis整合 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="configLocation" value="classpath:SqlMapConfig.xml"></property>
	<property name="dataSource" ref="dataSource"></property>
</bean>

<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
	<constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	<property name="basePackage" value="com.dao"></property>
</bean>

<bean id="personService" class="com.service.PersonService">
	<property name="sqlSessionTemplate" ref="sqlSessionTemplate"></property>
	<property name="personMapper" ref="personMapper"></property>
	<!-- 注入userMapper时比较特殊，我们只知道spring容器扫描了dao层的所有接口，却并不知道它会将它实例化成什么名字 -->
	<!-- 容器扫描dao层接口后，默认实例化的名字就是首字母小写后的名 -->
	<!-- 在mybatis中是SqlSession的getMapper方法实例化接口的 -->
	<!-- 整合，一次扫描dao下的所有接口实例化的 -->
</bean>

<!-- 以下是事务管理 -->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"></property>
</bean>


<tx:advice id="txAdvice" transaction-manager="txManager">
    <tx:attributes>
        <tx:method name="*" propagation="REQUIRED"/>
    </tx:attributes>
</tx:advice>

<aop:config>
    <aop:pointcut expression="execution(* com.service.PersonService.save(..))" id="txPointCut"/>
    <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/>
</aop:config>

</beans>

Test1.java

package com.test;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.entity.Person;
import com.service.IPersonService;
import com.service.PersonService;

public class Test1 {
	
	public static void main(String[] args){
		//单纯使用mybatis时这样测试
//		IPersonService personService = new PersonService();
//		Person p1 = new Person();
//		p1.setName("夏洛");
//		p1.setAge(18);
//		Person p2 = new Person();
//		p2.setName("马冬梅");
//		p2.setAge(19);
//		personService.save(p1);
		ApplicationContext app = new ClassPathXmlApplicationContext("beans.xml");
		IPersonService personService = (IPersonService) app.getBean("personService");
		System.out.println(personService);//personService是代理对象
		Person p1 = new Person();
		p1.setName("夏洛");
		p1.setAge(18);
		Person p2 = new Person();
		p2.setName("马冬梅");
		p2.setAge(19);
		//personService.save(p1);
		//打断点看看事务起不起作用
		personService.save(null);
		
		
	}
}

IPersonService.java

package com.service;

import com.entity.Person;

public interface IPersonService {
	
	public void save(Person p);

}

PersonService.java

package com.service;

import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.SqlSessionTemplate;

import com.dao.PersonMapper;
import com.entity.Person;
import com.util.DBHelper;

public class PersonService implements IPersonService {

	private PersonMapper personMapper;
	
	//spring与mybatis整合
	private SqlSessionTemplate sqlSessionTemplate;
	
	
	
	public SqlSessionTemplate getSqlSessionTemplate() {
		return sqlSessionTemplate;
	}

	public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {
		this.sqlSessionTemplate = sqlSessionTemplate;
	}

	public PersonMapper getPersonMapper() {
		return personMapper;
	}



	public void setPersonMapper(PersonMapper personMapper) {
		this.personMapper = personMapper;
	}



	@Override
	public void save(Person p) {
		//单纯使用mybatis时此方法这样写
//		SqlSession session = DBHelper.getSession();
//		personMapper = session.getMapper(PersonMapper.class);
//		personMapper.insertPerson(p);
//		session.commit();
//		session.close();
		
		Person p1 = new Person();
		p1.setName("夏洛");
		p1.setAge(18);
		Person p2 = new Person();
		p2.setName("马冬梅");
		p2.setAge(19);
		//打断点看看事务起不起作用
		//测试过了，事务还是起作用的
		personMapper.insertPerson(p1);
		personMapper.insertPerson(p2);
		
		
	}

}

Person.java

package com.entity;

public class Person {
	private int id;
	private String name;
	private int age;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	
	

}

Person.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD SQL Map 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="com.dao.PersonMapper">
	<insert id="insertPerson">
	INSERT INTO person(name,age)VALUES(#{name},#{age})
	</insert>
</mapper>

附工程目录图：

注意：mabatis和spring整合后，是不需要我们写DBHelper.java的
附jar包图：