依赖org.mybatis.spring.bootmybatis-spring-boot-starter2.2.2配置#mybatis-plus控制台打印SQL语句mybatis-plus:mapper-locations:classpath:/mapper/*.xmlconfiguration:#控制台打印并执行SQL语句log-impl:org.apache.ibatis.logging.stdout.StdOutImpl#扫描多个图层mybatis-plus:mapper-locations:classpath*:/mapper/**/*Mapper.xml添加apiMappMapping.insert(mapping);删除QueryWrapperqueryWrapper=newQueryWrapper<>();queryWrapper.eq("MAPPING_ID",dto.getId());apiMappMapping.delete(queryWrapper);更新UpdateWrapperdtoWrapper=newUpdateWrapper<>();dtoWrapper.eq("ID",dto.getId());dataSetTransformDtoMapper.update(dto,dtoWrapper);Pagination//分页条件Pagepage=newPage<>(current,pageSize);//条件构造器QueryWrapperwrapper=newQueryWrapper<>();//非空像模糊查询wrapper.like(StringUtils.isNotBlank(name),"NAME",name);//排序根据API_IDorderbydescwrapper.orderByDesc("API_ID");IPagedataIPage=apiDataMapper.selectPage(page,wrapper);分页嵌套另一个表集合Pagepage=newPage<>(current,pageSize);QueryWrapperwrapper=newQueryWrapper<>();//wrapper.like(StringUtils.isNotBlank(name),"NAME",name);wrapper.orderByDesc("ID");IPagedtoIPage=dataSetTransformDtoMapper.selectPage(page,wrapper);//遍历集合dtoIPage.getRecords().stream().forEach(item->{ListmappingList=apiMappMapping.selectList(newQueryWrapper().eq("MAPPING_ID",item.getId()));item.setApiMappingList(mappingList);});
