ibatis 迭代中使用in传递字符串数组或集合时的用法

本文链接：https://blog.youkuaiyun.com/u010813065/article/details/26465013

本文深入探讨了SQL Server中分页查询及动态更新的实现方式，包括使用ROW_NUMBER函数进行分页和IBatis框架下动态SQL的编写。详细介绍了如何通过SQL Server分页获取特定范围的数据，以及如何利用IBatis进行复杂条件下的动态更新操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

parameterClass="java.util.Map"

SELECT t.autoid as autoid,t.orderNo as orderNo,t.styleno as styleno,t.zdno as zdno FROM

Table t.zdno IN
<iterate property="autoids" open="(" close=")" conjunction=",">
#autoids[]#

</iterate>

sql server 分页

select * from (select row_number() over (order by t1.autoid desc) as rowid
, t1.*
from Table t1

) t where t.rowid between #startIndex# and #endIndex#

sql server2008截取年月日数据：

CONVERT(varchar, col, 120 )

--------------------------------------------------------------------------------------------------------------------------------------------------

ibatis动态更新

<update id="updateLayoutOrderImgs" parameterClass="java.util.Map">
update ripreport_LayoutOrder
<dynamic prepend="set">
<isNotNull prepend="," property="img">
img=#img#
</isNotNull>
<isNotNull prepend="," property="img0">
img0=#img0#
</isNotNull>
<isNotNull prepend="," property="img1">
img1=#img1#
</isNotNull>
<isNotNull prepend="," property="img2">
img2=#img2#
</isNotNull>
<isNotNull prepend="," property="img3">
img3=#img3#
</isNotNull>
</dynamic>
where layoutVisaAvailableDatePlanAutoid=#layoutVisaAvailableDatePlanAutoid#
</update>