grain-Edu-Note part09 向mapper接口添加自定义功能，并将xml打包

最新推荐文章于 2023-09-12 14:57:57 发布

Ezerbel

最新推荐文章于 2023-09-12 14:57:57 发布

阅读量212

点赞数

分类专栏：实战笔记

本文链接：https://blog.csdn.net/Ezerbel/article/details/108947328

版权

实战笔记专栏收录该内容

27 篇文章 0 订阅

订阅专栏

写mapper

在这里插入图片描述

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ezerbel.grain.service.edu.mapper.SubjectMapper">

    <select id="selectNestedListByParentId" resultMap="nestedSubject">
        select id,title,sort from edu_subject where parent_id = #{parentId}
    </select>

    <resultMap id="nestedSubject" type="com.ezerbel.grain.service.edu.entity.vo.SubjectVo">
        <id property="id" column="id"/>
        <result property="title" column="title"/>
        <result property="sort" column="sort"/>
        <!--   select语句传入参数为cloumn对应的id   -->
        <collection property="children"
                    column="id"
                    select="selectNestedListByParentId"
                    ofType="com.ezerbel.grain.service.edu.entity.vo.SubjectVo"/>
    </resultMap>

</mapper>

默认源码包内的xml不会被打包

在这里插入图片描述

maven添加源码包内xml打包配置

    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <!--      不过滤掉          -->
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

yml 配置中指明mapper文件的所在位置

#mybatis日志
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  mapper-locations: classpath:com/ezerbel/grain/service/edu/mapper/xml/*.xml