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

 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>