二、前后端分离通用权限系统（2）gansu-auth-parent(2).zip

package com.gansu.system; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.gansu.model.system.SysRole; import com.gansu.system.mapper.SysRoleMapper; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import java.util.ArrayList; import java.util.Arrays; import java.util.List; @SpringBootTest public class SysRoleMapperTest { @Autowired private SysRoleMapper sysRoleMapper; @Test //org.junit.jupiter.api.Test; 导入 junit5 public void test1(){ //UserMapper 中的 selectList() 方法的参数为 MP 内置的条件封装器 Wrapper //所以不填写就是无任何条件 List sysRoles = sysRoleMapper.selectList(null); for (SysRole sysRole : sysRoles) { System.out.println(sysRole); } } @Test //增加 public void test2(){ SysRole sysRole1 = new SysRole(); sysRole1.setRoleName("角色管理"); sysRole1.setRoleCode("roleManager"); sysRole1.setDescription("角色描述"); int insert = sysRoleMapper.insert(sysRole1); System.out.println(insert); //影响的行数 System.out.println(sysRole1.getId());//id自动会增 } @Test //更新 public void test3(){ SysRole sysRole1 = new SysRole(); sysRole1.setId(1824717962347577345L); sysRole1.setRoleName("橘色管理88"); sysRole1.setRoleCode("8888888"); sysRole1.setDescription("橘色描述"); int i = sysRoleMapper.updateById(sysRole1); System.out.println(i); //影响的行数 System.out.println(sysRole1.getId());//id不变 } @Test //根据id删除 public void test4(){ //逻辑删除 // sysRoleMapper.deleteById(1824717962347577345L); //批量删除 sysRoleMapper.deleteBatchIds(Arrays.asList(1824717962347577346L,1824717962347577347L)); } @Test //模糊查询 public void test5(){ //1.创建构造器 QueryWrapper wrapper = new QueryWrapper<>(); //wrapper.eq("role_name","普通管理员"); wrapper.like("role_name","管理员"); List sysRoles = sysRoleMapper.selectList(wrapper); System.out.println(sysRoles); } @Test //删除 public void test6(){ //1.创建构造器 QueryWrapper wrapper = new QueryWrapper<>(); wrapper.eq("role_name","用户管理员"); sysRoleMapper.delete(wrapper); } }