JSP+三层架构设计应用：商品列表信息

最新推荐文章于 2022-05-22 14:04:30 发布

姜源Jerry

最新推荐文章于 2022-05-22 14:04:30 发布

阅读量1k

点赞数

分类专栏： JSP 文章标签： java servlet jsp

©辛勤耕耘，转载请注明来源。 || 自建博客: janycode.github.io || CSDN博客：simple.blog.csdn.net

本文链接：https://blog.csdn.net/sinat_36184075/article/details/105820403

版权

JSP 专栏收录该内容

11 篇文章 1 订阅

订阅专栏

JSP+三层架构设计应用：商品列表信息

商品列表信息

1. productList.jsp 页面

<%@ page contentType="text/html;charset=UTF-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>商品列表</title>
</head>
<body>
<table border="1px" cellspacing="0px" cellpadding="5px" width="400px" height="200px" >
    <tr>
        <td>ID</td>
        <td>名称</td>
        <td>价格</td>
        <td>数量</td>
        <td>小计</td>
    </tr>
    <c:set var="total" value="0" scope="request"></c:set>
    <c:forEach items="${products}" var="product">
        <tr>
            <td>${product.id}</td>
            <td>${product.name}</td>
            <td>${product.price}</td>
            <td>${product.count}</td>
            <td>${product.price * product.count}</td>
        </tr>
        <c:set var="total" value="${total + product.price * product.count}"></c:set>
    </c:forEach>
    <tr>
        <td colspan="5" align="right">
            总计：${total}元
        </td>
    </tr>
</table>
</body>
</html>

2. servlet.ProductServlet 类

@WebServlet(name = "ProductServlet", urlPatterns = "/products")
public class ProductServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        ProductDao productDao = new ProductDaoImpl();
        try {
            List<Product> products = productDao.selectAll();
            System.out.println(products);
            request.getSession().setAttribute("products", products);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }
}

3. bean.Product 类

public class Product {
    private Integer id;
    private String name;
    private Integer count;
    private Double price;
    ...//无参构造、有参构造、get/set、toString
}

4. dao.ProductDaoImpl 类

// 接口：ProductDao
public class ProductDaoImpl implements ProductDao {
    private QueryRunner queryRunner = new QueryRunner(DBUtils.getDataSource());
    @Override
    public List<Product> selectAll() throws SQLException {
        return queryRunner.query("select * from goods", new BeanListHandler<>(Product.class));
    }
}