SpringBatch文章系列-SPL表达式的使用

参考例子:

<bean id="beanName" class="com.*****" scope="step">

			<property name="parameterValues">
				<map>
					<entry key="setlValDt" value="#{jobParameters[buzDate]}" />
					<entry key="_thdCnts" value="#{stepExecutionContext[_thdCnts].split(,)}" />
					<entry key="nodeLoanMinsize" value="#{jobParameters[nodeLoanMinsize]}" />
					<entry key="nodeLoanMaxsize" value="#{jobParameters[nodeLoanMaxsize]}" />
				</map>
			</property>

Mybatis写法

<select id="selectBySetlValDtForHBH" parameterType="map" resultType="com.yuchengtech.ycloans.sbatch.dao.model.SetLmtInfos">
	select * from ( select T.*, rownum rownum_ from (
		select b.* from (
			select e.*,rownum rowc from tst_setlmt e where exists (select 1 from tst_loan tl where tl.loan_no = e.LOAN_NO) and prcs_Page_Dt_Ind=Y) b where 1=1
	   		 
				<if test="_thdCnts !=null">
					AND THD_CNT in
					<foreach collection="_thdCnts" open="(" separator="," close=")" item="item">
						#{item}
					</foreach>
				</if>
	) T ) where rownum_ &lt;= #{_pagesize}
  </select>
经验分享 程序员 微信小程序 职场和发展