Mybatis整合Spring(SM)
整合思路
- SqlSessionFactory对象应该放到spring容器中作为单例存在。
- 传统dao的开发方式中,应该从spring容器中获得sqlsession对象。
- Mapper代理形式中,应该从spring容器中获得sqlsession对象。
- 数据库的连接以及数据库连接池事务管理都交给spring容器来完成。
整合需要的jar包
- spring的jar包
- Mybatis的jar包
- Spring+mybatis的整合包
- Mysql的数据库驱动jar包
- 数据库连接池的jar包
核心配置文件
Dao层的开发
两种dao的实现方式
- 原始dao的开发方式
- 使用Mapper代理形式开发方式(推荐)
(a 直接配置Mapper代理
(b 使用扫描包配置Mapper代理
需求:
- 实现根据用户id查询
- 实现根据用户名模糊查询
- 添加用户
- 创建pojo(User.java)
public class User {
private Integer id;
private String username;
private String sex;
private Date birthday;
private String address;
public Integer getId() {
return id;
}
public void setId(Integer 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 "User [id=" + id + ", username=" + username + ", sex=" + sex + ", birthday=" + birthday + ", address="
+ address + "]";
}
- 传统dao开发方式(因不常用,在此不再详述,之前的笔记有Java网课基础笔记(25)):
原始的dao开发接口+实现类来完成
需要dao实现类继承SqlSessionDaoSupport类
- 使用Mapper代理形式开发方式
编写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.feng.mapper.UserMapper">
<!-- 根据用户id查询用户 1. id必须和Mapper接口方法名一致 2. parameterType必须和接口方法参数类型一致 3. resultType必须和接口方法返回值类型一致 -->
<select id="queryUserById" parameterType="int"
resultType="User">
select * from user where id = #{id}
</select>
<!-- 根据用户名模糊查询用户 -->
<select id="queryUserByUsername" parameterType="string"
resultType="User">
select * from user where username like '%${value}%'
</select>
<!-- 添加用户 -->
<insert id="saveUser" parameterType="User">
<selectKey keyProperty="id" keyColumn="id" order="AFTER"
resultType="int">
select last_insert_id()
</selectKey>
insert into user(username, birthday, sex, address) values
(#{username}, #{birthday}, #{sex}, #{address})
</insert>
</mapper>
- UserMapper代理接口
public interface UserMapper {
public User queryUserById(int id);
public List<User> queryUserByUsername(String username);
public void saveUser(User user);
}
- 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>
<!-- 指定扫描包,别名就是类名,不区分大小写 -->
<package name="com.feng.pojo" />
</typeAliases>
<!-- 加载mapper文件 -->
<mappers>
<package name="com.feng.mapper" />
</mappers>
</configuration>
- 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: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.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">
<!-- 引入外部属性配置文件 -->
<context:property-placeholder
location="classpath:db.properties" />
<!-- 配置内置的数据源bean,使用db.properties -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.driverClass}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- 配置SqlSessionFactory -->
<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 配置数据库连接池 -->
<property name="dataSource" ref="dataSource"></property>
<!-- 加载mybatis的核心配置文件 -->
<property name="configLocation"
value="classpath:sqlMapConfig.xml"></property>
</bean>
<!-- Mapper代理的方式开发 方式一:配置Mapper代理对象 -->
<bean id="UserMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<!-- 配置Mapper接口 -->
<property name="mapperInterface"
value="com.feng.mapper.UserMapper"></property>
<!-- 配置sqlSessionfactory -->
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
<!-- Mapper代理的方式开发 方式二:扫描包配置代理 -->
<!-- 每个mapper代理对象的id就是类名,首字母小写 -->
<!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
配置mapper接口
<property name="basePackage" value="com.feng.mapper"></property>
</bean> -->
</beans>
- db.properties
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///mybatis-spring
jdbc.username=root
jdbc.password=12345678
- 测试类
public class UserMapperTest {
private ApplicationContext applicationContext;
@Before
public void setUp() throws Exception {
// 初始化Spring容器
applicationContext = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
}
@Test
public void testGetUserById() {
UserMapper userMapper = applicationContext.getBean(UserMapper.class); // 通过类型去装配
// UserDao userDao = (UserDao) applicationContext.getBean("userDaoImpl");
User user = userMapper.queryUserById(24);
System.out.println(user);
}
@Test
public void testQueryUserByUsername() {
//获取userMapper
UserMapper userMapper=this.applicationContext.getBean(UserMapper.class);
// 执行查询方法
List<User> list = userMapper.queryUserByUsername("张");
for (User user : list) {
System.out.println(user);
}
}
@Test
public void testSaveUser() {
//获取userMapper
UserMapper userMapper=this.applicationContext.getBean(UserMapper.class);
User user = new User();
user.setUsername("肖战");
user.setBirthday(new Date());
user.setSex("1");
user.setAddress("重庆");
// 执行查询方法
userMapper.saveUser(user);
}
}
- 测试结果
testGetUserById
testQueryUserByUsername
testSaveUser