java将数据显示在html页面上_java-使用MVC和DAO模式在JSP页面的HTML中显示JDBC ResultSet...

代表产品的真实世界的public class ProductDAO {

private DataSource dataSource;

public ProductDAO(DataSource dataSource) {

this.dataSource = dataSource;

}

public List list() throws SQLException {

List products = new ArrayList();

try (

Connection connection = dataSource.getConnection();

PreparedStatement statement = connection.prepareStatement("SELECT id, name, description, price FROM product");

ResultSet resultSet = statement.executeQuery();

) {

while (resultSet.next()) {

Product product = new Product();

product.setId(resultSet.getLong("id"));

product.setName(resultSet.getString("name"));

product.setDescription(resultSet.getString("description"));

product.setPrice(resultSet.getBigDecimal("price"));

products.add(product);

}

}

return products;

}

}类，它应该只是Javabean。

public class ProductDAO {

private DataSource dataSource;

public ProductDAO(DataSource dataSource) {

this.dataSource = dataSource;

}

public List list() throws SQLException {

List products = new ArrayList();

try (

Connection connection = dataSource.getConnection();

PreparedStatement statement = connection.prepareStatement("SELECT id, name, description, price FROM product");

ResultSet resultSet = statement.executeQuery();

) {

while (resultSet.next()) {

Product product = new Product();

product.setId(resultSet.getLong("id"));

product.setName(resultSet.getString("name"));

product.setDescription(resultSet.getString("description"));

product.setPrice(resultSet.getBigDecimal("price"));

products.add(product);

}

}

return products;

}

}

一个DAO类，它完成所有令人讨厌的JDBC工作，并返回一个不错的public class ProductDAO {

private DataSource dataSource;

public ProductDAO(DataSource dataSource) {

this.dataSource = dataSource;

}

public List list() throws SQLException {

List products = new ArrayList();

try (

Connection connection = dataSource.getConnection();

PreparedStatement statement = connection.prepareStatement("SELECT id, name, description, price FROM product");

ResultSet resultSet = statement.executeQuery();

) {

while (resultSet.next()) {

Product product = new Product();

product.setId(resultSet.getLong("id"));

product.setName(resultSet.getString("name"));

product.setDescription(resultSet.getString("description"));

product.setPrice(resultSet.getBigDecimal("price"));

products.add(product);

}

}

return products;

}

}。

public class ProductDAO {

private DataSource dataSource;

public ProductDAO(DataSource dataSource) {

this.dataSource = dataSource;

}

public List list() throws SQLException {

List products = new ArrayList();

try (

Connection connection = dataSource.getConnection();

PreparedStatement statement = connection.prepareStatement("SELECT id, name, description, price FROM product");

ResultSet resultSet = statement.executeQuery();

) {

while (resultSet.next()) {

Product product = new Product();

product.setId(resultSet.getLong("id"));

product.setName(resultSet.getString("name"));

product.setDescription(resultSet.getString("description"));

product.setPrice(resultSet.getBigDecimal("price"));

products.add(product);

}

}

return products;

}

}

一个Servlet类，它获取列表并将其放入请求范围。

@WebServlet("/products")

最后是@WebServlet("/products")中的JSP文件，该文件使用JSTL web.xml迭代http://example.com/contextname/products(在EL中由http://example.com/contextname/products提供)，并使用JSTL 逃逸字符串属性，以便避免涉及用户控制输入时出现XSS孔。

@WebServlet("/products")