前言
JPA（Java Persistence API）和MyBatis Plus是两种不同的持久化框架，它们具有不同的特点和适用场景。
JPA是Java官方的持久化规范，它提供了一种基于对象的编程模型，可以通过注解或XML配置来实现对象与数据库的映射关系。JPA的优点是可以对数据库进行更高级的操作，如查询、更新、删除等，同时也支持事务管理和缓存机制，能够更好地支持复杂的业务逻辑。
MyBatis Plus (MPP) 是在MyBatis基础上进行封装的增强版本，它提供了更简单易用的API和更高效的性能。MyBatis Plus通过XML或注解的方式来配置数据库映射关系，并提供了丰富的查询、更新、删除操作的方法。相对于JPA，MyBatis Plus配置简单、易于上手，同时也灵活性较高，能够更好地满足项目的特定需求。
如果只是针对单表的增删改查，两者十分相似，本质上都算ORM框架，那么到底什么时候适合用JPA，什么时候用MyBatisPlus，下面做下这两者的详细对比。
POM依赖
JPA
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
MPP
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
</dependency>
Entity定义
JPA
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.GeneratedValue;
@Entity
@Table(name = "dept")
public class Dept {
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
@Column(name = "code")
private String code;
@Column(name = "name")
private String name;
}
MPP
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
@TableName(value = "dept")
public class Dept {
@TableId(value = "id", type = IdType.AUTO)
private Long id;
@TableField(value = "code")
private String code;
@TableField(value = "name")
private String name;
}
DAO定义
基础CRUD
JPA
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
@Repository
public interface DeptRepository extends JpaRepository<Dept, Long> {
}
MPP
import org.apache.ibatis.annotations.Mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@Mapper
public interface DeptMapper extends BaseMapper<Dept> {
}
基类主要方法
| 方法 | JpaRepository | BaseMapper |
|---|---|---|
| 插入一条记录 | save(T entity) | insert(T entity) |
| 插入多条记录 | saveAll(Iterable entities) | insertBatchSomeColumn(List entityList) |
| 根据 ID 删除 | deleteById(ID id) | deleteById(Serializable id) |
| 根据实体(ID)删除 | delete(T entity) | deleteById(T entity) |
| 根据条件删除记录 | - | delete(Wrapper queryWrapper) |
| 删除（根据ID或实体 批量删除） | deleteAllById(Iterable<? extends ID> ids) | deleteBatchIds(Collection<?> idList) |
| 根据 ID 修改 | save(T entity) | updateById(T entity) |
| 根据条件更新记录 | - | update(Wrapper updateWrapper) |
| 根据 ID 查询 | findById(ID id) | selectById(Serializable id) |
| 查询（根据ID 批量查询） | findAllById(Iterable ids) | selectBatchIds(Collection<? extends Serializable> idList) |
| 根据条件查询一条记录 | - | selectOne(Wrapper queryWrapper) |
| 根据条件判断是否存在记录 | exists(Example example) | exists(Wrapper queryWrapper) |
| 根据条件查询总记录数 | count(Example example) | selectCount(Wrapper queryWrapper) |
| 根据条件查询全部记录 | findAll(Example example, Sort sort) | selectList(Wrapper queryWrapper) |
| 根据条件查询分页记录 | findAll(Example example, Pageable pageable) | selectPage(P page, Wrapper queryWrapper) |
自定义接口
JPA
JPA支持接口规范方法名查询，一般查询方法以 find、findBy、read、readBy、get、getBy为前缀，JPA在进行方法解析的时候会把前缀取掉，然后对剩下部分进行解析。例如：
@Repository
public interface DeptRepository extends JpaRepository<Dept, Long> {
// 调用此方法时，会自动生成 where code = ? 的条件
Dept getByCode(String code);
}
常用的方法命名有：
| 关键字 | 方法命名 | sql where字句 |
|---|---|---|
| Distinct | findDistinctByLastnameAndFirstname | select distinct … where x.lastname = ?1 and x.firstname = ?2 |
| And | findByNameAndPwd | where name= ? and pwd =? |
| Or | findByNameOrSex | where name= ? or sex=? |
| Is,Equals | findById, findByIdIs, findByIdEquals | where id= ? |
| Between | findByIdBetween | where id between ? and ? |
| LessThan | findByIdLessThan | where id < ? |
| LessThanEquals | findByIdLessThanEquals | where id <= ? |
| GreaterThan | findByIdGreaterThan | where id > ? |
| GreaterThanEquals | findByIdGreaterThanEquals | where id > = ? |
| After | findByIdAfter | where id > ? |
| Before | findByIdBefore | where id < ? |
| IsNull | findByNameIsNull | where name is null |
| isNotNull,NotNull | findByNameNotNull | where name is not null |
| Like | findByNameLike | where name like ? |
| NotLike | findByNameNotLike | where name not like ? |
| StartingWith | findByNameStartingWith | where name like ‘?%’ |
| EndingWith | findByNameEndingWith | where name like ‘%?’ |
| Containing | findByNameContaining | where name like ‘%?%’ |
| OrderBy | findByIdOrderByXDesc | where id=? order by x desc |
| Not | findByNameNot | where name <> ? |
| In | findByIdIn(Collection<?> c) | where id in (?) |
| NotIn | findByIdNotIn(Collection<?> c) | where id not in (?) |
| True | findByEnabledTue | where enabled = true |
| False | findByEnabledFalse | where enabled = false |
| IgnoreCase | findByNameIgnoreCase | where UPPER(name)=UPPER(?) |
| First,Top | findFirstByOrderByLastnameAsc | order by lastname limit 1 |
| FirstN,TopN | findTop3ByOrderByLastnameAsc | order by lastname limit 3 |
MPP
MyBatisPlus没有JPA那样可以根据接口的方法名自动组装查询条件，但是可以利用Java8的接口默认实现来达到同样的目的，只不过需要编写少量的代码：
import org.apache.ibatis.annotations.Mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@Mapper
public interface DeptMapper extends BaseMapper<Dept> {
default Dept getByCode(String code) {
return selectOne(Wrappers.<Dept>lambdaWrapper().eq(Dept::getCode, code));
}
}
自定义SQL
JPA支持通过@Query注解和XML的形式实现自定义SQL，而MyBatis支持通过@Select、@Delete、@Update、@Script注解和XML的形式实现自定义SQL。
JPA
JPA的自定义SQL分为JPQL(Java Persistence Query Language Java 持久化查询语言)和原生SQL两种。
JPQL:
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
@Repository
public interface DeptRepository extends JpaRepository<Dept, Long> {
@Query(value = "select d from Dept d where d.code = ?1")
Dept getByCode(String code);
@Modifying
@Query(value = "delete from Dept d where d.code = :code")
int deleteByCode(@Param("code") String code);
}
原生SQL
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
@Repository
public interface DeptRepository extends JpaRepository<Dept, Long> {
@Query(value = "SELECT * FROM dept WHERE name = ?1", countQuery = "SELECT count(*) FROM dept WHERE name = ?1", nativeQuery = true)
Page<Dept> findByName(@Param("name") String name, Pageable pageable);
}
XML形式：
/resource/META-INFO/orm.xml
<named-query name="Dept.getByCode">
<query> select d from Dept d where d.code = ?1</query>
</named-query>
<named-native-query name="Dept.deleteByCode">
<query> DELETE FROM dept WHERE code = ?1</query>
</named-native-query>
MyBatis
JPA的自定义SQL分为注解形式和XML形式
注解形式:
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
@Mapper
public interface DeptMapper extends BaseMapper<Dept> {
@Select(value = "SELECT * FROM dept WHERE code = #{code}")
Dept getByCode(@Param("code") String code);
@Delete("DELETE FROM dept WHERE code = #{code}")
int deleteByCode(@Param("code") String code);
@Select(value = "SELECT * FROM dept WHERE name = #{name}")
IPage<Dept> findByName(@Param("name") String name, IPage<Dept> page);
}
XML形式：
/resource/mapper/DeptMapper.xml
<select id = "getByCode", resultType = "Dept">
SELECT * FROM dept WHERE code = #{code}
</select>
<delete id = "deleteByCode">
DELETE FROM dept WHERE code = #{code}
</select>
<select id = "findByName">
SELECT * FROM dept WHERE name = #{name}
</select>
