不带事物的插入结果,一半成功一半失败
//模拟插入4条数据
public boolean Insert4Data(){
userMapperPrimary.insert("A", 1);
userMapperPrimary.insert("B", 2);
//手动报错
int a = Integer.parseInt("aaaa");
userMapperPrimary.insert("C", 3);
userMapperPrimary.insert("D", 4);
return true;
}
AB入库、CD丢失
带事物的插入,在Service层加@Transactional事物注解即可
@Transactional
//模拟插入4条数据
public boolean Insert4Data(){
userMapperPrimary.insert("A", 1);
userMapperPrimary.insert("B", 2);
//手动报错
int a = Integer.parseInt("aaaa");
userMapperPrimary.insert("C", 3);
userMapperPrimary.insert("D", 4);
return true;
}
执行结果:全部都没插入成功