实体类和DTO之间联系的xml的写法

最新推荐文章于 2024-06-18 11:04:37 发布

yu_zheng5163

最新推荐文章于 2024-06-18 11:04:37 发布

阅读量69

点赞数 2

文章标签： xml java 数据库

本文链接：https://blog.csdn.net/m0_56095048/article/details/139154772

版权

<?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.ruoyi.system.mapper.RepoMapper">
    
    <resultMap type="Repo" id="RepoResult">
        <result property="id"    column="id"    />
        <result property="code"    column="code"    />
        <result property="title"    column="title"    />
        <result property="remark"    column="remark"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectRepoVo">
        select id, code, title, remark, create_time, update_time from el_repo
    </sql>


    <resultMap id="ListResultMap"
               type="com.ruoyi.system.domain.RepoDto.response.RepoRespDTO"
               extends="RepoResult">
        <result column="radio_count" property="radioCount" />
        <result column="multi_count" property="multiCount" />
        <result column="judge_count" property="judgeCount" />
    </resultMap>
    <select id="paging" resultMap="ListResultMap">
        SELECT `id`, `code`, `title`, `remark`, `create_time`, `update_time`,
        (SELECT COUNT(0) FROM el_qu_repo WHERE repo_id=repo.id AND qu_type=1) AS radio_count,
        (SELECT COUNT(0) FROM el_qu_repo WHERE repo_id=repo.id AND qu_type=2) AS multi_count,
        (SELECT COUNT(0) FROM el_qu_repo WHERE repo_id=repo.id AND qu_type=3) AS judge_count
        FROM el_repo repo
        <where>
            <if test="query!=null">
                <if test="query.title!=null and query.title!=''">
                    AND repo.title LIKE CONCAT('%',#{query.title}, '%')
                </if>

                <if test="query.excludes!=null and query.excludes.size()>0">
                    AND repo.id NOT IN
                    <foreach collection="query.excludes" open="(" close=")" separator="," item="id">
                        #{id}
                    </foreach>
                </if>
            </if>
        </where>
    </select>


    <select id="listP" resultMap="ListResultMap">
        SELECT `id`, `code`, `title`, `remark`, `create_time`, `update_time`,
        (SELECT COUNT(0) FROM el_qu_repo WHERE repo_id=repo.id AND qu_type=1) AS radio_count,
        (SELECT COUNT(0) FROM el_qu_repo WHERE repo_id=repo.id AND qu_type=2) AS multi_count,
        (SELECT COUNT(0) FROM el_qu_repo WHERE repo_id=repo.id AND qu_type=3) AS judge_count
        FROM el_repo repo
        <where>
            <if test="query!=null">
                <if test="query.title!=null and query.title!=''">
                    AND repo.title LIKE CONCAT('%',#{query.title}, '%')
                </if>

                <if test="query.excludes!=null and query.excludes.size()>0">
                    AND repo.id NOT IN
                    <foreach collection="query.excludes" open="(" close=")" separator="," item="id">
                        #{id}
                    </foreach>
                </if>
            </if>
        </where>
    </select>