mybatis动态查询之foreach

啊哈哈哈哈啊有

于 2022-10-10 14:33:54 发布

阅读量1.2w

点赞数 2

文章标签： mybatis java mysql spring boot

本文链接：https://blog.csdn.net/jah5201/article/details/127244167

版权

	<select id="findList"  parameterType="object" resultType="自定义的返回对象">

		SELECT
			*

		FROM
		表名 n

		<where>
			<if test="condition.code!=null and condition.code!='' ">
				and n.code=#{condition.code}
			</if>

            <if test="condition.name!=null and condition.name!='' ">
				and n.name like concat('%',#{condition.name},'%')
			</if>
			<if test="condition.ids!=null and condition.ids.size()>0">
				and n.id in
				<foreach collection="condition.ids" item="item" index="index" open="(" separator="," close=")">
					#{item}
				</foreach>
			</if>
		</where>
	</select>