MyBatis.xml

<trim prefix=" and (" prefixOverrides="or " suffix=")">
	<choose>
		<when test="groupId != null">
			or group_id = #{groupId}
		</when>
		<when test="groupIdList != null and groupIdList.size() > 0 ">
			or group_id in
			<foreach collection="groupIdList" index="index" item="item" open="(" separator="," close=")">
				#{item}
			</foreach>
		</when>
	</choose>
</trim>