MyBatis动态SQL笔记

最新推荐文章于 2024-04-28 22:19:25 发布

O不X

最新推荐文章于 2024-04-28 22:19:25 发布

阅读量129

点赞数

分类专栏： MyBatis

本文链接：https://blog.csdn.net/weixin_43735779/article/details/84642870

版权

MyBatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1. <if标签>

在这里插入图片描述


 <select id="selectEmployeesByIf" resultType="Employee">
        select id, name, age from employee
        where 1 = 1
        <if test="myname != null and myname != ''">
            and name like '%' #{myname} '%'
        </if>
        <if test="myage > 0">
            and age &gt; #{myage}
        </if>

2. <where标签>

在这里插入图片描述

    <select id="selectEmployeesByWhere" resultType="Employee">
        select id, name, age from employee
        <where>
            <if test="myname != null and myname != ''">
                and name like '%' #{myname} '%'
            </if>
            <if test="myage > 0">
                and age &gt; #{myage}
            </if>
        </where>
    </select>

3.<choose/标签>

在这里插入图片描述

    <select id="selectEmployeesByChoose" resultType="Employee">
        select id, name, age from employee
        <where>
            <choose>
                <when test="myname != null and myname != ''">
                    and name like '%' #{myname} '%'
                </when>
                <when test="myage > 0">
                    and age &gt; #{myage}
                </when>
                <otherwise>
                    and 1 != 1
                </otherwise>
            </choose>
        </where>
    </select>

4. <foreach/标签>–遍历数组

在这里插入图片描述

5. <foreach/标签–遍历List

在这里插入图片描述

    <select id="selectEmployeesByForeach" resultType="Employee">
        select id, name, age from employee
        <if test="array != null and array.length > 0">
            <where>
                id in
                <foreach collection="array" open="(" close=")" separator="," item="id">
                    ${id}
                </foreach>
            </where>
        </if>
    </select>