mybatis杂篇记录

1、<sql>与<include>的使用

<sql id="Analysis">
FROM  ps_people
</sql>

<select id="findAllSoundStationCount" parameterType="Map" resultType="Integer">
 	select count(*)
 	<include refid="Analysis"></include>
</select>

2、<if>标签内list判断

<if test="null!=alList and alList .size()>0">
	and a.orgId in
    <foreach item="item" index="index" collection="alList " open="(" separator="," close=")">
	 #{item}
    </foreach>
</if>