Mybatis中动态sql(多条件查询)

动态SQL指：通过mtbatis提供的各种标签实现动态拼接sql语句

例如：

<!--动态SQL语句，多条件查询-->
   <select id="findSomeByMore" resultType="userInfoModel" parameterType="hashmap">
      select * from userinfo
--        (where标签自动去掉满足条件的第一个and)
      <where>
         <if test="userName!=null">
            and username=#{userName}
         </if>
         <if test="gender != null">
            and gender=#{gender}
         </if>
         <if test="orderId != null">
            and id in (select userid from orders where id=#{orderId})
         </if>

      </where>

   </select>

批量删除

<delete id="partDelete" parameterType="list" >
   delete from userinfo
   <where>
      <if test="list!=null and list.size()>0">
         <foreach collection="list" item="id" open="id in (" separator="," close=")">
            #{id}
         </foreach>
      </if>
   </where>
</delete>