23、(知识篇)Mybatis03使用（Mybatis整合Spring）

如果你有阅读我之前的文章，那么恭喜你，mybatis你应该已经熟悉使用了

整合spring虽然有些不同，但是基础应该已经打好了

/**

* Spring整合mybatis

* 1、加入spring和mybatis的相关包

* 2、加入mybatis-spring-x.x.x.jar 用于整合

* 3、配置spring的applicationContext.xml文件

* 4、用SqlSessionFactoryBean代替mybatis用的SqlSessionFactory

* 4.1SqlSessionFactoryBean配置如下属性

* 数据源： <property name="dataSource" ref="dataSource"></property>

* 别名包：用于mybatis的mapper.xml中的resulttype／parametertype 与类名对应 <property name="typeAliasesPackage" value="com.spring.vo"></property>

* 5、配置mybatis的mapper.xml的路径

* 方法1:加入标签 <mybatis-spring:scan base-package="com.spring.service" />

* 方法2:配置MapperScannerConfigurer的bean

* <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

* <property name="basePackage" value="com.spring.service"></property>

* 需要注意sqlSessionFactoryBeanName 填的时value，对应的时上面的sqlsessionfactorybean的id

* <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>

* </bean>

* 6、（参考userservice.java/userservice.xml）

* 6.0、java类只需要写接口就行，spring会管理根据mybatis做实现类

* 6.1、java类名要与mapper文件同名

* 6.2、java类写接口，mybatis的namespace要与java类全类名相同

* 6.3、接口里面的方法跟mybatis的方法要对应

* 

* 7、实现中只需声明java接口，然后通过spring的ioc获得实例调用方法即可

* 

* 

* 

* 

* @param args

*/

测试类：

package com.spring.test;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

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

import com.spring.service.UserService;
import com.spring.vo.User;


public class Test {
	/**
	 * Spring整合mybatis
	 * 1、加入spring和mybatis的相关包
	 * 2、加入mybatis-spring-x.x.x.jar 用于整合
	 * 3、配置spring的applicationContext.xml文件
	 * 4、用SqlSessionFactoryBean代替mybatis用的SqlSessionFactory
	 * 		4.1SqlSessionFactoryBean配置如下属性
	 * 		数据源： <property name="dataSource" ref="dataSource"></property>
	 *		别名包：用于mybatis的mapper.xml中的resulttype／parametertype 与类名对应 <property name="typeAliasesPackage" value="com.spring.vo"></property>
	 * 	5、配置mybatis的mapper.xml的路径
	 * 		方法1:加入标签 <mybatis-spring:scan base-package="com.spring.service" />
	 * 		方法2:配置MapperScannerConfigurer的bean
	 * 			<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	 *				<property name="basePackage" value="com.spring.service"></property>
	 *				需要注意sqlSessionFactoryBeanName 填的时value，对应的时上面的sqlsessionfactorybean的id
	 *				<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
	 *			</bean>
	 * 6、（参考userservice.java/userservice.xml）
	 * 		6.0、java类只需要写接口就行，spring会管理根据mybatis做实现类
	 * 		6.1、java类名要与mapper文件同名
	 * 		6.2、java类写接口，mybatis的namespace要与java类全类名相同
	 * 		6.3、接口里面的方法跟mybatis的方法要对应
	 * 
	 * 7、实现中只需声明java接口，然后通过spring的ioc获得实例调用方法即可
	 * 		
	 * 
	 * 
	 * 
	 * @param args
	 */
	
	public static void main(String[] args) {
		ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
		UserService userService = ctx.getBean(UserService.class);
		

		User user = userService.getUserById(1);
		System.out.println("user == "+user);
		
		
		Map<String,Object> condition = new HashMap<>();
		condition.put("userName", "Flash");
		List<User> users = userService.getUsers(condition);
		System.out.println("users == "+users);
		
	}
}

UserService接口：

package com.spring.service;

import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Service;

import com.spring.vo.User;

@Service
public interface UserService {
	
	int saveUser(User user);
	
	int updateUser(User user);
	
	int deleteUser(int id);
	
	User getUserById(int id);
	
	List<User> getUsers(Map<String,Object> condition);
	
	int getUserCount();
	
}

UserServiceMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 这里namespace必须于接口类名一致 -->
<mapper namespace="com.spring.service.UserService">
	<select id="getUserById" parameterType="int" resultType="User">
		select * from User where id = #{id}
	</select>
	<select id="getUsers" parameterType="java.util.Map" resultType="User">
		select * from User where 1=1
		<if test="userName!=null and userName != '' ">
			and userName like '%${userName}%'
		</if>
	</select>
</mapper>

user类：

package com.spring.vo;

import org.springframework.stereotype.Component;

@Component
public class User {
	private int id;
	private String userName;
	private int sex;

	public User() {
		super();
		// TODO Auto-generated constructor stub
	}

	public User(int id, String userName, int sex) {
		super();
		this.id = id;
		this.userName = userName;
		this.sex = sex;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public int getSex() {
		return sex;
	}

	public void setSex(int sex) {
		this.sex = sex;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", userName=" + userName + ", sex=" + sex + "]";
	}

}

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:tx="http://www.springframework.org/schema/tx"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd
		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-4.3.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
	
	<!-- scan annotation 包 -->
	<context:component-scan base-package="com.spring"></context:component-scan>
	<!-- 自动 sacn aop包 -->
	<aop:aspectj-autoproxy></aop:aspectj-autoproxy>

	<context:property-placeholder location="classpath:db.properties"/>
	<!-- 配置数据源 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.DriverManagerDataSource">
		<property name="driverClass" value="${driverClass}"></property>
		<property name="jdbcUrl" value="${url}"></property>
		<property name="user" value="${userName}"></property>
		<property name="password" value="${password}"></property>
	</bean>
	
	<!-- 配置sqlsessionfactorybean，需要使用mybatis－spring.jar的包 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		<property name="typeAliasesPackage" value="com.spring.vo"></property>
	</bean>
	
	<!-- 配置mybatis 扫描mapper的包 -->
	<!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.spring.service"></property>
		需要注意sqlSessionFactoryBeanName 填的时value，对应的时上面的sqlsessionfactorybean的id
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
	</bean> -->
	<!-- 配置mybatis 扫描mapper的包2 -->
	<mybatis-spring:scan base-package="com.spring.service" />
	
	<!-- 配置事务 -->
	<bean id="transactionManageer" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	<tx:annotation-driven transaction-manager="transactionManager"/>
	
</beans>

db.properties

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/Test
userName=root
password=root

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<!-- 整合spring这里不用配置了 -->
</configuration>