基于Java web开发的网上书店系统

USE [WSSD] GO /****** Object: Trigger [dbo].[reduce_stock] Script Date: 2018/1/4 10:49:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[reduce_stock] on [dbo].[order_item] AFTER INSERT AS DECLARE @book_quantity int ,@book_id numeric(20) select @book_quantity=quantity from inserted select @book_id=book_id from inserted update stock set stock_quantity=stock_quantity-@book_quantity where book_id=@book_id USE [WSSD] GO /****** Object: Trigger [dbo].[update_price] Script Date: 2018/1/4 10:50:03 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER trigger [dbo].[update_price] on [dbo].[order_item] after insert ,update as declare @total_price money ,@order_id varchar(20) select @total_price=sum(subtotal) from order_item where order_id=(select order_id from inserted) update [order] set order_price=@total_price where order_id=(select order_id from inserted) USE [WSSD] GO /****** Object: Trigger [dbo].[update_stock] Script Date: 2018/1/4 10:50:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER trigger [dbo].[update_stock] on [dbo].[order_item] after update as declare @number1 int ,@number2 int,@book_id numeric(20) select @number1=quantity from deleted select @number2=quantity from inserted update stock set stock_quantity=stock_quantity+@number1-@number2 where book_id=(select book_id from inserted) USE [WSSD] GO /****** Object: Trigger [dbo].[update_amount] Script Date: 2018/1/4 10:50:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER trigger [dbo].[update_amount] on [dbo].[stock] after insert ,update as declare @quantity int,@purchase_price money select @quantity=stock_quantity from stock where stock_id=(select stock_id from inserted) select @purchase_price=purchase_price from book where book_id=(select book_id from inserted) update stock set stock_amount=@quantity*@purchase_price where stock_id=(select stock_id from inserted)