1.查询所有一级分类

1.sun-club-application-controller 控制层

1.SubjectCategoryController.java 定义基础的queryPrimaryCategory，调用领域层

    @PostMapping("/queryPrimaryCategory")
    public Result<List<SubjectCategoryDTO>> queryPrimaryCategory() {
        List<SubjectCategoryBO> subjectCategoryBOList = subjectCategoryDomainService.queryPrimaryCategory();
    }

2.sun-club-domain 领域层

1.SubjectCategoryDomainService.java

    /**
     * 查询一级分类
     * @return
     */
    List<SubjectCategoryBO> queryPrimaryCategory();

2.SubjectCategoryConverter.java

    // 将List<SubjectCategory>转换为List<SubjectCategoryBO>
    List<SubjectCategoryBO> convertSubjectCategoryToBo(List<SubjectCategory> subjectCategoryList);

3.SubjectCategoryDomainServiceImpl.java

    @Override
    public List<SubjectCategoryBO> queryPrimaryCategory() {
        // 查询一级分类
        List<SubjectCategory> subjectCategoryList = subjectCategoryService.queryPrimaryCategory();
        // 将List<SubjectCategory>转换为List<SubjectCategoryBO>
        List<SubjectCategoryBO> subjectCategoryBOList = SubjectCategoryConverter.INSTANCE.convertSubjectCategoryToBo(subjectCategoryList);
        // 打印日志
        if (log.isInfoEnabled()) {
            log.info("SubjectCategoryDomainServiceImpl queryPrimaryCategory, subjectCategoryBOList:{}", JSON.toJSONString(subjectCategoryBOList));
        }
        return subjectCategoryBOList;
    }

3.sun-club-infra 基础设施层

1.service

1.SubjectCategoryService.java

    /**
     * 查询一级分类
     * @return
     */
    List<SubjectCategory> queryPrimaryCategory();

2.SubjectCategoryServiceImpl.java

    /**
     * 查询一级分类
     * @return
     */
    @Override
    public List<SubjectCategory> queryPrimaryCategory() {
        return this.subjectCategoryDao.queryPrimaryCategory();
    }

2.mapper

1.SubjectCategoryDao.java

    /**
     * 查询一级分类
     * @return
     */
    List<SubjectCategory> queryPrimaryCategory();

2.SubjectCategoryDao.xml

    <!--查询所有一级分类-->
    <select id="queryPrimaryCategory" resultMap="SubjectCategoryMap">
        select
        id, category_name, category_type, image_url, parent_id, created_by, created_time, update_by, update_time
        from subject_category
        where parent_id = 0
        and is_deleted = 0
    </select>

4.回到sun-club-application-controller

1.SubjectCategoryDTOConverter.java

    // 将List<SubjectCategoryBO>转换为List<SubjectCategoryDTO>
    List<SubjectCategoryDTO> convertSubjectCategoryToDto(List<SubjectCategoryBO> subjectCategoryBOList);

2.SubjectCategoryController.java

    @PostMapping("/queryPrimaryCategory")
    public Result<List<SubjectCategoryDTO>> queryPrimaryCategory() {
        List<SubjectCategoryBO> subjectCategoryBOList = subjectCategoryDomainService.queryPrimaryCategory();
        // 转换BO为DTO
        List<SubjectCategoryDTO> subjectCategoryDTOList = SubjectCategoryDTOConverter.INSTANCE.convertSubjectCategoryToDto(subjectCategoryBOList);
        return Result.ok(subjectCategoryDTOList);
    }

3.测试

4.问题分析

• 这样写的查询语句就太死了，所以需要使用动态SQL来优化

5.使用动态SQL优化查询

1.sun-club-infra

1.SubjectCategoryDao.xml

    <!--查询所有一级分类-->
    <select id="queryPrimaryCategory" resultMap="SubjectCategoryMap">
        select
        id, category_name, category_type, image_url, parent_id, created_by, created_time, update_by, update_time
        from subject_category
        <where>
            <if test="id != null">
                and id = #{id}
            </if>
            <if test="categoryName != null and categoryName != ''">
                and category_name = #{categoryName}
            </if>
            <if test="categoryType != null">
                and category_type = #{categoryType}
            </if>
            <if test="imageUrl != null and imageUrl != ''">
                and image_url = #{imageUrl}
            </if>
            <if test="parentId != null">
                and parent_id = #{parentId}
            </if>
            <if test="createdBy != null and createdBy != ''">
                and created_by = #{createdBy}
            </if>
            <if test="createdTime != null">
                and created_time = #{createdTime}
            </if>
            <if test="updateBy != null and updateBy != ''">
                and update_by = #{updateBy}
            </if>
            <if test="updateTime != null">
                and update_time = #{updateTime}
            </if>
            <if test="isDeleted != null">
                and is_deleted = #{isDeleted}
            </if>
        </where>
    </select>

2.SubjectCategoryDao.java

    /**
     * 查询一级分类
     * @return
     */
    List<SubjectCategory> queryPrimaryCategory(@Param("subjectCategory") SubjectCategory subjectCategory);

3.SubjectCategoryService.java

    /**
     * 查询一级分类
     * @return
     */
    List<SubjectCategory> queryPrimaryCategory(SubjectCategory subjectCategory);

4.SubjectCategoryServiceImpl.java

    /**
     * 查询一级分类
     * @return
     */
    @Override
    public List<SubjectCategory> queryPrimaryCategory(SubjectCategory subjectCategory) {
        return this.subjectCategoryDao.queryPrimaryCategory(subjectCategory);
    }

2.sun-club-domain

1.SubjectCategoryDomainServiceImpl.java

2.测试

2.根据分类id查二级分类

1.sun-club-application-controller

1.SubjectCategoryController.java

    /**
     * 根据id查询二级分类
     * @param subjectCategoryDTO
     * @return
     */
    @PostMapping("/queryCategoryByPrimary")
    public Result<List<SubjectCategoryDTO>> queryCategoryByPrimary(@RequestBody SubjectCategoryDTO subjectCategoryDTO) {
        try {
            // 打日志
            if (log.isInfoEnabled()) {
                log.info("SubjectCategoryController queryCategoryByPrimary SubjectCategoryDTO, subjectCategoryDTO:{}", JSON.toJSONString(subjectCategoryDTO));
            }
            // 参数校验
            Preconditions.checkNotNull(subjectCategoryDTO.getParentId(), "分类id不能为空");
            // 转换DTO为BO
            SubjectCategoryBO subjectCategoryBO = SubjectCategoryDTOConverter.INSTANCE.convertDTOToSubjectCategory(subjectCategoryDTO);
            // 查询二级分类
            List<SubjectCategoryBO> subjectCategoryBOList = subjectCategoryDomainService.queryCategory(subjectCategoryBO);
            // 转换BO为DTO
            List<SubjectCategoryDTO> subjectCategoryDTOList = SubjectCategoryDTOConverter.INSTANCE.convertSubjectCategoryToDto(subjectCategoryBOList);
            return Result.ok(subjectCategoryDTOList);
        } catch (Exception e) {
            // 记录日志
            log.error("SubjectCategoryController queryPrimaryCategory error:{}", e.getMessage(), e);
            return Result.fail("查询一级分类失败");
        }
    }

2.修改所有queryPrimaryCategory为queryCategory

3.修改动态sql，使其可以只查询出未逻辑删除的记录

3.分类模块接口开发

1.接口设计

2.sun-club-application-controller

1.SubjectCategoryController.java

    /**
     * 更新分类
     * @param subjectCategoryDTO
     * @return
     */
    @PostMapping("/update")
    public Result<Boolean> update(@RequestBody SubjectCategoryDTO subjectCategoryDTO) {
        try {
            if (log.isInfoEnabled()) {
                log.info("SubjectCategoryController update SubjectCategoryDTO, subjectCategoryDTO:{}", JSON.toJSONString(subjectCategoryDTO));
            }
            // 参数校验
            Preconditions.checkNotNull(subjectCategoryDTO.getId(), "分类id不能为空");
            // 转换DTO为BO
            SubjectCategoryBO subjectCategoryBO = SubjectCategoryDTOConverter.INSTANCE.convertDTOToSubjectCategory(subjectCategoryDTO);
            Boolean result =  subjectCategoryDomainService.update(subjectCategoryBO);
            return Result.ok(result);
        } catch (Exception e) {
            log.error("SubjectCategoryController update error:{}", e.getMessage(), e);
            return Result.fail("更新分类失败");
        }
    }

3.sun-club-domain

1.SubjectCategoryDomainService.java

    /**
     * 更新分类
     * @param subjectCategoryBO
     * @return
     */
    Boolean update(SubjectCategoryBO subjectCategoryBO);

2.SubjectCategoryDomainServiceImpl.java

    @Override
    public Boolean update(SubjectCategoryBO subjectCategoryBO) {
        if (log.isInfoEnabled()) {
            log.info("SubjectCategoryDomainServiceImpl update SubjectCategoryBO, SubjectCategoryBO:{}", JSON.toJSONString(subjectCategoryBO));
        }
        SubjectCategory subjectCategory = SubjectCategoryConverter.INSTANCE.convertBoToSubjectCategory(subjectCategoryBO);
        int update = subjectCategoryService.update(subjectCategory);
        return update > 0;
    }

4.sun-club-infra

1.SubjectCategoryService.java

    /**
     * 修改数据
     *
     * @param subjectCategory 实例对象
     * @return 实例对象
     */
    int update(SubjectCategory subjectCategory);

2.SubjectCategoryServiceImpl.java

    /**
     * 修改数据
     *
     * @param subjectCategory 实例对象
     * @return 实例对象
     */
    @Override
    public int update(SubjectCategory subjectCategory) {
        return this.subjectCategoryDao.update(subjectCategory);
    }

3.SubjectCategoryDao.java

    /**
     * 修改数据
     *
     * @param subjectCategory 实例对象
     * @return 影响行数
     */
    int update(SubjectCategory subjectCategory);

4.SubjectCategoryDao.xml

    <!--通过主键修改数据-->
    <update id="update">
        update subject_category
        <set>
            <if test="categoryName != null and categoryName != ''">
                category_name = #{categoryName},
            </if>
            <if test="categoryType != null">
                category_type = #{categoryType},
            </if>
            <if test="imageUrl != null and imageUrl != ''">
                image_url = #{imageUrl},
            </if>
            <if test="parentId != null">
                parent_id = #{parentId},
            </if>
            <if test="createdBy != null and createdBy != ''">
                created_by = #{createdBy},
            </if>
            <if test="createdTime != null">
                created_time = #{createdTime},
            </if>
            <if test="updateBy != null and updateBy != ''">
                update_by = #{updateBy},
            </if>
            <if test="updateTime != null">
                update_time = #{updateTime},
            </if>
            <if test="isDeleted != null">
                is_deleted = #{isDeleted},
            </if>
        </set>
        where id = #{id}
    </update>

5.启动测试

4.删除分类接口开发

1.基本设计

2.sun-club-application-controller

1.SubjectCategoryController.java

    /**
     * 删除分类
     * @param subjectCategoryDTO
     * @return
     */
    @PostMapping("/delete")
    public Result<Boolean> delete(@RequestBody SubjectCategoryDTO subjectCategoryDTO) {
        try {
            if (log.isInfoEnabled()) {
                log.info("SubjectCategoryController delete SubjectCategoryDTO, subjectCategoryDTO:{}", JSON.toJSONString(subjectCategoryDTO));
            }
            // 参数校验
            Preconditions.checkNotNull(subjectCategoryDTO.getId(), "分类id不能为空");
            // 转换DTO为BO
            SubjectCategoryBO subjectCategoryBO = SubjectCategoryDTOConverter.INSTANCE.convertDTOToSubjectCategory(subjectCategoryDTO);
            Boolean result =  subjectCategoryDomainService.delete(subjectCategoryBO);
            return Result.ok(result);
        } catch (Exception e) {
            log.error("SubjectCategoryController delete error:{}", e.getMessage(), e);
            return Result.fail("删除分类失败");
        }
    }

3.sun-club-common

1.IsDeleteFlagEnum.java

package com.sunxiansheng.subject.common.enums;

import lombok.Getter;

/**
 * Description: 删除标识枚举
 * @Author sun
 * @Create 2024/5/24 9:53
 * @Version 1.0
 */
@Getter
public enum IsDeleteFlagEnum {
    DELETED(1, "已删除"),
    UN_DELETED(0, "未删除");

    public int code;
    public String desc;

    IsDeleteFlagEnum(int code, String desc) {
        this.code = code;
        this.desc = desc;
    }

    /**
     * 根据code获取枚举
     * @param code
     * @return
     */
    public static IsDeleteFlagEnum getByCode(int code) {
        for (IsDeleteFlagEnum value : values()) {
            if (value.code == code) {
                return value;
            }
        }
        return null;
    }
}

4.sun-club-domain

1.SubjectCategoryDomainService.java

    /**
     * 删除分类
     * @param subjectCategoryBO
     * @return
     */
    Boolean delete(SubjectCategoryBO subjectCategoryBO);

2.SubjectCategoryDomainServiceImpl.java

    @Override
    public Boolean delete(SubjectCategoryBO subjectCategoryBO) {
        if (log.isInfoEnabled()) {
            log.info("SubjectCategoryDomainServiceImpl delete SubjectCategoryBO, SubjectCategoryBO:{}", JSON.toJSONString(subjectCategoryBO));
        }
        SubjectCategory subjectCategory = SubjectCategoryConverter.INSTANCE.convertBoToSubjectCategory(subjectCategoryBO);
        // 逻辑删除
        subjectCategory.setIsDeleted(1);
        int update = subjectCategoryService.update(subjectCategory);
        return update > 0;
    }

3.测试

5.分类接口总览

1.使用commons-lang3进行开发

1.sun-club-common引入依赖

        <!-- commons-lang3 -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-lang3</artifactId>
            <version>3.11</version>
        </dependency>

2.SubjectCategoryController.java使用isBlank进行校验

2.SubjectCategoryDomainServiceImpl.java 插入时设置逻辑删除

3.查询一级分类

1.SubjectCategoryDao.xml，添加逻辑删除字段

2.sun-club-common添加分类的枚举CategoryTypeEnum.java

package com.sunxiansheng.subject.common.enums;

import lombok.Getter;

/**
 * Description: 删除标识枚举
 * @Author sun
 * @Create 2024/5/24 9:53
 * @Version 1.0
 */
@Getter
public enum CategoryTypeEnum {
    PRIMARY(1, "岗位大类"),
    SECOND(2, "二级分类");

    public int code;
    public String desc;

    CategoryTypeEnum(int code, String desc) {
        this.code = code;
        this.desc = desc;
    }

    /**
     * 根据code获取枚举
     * @param code
     * @return
     */
    public static CategoryTypeEnum getByCode(int code) {
        for (CategoryTypeEnum value : values()) {
            if (value.code == code) {
                return value;
            }
        }
        return null;
    }
}

3.SubjectCategoryDomainServiceImpl.java查询未删除字段

4.SubjectCategoryController.java修改查询一级分类逻辑，使其传入category_type

5.修改接口

6.重启测试

4.查询二级分类

1.修改接口