Mybatis整合Spring

整合思路

1、  数据源信息交给spring管理

2、  SqlSessionFactory交给spring进行单例管理

3、  由spring来管理原始dao的实现类或者mapper代理的代理类。

1新建项目工程

导入jar包： 数据库驱动包， dbcp连接池包，Junit包，Mybatis核心包+依赖包，spring的jar包，spring与mybatis的集合包

2配置文件集成(数据源)

Mybatis： sqlMapConfig.xml db.properties 和 log4j.properties

spring: ApplicationContext.xml

在config-mybatis目录下， sqlMapConfig.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>
<!-- 自定义别名  -->
<typeAliases>
	<!-- 批量定义别名 -->
	<!-- name：指定需要别名定义的包的名称 它的别名就是类名（类名的首字母大小写都可）-->
	<package name="cn.itcast.ms.po"></package>	
</typeAliases>


<!-- 注意：与spring集成后，数据源和事务交给spring来管理 -->

<!-- 加载映射文件 -->
<mappers>	

<mapper resource="mybatis/sqlmap/User.xml"/>
<!-- 批量加载mapper
注意：mapper接口文件和mapper映射文件，名称相同，在同一个包下 -->

<!-- 注册指定包下的所有映射文件 -->
<!-- 	<package name="cn.itcast.ms.mapper"/> -->
</mappers>
</configuration>

在config-spring目录下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:mvc="http://www.springframework.org/schema/mvc"
	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-3.2.xsd 
						http://www.springframework.org/schema/mvc 
						http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
						http://www.springframework.org/schema/context 
						http://www.springframework.org/schema/context/spring-context-3.2.xsd 
						http://www.springframework.org/schema/aop 
						http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
						http://www.springframework.org/schema/tx 
						http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
<!-- 加载java配置文件 -->
<context:property-placeholder location="db.properties"/>

<!-- 创建数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
	<property name="driverClassName" value="${db.driver}"></property>
	<property name="url" value="${db.url}"></property>
	<property name="username"  value="${db.username}"></property>
	<property name="password" value="${db.password}"></property>
	<property name="maxActive" value="10"></property>
</bean>

<!-- SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="configLocation" value="mybatis/SqlMapConfig.xml"></property>
	<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 配置UserDao实现类 -->
<bean id="userDao" class="cn.itcast.ms.dao.UserDaoImpl">
<!-- 依赖注入sqlSessionFactory -->
	<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
</beans>

在config下

： db.properties

db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/zn
db.username=root
db.password=123456

log4j.properties

#global logging configuration
log4j.rootLogger=DEBUG, CONSOLE 
#console output...
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender  
log4j.appender.CONSOLE.Encoding=UTF-8 
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout  
log4j.appender.CONSOLE.layout.ConversionPattern=[%d{yyyy-MM-dd HH\:mm\:ss\:SSS} [%p]] [%t] - %m%n

需求1：

使用原始dao方式实现以下功能：

根据用户ID查询商品信息

1po类User

package cn.itcast.ms.po;


import java.util.Date;
import java.util.List;

public class User {
	private int id;
	private String username;
	private String sex;
	private Date birthday;
	private String address;

	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 String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	@Override
	public String toString() {
		return "\nUser [id=" + id + ", username=" + username + ", sex=" + sex
				+ ", birthday=" + birthday + ", address=" + address + "]";
	}
	

}

2User.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">


<mapper namespace="test">


<!-- 根据用户ID查询用户信息 -->
<select id="findUserById" parameterType="int" resultType="user">
select * from user where id = #{id}
</select>


</mapper>

3UserDao接口

package cn.itcast.ms.dao;

import cn.itcast.ms.po.User;



public interface UserDao {
	//根据用户ID查询用户信息 
		public User findUserById(int id)  throws Exception;	
}

4UserDao实现类

package cn.itcast.ms.dao;

import org.mybatis.spring.support.SqlSessionDaoSupport;

import cn.itcast.ms.po.User;

public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {

	@Override
	public User findUserById(int id) throws Exception {
		
		return this.getSqlSession().selectOne("test.findUserById", id);
	}

}

5spring定义bean 

<!-- 配置UserDao实现类 -->
<bean id="userDao" class="cn.itcast.ms.dao.UserDaoImpl">
<!-- 依赖注入sqlSessionFactory -->
	<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>

6测试

package cn.itcast.ms.dao;

import static org.junit.Assert.*;

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

import cn.itcast.ms.po.User;

public class UserDaoTest {
	private ApplicationContext ctx ;
	@Before
	public void setUp() throws Exception {
		 ctx = new ClassPathXmlApplicationContext("spring/ApplicationContext.xml");
		
	}

	@Test
	public void testFindUserById() throws Exception {
		UserDao userDao = (UserDao) ctx.getBean("userDao") ; //创建对象
		User user = userDao.findUserById(1);
		System.out.println(user);
		
	}

}

需求2：

使用mapper代理方式实现以下功能：

根据用户ID查询商品信息