@EnableScheduling //開(kāi)啟任務(wù)調(diào)度
@SpringBootApplication
public class UploadApplication {
    public static void main(String[] args) {
        SpringApplication.run(UploadApplication.class, args);
    }
}

//mapper
//獲取僵尸token的id
List<Integer> selectDeadTokens();
//清除僵尸數(shù)據(jù)
int deleteDeadToken(@Param("ids") List<Integer> ids);

<delete id="deleteDeadToken">
       delete from imagetoken where id in
       <foreach collection="ids" item="e" open="(" separator="," close=")">
           #{e}
       </foreach>
</delete>
<select id="selectDeadTokens" resultType="java.lang.Integer">
        SELECT id FROM imagetoken t
        WHERE t.token NOT IN (select token FROM good)
</select>

//service 
@Transactional(propagation = Propagation.REQUIRED,isolation = Isolation.SERIALIZABLE)
    @Override
    public void deleteDeadToken() {
        System.out.println("---開(kāi)始清除所有僵尸token---");
        List<Integer> list = imagetokenMapper.selectDeadTokens();
        System.out.println("已找到"+list.size()+"條數(shù)據(jù)");
        if (list.size()>0) {
            int result = imagetokenMapper.deleteDeadToken(list);
            System.out.println("本次刪除"+result+"條數(shù)據(jù)");
        }
    }

 @Override
    public List<String> getList() {
        //條件構(gòu)造器 查存放地址
        LambdaQueryWrapper<Good> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.select(Good::getSavepath);
        //this指的是當(dāng)前service
        List<Good> list = this.list(queryWrapper);
//        System.out.println("查詢到的數(shù)據(jù):");
//        System.out.println(list);
        //獲取數(shù)據(jù)庫(kù)中所有圖片的絕對(duì)路徑List<String>
        ArrayList<String> paths = new ArrayList<>();
        //將查到的數(shù)據(jù)中的文件地址遍歷到String類型的list中
        list.stream().forEach(good -> {
            paths.add(good.getSavepath());
        });
        //System.out.println("查到的路徑:"+paths);
        return  paths;
    }

@Value("${image.savepath}")
    String savePath;
    /**
     * 每天晚上23點(diǎn)清除無(wú)效token數(shù)據(jù)并刪除圖片
     */
    @Scheduled(cron = "0 0 23 * * ?")
    public void delete(){
        //1.清除無(wú)效token
        imagetokenService.deleteDeadToken();
        //2.刪除僵尸文件
        //2.1獲取數(shù)據(jù)庫(kù)中文件存儲(chǔ)列表
        List<String> paths = goodService.getList();
        //2.2 獲取圖片存儲(chǔ)地址
        File target=new File(savePath);
        //2.3遍歷圖片存儲(chǔ)所在文件夾的文件
        File[] files=target.listFiles();
        for (File file : files) {
            if (file.isFile()){
                //2.4獲取存儲(chǔ)文件的絕對(duì)地址,需要將盤(pán)符修改,
                String absPath = file.getAbsolutePath().replaceAll("\\\\", "/");
                //2.5將不存在的文件刪除
                if(!paths.contains(absPath)){
                     //System.out.println("要?jiǎng)h除文件的覺(jué)得路徑:"+absPath);
                     file.delete();
                 }
            }
        }
    }