MyBatis简介
MyBatis是一款优秀的持久层框架,它对JDBC操作数据库的过程进行了封装,使得数据库操作更简洁、更方便。MyBatis消除了几乎所有的JDBC代码和手动设置参数以及获取结果集的工作,大大简化了数据层的开发工作。下面,我们将从入门到进阶,深入解析MyBatis的实战应用。
MyBatis入门
1. 环境搭建
要开始使用MyBatis,首先需要在项目中引入相应的依赖。以下是Maven项目中添加MyBatis依赖的示例代码:
<dependencies>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>
</dependency>
</dependencies>
2. 配置文件
在项目中创建一个名为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/mydb"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/example/mapper/UserMapper.xml"/>
</mappers>
</configuration>
3. 编写Mapper接口和XML映射文件
创建一个Mapper接口,定义需要执行的SQL语句。
package com.example.mapper;
public interface UserMapper {
int insert(User user);
User selectById(int id);
}
创建对应的XML映射文件,配置SQL语句。
<?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 users (name, age) VALUES (#{name}, #{age})
</insert>
<select id="selectById" resultType="User">
SELECT * FROM users WHERE id = #{id}
</select>
</mapper>
4. 使用MyBatis
在业务层调用Mapper接口的方法,完成数据库操作。
package com.example.service;
import com.example.mapper.UserMapper;
import com.example.model.User;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
public class UserService {
private final SqlSessionFactory sqlSessionFactory;
public UserService(SqlSessionFactory sqlSessionFactory) {
this.sqlSessionFactory = sqlSessionFactory;
}
public void addUser(User user) {
try (SqlSession session = sqlSessionFactory.openSession()) {
UserMapper userMapper = session.getMapper(UserMapper.class);
userMapper.insert(user);
session.commit();
}
}
public User getUserById(int id) {
try (SqlSession session = sqlSessionFactory.openSession()) {
UserMapper userMapper = session.getMapper(UserMapper.class);
return userMapper.selectById(id);
}
}
}
MyBatis进阶
1. 动态SQL
MyBatis提供了动态SQL功能,可以灵活地处理SQL语句的编写。例如,根据不同条件动态拼接SQL语句。
<select id="selectUsers" resultType="User">
SELECT * FROM users
<where>
<if test="name != null">
AND name = #{name}
</if>
<if test="age != null">
AND age = #{age}
</if>
</where>
</select>
2. 类型处理器
MyBatis允许自定义类型处理器,将Java类型和数据库类型之间进行转换。
public class DateTypeHandler extends BaseTypeHandler<Date> {
@Override
public void setNonNullParameter(PreparedStatement ps, int i, Date parameter, JdbcType jdbcType) throws SQLException {
ps.setDate(i, new java.sql.Date(parameter.getTime()));
}
@Override
public Date getNullableResult(ResultSet rs, String columnName) throws SQLException {
return rs.getDate(columnName);
}
@Override
public Date getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
return rs.getDate(columnIndex);
}
@Override
public Date getNullableResult(Statement statement, int columnIndex) throws SQLException {
ResultSet rs = statement.getResultSet();
return rs.getDate(columnIndex);
}
}
3. 批处理
MyBatis提供了批处理功能,可以一次性执行多条SQL语句。
public void addUsers(List<User> users) {
try (SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH)) {
UserMapper userMapper = session.getMapper(UserMapper.class);
for (User user : users) {
userMapper.insert(user);
}
session.commit();
}
}
MyBatis应用案例解析
1. 商品管理模块
在商品管理模块中,可以使用MyBatis实现商品的增删改查功能。例如,创建一个ProductMapper接口和对应的XML映射文件,配置SQL语句。
<mapper namespace="com.example.mapper.ProductMapper">
<insert id="insert" parameterType="Product">
INSERT INTO products (name, price) VALUES (#{name}, #{price})
</insert>
<select id="selectById" resultType="Product">
SELECT * FROM products WHERE id = #{id}
</select>
<update id="update" parameterType="Product">
UPDATE products SET name = #{name}, price = #{price} WHERE id = #{id}
</update>
<delete id="delete" parameterType="int">
DELETE FROM products WHERE id = #{id}
</delete>
</mapper>
在业务层调用ProductMapper接口的方法,完成商品的数据库操作。
public class ProductService {
private final SqlSessionFactory sqlSessionFactory;
public ProductService(SqlSessionFactory sqlSessionFactory) {
this.sqlSessionFactory = sqlSessionFactory;
}
public void addProduct(Product product) {
try (SqlSession session = sqlSessionFactory.openSession()) {
ProductMapper productMapper = session.getMapper(ProductMapper.class);
productMapper.insert(product);
session.commit();
}
}
public Product getProductById(int id) {
try (SqlSession session = sqlSessionFactory.openSession()) {
ProductMapper productMapper = session.getMapper(ProductMapper.class);
return productMapper.selectById(id);
}
}
public void updateProduct(Product product) {
try (SqlSession session = sqlSessionFactory.openSession()) {
ProductMapper productMapper = session.getMapper(ProductMapper.class);
productMapper.update(product);
session.commit();
}
}
public void deleteProduct(int id) {
try (SqlSession session = sqlSessionFactory.openSession()) {
ProductMapper productMapper = session.getMapper(ProductMapper.class);
productMapper.delete(id);
session.commit();
}
}
}
2. 用户权限管理模块
在用户权限管理模块中,可以使用MyBatis实现用户信息的增删改查、角色权限的分配等功能。例如,创建一个UserMapper接口和对应的XML映射文件,配置SQL语句。
<mapper namespace="com.example.mapper.UserMapper">
<insert id="insert" parameterType="User">
INSERT INTO users (username, password, email) VALUES (#{username}, #{password}, #{email})
</insert>
<select id="selectById" resultType="User">
SELECT * FROM users WHERE id = #{id}
</select>
<update id="update" parameterType="User">
UPDATE users SET username = #{username}, password = #{password}, email = #{email} WHERE id = #{id}
</update>
<delete id="delete" parameterType="int">
DELETE FROM users WHERE id = #{id}
</delete>
</mapper>
在业务层调用UserMapper接口的方法,完成用户的数据库操作。
public class UserService {
private final SqlSessionFactory sqlSessionFactory;
public UserService(SqlSessionFactory sqlSessionFactory) {
this.sqlSessionFactory = sqlSessionFactory;
}
public void addUser(User user) {
try (SqlSession session = sqlSessionFactory.openSession()) {
UserMapper userMapper = session.getMapper(UserMapper.class);
userMapper.insert(user);
session.commit();
}
}
public User getUserById(int id) {
try (SqlSession session = sqlSessionFactory.openSession()) {
UserMapper userMapper = session.getMapper(UserMapper.class);
return userMapper.selectById(id);
}
}
public void updateUser(User user) {
try (SqlSession session = sqlSessionFactory.openSession()) {
UserMapper userMapper = session.getMapper(UserMapper.class);
userMapper.update(user);
session.commit();
}
}
public void deleteUser(int id) {
try (SqlSession session = sqlSessionFactory.openSession()) {
UserMapper userMapper = session.getMapper(UserMapper.class);
userMapper.delete(id);
session.commit();
}
}
}
总结
MyBatis是一款优秀的持久层框架,可以帮助开发者简化数据库操作。本文从入门到进阶,详细解析了MyBatis的实战应用,包括环境搭建、配置文件、Mapper接口、XML映射文件、动态SQL、类型处理器、批处理等。同时,还介绍了MyBatis在实际项目中的应用案例,如商品管理模块和用户权限管理模块。希望本文能够帮助您更好地掌握MyBatis的使用技巧。
