接口:
int findDeleteAll(String [] trainNo);
Biz:
@Override
public int updateByid(Tstrain tstrain) {
int result= tstrainDao.updateByid(tstrain);
return result;
}
Dao:
//多个删除
@Override
public int findDeleteAll(String []trainNo) {
StringBuffer sb=new StringBuffer("DELETE from train_info WHERE train_no IN(");//创建StudentBuffer
int result=0;
//解决方案1 循环调用弊端(频繁连接数据库)中裤sql报错 无法回滚已经执行的sql语句
if(trainNo!=null&&trainNo.length>0) {
for(int i=0;i<trainNo.length;i++) {
sb.append("'"+trainNo[i]+"'");//循环一次添加一次
if(i!=trainNo.length-1) {//如果是最后一个追加一个 不是-一个,s
sb.append(",");//追加
}
}
sb.append(")");
result=super.executeUpdate(sb.toString());
}
return result;
}
首页:
<%@page import="com.haochenit.entity.Tstrain"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
List<Tstrain>tstrainlist=(List<Tstrain>)request.getAttribute("Tstrainlist");
if(tstrainlist==null){
response.sendRedirect("do_list.jsp");
return;
}
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>火车列表</title>
<script type="text/javascript" src="js/jquery-1.8.3.min.js"></script>
<script type="text/javascript">
function del() {
$("#dent").submit();
}
</script>
</head>
<body>
<form id="dent" method="post" action="do_del.jsp" >
<table border="1" align="center">
<tr>
<td><a href="javascript:del();" >删除</a></td>
<td><a>车次</a></td>
<td>发车---到达</td>
<td>发时---到时</td>
<td>车型</td>
<td>运行时长(小时)</td>
<td>操作</td>
</tr>
<%
for(Tstrain tstrain:tstrainlist){
%>
<tr>
<td><input type="checkbox" name="id"value="<%=tstrain.getTrainNo() %>"/></td>
<td><a href="info.jsp?id=<%=tstrain.getTrainNo() %>"><%=tstrain.getTrainNo() %> </a></td>
<td><%=tstrain.getTrainStation() %>---<%=tstrain.getArrivalStation() %></td>
<td><%=tstrain.getStartTime() %>----<%=tstrain.getArrivalTime() %></td>
<td><%=tstrain.getVehiclemodel() %></td>
<td><%=tstrain.getRuntime() %></td>
<td><a href="update.jsp?id=<%=tstrain.getTrainNo() %>">修改</a></td>
<td><a href="">新增</a></td>
</tr>
<%
}
%>
</table>
</form>
</body>
</html>
删除处理页面:
<%@page import="com.haochenit.dao.impl.TstrainDaoImpl"%>
<%@page import="com.haochenit.dao.TstrainDao"%>
<%@page import="com.haochenit.entity.Tstrain"%>
<%@page import="com.haochenit.biz.impl.TstrainBizDaoImpl"%>
<%@page import="com.haochenit.biz.TstrainBizDao"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
TstrainBizDao tstrainBizDao=new TstrainBizDaoImpl();
//获取多个id值 使用数组 接受所有id值
String ids[]=request.getParameterValues("id");
int result= tstrainBizDao.findDeleteAll(ids);
out.print("<script>");
if(result>0){
out.print("alert('删除成功');");
} else{
out.print("alert('删除失败');");
}
out.print("loaction.href='list.jsp'");
out.print("</script>");
%>