創(chuàng)建實(shí)體類和數(shù)據(jù)庫建立映射關(guān)系

package com.xbb.mybatisplus.tutorial.entity;

public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "User [id=" + id + ", name=" + name + ", age=" + age + ", email=" + email + "]";
    }
    
}

建立Mapper接口用于訪問數(shù)據(jù)庫

package com.xbb.mybatisplus.tutorial.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xbb.mybatisplus.tutorial.entity.User;

public interface UserMapper extends BaseMapper<User> {

    
    
}

在src/test/java下創(chuàng)建com.xbb.mybatisplus.tutorial.MybatisPlusTest

image.png

package com.xbb.mybatisplus.tutorial;

import java.util.List;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.xbb.mybatisplus.tutorial.entity.User;
import com.xbb.mybatisplus.tutorial.mapper.UserMapper;

@SpringBootTest
class MybatisPlusTest {

    @Autowired
    private UserMapper userMapper;

    /**
     * 保存
     */
    @Test
    public void save() {
        User user = new User();
        user.setId(6l);
        user.setAge(18);
        user.setEmail("zhubajie@163.com");
        user.setName("zhubajie");
        userMapper.insert(user);
    }
    
    /**
     * 全表字段更新
     */
    @Test
    public void update() {
        User user = new User();
        user.setId(6l);
        user.setAge(19);
        user.setEmail("sunwukong@163.com");
        user.setName("sunwukong");
        userMapper.updateById(user);
    }
    
    /**
     * 只更新特定字段
     */
    @Test
    public void updateSelected() {
        User user = new User();
        user.setId(6l);
        user.setAge(25);
        userMapper.updateById(user);
    }

    /**
     * 刪除
     */
    @Test
    public void delete() {
        userMapper.deleteById(6l);
    }
    
    /**
     * 查詢
     */
    @Test
    public void selectList() {
        QueryWrapper<User> qw = new QueryWrapper<>();
        List<User> selectList = userMapper.selectList(qw);
        selectList.forEach(user->{
            System.out.println(user);
        });
    }
    
    /**
     * 等值條件查詢
     */
    @Test
    public void listByEq() {
        QueryWrapper<User> qw = new QueryWrapper<>();
        qw.eq("name", "Jone");
        List<User> selectList = userMapper.selectList(qw);
        selectList.forEach(user->{
            System.out.println(user);
        });
    }
    
    /**
     * 通過id查找某一條記錄
     */
    @Test
    public void listById() {
        User user = userMapper.selectById(3l);
        System.out.println(user);
    }
    
    /**
     * 分頁查詢
     */
    @Test
    public void page() {
        QueryWrapper<User> qw = new QueryWrapper<>();
        Page<User> page = new Page<>();
        page.setSize(2l);
        page.setCurrent(1l);
        Page<User>  pageResult = userMapper.selectPage(page, qw);
        System.out.println("總頁數(shù):" + pageResult.getPages());
        System.out.println("每頁顯示的最大記錄數(shù):"+pageResult.getSize());
        System.out.println("當(dāng)前頁碼:" + pageResult.getCurrent());
        System.out.println("符合條件的總記錄數(shù):" + pageResult.getTotal());
        pageResult.getRecords().forEach(user -> {
            System.out.println(user);
        });
    }
    
}