用onclick和JavaScript实现数据删除功能

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>管理检查设施信息———欢迎使用晋城市高级技工学校宿舍管理系统！</title>
<style type="text/css">
<!--@import url("../../css/index.css");
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(../../Images/xx.gif);
background-color: #f2f2f2;
}
-->
</style>
<link href="../../css/index.css" rel="stylesheet" type="text/css" media="screen"/>
</head>
<%@ include file="../Header.jsp"%>
<script language="javascript">
function delStudent(id){
String driverName="com.mysql.jdbc.Driver";
String dbName="dorm";
String userName="root";
String userPasswd="";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
//boolean a;
String sql="delete from do_facilities where id='"+id+"'";
stmt.executeUpdate(sql);
}</script><%
String driverName="com.mysql.jdbc.Driver";
String dbName="dorm";
String userName="root";
String userPasswd="";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
//boolean a;
String sql="select * from do_facilities";
ResultSet rs=stmt.executeQuery(sql);
//while(rs.next()){
//String fa_type=rs.getString("fa_type");
//String fa_date=rs.getString("fa_date");
//String fa_place=rs.getString("fa_place");
//String fa_txt=rs.getString("fa_txt");
//String fa_complete=rs.getString("fa_complete");  
//}
%>

<table width="900" style="height:900px" border="0" cellSpacing=0 cellPadding=0 align="center">  <tr>
    <td width="17"  style="background:url(../../Images/bg2.jpg)"></td>
    <td bgcolor="#FFFEFF" class="biankuang"><table width="100%" style="height:900px" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="20" colspan="2" class="biankuang2">当前位置：?&gt;查看公寓公共设施</td>
      </tr>
      <tr valign="top">
        <td width="60" class="biankuang1">&nbsp;</td>
        <td align="center">
<form action="" method="post">
          <table border="0" cellpadding="0" cellspacing="0">
            <tr>
<td><div align="center">请选择</div></td>
              <td><div align="center">设施名称</div></td>
              <td><div align="center">报修日期</div></td>
              <td><div align="center">位置</div></td>
              <td>备注</td>
              <td><div align="center">修好日期</div></td>
              <td><div align="center">操作</div></td>
            </tr>
            
            
<%
  while(rs.next()){
  %>
  <tr>
  <td>
  <input name="" type="checkbox" value="" /><input name="checbox" type="hidden" value="<%=rs.getString("id")%>" />
<%
String id=rs.getString("id");
out.print(id);%>
<%out.print(rs.getRow());%>
              </td>
              <td>
  
  <%=rs.getString("fa_type")%>

              </td>
              <td>
               <%=rs.getString("fa_date")%>
             </td>
              <td>&nbsp;
              
  </td>
              <td>
 <%=rs.getString("fa_txt")%>
   </td>
              <td>&nbsp;
         df
              </td>
              <td><div align="center">修改&nbsp;<a href="#" onclick="delStudent(id)"/>删除</a>
  <input type="submit" name="submit" onclick="delStudent(id)" />
 </div></td>
         </tr>
     <%
  }
            %>
    
  
          </table>
        </form>
 </td>
      </tr>
    </table></td>
    <td width="17" style="background:url(../../Images/bg3.jpg)"></td>
  </tr>
</table>
<%@ include file="../Footer.jsp"%>
</body>
</html>

解决方案 »

  1.   

    这个页面中怎么点击删除就删除当前记录，这个是个循环体，可以把一个表中的记录全部读取出来。希望在本页面中JavaScript实现
      

  2.   

    remove(i)是什么意思，能详细点吗
      

  3.   

    <%
    while(rs.next()){
    %>
    <tr>
    <td>
    <input name="" type="checkbox" value="" /><input name="checbox" type="hidden" value="<%=rs.getString("id")%>" />
    <%
    String id=rs.getString("id");
    out.print(id);%>
    <%out.print(rs.getRow());%>
      </td>
    先改为 <%for(int i=1;rs.next();i++){%>
     <tr>
     <td id="<%=i%>"
     <input name="checkbox" type="checkbox" value="" /><input name="<%=i%>" type="hidden" value="<%=rs.getString("id")%>" />
      </td>
    定义一个方法 
    <a href="#" onclick="delStudent(id)"/>删除</a>
    <input type="submit" name="submit" onclick="delStudent(id)" />
    先改为<a href="#" onclick="delStudent()"/>删除</a>
    定义delStudent方法
    <script>
    function andy(){
       var ol =document.getElementsByName("checkbox");
        var str;
       for (var i=0;i<ol.length;i++){
         if(ol[i].status){
            var id = ol[i].parentElement.id;
            if(i==(ol.length-1)){
                
                str = document.getElementById(id).value;
            }
    str =document.getElementById(id).value+","; //获得所有选中的记录的记录的ID
         }
       }
        frm.action="xxx.jsp?str="+str; 
     //在xxx.jsp获取到要删除的记录的ID的字符串集，然后用 
      //split(",")将字符分开，然后遍历所有记录 
     // 然后使用 String sql="delete from do_facilities where id='"+id+"'";
     // stmt.executeUpdate(sql);将该记录删除    frm.submit();
       }
    </script>