Mybatis的标签：if标签、where标签、choose，when标签、set标签

DAY24.1 Java核心基础

Mybatis的标签

if标签

<?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.shuwu.mapper.UserMapper" >
    <select id="getUser" parameterType="com.shuwu.entity.User" resultType="com.shuwu.entity.User">
        select * from user
        <if test="id !=null">
            id = #{id}
        </if>
        <if test="name !=null">
            and name = #{name}
        </if>
        <if test="pwd !=null">
            and pwd = #{pwd}
        </if>
        <if test="email !=null">
            and email = #{email}
        </if>
    </select>
</mapper>

有个问题就是这样的话没有id就会出现sql语法错误，我们发现在前面多了一个and，能否把and也设置为动态的呢，不出现在第一个参数的前面，可以用

where标签

<?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.shuwu.mapper.UserMapper" >
    <select id="getUser" parameterType="com.shuwu.entity.User" resultType="com.shuwu.entity.User">
        select * from user
        <where>
            <if test="id !=null">
                id = #{id}
            </if>
            <if test="name !=null">
                and name = #{name}
            </if>
            <if test="pwd !=null">
                and pwd = #{pwd}
            </if>
            <if test="email !=null">
                and email = #{email}
            </if>
        </where>

    </select>
</mapper>

完美解决

choose，when标签，和if标签的效果一样

<choose>
    <when test="id!=null">
        id=#{id}
    </when>
    <when test="name!=null">
        name=#{name}
    </when>
    <when test="pwd != null">
        pwd=#{pwd}
    </when>
    <when test="email != null">
        email=#{email}
    </when>
</choose>

等价于

<if test="id !=null">
    id = #{id}
</if>
<if test="name !=null">
    and name = #{name}
</if>
<if test="pwd !=null">
    and pwd = #{pwd}
</if>
<if test="email !=null">
    and email = #{email}
</if>

set标签，用于更新

<update id="updateUser" parameterType="com.shuwu.entity.User">
    update user
    <set>
        <if test="name!=null">
            name= #{name},
        </if>
        <if test="pwd!=null">
            pwd=#{pwd},
        </if>
        <if test="email!=null">
            email=#{email}
        </if>
    </set>
    where id=#{id}
</update>

MybatisPlus和Mybatis的优劣