触发器删除
drop trigger trig_oilApply //trig_oilApply 触发器名称
创建触发器 == 从另一张表中把保存的id拿到
create trigger trig_oilApply
on [DBModel].[dbo].[Tab_万金分油申请表]
after insert
as
begin
if object_id(N’oilApply_id’,N’U’) is null–判断student_sum表是否存在
create table oilApply_id(saveRecordNo int default(0));–创建存储学生人数的student_sum表
declare @id int;
select @id = count(*)from [DBModel].[dbo].[Tab_万金分油申请表];
if not exists (select * from oilApply_id)–判断表中是否有记录
insert into oilApply_id values(0);
update oilApply_id set saveRecordNo =@id; --把更新后总的学生数插入到student_sum表中
end
最大id【记录编号】万一有删除的数据 用count(*)就会不正确//记录编号就是主键
create trigger trig_oilApply
on [DBModel].[dbo].[Tab_万金分油申请表]
after insert
as
begin
if object_id(N’oilApply_id’,N’U’) is null–判断student_sum表是否存在
create table oilApply_id(saveRecordNo int default(0));–创建存储学生人数的student_sum表
declare @id int;
select @id = max([记录编号]) from [DBModel].[dbo].[Tab_万金分油申请表] ;
if not exists (select * from oilApply_id)–判断表中是否有记录
insert into oilApply_id values(0);
update oilApply_id set saveRecordNo =@id; --把更新后总的学生数插入到student_sum表中
end
mybatis xml 写法
saveRecordNo 是 ApplyOilBean类的属性 并且给了getter和setter
SELECT saveRecordNo from oilApply_id
insert INTO [DBModel].[dbo].[Tab_万金分油申请表] ( [记录编号] ,[司机编号] ,[司机姓名] ,[