MyBatisPlus实例

• mp配置

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.1.0</version>
</dependency>

spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/plus?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

• mp-CRUD

@SpringBootTest
class MybatisPlusApplicationTests {

    @Autowired
    private UserMapper mapper;

    @Test
    void contextLoads() {
        List<User> users = mapper.selectList(null);
        for (User user : users) {
            System.out.println(user);
        }
    }
    @Test
    void insert(){
        User user = new User();
        user.setUsername("yoho");
        user.setSex("男");
        user.setAddress("西安");
        mapper.insert(user);
    }
    @Test
    void Update(){
        User user = new User();
        user.setId(54L);
        user.setUsername("xixi");
        user.setSex("神");
        mapper.updateById(user);
    }
    @Test
    void select(){
        User user = mapper.selectById(50L);
        System.out.println(user);
    }
    @Test
    void selectByBatchId(){
        List<User> users = mapper.selectBatchIds(Arrays.asList(48L, 49L, 50L));
        System.out.println(users);
    }
    @Test
    void selectByBatchMap(){
        HashMap<String, Object> map = new HashMap<>();
        //可以实现动态sql,模糊查询
        map.put("username","谈雨儿");
//        map.put("username","yoho");
//        map.put("address","西安");
        mapper.selectByMap(map);
    }
    @Test
        //分页查询
    void testPageSelected(){