MybatisPlus使用

 

引入包

        <!--mybatis-plus的springboot支持-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>

dao层写class时继承BaseMapper<User>，就可以使用baseMapper中定义的方法了，如下

import cn.itcast.mybatisplus.pojo.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

public interface UserMapper extends BaseMapper<User> {
}

baseMapper中定义的方法只能用于做 单表查询，

具体的使用方法，查看官网：https://mp.baomidou.com/guide/wrapper.html#abstractwrapper

测试：

package cn.itcast.mybatisplus.mapper;


import cn.itcast.mybatisplus.pojo.User;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

@RunWith(SpringRunner.class)
@SpringBootTest
public class UserMappperTest {


    // 这里报错，原因是在工程里面没有一个接口的实现类，但是这里的userMapper继承的BaseMapper，这里的错误忽略
    // 解决报错：光标放在错误上，alt+enter -> inspection... ->  desable..
    @Autowired
    private UserMapper userMapper;

    @Test
    public void testSelect() {
        List<User> users = this.userMapper.selectList(null);
        
        for (User user : users) {
            System.out.println(user);
        }
    }

    @Test
    public void testSelectById() {
        User user = this.userMapper.selectById(3L);
        System.out.println(user);
    }

    @Test
    public void testSelectByList() {
        QueryWrapper<User> wrapper = new QueryWrapper<User>();
        wrapper.like("name", "o");
        List<User> list = this.userMapper.selectList(wrapper);
        // 快捷键 iter 生成foreach
        for (User user : list) {
            // sout 生成system.out.println
            System.out.println(user);
        }
    }

    @Test
    public void testSelectByLe() {
        QueryWrapper<User> wrapper = new QueryWrapper<User>();
        wrapper.le("age", "20");
        List<User> list = this.userMapper.selectList(wrapper);
        // 快捷键 iter 生成foreach
        for (User user : list) {
            // sout 生成system.out.println
            System.out.println(user);
        }
    }

    @Test
    public void testSave() {
        User user = new User();
        user.setAge(25);
        user.setEmail("zhangsan@qq.com");
        user.setName("zhangsan");
        int count = this.userMapper.insert(user);
        System.out.println("新增数据成功! count => " + count);
    }

    @Test
    public void testDelete() {
        this.userMapper.deleteById(5L);
        System.out.println("删除成功");
    }

    @Test
    public void testUpdate() {
        User user = new User();
        user.setId(4L);
        user.setName("woodie");
        this.userMapper.updateById(user);
    }


    @Test
    public void testSelectPage() {
        Page<User> page = new Page<>(2, 2);
        IPage<User> userIPage = this.userMapper.selectPage(page, null);
        System.out.println("总条数 ------> " + userIPage.getTotal());
        System.out.println("当前页数 ------> " + userIPage.getCurrent());
        System.out.println("当前每页显示数 ------> " + userIPage.getSize());
        List<User> records = userIPage.getRecords();
        for (User user : records) {
            System.out.println(user);
        }

    }
}