Mapper.xml 动态sql语句

一. Mapper.xml 动态sql语句

<?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.project.dao.UserDao">

    <!--sql片段: 把一些重复使用sql语句抽取出来
                 id唯一的标志
                文本是指向的sql语句

     <include refid="select_user"></include>
                引用sql片段
                refid： 关联id
    -->


    <sql id="select_user">
        select u_id ,name ,sex,address,birthday from sys_user
    </sql>

    <resultMap id="users" type="user">
        <id column="u_id" property="id"></id>
    </resultMap>
        
    <!--
        if语句判断

        根据姓名和性别条件查询
    -->
    <select id="findByCondition1" resultMap="users" parameterType="user">

        <include refid="select_user"></include>  where 1=1
        <if test="name != null and name != ''">
            and name like "%"#{name}"%"
        </if>
        <if test="sex != null">
           and sex = #{sex}
        </if>

    </select>

    <!--

        where :可以自动处理第一个and符号

        根据姓名和性别条件查询
    -->
    <select id="findByCondition" resultMap="users" parameterType="user">
        <include refid="select_user"></include>
        <where>
            <if test="name != null">
                name like "%"#{name}"%"
            </if>
            <if test="sex != null">
                and sex = #{sex}
            </if>
        </where>
    </select>

    <!--删除多个用户-->
    <!--

         parameterType：如果传递的是一个数组或者一个集合就不要配置了


        foreach循环标签
           collection:  传递参数的类型：list, array
            open: 以什么开头
            close：以什么结尾
            separator：分隔符
            item: 集合(数组)中每一个元素


            delete from sys_user where u_id in(1,2,3);
    -->
    <delete id="del">
        delete from sys_user
        <if test="array != null">
            <foreach collection="array" open="where u_id in(" separator="," close=")" item="id">
                #{id}
            </foreach>
        </if>

    </delete>
    
    
    <delete id="delByList" >
        delete from sys_user
              <foreach collection="list" open="where u_id in(" separator="," close=")" item="id">
                  #{id}
              </foreach>
    </delete>
</mapper>

Mybatis 框架配置文件详解(SqlMapConfig.xml&&Mapper.xml)

Mybatis Mapper.xml 增删改查详解

Mapper.xml 传递参数详解

Mapper.xml 返回值详解