//删除
function fDelete() {
var usecheckbox;
var singDel;
var AllDel ="";
var delCount= 0;
<c:forEach items="${pageBean.list}" var="list" varStatus="status">
usecheckbox = document.all["checkbox" + '${status.index}'];
if (usecheckbox.checked){
//singDel="'"+document.all["tbemail"+'${status.index}'].value+"'";
singDel = document.all["tbemail" + '${status.index}'].value;
delCount = delCount + 1;
//组字符串
if (AllDel == "") {
AllDel = singDel;
} else {
AllDel = AllDel + "," + singDel;
}
}
</c:forEach>
if (AllDel== "") {
alert("您没有选择要删除的数据");
return false;
}
document.all["pageBean.pageNo"].value = 0;
document.all["id"].value = AllDel;
document.emailBottom.action = "admin/deleteTbemail.do";
if (confirm("是否进行删除")) {
document.emailBottom.submit();
}
}
//全部选中checkbox
function fCheckAll() {
var vIndex;
var vTopBh =document.emailTop.id.value;
var objForm= document.emailBottom;
var length =objForm.elements.length;
var bChecked= $("#sel_check_all").is(":checked");
for ( var i = 0; i< length; i++) {
if (objForm.elements[i].type== "checkbox") {
if (objForm.elements[i].name!= "checkName") {
if (bChecked!= objForm.elements[i].checked) {
objForm.elements[i].click();
if (vTopBh!= null && vTopBh != "") {
if (vTopBh== objForm.elements[i].id) {
vIndex = i;
}
}
}
}
}
}
if (vTopBh== null || vTopBh == "") {
document.emailTop.reset();
$("#id").val("");
} else {
objForm.elements[vIndex].click();
objForm.elements[vIndex].click();
}
}
<input type=button value="删除所选"
class="inputbutton"onclick="fDelete()"></td>
Controller:
// 删除单个
@RequestMapping("/deleteTbemail")
public String deletetbemail(Tbemail tbemail) throws Exception {
System.out.println(tbemail.getId());
int i= tbemailService.deleteByPrimaryKey(tbemail.getId());
return "redirect:findTbemail/1.do";
}
ServiceImpl里面
@Override
public int deleteByPrimaryKey(String id) {
// TODO Auto-generated method stub
String [] arrIds = id.split(",");
Map<String, Object> params = new HashMap<String, Object> ();
params.put("ids",arrIds);
return dao.deleteByPrimaryKey(params);
}
Service:
public int deleteByPrimaryKey(String id);//删除
mybatis的XML页面:
<delete id="deleteByPrimaryKey"parameterType="java.util.Map">
delete from tb_email
where id IN
<foreach item="tempId" collection="ids"open="(" separator=","close=")">
#{tempId}
</foreach>
</delete>