部门管理（单表）

创建实体类Dept，统一结果响应类Result

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Dept {
    private Integer id;
    private String name;
    private LocalDateTime createTime;
    private LocalDateTime updateTime;
}

@Data
public class Result {

    private Integer code;
    private String msg;
    private Object data;

    public static Result success(){
        Result result = new Result();
        result.code = 1;
        result.msg = "success";
        return result;
    }

    public static Result success(Object object){
        Result result = new Result();
        result.data = object;
        result.code = 1;
        result.msg = "success";
        return result;
    }
    public static Result error(String msg){
        Result result = new Result();
        result.msg = "error";
        result.code = 0;
        result.msg = "error";
        return result;
    }

查询部门 开发规则：不需要分页，最后查询时间为倒序 接口：请求路径"/depts"请求方式get 响应数据json

Controller接受请求响应数据

@Slf4j
@RestController
public class DeptController {

    @Autowired
    DeptService deptService;

    @RequestMapping("/depts")
    public Result list(){
        log.info("查询所有部门数据");
        List<Dept> deptList = deptService.findAll();
        return Result.success(deptList);
    }


}

Service

@Service
public class DeptServiceImpl implements DeptService {

    @Autowired
    DeptMapper deptMapper;

    @Override
    public List<Dept> findAll() {
        return deptMapper.findAll();
    }
}

Mapper

@Mapper
public interface DeptMapper {

    @Select("select id,name,create_time,update_time from dept order by update_time desc ")
    List<Dept> findAll();
}

apifox

{
    "code": 1,
    "msg": "success",
    "data": [
        {
            "id": 9,
            "name": "廖家庄",
            "createTime": null,
            "updateTime": null
        }
    ]
}

mybatis实体类当中属性名与数据库查询返回的字段名是一致的，mybatis会自动封装

如果不一致则不能封装 1.result

Nginx的配置文件conf

删除部门 获取请求参数id

2.