一、整合思路
- SqlSessionFactory对象应该放到Spring容器中作为单例存在。
- 传统dao的开发方式中,应该从spring容器中获得sqlsession对象。
- Mapper代理形式中,应该从spring容器中直接获得mapper的代理对象。
- 数据库的链接以及数据库连接池事务管理都交给spring容器来完成。
二、整合需要的jar包
- spring需要的jar包
- Mybatis的jar包
- Spring-Mybatis的整合包
- MySql的数据库驱动jar包
- 数据库连接池的jar包
三、整合示例
1.创建工程
2.导入jar包
3.加入配置文件
- Mybatis-Spring的配置文件applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
<!-- 加载配置文件 -->
<context:property-placeholder location="classpath:db.properties" />
<!-- 数据库连接池 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<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.class">
<!-- 配置数据源 -->
<property name="dataSource" ref="dataSource"></property>
<!-- 加载mybatis核心配置文件 -->
<property name="configLocation" value="classpath:SqlMapConfig.xml"></property>
<!-- 别名包扫描 -->
<property name="typeAliasesPackage" value="com.rosinante.mybatis.pojo"></property>
</bean>
</beans>
- mybatis的配置文件SqlMapperConfig.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>
</configuration>
- db.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
- log4j.properties
# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
四、Dao的开发
两种dao的实现方式:
1,原始dao的开发方式
2.使用Mapper代理形式开发方式
(1)直接配置Mapper代理
(2)使用扫描包配置Mapper代理
需求:
1.实现根据用户id查询
2.实现根据用户名模糊查询
3.添加用户
1.创建pojo类
public class User {
private int id;
private String username;// 用户姓名
private String sex;// 性别
private Date birthday;// 生日
private String address;// 地址
get/set
}
2.传统dao的开发方式
原始的dao开发接口+实现类来完成
需要dao实现类继承SqlSessionDaoSupport类
- 实现Mapper.xml
编写User..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">
<!-- namespacey 命名空间 用于隔离sql语句 -->
<!-- #{}:占位符,相当于jdbc的? -->
<!-- ${}:字符串拼接指令,如果入参为普通数据类型,{}内只能写value -->
<mapper namespace="user">
<!--
id:sql id 语句的唯一标识
parameterType:入参的数据类型
resultType:返回结果的数据类型
-->
<select id="getUserById" parameterType="int" resultType="com.rosinante.mybatis.pojo.User">
SELECT
`id`,
`username`,
`birthday`,
`sex`,
`address`
FROM
`user`
WHERE id = #{id1}
</select>
<!-- resultType:如果返回结果为集合,只需设置为每一个的数据类型 -->
<select id="getUserByUserName" parameterType="string" resultType="com.rosinante.mybatis.pojo.User">
SELECT
`id`,
`username`,
`birthday`,
`sex`,
`address`
FROM
`user`
WHERE username LIKE '%${value}%'
</select>
<!-- userGeneratedKeys:使用自增 KeyPeoperty与之配套使用,这里是user的主键 -->
<insert id="insertUser" parameterType="com.rosinante.mybatis.pojo.User" useGeneratedKeys="true" keyProperty="id">
<!-- selectKey:主键返回
keyProperty:user中的主键属性
resultType:主键数据类型
order:指定selectKey何时执行
-->
<!-- <selectKey keyProperty="id" resultType="int" order="AFTER">
SELECT LAST_INSERT_ID()
</selectKey> -->
INSERT INTO `user` (
`username`,
`birthday`,
`sex`,
`address`
)
VALUES(
#{username},
#{birthday},
#{sex},
#{address}
) ;
</insert>
<update id="updateUser" parameterType="com.rosinante.mybatis.pojo.User">
UPDATE
`user`
SET
`username` = #{username},
WHERE `id` = #{id} ;
</update>
<delete id="deleteUser" parameterType="int">
DELETE
FROM
`user`
WHERE `id` = #{id};
</delete>
</mapper>
- 加载Mapper.xml:
在SqlMapperConfig.xml文件中进行如下配置:
<mappers>
<mapper resource="mybatis/user.xml"/>
</mappers>
- 实现UserDao接口:
package com.rosinante.mybatis.dao;
import java.util.List;
import com.rosinante.mybatis.pojo.User;
/**
* 用户信息持久化窗口
* @author Administrator
*
*/
public interface UserDao {
/**
* 根据ID查询用户信息
* @param id
* @return
*/
User getUserById(Integer id);
/**
* 根据用户名查找用户列表
* @param userName
* @return
*/
List<User> getUserByUserName(String userName);
/**
* 添加用户
* @param user
*/
void insertUser(User user);
}
- 实现UserDaoImpl实现类:
package com.rosinante.mybatis.dao.impl;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import com.rosinante.mybatis.dao.UserDao;
import com.rosinante.mybatis.pojo.User;
public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {
@Override
public User getUserById(Integer id) {
SqlSession sqlSession = super.getSqlSession();
User user = sqlSession.selectOne("user.getUserById", id);
//不能关闭SqlSession
return user;
}
@Override
public List<User> getUserByUserName(String userName) {
SqlSession sqlSession = super.getSqlSession();
List<User>list = sqlSession.selectList("user.getUserByUserName",userName);
return list;
}
@Override
public void insertUser(User user) {
SqlSession sqlSession = super.getSqlSession();
sqlSession.insert("user.insertUser",user);
}
}
- 配置dao:
把dao实现类配置到spring容器中:
<!-- 原始方式开发dao,配置dao到Spring中 -->
<bean id="userdao" class="com.rosinante.mybatis.dao.impl.UserDaoImpl">
<!-- 配置SqlSessionFactory -->
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
- 测试方法:
以testGetUserById为例:
package com.rosinante.mybatis.test;
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 com.rosinante.mybatis.dao.UserDao;
import com.rosinante.mybatis.pojo.User;
public class UserDaoTest {
private ApplicationContext context;
@Before
public void setUp() throws Exception {
this.context = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
}
@Test
public void testGetUserById() {
//获取UserDao
UserDao userDao =this.context.getBean(UserDao.class);
User user = userDao.getUserById(1);
System.out.println(user);
}
@Test
public void testGetUserByUserName() {
fail("Not yet implemented");
}
@Test
public void testInsertUser() {
fail("Not yet implemented");
}
}
- 执行测试方法testGetUserById:
3.Mapper代理形式开发dao
- 实现mapper.xml
编写UserMapper.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="com.rosinante.mybatis.mapper.UserMapper">
<select id="getUserById" parameterType="int" resultType="com.rosinante.mybatis.pojo.User">
SELECT
`id`,
`username`,
`birthday`,
`sex`,
`address`
FROM
`user`
WHERE id = #{id1}
</select>
<select id="getUserByUserName" parameterType="string" resultType="com.rosinante.mybatis.pojo.User">
SELECT
`id`,
`username`,
`birthday`,
`sex`,
`address`
FROM
`user`
WHERE username LIKE '%${value}%'
</select>
<!-- userGeneratedKeys:使用自增 KeyPeoperty与之配套使用,这里是user的主键 -->
<insert id="insertUser" parameterType="com.rosinante.mybatis.pojo.User" useGeneratedKeys="true" keyProperty="id">
INSERT INTO `user` (
`username`,
`birthday`,
`sex`,
`address`
)
VALUES(
#{username},
#{birthday},
#{sex},
#{address}
) ;
</insert>
<update id="updateUser" parameterType="com.rosinante.mybatis.pojo.User">
UPDATE
`user`
SET
`username` = #{username},
WHERE `id` = #{id} ;
</update>
<delete id="deleteUser" parameterType="int">
DELETE
FROM
`user`
WHERE `id` = #{id};
</delete>
</mapper>
- 实现UserMapper接口:
package com.rosinante.mybatis.mapper;
import java.util.List;
import com.rosinante.mybatis.pojo.User;
public interface UserMapper {
/**
* 根据ID查询用户信息
* @param id
* @return
*/
User getUserById(Integer id);
/**
* 根据用户名查找用户列表
* @param userName
* @return
*/
List<User> getUserByUserName(String userName);
/**
* 添加用户
* @param user
*/
void insertUser(User user);
}
方式一:配置mapper代理
- 在applicationContext,xml添加配置:
<!-- Mapper代理的方式,配置Mapper代理对象 -->
<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<!-- 配置SqlSessionFactory -->
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
<!-- 配置一个接口 -->
<bean parent="userMapper">
<!-- 配置Mapper接口 -->
<property name="mapperInterface" value="com.rosinante.mybatis.mapper.UserMapper"></property>
</bean>
- 测试方法:
package com.rosinante.mybatis.test;
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 com.rosinante.mybatis.mapper.UserMapper;
import com.rosinante.mybatis.pojo.User;
public class UserMapperTest {
private ApplicationContext context;
@Before
public void setUp() throws Exception {
this.context = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
}
@Test
public void testGetUserById() {
//获取Mapper
UserMapper userMapper = this.context.getBean(UserMapper.class);
User user = userMapper.getUserById(1);
System.out.println(user);
}
@Test
public void testGetUserByUserName() {
fail("Not yet implemented");
}
@Test
public void testInsertUser() {
fail("Not yet implemented");
}
}
- 执行testGetUserById():
方式二:扫描包形式配置mapper
每个mapper代理对象的id就是类名,首字母小写
<!-- 动态代理第二种方式 包扫描 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.rosinante.mybatis.mapper"></property>
</bean>
- 运行结果: