1.if标签
<where>
<if test =”条件”> 满足条件的语句 </if>
</where>
<select id="selectByMoney" resultType="demo.entity.User">
select * from t_user
<where>
<if test="money != null and money != ''" >
and money > 1000
</if>
</where>
</select>
2.foreach标签
item:循环元素
open:用什么符号开始将元素包装
close:用什么符号结束将集合元素包装
collection:方法传递的参数,集合/数组
separator:各元素的间隔符号
<select id="selectUserByIds" resultType="demo.entity.User">
select * from t_user
<where>
<foreach collection="ids" open="and id in(" item="id" separator="," close=")">
#{id}
</foreach>
</where>
</select>
三、sql标签
<sql id="sql_temp">
select id ,user_name, passwd, money from t_user
</sql>
<select id="login" resultType="demo.entity.User">
<include refid="sql_temp"></include> where user_name=#{userName} and passwd=#{passwd}
</select>