一、前言
mybatis-plus相比mybatis做了增强,提供了基础的CRUD接口。关于mybatis-plus
的更多介绍,请看官网=》https://baomidou.com/,下面我们记录下如何将其快速整合到springboot项目中.
二、步骤
1.创建maven项目,并修改为springboot项目
<parent>
<artifactId>spring-boot-starter-parent</artifactId>
<groupId>org.springframework.boot</groupId>
<version>2.3.7.RELEASE</version>
</parent>
2.导入相关的依赖,mybatis-plus-boot-starter
,mysql-connector-java
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3</version>
</dependency>
3.配置
spring:
datasource:
username: root
password: ***
url: jdbc:mysql://127.0.0.1:3306/demo?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=false
driver-class-name: com.mysql.cj.jdbc.Driver
mybatis-plus:
configuration:
map-underscore-to-camel-case: true
auto-mapping-behavior: FULL
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
# 指定mapper文件的位置
mapper-locations:
classpath*:mapper/*.xml
三、验证
假设当前数据库有这样一个表user,其表结构如下:
实体类:
@Data
@AllArgsConstructor
public class User {
private int id;
private String name;
}
接口:
@Mapper
public interface UserMapper extends BaseMapper<User> {
List<User> selectAllByName(@Param("name") String name);
}
接口对应的mapper文件:
<?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.lys.mapper.UserMapper">
<select id="selectAllByName" resultType="com.lys.model.User">
select * from user where name = #{name}
</select>
</mapper>
测试
//启动上下文
@SpringBootTest(classes = MpApplication.class)
@Slf4j
@RunWith(SpringRunner.class)
public class UserTest {
@Autowired
private UserMapper userMapper;
@Test
public void test() {
// 调用MP自带的CRUD接口
// 通过id查询一条数据
User user = userMapper.selectById(1);
log.debug(String.valueOf(user));
// 查询全部数据
List<User> users = userMapper.selectList(null);
log.debug(String.valueOf(user));
}
@Test
public void test2(){
// 调用自定义的接口
List<User> users = userMapper.selectAllByName("lys");
log.debug(String.valueOf(users));
}
}
四、总结
整体上springboot整合mybatis-plus还是很简单的。创建项目=》导入依赖=》配置数据库=》mapper文件位置、日志输入等=》model=》mapper=》@Aurowired注入使用即可。