修改事务回滚异常

admin

2019-12-19 79ea414897eba7feca498ae96474349a03bb7b1c

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
package com.yeshi.fanli.service.impl.homemodule; 
 
import java.util.ArrayList; 
import java.util.List; 
 
import javax.annotation.Resource; 
 
import org.springframework.stereotype.Service; 
import org.springframework.transaction.annotation.Transactional; 
import org.yeshi.utils.tencentcloud.COSManager; 
 
import com.yeshi.fanli.dao.mybatis.homemodule.SwiperBannerMapper; 
import com.yeshi.fanli.entity.bus.homemodule.SwiperBanner; 
import com.yeshi.fanli.entity.bus.homemodule.SwiperPicture; 
import com.yeshi.fanli.exception.banner.SwiperBannerException; 
import com.yeshi.fanli.service.inter.homemodule.SwiperBannerService; 
import com.yeshi.fanli.service.inter.homemodule.SwiperPictureService; 
import com.yeshi.fanli.util.StringUtil; 
 
@Service 
public class SwiperBannerServiceImpl implements SwiperBannerService { 
 
    @Resource 
    private SwiperBannerMapper swiperBannerMapper; 
     
    @Resource 
    private SwiperPictureService swiperPictureService; 
     
     
    @Override 
    public int deleteByPrimaryKey(Long id){ 
        return swiperBannerMapper.deleteByPrimaryKey(id); 
    } 
 
    @Override 
    public int insert(SwiperBanner record){ 
        return swiperBannerMapper.insert(record); 
    } 
 
    @Override 
    public int insertSelective(SwiperBanner record){ 
        return swiperBannerMapper.insertSelective(record); 
    } 
 
    @Override 
    public SwiperBanner selectByPrimaryKey(Long id){ 
        return swiperBannerMapper.selectByPrimaryKey(id); 
    } 
 
    @Override 
    public int updateByPrimaryKeySelective(SwiperBanner record) throws SwiperBannerException{ 
        return swiperBannerMapper.updateByPrimaryKeySelective(record); 
    } 
 
    @Override 
    public int updateByPrimaryKey(SwiperBanner record) { 
        return swiperBannerMapper.updateByPrimaryKey(record); 
    } 
 
    @Override 
    public List<SwiperBanner> query(long start, int count, String key, Integer sort) throws SwiperBannerException{ 
        return swiperBannerMapper.query(start, count, key, sort); 
    } 
 
    @Override 
    public long countQuery(String key) throws SwiperBannerException{ 
        return swiperBannerMapper.countQuery(key); 
    } 
 
    @Override 
    @Transactional(rollbackFor=Exception.class) 
    public int deleteBatchByPrimaryKey(List<Long> list) throws Exception { 
         
        List<Long> listPicID = new ArrayList<Long>(); 
         
        List<SwiperPicture> listPic = swiperPictureService.queryByListBannerID(list); 
        for (SwiperPicture swiperPicture: listPic) { 
            String src = swiperPicture.getSrc(); 
            if (!StringUtil.isNullOrEmpty(src)) { 
                COSManager.getInstance().deleteFile(src); 
            } 
            listPicID.add(swiperPicture.getId()); 
        } 
         
        if (listPicID.size() > 0) { 
            swiperPictureService.deleteBatchByPrimaryKey(listPicID); 
        } 
         
        return swiperBannerMapper.deleteBatchByPrimaryKey(list); 
    } 
     
    @Override 
    public List<SwiperBanner> getEffectiveOption() { 
        return swiperBannerMapper.getEffectiveOption(); 
    } 
}