【SSM 框架】SpringMVC+Spring+Mybatis SSM-Mybatis整合Spring（有 Mapper 实现类 ）

本章学习目标

• MyBatis 整合 Spring - 有 Mapper 实现类

2. MyBatis 整合 Spring - 有 Mapper 实现类

2.1.导入必须包

• mybatis-spring
• spring-ioc spring-aop
• spring-tx spring-context
  

2.2.编写 Mapper 的实现类

接口：

package cn.sm1234.dao;

import cn.sm1234.domain.Customer;

public interface CustomerMapper {

	/**
	 * 添加客户
	 */
	public void saveCustomer(Customer customer);
}

实现:

package cn.sm1234.dao.impl;

import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import cn.sm1234.dao.CustomerMapper;
import cn.sm1234.domain.Customer;

public class CustomerMapperImpl extends SqlSessionDaoSupport implements CustomerMapper {

	public void saveCustomer(Customer customer) {
		SqlSession sqlsession = this.getSqlSession();
		sqlsession.insert("saveCustomer",customer);
		//这里不需要事物提交

	}

}

2.3.编写 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:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" 
	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
	http://www.springframework.org/schema/context/spring-context.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx.xsd">
	
	<!-- 读取jdbc.properties -->
	<context:property-placeholder location="classpath:jdbc.properties"/>

	<!-- 创建DataSource -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="url" value="${jdbc.url}"/>
		<property name="driverClassName" value="${jdbc.driverClass}"/>
		<property name="username" value="${jdbc.user}"/>
		<property name="password" value="${jdbc.password}"/>
		<property name="maxActive" value="10"/>
		<property name="maxIdle" value="5"/>
	</bean>	
	
	<!-- 创建SqlSessionFactory对象 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 关联连接池 -->
		<property name="dataSource" ref="dataSource"/>
		<!-- 加载sql映射文件 -->
		<property name="mapperLocations" value="classpath:mapper/*.xml"/>
	</bean>
	
	<!-- 创建CustomerMapperImpl对象，注入SqlSessionFactory -->
	<bean id="customerMapper" class="cn.sm1234.dao.impl.CustomerMapperImpl">
		<!-- 关联sqlSessionFactory -->
		<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
	</bean>
	
</beans>

2.4.编写测试类

package cn.sm1234.test;

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

import cn.sm1234.dao.CustomerMapper;
import cn.sm1234.domain.Customer;


public class MyBatisSpringTest {

	@Test
	public void test(){
		//1.加载spring配置
		ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
		
		//2.获取对象
		CustomerMapper customerMapper = (CustomerMapper)ac.getBean("customerMapper");
		
		//3.调用方法
		Customer customer = new Customer();
		customer.setName("小美");
		customer.setGender("女");
		customer.setTelephone("020-666666");
		customer.setAddress("广州体育中心");
		
		customerMapper.saveCustomer(customer);
	}
}