mybatis批量删除

dao接口

/**
	 * 根据ID集合批量删除对象
	 * 
	 * @param list
	 * @return 影响条数
	 * 
	 */
	public int deleteBatch(List<String> list);

mapper.xml

<delete id="deleteBatch" parameterType="java.util.List">
		DELETE FROM  STS_REPORT_DESIGN_T WHERE ID IN
	  <foreach item="id" collection="list" open="(" separator="," close=")">
	  #{id}
	  </foreach>
	</delete>