#### 根據Id刪除單條 Mapper接口 ``` void deleteById(@Param("id") String id) throws Exception; ``` Mapper.xml ``` <delete id="deleteById" parameterType="java.lang.String"> DELETE FROM TABLE WHERE id = #{id} </delete> ``` #### 根據Id批量刪除 Mapper接口 ``` //批量刪除 - 傳入數組 void batchDeleteEmps(int[] empno); //批量刪除 - 傳入List集合 void batchDeleteEmps(List<String> empno); ``` Mapper.xml ``` collection指的是接口中的參數注解，如果沒寫注解，則數組寫array，list寫list 1、當collection=”array“時,表名參數為數組。 2、當collection=”list“時,表名參數為集合。 <!-- 批量刪除 - 數組 --> <delete id="batchDeleteEmps" parameterType="int"> delete from TABLE where empno in <foreach item="empnoItem" collection="array" open="(" separator="," close=")"> #{empnoItem} </foreach> </delete> <!-- 批量刪除 - 集合 --> <delete id="batchDeleteEmps" parameterType="int"> delete from TABLE where empno in <foreach item="empnoItem" collection="list" open="(" separator="," close=")"> #{empnoItem} </foreach> </delete> ```