使您的search()
方法返回a List<Product>
而不是单个Product
。
public List<Product> search(){
List<Product> products = new ArrayList<Product>();
ResultSet rs = DAO.fetch("SELECT * FROM Products");
while (rs.next()) {
Product product = new Product();
product.setNumber(rs.getString("ProductNumber"));
product.setName(rs.getString("ProductName"));
product.setQty(rs.getString("ProductQty"));
products.add(product);
}
return products;
}
然后,在您的JSP文件中,迭代返回的列表:
<c:forEach var="product" items="${products}">
<!-- build your row -->
</c:forEach>