入道彌深，所見彌大

1.入參為對象的時候
List<AppUser> queryUser(AppUser user);對應的sql

<!--模糊查詢方式一 對象-->
    <select id="queryUser" resultType="AppUser">
        select
        <include refid="dto" /> from USER where
        <if test="phone != null and phone != ''">
            <bind name="uphone" value="'%'+phone+'%'"/>
            phone like #{uphone}
        </if>
         <if test="name != null and name != ''">
             <bind name="uname" value="'%'+name+'%'"/>
             and name like #{uname}
         </if>
         order by id desc
    </select>

2.入參類型為Map，且沒有加注解的時候，key 為phone、name
List<AppUser> queryUserBy2Map(HashMap<String,Object> mp);對應的sql

<select id="queryUserBy2Map" parameterType="java.util.HashMap" resultType="AppUser" >
        select
        <include refid="dto" /> from USER where
        <if test="phone != null and phone != ''">
            <bind name="uphone" value="'%'+phone+'%'"/>
            phone like #{uphone}
        </if>
        <if test="name != null and name != ''">
            <bind name="uname" value="'%'+name+'%'"/>
            and name like #{uname}
        </if>
        order by id desc
    </select>

3.入參類型為Map，但是dao 層添加注解@Param,key為phone,name
List<AppUser> queryUserByMap(@Param("appUser") HashMap mp);對應的sql

<!--模糊查詢 map 方式,dao層加@Param("appUser") 注解-->
    <select id="queryUserBy2Map" parameterType="java.util.HashMap" resultType="AppUser" >
        select
        <include refid="dto" /> from USER where
        <if test="phone != null and phone != ''">
            <bind name="uphone" value="'%'+phone+'%'"/>
            phone like #{uphone}
        </if>
        <if test="name != null and name != ''">
            <bind name="uname" value="'%'+name+'%'"/>
            and name like #{uname}
        </if>
        order by id desc
    </select>