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

来源：互联网发布：硫酸钙网络地板编辑：程序博客网时间：2024/05/16 01:35

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>

0 0