定时备份数据库表

 

/**
 * @author 作者 :dengxiangyu
 * @version 创建时间：2019年4月8日 下午4:35:06
 * 
 */
@Component
public class SdnBackup {

  private static final Logger logger = LoggerFactory.getLogger(SdnBackup.class);
  @Autowired
  private SdnBackupMapper sdnBackupMapper;

  @Value("${hz.kakashi.sdn.table}")
  String tables;

  //每晚六点备份
  @Scheduled(cron = "0 0 18 * * ? ")
  public void timing() {
    logger.info("sdn开始备份");
    backup();
    logger.info("sdn备份完成");
    clean();
    logger.info("sdn30天前备份表删除完成");
  }

  /**
   * 备份
   */
  public void backup() {
    SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd");
    String date = df.format(new Date());
    List<String> list = Arrays.asList(tables.split(","));
    for (String table : list) {
      sdnBackupMapper.backup(table, table + "_" + date);
    }
  }

  /**
   * 删除一个月前备份
   */
  public void clean() {
    SimpleDateFormat df = new SimpleDateFormat("yyyyMMdd");
    Calendar c = Calendar.getInstance();
    c.setTime(new Date());
    c.add(Calendar.DATE, -30);
    Date d = c.getTime();
    String day = df.format(d);
    List<String> list = Arrays.asList(tables.split(","));
    for (String table : list) {
      try {
        sdnBackupMapper.delete(table + "_" + day);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
}