时间戳

首页 > 解决方案 > 如何根据用户选择过滤jsp页面中的表格元素

jsp - 如何根据用户选择过滤jsp页面中的表格元素

问题描述

index.jsp 页面

!DOCTYPE html>
<html>
<head>

</head>
<body>

<div align="center">

<form action ="demo.jsp" method="post">
    <table id="formTable">
        <tbody>
        
        <tr>
            <th> <label>START Date: </label> </th>
            <th> <input type = "date" name="Date1" id="date"></th>
         
        </tr>
        <tr>
            <th> <label>END Date: </label> </th>
            <th> <input type = "date" name="Date2" id="date"></th>
        </tr>
        
        <tr>
    
        <td> <label>Author </label> </td>
        <td> <input type ="text" name ="Author" id="author"> </td>
        </tr>
        <tr>
    
        <td> <label>Book Name </label> </td>
        <td> <input type ="text" name ="book_Name" id="bookName"> </td>
        </tr>
        <tr>

        <td> <label>Domain </label> </td>
        <td>  <select id="domain" name="Domain" id="domain">
                  <option value ="" selected Disabled>Select Domain</option>
                  <option>Biology</option>
                  <option>chemistry</option>
                  <option>maths</option>
                  
                  </select> </td>
                  </tr>
                  
        
        
        
        </tbody>
        </table>
        <br>
        <br>
        <input type = "submit"  value = "Submit" name = "submit"/>  
</form>
</div>
</body>
</html>

demo.jsp 页面

 <!DOCTYPE html>
    <html>
    
    
    <body>
    
    
    <div align="center">
    <table id="customers" >
        <thead>
            <tr>
                <td> <label> Id </label> </td>
                <td> <label>book Name </label> </td>
                <td> <label>author </label> </td>
                <td> <label>domain</label></td>
                
                
            </tr>  
        
        
        
            <%
    
        
                      try{
                         
                          String query ="select * from book"
                          Connection conn = SqlConnection.getConnection();
                          Statement stmt = conn.createStatement();
                          ResultSet rs = stmt.executeQuery(query);
                          while(rs.next()){
                              %>
                              <tr>
                              <td><input type = text readonly value ="<%=rs.getString("Id")%>"> </td>
                              <td><input type = text readonly value ="<%=rs.getString("bookName")%>"> </td>
                              <td><input type = text readonly value ="<%=rs.getString("author")%>"></td>
                              <td><input class ="btn"type = text readonly value ="<%=rs.getString("domain")%>"title="<%=rs.getString("domain")%>"> </td>
                             
                              
                              </tr>
                              <%
                              }
                        }
                        catch(Exception ex){
                            System.out.println(ex);
                        }
               %>
        </thead>
    </table>
    
    
    
    </div>
    
    </body>
    </html>

这些是我的 jsp 页面 - 如果用户选择开始日期和结束日期，则在索引页面中只应选择该日期范围内的报告。如果用户填写任何其他文本字段以及此开始和结束日期，则应根据此字段过滤结果。例如，如果我选择开始日期 01/01/2020 和结束日期 28/02/2020 以及域“生物学”，则应显示域“生物学”的报告。

提前致谢。

更新了 demo.jsp

<html>


<body>


<div align="center">
<table id="customers" >
    <thead>
        <tr>
            <td> <label> Id </label> </td>
            <td> <label>book Name </label> </td>
            <td> <label>author </label> </td>
            <td> <label>domain</label></td>
            
            
        </tr>  
    
    
    
        <%
                 string sdate =request.getParameter("date1");
                 string edate =request.getParameter("date2");
                 string author =request.getParameter("Author");
                 string book =request.getParameter("book_name");
                 string domain =request.getParameter("Domain");

    
                  try{
                     
                      String query ="select * from book where date 
                      between"'+sdate'" and "'+end+'" or author = 
                      "'+author+'" or bookName = "'+book_name+'" or "'+domain'"
                      Connection conn = SqlConnection.getConnection();
                      preparedStatement psmt = conn.createStatement();
                      psmt.setString(1,request.getParameter("date");
                      psmt.setString(2,request.getParameter("date");
                      psmt.setString(3,request.getParameter("author");
                     psmt.setString(4,request.getParameter("bookName");
                     psmt.setString(5,request.getParameter("domain");

                      ResultSet rs = stmt.executeQuery(query);
                      while(rs.next()){
                          %>
                          <tr>
                          <td><input type = text readonly value ="<%=rs.getString("Id")%>"> </td>
                          <td><input type = text readonly value ="<%=rs.getString("bookName")%>"> </td>
                          <td><input type = text readonly value ="<%=rs.getString("author")%>"></td>
                          <td><input class ="btn"type = text readonly value ="<%=rs.getString("domain")%>"title="<%=rs.getString("domain")%>"> </td>
                         
                          
                          </tr>
                          <%
                          }
                    }
                    catch(Exception ex){
                        System.out.println(ex);
                    }
           %>
    </thead>
</table>



</div>

</body>
</html>

标签： jsp

解决方案

推荐阅读