Untitled

<%@ page import = "java.util.List, java.sql.*, com.codebyamir.demo.Product" %>

<%
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "dbuser", "dbpass");
%>

<%!
  public List<Product> getProducts(Connection conn) throws SQLException {

    List<Product> products = new ArrayList<>();

    String sql = "SELECT id, name FROM product";
    PreparedStatement stmt = conn.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
    ResultSet resultSet = stmt.executeQuery();

    while (resultSet.next()) {
      Product product = new Product(resultSet.getInt("id"), resultSet.getString("name");
      products.add(product);
    }

    return products;
  }
%>

<!DOCTYPE html>
<html>

<body>
  <ul class="product-list">

  <%
    for (Product product : getProducts(conn)) {
      out.print("<li>" + product.getName() + "</li>");
    }
  %>

  </ul>
</body>

</html>