package com.uas;

import com.uas.main.DownloadStcockQty;
import com.uas.util.BaseUtil;
import com.uas.util.JdbcUtil;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.scheduling.annotation.EnableScheduling;
import org.springframework.scheduling.annotation.Scheduled;

import java.util.Date;

import static com.uas.main.Download.downloadRun;
import static com.uas.main.DownloadFilePath.runDownloadFilePath;
import static com.uas.main.Upload.uploadRun;

@SpringBootApplication
@EnableScheduling
public class HSLApplication {

    public static void main(String[] args) {
        SpringApplication.run(HSLApplication.class, args);
    }

    @Scheduled(fixedRate=1000*60*5)
    public void ediSendAndReceive() {
        uploadRun();
        downloadRun();
        closeJDBC();
    }

    @Scheduled(fixedRate=1000*60*60)
    public void downloadStcockQty() {
        DownloadStcockQty.downloadQty();
        closeJDBC();
    }


    @Scheduled(fixedRate=1000*60*60)
    public void filePath() {
        runDownloadFilePath();
        closeJDBC();
     }

    private void closeJDBC(){
        try{ //关闭数据库连接
            if(JdbcUtil.connection!=null){
                JdbcUtil.connection.close();
            }
        }catch(Exception e){
            BaseUtil.getLogger().error(e.toString());
            e.printStackTrace();
        }finally{
            JdbcUtil.connection = null;
        }
    }

}