impl
@Override
public String getExistArrangeCourse(RwlscxModel model) {
if(!BlankUtils.isBlank(model.getJxb_id())){
String a[] = model.getJxb_id().split(",");
model.setXx_id_list(Arrays.asList(a));//更新的号
}
return dao.getExistArrangeCourse(model);
}
Dao
public String getExistArrangeCourse(RwlscxModel model);
SQL
<!-- 存在 返回>0 不存在 =0-->
<select id="getExistArrangeCourse" resultType="String" parameterType="com.zfsoft.jwglxt.jxjhgl.dao.rwlscx.entities.RwlscxModel">
select count(*)
from jw_jxrw_jxbxxb b
where
((b.psjzt != '0' or b.pcdzt != '0')
or exists
(select 'x' from JW_PK_XSFPB fpb where fpb.jxb_id = b.jxb_id))
and
<foreach collection="xx_id_list" item="item" index="index" open="(" close=")" separator="or">
b.jxb_id = #{item}
</foreach>
</select>