- A+
所属分类：mybatis
<select id="findByStatusIn" resultMap="xxxxx">
select <include refid="Base_Column_List"/>
from xxxxx
where
status in
<foreach collection="status" item="status" index="index" open="(" close=")" separator=",">
#{status}
</foreach>
and is_delete = 0
limit #{pageNum},#{pageSize}
</select>
