JavaWed(页面的添加，页面的删除)

最新推荐文章于 2024-05-14 23:25:13 发布

灰太狼吃羊羊

最新推荐文章于 2024-05-14 23:25:13 发布

阅读量143

点赞数

文章标签： java sql 数据库

本文链接：https://blog.csdn.net/m0_65474726/article/details/129188848

版权

本节要点:页面的添加，页面的删除

1.页面的添加(方法)

public int add(Goods goods) {
        try {
            //获取数据的链接
            connection = JDBCUtil.kai();
            //定义一个sql语句
            String sql = "insert into t_goods(gname,price,mark) values(?,?,?)";
            //获取处理对象
            pstm = connection.prepareStatement(sql);
            //传参
            pstm.setObject(1,goods.getGname());
            pstm.setObject(2, goods.getPrice());
            pstm.setObject(3,goods.getMark());
//执行SQL语句
            row = pstm.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtil.ends(connection, pstm);
        }

        return row;
    }

第二步(使用JDBC)，这种的添加，删除，修改分为三步走 1.执行中文编译，获取传参

2.执行JDBC 3.判断是否

  @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //中文设置
        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");

        Goods goods = new Goods();
        goods.setGname(req.getParameter("gname"));
        goods.setPrice(Double.parseDouble(req.getParameter("price")));
        goods.setMark(req.getParameter("mark"));
        //执行jdbc
        GoodsDao goodsDao = new GoodsDao();
        int row = goodsDao.add(goods);

        //判断
        if (row > 0) {
            req.getRequestDispatcher("Chaxun").forward(req, resp);
        } else {
            req.setAttribute("error_msg", "添加信息失败!");
            req.getRequestDispatcher("error.jsp").forward(req, resp);
        }
    }

页面信息

<body>
<form action="addGoods" method="post">
    商品信息:<input type="text" name="gname" value=""/><br/>
    商品价格:<input type="number" step="0.01" name="price" value=""/><br/>
    商品说明:<input type="text" name="mark" value=""/><br/>
    <input type="submit"  value="提交"/>


</form>
</body>

2.页面信息的删除(int类型，传参为gid)

 public int del(int gid) {
        try {
            //获取数据的链接
            connection = JDBCUtil.kai();
            //定义一个sql语句
            String sql =  "delete  from t_goods where gid=?";
            //获取处理对象
            pstm = connection.prepareStatement(sql);
            //传参
            pstm.setObject(1,gid);
//执行SQL语句
            row = pstm.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtil.ends(connection, pstm);
        }

        return row;
    }

第二部(使用删除的方法)


    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        
        int gid = Integer.parseInt(req.getParameter("gid"));
        //执行JDBC
        GoodsDao goodsDao = new GoodsDao();
        int row = goodsDao.del(gid);
        
        
        if (row > 0) {
            req.getRequestDispatcher("Chaxun").forward(req, resp);
        } else {
            req.setAttribute("error_msg", "添加信息失败!");
            req.getRequestDispatcher("error.jsp").forward(req, resp);
        }
    }

删除页面(${信息录入})

<body>
<a href="addGoods.jsp">添加商品</a>
<table>
    <tr>
        <th>商品编号</th>
        <th>商品名称</th>
        <th>商品价格</th>
        <th>商品说明</th>
        <th>操作</th>
    </tr>

    <c:forEach items="${goodsList}" var="goods">
        <tr>
            <td>${goods.gid}  </td>
            <td>${goods.gname}</td>
            <td>${goods.price}</td>
            <td>${goods.mark}</td>
            <td><a href="#">修改</a></td>
            <td><a href="del?gid=${goods.gid}">删除</a></td>
        </tr>

    </c:forEach>

</table>

</body>