一、MyBatis简介
MyBatis是一个优秀的持久层框架,它对JDBC的数据库操作进行了封装,使得数据库操作变得更加简单。MyBatis将数据库操作封装为映射器(Mapper)和映射文件(XML),开发者只需编写SQL语句和相应的映射文件即可实现数据库的CRUD操作。
二、MyBatis入门
2.1 环境搭建
- 添加依赖
在项目的pom.xml文件中添加以下依赖:
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<dependency>
<groupId>org.mybatis.caches</groupId>
<artifactId>mybatis-redis</artifactId>
<version>1.0.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>
</dependency>
- 配置数据库连接
在application.properties或application.yml中配置数据库连接信息:
# 数据库连接信息
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
- 创建MyBatis配置文件
在项目的根目录下创建mybatis-config.xml文件,配置MyBatis的运行环境:
<?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>
<!-- 数据库连接信息 -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/test"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!-- 映射文件路径 -->
<mappers>
<mapper resource="com/example/mapper/UserMapper.xml"/>
</mappers>
</configuration>
- 编写Mapper接口和映射文件
创建Mapper接口:
public interface UserMapper {
int insert(User user);
int update(User user);
int delete(Integer id);
User selectById(Integer id);
}
创建对应的映射文件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.example.mapper.UserMapper">
<insert id="insert" parameterType="User">
INSERT INTO user (name, age) VALUES (#{name}, #{age})
</insert>
<update id="update" parameterType="User">
UPDATE user SET name = #{name}, age = #{age} WHERE id = #{id}
</update>
<delete id="delete" parameterType="int">
DELETE FROM user WHERE id = #{id}
</delete>
<select id="selectById" parameterType="int" resultType="User">
SELECT * FROM user WHERE id = #{id}
</select>
</mapper>
2.2 使用MyBatis
- 创建MyBatis的SqlSessionFactory
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
- 使用SqlSession执行数据库操作
try (SqlSession session = sqlSessionFactory.openSession()) {
UserMapper mapper = session.getMapper(UserMapper.class);
User user = new User();
user.setName("张三");
user.setAge(20);
mapper.insert(user);
session.commit();
}
三、MyBatis进阶
3.1 映射器开发
- Mapper接口方法与XML配置
MyBatis要求Mapper接口的方法名必须与XML配置中的SQL语句的id属性相匹配。
- 参数传递
MyBatis支持多种参数传递方式,如单个参数、多个参数、对象参数等。
- 返回结果类型
MyBatis支持多种返回结果类型,如基本类型、集合类型、对象类型等。
3.2 动态SQL
MyBatis提供了丰富的动态SQL功能,可以灵活地构建SQL语句。
- 条件判断
使用<if>标签进行条件判断,例如:
<select id="selectUser" resultType="User">
SELECT * FROM user
<where>
<if test="name != null and name != ''">
AND name = #{name}
</if>
<if test="age != null">
AND age = #{age}
</if>
</where>
</select>
- 循环遍历
使用<foreach>标签遍历集合,例如:
<update id="updateUserRoles" parameterType="map">
UPDATE user_role
<set>
<foreach collection="roles" item="role" separator=",">
role_id = #{role.id}
</foreach>
</set>
WHERE user_id = #{userId}
</update>
3.3 MyBatis与Spring集成
MyBatis可以与Spring框架集成,使用Spring管理MyBatis的SqlSessionFactory、SqlSession等对象。
- 配置Spring集成
在applicationContext.xml或application.properties中配置MyBatis与Spring的集成:
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.example.model
- 使用MyBatis的Bean
在Spring的配置文件中声明MyBatis的Mapper接口Bean:
<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.example.mapper.UserMapper"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
四、实战案例解析
以下是一个简单的MyBatis实战案例,演示了如何使用MyBatis进行用户管理。
4.1 用户实体类
public class User {
private Integer id;
private String name;
private Integer age;
// 省略getter和setter方法
}
4.2 Mapper接口
public interface UserMapper {
int insert(User user);
int update(User user);
int delete(Integer id);
User selectById(Integer id);
}
4.3 映射文件
<?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.example.mapper.UserMapper">
<insert id="insert" parameterType="User">
INSERT INTO user (name, age) VALUES (#{name}, #{age})
</insert>
<update id="update" parameterType="User">
UPDATE user SET name = #{name}, age = #{age} WHERE id = #{id}
</update>
<delete id="delete" parameterType="int">
DELETE FROM user WHERE id = #{id}
</delete>
<select id="selectById" parameterType="int" resultType="User">
SELECT * FROM user WHERE id = #{id}
</select>
</mapper>
4.4 Spring集成
@Configuration
public class MyBatisConfig {
@Bean
public SqlSessionFactory sqlSessionFactory() throws IOException {
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(
Resources.getResourceAsStream("mybatis-config.xml"));
return sqlSessionFactory;
}
@Bean
public SqlSession sqlSession(SqlSessionFactory sqlSessionFactory) throws IOException {
return sqlSessionFactory.openSession();
}
@Bean
@Scope("prototype")
public UserMapper userMapper(SqlSession sqlSession) {
return sqlSession.getMapper(UserMapper.class);
}
}
五、总结
本文从MyBatis入门到精通,介绍了MyBatis的基本概念、环境搭建、入门案例、进阶使用和实战案例解析。通过学习本文,相信读者可以掌握MyBatis的使用方法,并在实际项目中高效地构建持久层。
