MybatisPlus学习笔记

零、环境准备

1.创建一个空的springboot项目

2.添加依赖

<!--mysql驱动-->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<scope>runtime</scope>
</dependency>
<!--Lombok-->
<dependency>
	<groupId>org.projectlombok</groupId>
	<artifactId>lombok</artifactId>
	<optional>true</optional>
</dependency>
<!-->导入了mybatis-plus依赖就不需要再导入mybatis依赖-->
<dependency>
     <groupId>com.baomidou</groupId>
     <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>3.4.0</version>
</dependency>

3.链接数据库

spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql:///mybatis_plus?serverTimezone=UTC&characterEncoding=utf-8

# 配置日志，输出sql的信息到控制台上
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

4.创建你的数据库表

5.编写你的pojo

一、普通查询

1.编写Mapper类，继承BaseMapper

@Mapper
public interface UserMapper extends BaseMapper<User> {
   
}

1）、根据id查询单个

@Test
public void testSelectById(){
   
	User user = mapper.selectById(1L);
}

2）、根据id批量查询

@Test
public void testSelectById() {
   
	List<User> users = mapper.selectBatchIds(Arrays.asList(1,2,3));
	users.forEach(System.out::println);
}

3)、按条件查询（map）

@Test
	public void testSelectByCondition() {
   
		HashMap<String,Object> map = new HashMap<String,Object>();
		//添加条件
		//对应的sql：SELECT id,name,email,age,verson,create_time,update_time FROM user WHERE name = ?
		map.put("name", "Jack");
		
		List<User> list = mapper.selectByMap(map);
		
		list.forEach(System.out::println);
	}

4)、无条件查询所有

@Test
void contextLoads() {
   
	//参数是Wrapper，这个到后面会有介绍
	List<User> users = mapper.selectList(null);
	users.forEach(System.out::println);
}

二、分页查询

1.配置拦截器，添加分页插件

@Configuration //配置类
@EnableTransactionManagement //开启事务管理
@MapperScan("cn.wyu.mapper") //扫描mapper包
public class MyBatisPlusConfig {
   
	@Bean
	public MybatisPlusInterceptor MybatisPlusInterceptor() {
   
		MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
		//分页插件
		mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL))