ibatis循环迭代匹配不同的语句

最新推荐文章于 2022-09-15 14:55:40 发布

小小菜鸟呀

最新推荐文章于 2022-09-15 14:55:40 发布

阅读量194

点赞数

本文链接：https://blog.csdn.net/m0_53891873/article/details/114589411

版权

根据迭代中的数据的值来匹配的不同的查询

<isNotEmpty property="list" prepend="and">
					<iterate property="list" open="(" close=")" conjunction="OR">						
							<isLessEqual property="list[]" compareValue="3">
							b.test1= #list[]#
						</isLessEqual>
						<isGreaterThan property="list[]" compareValue="3">
							<isEqual property="list[]" compareValue="9">
								((b.test1 = 9 or b.test1 = 3) and a.test2=0)
							</isEqual>
							 <isEqual  property="list[]" compareValue="20">
							    b.test1= #list[]#
							  </isEqual>
							  <isEqual  property="list[]" compareValue="21">
							    b.test1= #list[]#
							  </isEqual>
							  <isEqual  property="list[]" compareValue="22">
							    b.test1 = #list[]#
							  </isEqual>
							  <isEqual  property="list[]" compareValue="23">
							    b.test1= #list[]#
							  </isEqual>
							<isNotEqual property="list[]" compareValue="9">
							   <isNotEqual property="list[]" compareValue="20">
							    <isNotEqual property="list[]" compareValue="21">
							    <isNotEqual property="list[]" compareValue="22">
							    <isNotEqual property="list[]" compareValue="23">
								  a.test2= #list[]#
								</isNotEqual>
								</isNotEqual>
								</isNotEqual>
								</isNotEqual>
							</isNotEqual>
						</isGreaterThan>
						</iterate>
				</isNotEmpty>