MyBatis和Spring整合

矫情吗；* 2022-05-12 12:16 179阅读 0赞

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

附工程目录图：  
![在这里插入图片描述][70]  
注意：mabatis和spring整合后，是不需要我们写DBHelper.java的  
附jar包图：  
![在这里插入图片描述][70 1]

[70]: /images/20220512/6e2b893bec6a42c78c3a0c2bddcdf925.png
[70 1]: /images/20220512/87834145cce04d99a6b9daa7631ec819.png