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 configurationPUBLIC "-//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.Driverdb.url=jdbc:mysql://localhost:3306/zndb.username=rootdb.password=123456

log4j.properties

#global logging configurationlog4j.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;}@Overridepublic 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 {@Overridepublic 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 ;@Beforepublic void setUp() throws Exception { ctx = new ClassPathXmlApplicationContext("spring/ApplicationContext.xml");}@Testpublic void testFindUserById() throws Exception {UserDao userDao = (UserDao) ctx.getBean("userDao") ; //创建对象User user = userDao.findUserById(1);System.out.println(user);}}

需求2：

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

根据用户ID查询商品信息