首頁猿問這段代碼有什么問題...

這段代碼有什么問題我傳了一個list集合進行批量刪除

Java

愛邊成的涼馬龍 2016-11-07 21:33:56

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

查看完整描述

1 回答

已采納

你好小Song

TA貢獻29條經(jīng)驗獲得超10個贊

需要對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>

反對回復 2016-11-16