java - 动态下拉从 jsp 返回空值

Question

我写了一个由数据库填充的下拉列表。这是我在 JSP 文件中的下拉代码。

 <td>Category:</td>
 <%
  try {
      dbConnect dbConnect = new dbConnect();
      Connection currentCon = dbConnect.Connect();
      System.out.println("Connection sucess");
      String sql = "SELECT * FROM categories";
      PreparedStatement ps = currentCon.prepareStatement(sql);
      ResultSet rs = ps.executeQuery();%>
 <td><select name="category" class="form-control" required>
      <%
        while (rs.next()) {
           String cname = rs.getString("category_name");
           String id = rs.getString("category_id");
           System.out.println(id);
      %>
      <option value="<%= id%>"><%= cname%></option>
      <%
        }
      %>
      </select>
      <%
      } catch (SQLException sqe) {
            out.println(sqe);
      }
 %>
 </td>

相关的servlet代码是；

String id = request.getParameter("category");

在 JSP 下拉列表的底部，它打印了类别中的所有 ID。但是当涉及到 servlet 时，它返回一个空值。如何解决这个问题？

Answer 1

我没有找到任何 <form> tag都不是 submit代码中的按钮，尝试以下代码:

    <td>Category:</td>
     <form method="post"  action="yourservleturl">//form tag for submitting data

         <%
          try {
              dbConnect dbConnect = new dbConnect();
              Connection currentCon = dbConnect.Connect();
              System.out.println("Connection sucess");
              String sql = "SELECT * FROM categories";
              PreparedStatement ps = currentCon.prepareStatement(sql);
              ResultSet rs = ps.executeQuery();%>
         <td><select name="category" class="form-control" required>
              <%
                while (rs.next()) {

              %>
              <option value="<%=rs.getString("category_id")%>"><%=rs.getString("category_name")%></option> // printing option values
              <%
                }
              %>
              </select>
              <%
              } catch (SQLException sqe) {
                    out.println(sqe);
              }
         %>
     <input type="submit" value="submit">///submit btn
  </form>
</td>

还可以通过 String id = request.getParameter("category"); 获取下拉值.它应该有效。