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_ <= #{_pagesize} </select>