JavaWeb基础系列（八）商城后台增删改查

最新推荐文章于 2025-06-28 14:05:20 发布

北极星小王子

最新推荐文章于 2025-06-28 14:05:20 发布

阅读量1.3w

点赞数 25

CC 4.0 BY-SA版权

分类专栏： JavaWeb基础系列 JavaWeb基础系列（干货版）文章标签： java javaweb 商城增删改查后台

本文链接：https://blog.csdn.net/weixin_41835916/article/details/80791882

本文详细介绍了如何在JavaWeb环境下实现商城后台的商品管理功能，包括商品列表展示、添加商品（商品分类选择）、删除商品以及商品信息的修改。各个步骤涵盖了从Web层到Dao层的完整流程，并提供了Jsp页面的关键代码示例和运行结果截图。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、商品列表的展示

Web层：

@WebServlet(name = "adminProductList",
        urlPatterns = {
  
  "/adminProductList"})
public class adminProductList extends HttpServlet {
   
   
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //传递请求到service层
        AdminProductService service = new AdminProductService();
        List<Product> productList = null;
        try {
            productList = service.findAllProduct();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //将productList放到request域
        request.setAttribute("productList", productList);
        request.getRequestDispatcher("/admin/product/list.jsp").forward(request, response);
    }
}

Service层：

public class AdminProductService {
    public List<Product> findAllProduct() throws SQLException {
        //因为没有复杂业务，直接传递请求到dao层
        AdminProductDao dao = new AdminProductDao();
        return dao.findAllProduct();
    }
}

Dao层：

public class AdminProductDao {
    public List<Product> findAllProduct() throws SQLException {
        QueryRunner runner = new QueryRunner(DataSourceUtils.getDataSource());
        String sql = "select * from product";
        List<Product> productList = runner.query(sql, new BeanListHandler<Product>(Product.class));
        return productList;
    }
}

Jsp：

<c:forEach items="${productList }" var="pro" varStatus="vs">
    <tr onmouseover="this.style.backgroundColor = 'white'"
          onmouseout="this.style.backgroundColor = '#F5FAFE';">
          <td style="CURSOR: hand; HEIGHT: 22px" align="center"
              width="18%">${vs.count }</td>
          <td style="CURSOR: hand; HEIGHT: 22px" align="center"
              width="17%">
              <img width="40" height="45" src="${pageContext.request.contextPath }/${pro.pimage }">
          </td>
          <td style="CURSOR: hand; HEIGHT: 22px" align="center"
              width="17%">${pro.pname }</td>
          <td style="CURSOR: hand; HEIGHT: 22px" align="center"
              width="17%">${pro.shop_price }</td>
          <td style="CURSOR: hand; HEIGHT: 22px" align="center"
              width="17%">${pro.is_hot==1?"是":"否" }</td>
          <td align="center" style="HEIGHT: 22px">
          <a href="${ pageContext.request.contextPath }/adminUpdateProductUI?pid=${pro.pid}">
          <img src="${pageContext.request.contextPath}/images/i_edit.gif"
                border="0" style="CURSOR: hand">
          </a></td>

          <td align="center" style="HEIGHT: 22px">
              <a href="javascript:void(0);" onclick="delProduct('${pro.pid}')">
                  <img src="${pageContext.request.contextPath}/images/i_del.gif"
                       width="16" height="16" border="0" style="CURSOR: hand">
              </a>
          </td>
      </tr>
  </c:forEach>

运行结果：
这里写图片描述

二、添加商品功能

2.1、商品分类添加进来

Jsp页面，当点击了添加按钮之后就讲商品页面添加进来：

<script type="text/javascript">
    function addProduct(){
    
    
        window.location.href = "${pageContext.request.contextPath}/adminAddProductUI";
    }
</script>

Web层：

@WebServlet(name = "adminAddProductUI",
        urlPatterns = {
  
  "/adminAddProductUI"})
public class adminAddProductUI extends HttpServlet {
   
   
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //获得所有的商品的类别数据
        AdminProductService service = new AdminProductService();
        List<Category> categoryList = null;
        try {
            categoryList = service.findAllCategory();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        request.setAttribute("categoryList", categoryList);
        request.getRequestDispatcher("/admin/product/add.jsp").forward(request, response);
    }
}

Service层：

public class AdminProductService {
    public List<Category> findAllCategory() throws SQLException {
        AdminProductDao dao = new AdminProductDao();
        return dao.findAllCategory();
    }
}

Dao层：