当前位置：主页 > 经验教程 > 建站编程 >

JavaWeb:servlet+jsp+mybatis商品管理增删改查

JavaWeb:servlet+jsp+mybatis商品管理增删改查(3)

时间：2024-01-21 13:23:02 来源：IT袋作者：马勇

导读：JavaWeb:servlet+jsp+mybatis商品管理增删改查，在修改页面进行数据修改，点击提交按钮，会将数据提交到后端程序，后端程序会对表中的数据进行修改操作，然后重新进行数据的查询操作。整体流

JavaWeb:servlet+jsp+mybatis商品管理增删改查

JavaWeb:servlet+jsp+mybatis商品管理增删改查

在修改页面进行数据修改，点击提交按钮，会将数据提交到后端程序，后端程序会对表中的数据进行修改操作，然后重新进行数据的查询操作。

整体流程如下：

JavaWeb:servlet+jsp+mybatis商品管理增删改查

功能实现

1、编写BrandMapper方法

在 BrandMapper 接口，在接口中定义 update(Brand brand) 方法

@Update("update tb_brand set brand_name = #{brandName},company_name = #{companyName},ordered = #{ordered},description = #{description},status = #{status} where id = #{id};")
void updateBrand(Brand brand);

2、编写BrandService方法

在 BrandService 类中定义根据id查询数据方法 update(Brand brand)

public void updateBrand(Brand brand) {
    SqlSession sqlSession = MyBatisUtils.openSession();
    BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
    mapper.updateBrand(brand);
    sqlSession.commit();
    sqlSession.close();
}

3、编写servlet 在 web 包下创建 updateServlet

@WebServlet(value = "/updateServlet")
public class UpdateServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        Brand brand = new Brand();
        Map<String, String[]> parameterMap = request.getParameterMap();
        try {
            BeanUtils.populate(brand,parameterMap);
            BrandService brandService = new BrandService();
            brandService.updateBrand(brand);
            response.sendRedirect("selectAllServlet");
        } catch (IllegalAccessException e) {
            throw new RuntimeException(e);
        } catch (InvocationTargetException e) {
            throw new RuntimeException(e);
        }
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        doGet(request,response);
    }
}

4、编写前端页面

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改品牌</title>
</head>
<body>
<h3>修改品牌</h3><form action="updateServlet" method="post">
    <input type="hidden" name="id" value="${brand.id}">
    品牌名称：<input name="brandName" value="${brand.brandName}"><br>
    企业名称：<input name="companyName" value="${brand.companyName}"><br>
    排序：<input name="ordered" value="${brand.ordered}"><br>
    描述信息：<textarea rows="5" cols="20" name="description">${brand.description}</textarea><br>
    状态：
    <c:if test="${brand.status == 0}">
        <input type="radio" name="status" value="0" checked>禁用
        <input type="radio" name="status" value="1">启用<br>
    </c:if>
    <c:if test="${brand.status == 1}">
        <input type="radio" name="status" value="0">禁用
        <input type="radio" name="status" value="1" checked>启用<br>
    </c:if>
    <input type="submit" value="提交">
</form>
</body>
</html>

2.5、删除数据

1、编写servlet 在 web 包下创建 DeleteServlet

@WebServlet(value = "/deleteByIdServlet")
public class DeleteByIdServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String idStr = request.getParameter("id");
        int id = Integer.parseInt(idStr);
        BrandService brandService = new BrandService();
        brandService.deleteBrand(id);
        response.sendRedirect("selectAllServlet");
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        doGet(request,response);
    }
}

2、编写BrandService方法

在 BrandService 类中定义根据id查询数据方法 deleteBrand(int id)

public void deleteBrand(int id) {
    SqlSession sqlSession = MyBatisUtils.openSession();
    BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
    mapper.deleteBrand(id);
    sqlSession.commit();
    sqlSession.close();
}

3、编写BrandMapper方法

在 BrandMapper 接口，在接口中定义 deleteBrand(int id) 方法

@Delete("delete from tb_brand where id = #{id}")
void deleteBrand(int id);

上述的关于JavaWeb:servlet+jsp+mybatis商品管理增删改查的全面介绍了，希望给IT袋网网的网友们带来一些相关知识。

IT袋