分页

v-tawe · v-tawe · commit 3a693ff38cdf · 2020-10-28T10:19:19.000+08:00
diff --git a/4-Spring/SpringBoot/code/mybatis-plus/src/main/java/com/tawe/mybatisplus/config/MyBatisPlusConfig.java b/4-Spring/SpringBoot/code/mybatis-plus/src/main/java/com/tawe/mybatisplus/config/MyBatisPlusConfig.java
@@ -38,8 +38,15 @@ public class MyBatisPlusConfig {
     // 增加乐观锁
     @Bean
     public MybatisPlusInterceptor mybatisPlusInterceptor() {
+
         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
+
+        // 乐观锁插件
         interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
+
+        // 分页插件
+        interceptor.addInnerInterceptor(new PaginationInnerInterceptor());
+
         return interceptor;
     }
 }
diff --git a/4-Spring/SpringBoot/code/mybatis-plus/src/test/java/com/tawe/mybatisplus/MybatisPlusApplicationTests.java b/4-Spring/SpringBoot/code/mybatis-plus/src/test/java/com/tawe/mybatisplus/MybatisPlusApplicationTests.java
@@ -1,12 +1,15 @@
 package com.tawe.mybatisplus;
 
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.tawe.mybatisplus.entity.User;
 import com.tawe.mybatisplus.mapper.UserMapper;
 import org.junit.jupiter.api.Test;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.boot.test.context.SpringBootTest;
 import org.springframework.test.context.junit4.SpringRunner;
 
+import java.util.Arrays;
+import java.util.HashMap;
 import java.util.List;
 
 @SpringBootTest
@@ -64,4 +67,26 @@ public void testOptimisticLocker() {
         userMapper.updateById(user);
     }
 
+    @Test
+    public void testSelectFunctions() {
+        // 根据 ID 查询
+        User user1 = userMapper.selectById(1321036140195209217L);
+        // 根据多个 IDs 查询
+        List<User> users = userMapper.selectBatchIds(Arrays.asList(1L, 2L, 3L));
+
+        // 根据 多个 条件 进行查询
+        HashMap<String, Object> map = new HashMap<>();
+        map.put("id", 1L);
+        map.put("name", "David Tang2");
+
+        userMapper.selectByMap(map);
+
+    }
+
+    @Test
+    public void testSelectPage() {
+        Page<User> userPage = userMapper.selectPage(new Page<>(3,5), null);
+        System.out.println(userPage);
+    }
+
 }
