这段代码有什么问题 我传了一个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>