批量删除 mysql

之前做的批量删除都是一条一条的进行删除的。一直觉得不太理想。于是更改如下

</pre><pre name="code" class="html"><?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.battleship.app.console.repository.academicYear.impl.AcademicYearRepositoryImpl">
<!-- 批量删除的SQL语句 -->
<select id="delete" resultType="int" parameterType="int">
		delete from B_AcademicYear where AcademicYearID in(#{academicYearID})
	</select>
</mapper>

//控制器里的方法
/**
	 * 批量删除
	 * @param list 保存有页面传递过来id
	 * @return 布尔值判断是否删除成功
	 */
	@RequestMapping("/delete")
	@ResponseBody
	public boolean delet(String list) {
		boolean f = false;
		System.out.println("lsit:" + list);
		String[] l = list.split(",");
		for (int i = 0, len = l.length; i < len; i++) {
			int id = Integer.parseInt(l[i]);
			System.out.println(id + "正确的数值");
			if (year.delete(id)) {
				return f = true;
			} else {
				return f;
			}
		}
		return f;
	}

/**
 * 批量删除
 */
	function deleteBatch(){
		var list = new Array();
	 	$("input[type=checkbox]:checked").each(function(){
			list.push($(this).val());
	 	});
	 	alert(list + "list");
	 	if(list.length > 0){
	 		if(window.confirm("确认删除？")){
	 			$.getJSON("/Mars/console/year/delete",{list:list.join(",")},function(data){
					if(data){
						alert("删除成功");
						location.reload();//刷新页面
					}else{
						alert("删除失败");
						location.reload();
					}
				});
		 	}
	 	}else{
	 		alert("请选择一项！");
	 	}
	}

在用JSON传值得时候注意要转换成字符串或者是通过请求来传值