jsp修改订单数量

<form action="updateOrderQuantity" method="post">
    订单ID: <input type="text" name="orderId" required><br>
    新数量: <input type="number" name="newQuantity" required><br>
    <input type="submit" value="更新数量">
</form>

@WebServlet("/updateOrderQuantity")
public class UpdateOrderQuantityServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String orderId = request.getParameter("orderId");
        int newQuantity = Integer.parseInt(request.getParameter("newQuantity"));
        
        // 调用业务逻辑层方法更新订单数量
        OrderService orderService = new OrderService();
        boolean success = orderService.updateOrderQuantity(orderId, newQuantity);
        
        if(success){
            response.sendRedirect("success.jsp");
        }else{
            response.sendRedirect("error.jsp");
        }
    }
}

public class OrderService {
    public boolean updateOrderQuantity(String orderId, int newQuantity) {
        // 数据库连接及更新操作
        try (Connection conn = DatabaseUtil.getConnection()) {
            String sql = "UPDATE orders SET quantity = ? WHERE id = ?";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, newQuantity);
            pstmt.setString(2, orderId);
            int affectedRows = pstmt.executeUpdate();
            return affectedRows > 0;
        } catch (SQLException e) {
            e.printStackTrace();
            return false;
        }
    }
}