这段代码有什么问题 我传了一个list集合进行批量删除

Question

 <delete id="removePlan"  >           delete from  tbl_plan  where P_no in              <foreach collection="list" index="index" item="pNo" open="(" separator="," close=")"> #{pNo}           </foreach> </delete>

Answer 1

需要对list进行判空.

<delete id="removePlan" parameterType="List">
    delete from tbl_plan
    <if test="list!=null">
        <where>
            P_no in 
            <foreach item="pNo" collection="list" open="(" separator="," close=")">
                #{pNo}
            </foreach>
        </where>
    </if>
</delete>