删除条件提交页面：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<html>
   <body>
    请选择删除记录条件<hr width="100%" size="3">
    <form action="delete_stu_2.jsp" method="post">
       性名：<input type="text" name="name"><br><br>
       性别：男<input type="radio" value="man" name="sex"> 
       女<input type="radio" value="woman" name="sex"><br><br>
     体重范围：<p>
     最小<input type="text" name="w1"><br><br>
     最大<input type="text" name="w2"><p>
     <input type="submit" value="提 交">&nbsp;&nbsp;&nbsp;&nbsp;
     <input type="reset" value="取 消">  
    </form>
  </body>
</html>

从提交页面获取查询信息，在数据库表中查询满足该条件的记录。

<%@ page contentType="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
  <body>
    <%String driverName="com.mysql.jdbc.Driver";
      String userName="root";
      String userPwd="123456";
      String dbName="student";
      String url1="jdbc:mysql://localhost:3306/"+dbName;
      String url2="?user="+userName+"&password="+userPwd;
      String url3="&useUnicode=true&characterEncoding=UTF-8";
      String url=url1+url2+url3;
      Class.forName(driverName);
      Connection conn=DriverManager.getConnection(url);
      
      request.setCharacterEncoding("utf-8");
      String name=request.getParameter("name");
      String sex=request.getParameter("sex");
      String ww1=request.getParameter("w1");
      String ww2=request.getParameter("w2");
      String s="1=1";
      if(!name.equals(""))s=s+"and name='"+name+"'";
      if(sex!=null)s=s+"and sex='"+sex+"'";
      float w1,w2;
      if(!ww1.equals("")){w1=Float.parseFloat(ww1);s=s+"and weight>="+w1;}
      if(!ww2.equals("")){w2=Float.parseFloat(ww2);s=s+"and weight<="+w2;}
      String sql="delete from stu_info where"+s;
      PreparedStatement pstmt=conn.prepareStatement(sql);
      int n=pstmt.executeUpdate();
      if(n==1){%>数据删除操作成功！<br><%}
      else{ %>数据删除操作失败<br><%}
      if(pstmt!=null){pstmt.close();}
      if(conn!=null){conn.close();}
     %>
  </body>
</html>