本章学习目标
- 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);
}
}