MyBatis与Spring整合（一）

之前，分享过MyBatis的基础使用方法，但是，在日常开发中，大多会和Spring整合，在这里，简单分享一下。

这是学习官方的教程总结，官方教程地址：http://mybatis.github.io/spring/getting-started.html

1. pom.xml

与Spring整合的话，首先需要的是依赖包，

<?xml version="1.0"?>
<project
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
	xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<modelVersion>4.0.0</modelVersion>

	<parent>
		<artifactId>mybatis-parent</artifactId>
		<groupId>org.ygy.demo</groupId>
		<version>0.0.1-SNAPSHOT</version>
	</parent>

	<artifactId>mybatis-spring</artifactId>

	<name>mybatis-spring</name>
	<url>http://maven.apache.org</url>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<spring.version>3.1.1.RELEASE</spring.version>
		<struts.version>2.3.15.1</struts.version>
		<mybatis.version>3.2.2</mybatis.version>
	</properties>

	<profiles>
		<profile>
			<id>development</id>
			<properties>
				<jdbc_url>jdbc:oracle:thin:@xxx</jdbc_url>
				<jdbc_user>dptest</jdbc_user>
				<jdbc_password>dptest</jdbc_password>
			</properties>

			<build>
				<resources>
					<resource>
						<directory>src/main/resources</directory>
						<filtering>true</filtering>
					</resource>
				</resources>
			</build>

			<activation>
				<activeByDefault>true</activeByDefault>
			</activation>
		</profile>
	</profiles>

	<dependencies>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.0</version>
		</dependency>

		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>0.2.9</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring.version}</version>
		</dependency>
	</dependencies>

</project>

2. 实体

在持久层操作，就离不开实体啦

package org.ygy.mybatis.spring.entity;

import lombok.Data;

@Data
public class UserEntity implements java.io.Serializable{
	private static final long serialVersionUID = 8663915064096283715L;
	
	private Integer id; 
	private String name;
	private Integer age;
	
}

3. 持久层接口

以前的话，我个人大多是使用配置文件，就是Mapper文件，将SQL都写在里面，在这里的话，官方使用了注解，在这里顺道也学习一下。

package org.ygy.mybatis.spring.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.ygy.mybatis.spring.entity.UserEntity;

public interface UserMapper {
	
	@Select("SELECT * FROM t_ygy_demo_person WHERE id = #{id}")
	public UserEntity queryById(@Param("id") Integer id);
	
	@Insert("INSERT INTO t_ygy_demo_person(id , name , age) values(#{id} , #{name} , #{age})")
	public void insert(UserEntity user);
	
	@Update("UPDATE t_ygy_demo_person set name=#{name} , age=#{age} where id=#{id}")
	public void update(UserEntity user);
	
	@Delete("DELETE FROM t_ygy_demo_person where id=#{id} ")
	public void delete(@Param("id") Integer id);
	
	@Select("SELECT *FROM t_ygy_demo_person")
	public List<UserEntity> queryAll();
}

4. 配置文件

<?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:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="
     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
     http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
     http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
     http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">


	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
		init-method="init" destroy-method="close">
		<!-- 基本属性 url、user、password -->
		<property name="url" value="jdbc:oracle:thin:@192.168.17.254:1521:dpweb" />
		<property name="username" value="dptest" />
		<property name="password" value="dptest" />

		<!-- 配置初始化大小、最小、最大 -->
		<property name="initialSize" value="1" />
		<property name="minIdle" value="1" />
		<property name="maxActive" value="20" />

		<!-- 配置获取连接等待超时的时间 -->
		<property name="maxWait" value="60000" />

		<!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
		<property name="timeBetweenEvictionRunsMillis" value="60000" />

		<!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
		<property name="minEvictableIdleTimeMillis" value="300000" />

		<property name="validationQuery" value="SELECT 'x'" />
		<property name="testWhileIdle" value="true" />
		<property name="testOnBorrow" value="false" />
		<property name="testOnReturn" value="false" />

		<!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->
		<property name="poolPreparedStatements" value="true" />
		<property name="maxPoolPreparedStatementPerConnectionSize"
			value="20" />

		<!-- 配置监控统计拦截的filters -->
		<property name="filters" value="stat" />
	</bean>

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
	</bean>

	<!-- 1.使用注解 -->
	<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		<property name="mapperInterface" value="org.ygy.mybatis.spring.mapper.UserMapper" />
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean>

</beans>

整合的话，重点在配置文件中。

5. 测试

package org.ygy.mybatis.test;

import java.util.List;

import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.ygy.mybatis.spring.entity.UserEntity;
import org.ygy.mybatis.spring.mapper.UserMapper;

public class Client {
	private UserMapper userMapper = null;
	
	@Before
	public void before() {
		ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml");
		userMapper = applicationContext.getBean("userMapper" , UserMapper.class);
	}
	
	@Test
	public void testInsert() {
		UserEntity user = new UserEntity();
		user.setId(9001);
		user.setName("一户");
		user.setAge(22);
		
		userMapper.insert(user);
	} 
	
	@Test
	public void testDelete() {
		userMapper.delete(9001);
	}
	
	@Test
	public void testUpdate() {
		UserEntity user = new UserEntity();
		user.setId(9002);
		user.setName("孙悟空");
		user.setAge(222);
		
		userMapper.insert(user);
		
		UserEntity target = userMapper.queryById(9002);
		System.out.println(target);
		
		target.setName("猪八戒");
		userMapper.update(target);
		
		UserEntity result = userMapper.queryById(9002);
		System.out.println(result);
	}
	
	@Test
	public void testQueryAll() {
		List<UserEntity> userList = userMapper.queryAll();
		System.out.println(userList);
	}
	
	@Test
	public void testQueryById() {
		UserEntity user = userMapper.queryById(9002);
		System.out.println(user);
	}
}