MyBatis批量删除写法

1、DAO层接口

void deleteAll(@Param("ids")List<Integer> ids);	

2、Mapper文件

<update id="deleteAll">
		update ems_emp set status=0 where id in
		<foreach collection="ids" open="(" item="id" separator="," close=")">
			#{id} 
		</foreach>
	</update>

3、Action

private List<Integer> ids;
public List<Integer> getIds() {
		return ids;
	}
	public void setIds(List<Integer> ids) {
		this.ids = ids;
	}
public String deleteAll(){
		if(ids==null)return "deleteFail";
		else{
			List<Integer> idss = new ArrayList<Integer>();
			for(int i=0;i<ids.size();i++){				
				idss.add(ids.get(i));
				es.removeAll(idss);
			}
			return "deleteAll";
		}		
	}

4、jsp

<input type='checkbox' name='ids' value='<s:property value="id"/>'/>