区域管理查询

whyclxw

2024-11-26 c93546d364bb1f3c28f443546286b73f70f0c138

区域管理查询

 src/main/java/com/whyc/controller/AreaInfController.java

New file
@@ -0,0 +1,25 @@
package com.whyc.controller;

import com.whyc.dto.Response;
import com.whyc.service.AreaInfService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

@RestController
@Api(tags = "区域管理")
@RequestMapping("areaInf")
public class AreaInfController {
    @Autowired
    private AreaInfService service;

    @ApiOperation(value = "查询所有区域信息")
    @GetMapping("getAllAreaInf")
    public Response getAllAreaInf(){
        return service.getAllAreaInf();
    }
}

 src/main/java/com/whyc/mapper/AreaInfMapper.java

New file
@@ -0,0 +1,6 @@
package com.whyc.mapper;

import com.whyc.pojo.db_area.AreaInf;

public interface AreaInfMapper extends CustomMapper<AreaInf>{
}

 src/main/java/com/whyc/pojo/db_area/AreaInf.java

New file
@@ -0,0 +1,51 @@
package com.whyc.pojo.db_area;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.io.Serializable;

/**
 * <p>
 * 
 * </p>
 *
 * @author lxw
 * @since 2024-11-26
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@AllArgsConstructor
@NoArgsConstructor
@TableName(schema = "db_area",value ="tb_area_inf")
@ApiModel(value="AreaInf对象", description="")
public class AreaInf implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    @ApiModelProperty(value = "父id")
    private Integer parentId;

    @ApiModelProperty(value = "区域名称")
    private String areaName;

    @ApiModelProperty(value = "区域层级路径")
    private String areaPath;

    @ApiModelProperty(value = "区域层级")
    private Integer areaLevel;


}

 src/main/java/com/whyc/service/AreaInfService.java

New file
@@ -0,0 +1,26 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.whyc.dto.Response;
import com.whyc.mapper.AreaInfMapper;
import com.whyc.pojo.db_area.AreaInf;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class AreaInfService {
    @Autowired(required = false)
    private AreaInfMapper mapper;


    //查询所有区域信息
    public Response getAllAreaInf() {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.like("area_path","武汉源畅%");
        wrapper.orderByAsc("area_path");
        List<AreaInf> list=mapper.selectList(wrapper);
        return new Response().setII(1,list!=null,list,"查询所有区域信息");
    }
}