选择全部或部分，执行动作代码_代码部分执行-CSDN博客

本文链接：https://blog.csdn.net/lindazhou2005/article/details/486310

//选择页面

<form action="del.jsp" method="post" name="list" id="list">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="32%" bgcolor="#D4D0C8"><strong>选定</strong></td>
            <td width="36%" height="23" bgcolor="#D4D0C8"><strong>父类名称</strong></td>
            <td width="32%" bgcolor="#D4D0C8"><strong>子类名称</strong></td>
          </tr>
          <%
   int curPages = Pagination.curPages(Pagination.strPage(request,"page"));
   Pagination.setRows(16);
   ResultSet rs_count=DBconn.executeQuery("select count(*) as t from class_ware");
   rs_count.next();
   int resultconts=rs_count.getInt("t");
   int totalPages = Pagination.getPages(resultconts);
   ResultSet rs=Pagination.getPageSet(DBconn.executeQuery("select * from class_ware order by news_class"),curPages);
%>
          <%int i=1;%>
          <%while (rs.next()){%>
          <tr>
            <td><input name="ID" type="checkbox" id="select" value="<%=rs.getString("ID")%>"></td>
            <td height="23"><%=rs.getString("news_class")%> </td>
            <td height="23"><%=rs.getString("news_subclass")%> </td>
          </tr>
          <tr valign="top" bgcolor="#D4D0C8" class="biaoge">
            <td height="1" colspan="3"></td>
          </tr>
          <%
   i=i+1;
   if(i>15)
       break;
    }
%>
        </table>
          <div align="right">第<%=curPages%>页共<%=totalPages%>页
              <%
           if(curPages>1)
          {
          %>
              <a href="./organ_list.jsp?page=<%=curPages-1%>">上一页</a>
              <%}%>
              <%
          if(curPages<totalPages)
            {
          %>
              <a href="./organ_list.jsp?page=<%=curPages+1%>">下一页</a>
              <%}%>
       </div></td>
    </tr>
</table>
<p align="center">

<input name="Submit3" type="button" class="area_self" value="删除所有选择的机构信息" onClick="javascript:if (confirm('确认要删除吗？')) list.submit();else return ">
<input name="table" type="hidden" id="table" value="class_ware">
<input name="url" type="hidden" id="url" value="news_class_add">
</p>
</form>

//执行删除页面

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<jsp:useBean id="DBconn" scope="page" class="DBconn.DBconn"/>
<body>
<%   String teacher_name = (String)session.getValue("teacher_name");
if(teacher_name==null||teacher_name=="")
{
response.sendRedirect("../../do/land.jsp");
}
else{
  String sqlCheck= "select mark from teacher where name='"+teacher_name+"'";
  ResultSet rsCheck=DBconn.executeQuery(sqlCheck);
  rsCheck.next();
  String mark = rsCheck.getString("mark");
  if(mark.trim().equals("info")||mark.trim().equals("manager"))
  {
    String table = request.getParameter("table");
    String url = request.getParameter("url");
    String[] ID=request.getParameterValues("ID");
    for(int i=0;i<ID.length;i++)
    {
    String sql = "delete from "+table+" where ID='"+ID[i]+"'";
    DBconn.executeUpdate(sql);
    //out.print(sql);
    }
    //out.print(url);
    response.sendRedirect(url+".jsp");
  }
  else
  {
  out.print("对不起，您没有删除的权限。");
  }
  }
%>
<%
DBconn.closeStmt();
DBconn.closeConn();
%>
</body>
</html>