JSP课程设计报告

继续购物 清空购物车 5.增删查改的功能模块 增删查改的功能嵌套在buy.jsp里，实现对商品的添加、删除、修改、查询的功能。 if (op.equals(\)){ //从商品库中取出所选购商品的数据 String bm = request.getParameter(\); String name=null,price=null; sql = \; pstat = conn.prepareStatement(sql); pstat.setString(1,bm); rs = pstat.executeQuery(); if (rs.next()){ name = rs.getString(\).trim(); price = rs.getString(\).trim(); } rs.close(); pstat.close(); //将所选购商品加入到购物车中 sql = \values(?,?,?,?)\; pstat = conn.prepareStatement(sql); pstat.setString(1,name); pstat.setString(2,price); pstat.setInt(3,1); pstat.setString(4,price); pstat.executeUpdate(); pstat.close(); //关闭数据库连接 conn.close(); //重定向到购物车页面 response.sendRedirect(\); } //更改商品的数量 if (op.equals(\)){ int id = Integer.parseInt(request.getParameter(\)); int num = Integer.parseInt(request.getParameter(\)); double price=Double.parseDouble(request.getParameter(\)); sql = \; pstat = conn.prepareStatement(sql); pstat.setInt(1,num); pstat.setString(2,new Double(price*num).toString()); pstat.setInt(3,id); pstat.executeUpdate(); pstat.close(); conn.close(); response.sendRedirect(\); } //将商品退回到商品架(将商品从购物车中删除) if (op.equals(\)){ int id = Integer.parseInt(request.getParameter(\)); sql = \; pstat = conn.prepareStatement(sql); pstat.setInt(1,id); pstat.executeUpdate(); pstat.close(); conn.close(); response.sendRedirect(\); } //清空购物车 if (op.equals(\)){ sql = \; pstat = conn.prepareStatement(sql); pstat.executeUpdate(); pstat.close(); conn.close(); response.sendRedirect(\); }