Springboot 快速集成 MyBatis-Plus

1. 引入依赖

        
            com.baomidou
            mybatis-plus-boot-starter
            3.4.2
        
        
            com.baomidou
            mybatis-plus-extension
            3.4.2
        

2. 测试实体类

@Data
public class FacePerson implements Serializable {

    private Long id;
    private String name;
    private byte[] feature;
    private Long imageId;
    private String imageUrl;
}

3. Service 接口和 ServiceImpl

public interface FacePersonService {

    List list();

    int add(FacePerson facePerson);

    IPage page(Page page, FacePersonQuery query);

    int delete(Long id);
}

@Service
public class FacePersonServiceImpl implements FacePersonService {

    @Autowired
    private FacePersonMapper facePersonMapper;

    @Override
    public List list() {
        return facePersonMapper.selectList(null);
    }

    @Override
    @Transactional
    public int add(FacePerson facePerson) {
        return facePersonMapper.insert(facePerson);
    }

    @Override
    public IPage page(Page page, FacePersonQuery query) {
        return facePersonMapper.page(page,query);
    }

    @Override
    public int delete(Long id) {
        return facePersonMapper.deleteById(id);
    }
}

4. Mapper接口和xml

public interface FacePersonMapper extends baseMapper {

    IPage page(Page page, @Param("param")FacePersonQuery query);
    
}

xml 放于默认位置 resource/mapper 下

    
        
        
        
        
        
    

    
        select
        t.id,
        t.name,
        t.image_url from face_person t
        
            
                and t.name like concat('%', #{param.name,jdbcType=VARCHAR}, '%')
            
        
    

5. 加入@MapperScan注解，指定mapper接口所在包

@SpringBootApplication
@MapperScan(basePackages = {"top.yinjinbiao.arcface.mapper"})
public class ArcfaceApplication {

    public static void main(String[] args) {
        SpringApplication.run(ArcfaceApplication.class, args);
    }
}

6. application.yml中加入配置

mybatis-plus:
  mapper-locations: classpath*:/mapper/*Mapper.xml
  typeAliasesPackage: top.yinjinbiao.arcface.domains.entity
  global-config:
    db-config:
      id-type: auto