java插入数据时为什么有时能执行到触发器,有时又不行
这是触发器代码:
CREATE TRIGGER [TRIGGERINSERT] ON dbo.Customers
FOR INSERT
AS
DECLARE @AMOUNT INT
SELECT @AMOUNT=PRODUCT_AMOUNT FROM PRODUCT
SET @AMOUNT= @AMOUNT-1
UPDATE PRODUCT SET PRODUCT_AMOUNT=@AMOUNT WHERE PRODUCT_ID=(SELECT PRODUCT_ID FROM INSERTED)
这是java代码:
String sql="insert into Customers(custom_name,employ_id,custom_date,product_id,product_total,total_price) values('text',1,1,'2008-05-20',1,2,50)";
Connection con=super.getCon();
PreparedStatement pstm=null;
boolean result=false;
try {
pstm=con.prepareStatement(sql);
pstm.execute();
result =true;
} catch (SQLException e) {
System.err.println(e.getMessage());
e.printStackTrace();
}
连续插入两条记录,为什么只执行一次触发器,这个问题怎么解决?