| | |
| | | |
| | | import java.io.BufferedReader; |
| | | import java.io.File; |
| | | import java.io.FileInputStream; |
| | | import java.io.FileOutputStream; |
| | | import java.io.FileWriter; |
| | | import java.io.IOException; |
| | |
| | | import java.io.InputStreamReader; |
| | | import java.nio.charset.StandardCharsets; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.Date; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Properties; |
| | | import java.util.zip.ZipEntry; |
| | | import java.util.zip.ZipOutputStream; |
| | | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.alibaba.druid.util.StringUtils; |
| | |
| | | import com.jcraft.jsch.SftpException; |
| | | import com.jcraft.jsch.SftpProgressMonitor; |
| | | import com.product.core.config.Global; |
| | | import com.product.core.dao.BaseDao; |
| | | import com.product.core.entity.DataTableEntity; |
| | | import com.product.core.entity.FieldSetEntity; |
| | | import com.product.core.service.support.AbstractBaseService; |
| | | import com.product.system.backup.entity.BackupLogger; |
| | | import com.product.system.backup.util.SystemBackupUtil; |
| | | |
| | | /** |
| | | * ç³»ç»å¤ä»½ |
| | | * æ°æ®åºå¤ä»½ï¼æ¯å¤©æ§è¡ä»£ç å¤ä»½ |
| | | * éä»¶å¤ä»½ï¼æ¯å¤©æ§è¡ä»£ç å¤ä»½å½å¤©éä»¶ |
| | | * éçé®é¢ï¼é件被修æ¹ï¼ä¸è½éå®éå½å¤©è¢«ä¿®æ¹çéä»¶ |
| | | */ |
| | | @Service("systemBackService1") |
| | | public class SystemBackupService { |
| | | @Service("systemBackService") |
| | | public class SystemBackupService extends AbstractBaseService{ |
| | | |
| | | @Autowired |
| | | BaseDao baseDao; |
| | | |
| | | // å¤ä»½é
ç½® |
| | | Properties config; |
| | |
| | | // æ°åæ¶é´åæ°åæ¥æï¼ç¨åæä»¶å¤¹æè
æä»¶åï¼ |
| | | String NUMBER_TIME; //ä¾å¦ï¼20250428091001ï¼ |
| | | String NUMBER_DATE; //ä¾å¦ï¼20240428ï¼ |
| | | String STANDARD_START_TIME; // ä¾å¦ï¼2024-04-28 09:10:00ï¼ |
| | | String STANDARD_FINAL_TIME; // ä¾å¦ï¼2024-04-28 09:10:00ï¼ |
| | | |
| | | // æ°åæ¥ææ ¼å¼ |
| | | SimpleDateFormat numberTimeFormat = new SimpleDateFormat("yyyyMMddHHmmss"); |
| | | SimpleDateFormat numberTimeFormat = new SimpleDateFormat("yyyyMMddHHmm00"); |
| | | SimpleDateFormat numberDateFormat = new SimpleDateFormat("yyyyMMdd"); |
| | | SimpleDateFormat standardTimeFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:00"); |
| | | |
| | | // å¤ä»½é
ç½®æä»¶ |
| | | private static final String CONFIG_FILE_PATH = "systemBackup.properties"; |
| | | |
| | | /** |
| | | * ç³»ç»å¤ä»½å
¥å£ |
| | | * ç³»ç»å¤ä»½å¤å® |
| | | * è°ç¨å°ç¹ï¼å®æ¶ä»»å¡é
ç½®åè½(bean) |
| | | */ |
| | | public void systemBackupInit(){ |
| | | // åå§æ¥å¿æä»¶ |
| | | log = new BackupLogger(); |
| | | // 卿¥å¿ä¸è®°å½æä½ç³»ç»ä¿¡æ¯ï¼ä¾¿äºè°è¯ |
| | | log.writeInfo("ãç³»ç»å¤ä»½å
¥å£ãæä½ç³»ç»: " + System.getProperty("os.name"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãç³»ç»å¤ä»½å
¥å£ãæä»¶åé符: " + File.separator, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãç³»ç»å¤ä»½å
¥å£ãç³»ç»å¤ä»½å¼å§..................", BackupLogger.INFO_TYPE); |
| | | NUMBER_TIME = numberTimeFormat.format(new Date()); |
| | | NUMBER_DATE = numberDateFormat.format(new Date()); |
| | | log.writeInfo("ãç³»ç»å¤ä»½å
¥å£ãç³»ç»æ¥æï¼" + NUMBER_DATE, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãç³»ç»å¤ä»½å
¥å£ãç³»ç»æ¶é´ï¼" + NUMBER_TIME, BackupLogger.INFO_TYPE); |
| | | // è¿å
¥å¤ä»½è¿ç¨ |
| | | backupProcess(); |
| | | log.closeLogger(); |
| | | public void systemBackupInit() { |
| | | // è·åç³»ç»æ¶é´ |
| | | Date finalTime = new Date(); |
| | | Date startTime = null; |
| | | // è·åç³»ç»å¤ä»½å¨æ(åé) |
| | | int backupCycle = Integer.valueOf(Global.getSystemConfig("SYSTEM_BACK_CYCLE", "1440")); |
| | | // è·åç³»ç»æå¤§å¤ä»½æ¶é´ |
| | | StringBuilder sbSql = new StringBuilder(); |
| | | sbSql.append("SELECT TIMESTAMPDIFF(MINUTE, end_time, ?) AS diff_minutes,end_time \n"); |
| | | sbSql.append("FROM product_sys_backup_log \n"); |
| | | sbSql.append("WHERE backup_status = 1 \n"); |
| | | sbSql.append("ORDER BY end_time DESC \n"); |
| | | sbSql.append("LIMIT 1 \n"); |
| | | FieldSetEntity fseMaxLogTime = baseDao.getFieldSetEntityBySQL(sbSql.toString(), new Object[] {standardTimeFormat.format(finalTime)}, false); |
| | | if(fseMaxLogTime != null && !StringUtils.isEmpty(fseMaxLogTime.getString("diff_minutes"))) { |
| | | Integer diffMinutes = fseMaxLogTime.getInteger("diff_minutes"); |
| | | if (diffMinutes < backupCycle) { |
| | | // å°äºå¤ä»½å¨æï¼ä¸å¤ä»½ |
| | | return ; |
| | | } |
| | | startTime = fseMaxLogTime.getDate("end_time"); |
| | | } |
| | | // åå§å¤ä»½æ¥å¿æ°æ® |
| | | FieldSetEntity fseBackLog = new FieldSetEntity("product_sys_backup_log"); |
| | | fseBackLog.setValue("start_time", startTime); |
| | | fseBackLog.setValue("end_time", finalTime); |
| | | |
| | | // æ§è¡å¤ä»½ |
| | | boolean flag = backupProcess(startTime, finalTime); |
| | | if (flag) { |
| | | fseBackLog.setValue("backup_status", 1); |
| | | } else { |
| | | fseBackLog.setValue("backup_status", 0); |
| | | } |
| | | // ä¿åæ¥å¿ |
| | | baseDao.saveFieldSetEntity(fseBackLog); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * æ°æ®å¤ä»½è¿ç¨ |
| | | * æ°æ®å¤ä»½è¿ç¨ |
| | | * @param startTime å¤ä»½å¼å§æ¶é´ |
| | | * @param finalTime å¤ä»½æªæ¢æ¶é´ |
| | | * @return |
| | | */ |
| | | public void backupProcess() { |
| | | public boolean backupProcess(Date startTime, Date finalTime) { |
| | | // åå§æ¥å¿æä»¶ |
| | | log = new BackupLogger(); |
| | | log.writeInfo("ãç³»ç»å¤ä»½è¿ç¨ãç³»ç»å¤ä»½è¿ç¨å¼å§..................", BackupLogger.INFO_TYPE); |
| | | long start = System.currentTimeMillis(); |
| | | boolean status= true; |
| | | // ç¬¬ä¸æ¥ï¼åå§é
æä»¶åæ°,å½åç®çææ¶é´æ³çæä»¶å¤¹ |
| | | status = initSystemConfig(); |
| | | // ç¬¬ä¸æ¥ï¼åå§å¤ä»½åæ° |
| | | initBackupParam(startTime, finalTime); |
| | | // ç¬¬äºæ¥ï¼åå§é
æä»¶åæ°,å½åç®çææ¶é´æ³çæä»¶å¤¹ |
| | | boolean status = initSystemConfig(); |
| | | if (!status) |
| | | return; |
| | | // ç¬¬äºæ¥ï¼æ§è¡æ°æ®åºå¤ä»½ |
| | | return false; |
| | | // ç¬¬ä¸æ¥ï¼æ§è¡æ°æ®åºå¤ä»½ |
| | | status = runExpDataBase(); |
| | | if (!status) |
| | | return; |
| | | // ç¬¬ä¸æ¥ï¼æ§è¡å¯¹æ°æ®åºæä»¶ãå·¥ç¨ä»£ç ãä¸ä¼ æä»¶åå缩å¤ä»½ |
| | | return false; |
| | | // ç¬¬åæ¥ï¼æ§è¡å¯¹æ°æ®åºæä»¶ãå·¥ç¨ä»£ç ãä¸ä¼ æä»¶åå缩å¤ä»½ |
| | | status = zipDataBackup(); |
| | | if (!status) |
| | | return; |
| | | // ç¬¬åæ¥ï¼ä¸ä¼ å缩å¤ä»½æä»¶å°FTP |
| | | status = sftpTransferService(true); |
| | | // uploadBackupMachine2(); |
| | | return false; |
| | | // ç¬¬äºæ¥ï¼ä¸ä¼ å缩å¤ä»½æä»¶å°FTP |
| | | status = sftpTransferService(); |
| | | if (!status) |
| | | return; |
| | | // ç¬¬äºæ¥ï¼æ¸
餿°æ® |
| | | return false; |
| | | // 第å
æ¥ï¼æ¸
餿°æ® |
| | | // clearKeepData(); |
| | | |
| | | long end = System.currentTimeMillis(); |
| | | log.writeInfo("ãç³»ç»å¤ä»½è¿ç¨ãç³»ç»å¤ä»½è¿ç¨ç»æï¼èæ¶.................." + ((end - start) / 1000) + "ç§", BackupLogger.INFO_TYPE); |
| | | System.out.println("ç³»ç»å¤ä»½èæ¶.................." + ((end - start) / 1000) + "ç§"); |
| | | // å
³éæ¥å¿ |
| | | log.closeLogger(); |
| | | return status; |
| | | } |
| | | |
| | | /** |
| | | * ç¬¬ä¸æ¥ï¼åå§å¤ä»½åæ° |
| | | * @param startTime å¤ä»½å¼å§æ¶é´ |
| | | * @param finalTime å¤ä»½æªæ¢æ¶é´ |
| | | * @return |
| | | */ |
| | | public boolean initBackupParam(Date startTime, Date finalTime){ |
| | | // 卿¥å¿ä¸è®°å½æä½ç³»ç»ä¿¡æ¯ï¼ä¾¿äºè°è¯ |
| | | log.writeInfo("ãåå§å¤ä»½åæ°ãæä½ç³»ç»: " + System.getProperty("os.name"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§å¤ä»½åæ°ãæä»¶åé符: " + File.separator, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§å¤ä»½åæ°ãç³»ç»å¤ä»½å¼å§..................", BackupLogger.INFO_TYPE); |
| | | NUMBER_TIME = numberTimeFormat.format(finalTime); |
| | | NUMBER_DATE = numberDateFormat.format(finalTime); |
| | | if(startTime == null) { |
| | | STANDARD_START_TIME = "2000-01-01 00:00:00"; |
| | | } else { |
| | | STANDARD_START_TIME = standardTimeFormat.format(startTime); |
| | | } |
| | | STANDARD_FINAL_TIME = standardTimeFormat.format(finalTime); |
| | | log.writeInfo("ãåå§å¤ä»½åæ°ãç³»ç»æ¥æï¼" + NUMBER_DATE, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§å¤ä»½åæ°ãç³»ç»æ¶é´ï¼" + NUMBER_TIME, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§å¤ä»½åæ°ãç³»ç»å¤ä»½å¼å§æ¶é´ï¼" + STANDARD_START_TIME, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§å¤ä»½åæ°ãç³»ç»å¤ä»½æªæ¢æ¶é´ï¼" + STANDARD_FINAL_TIME, BackupLogger.INFO_TYPE); |
| | | |
| | | return true; |
| | | } |
| | | |
| | | /** |
| | | * ç¬¬ä¸æ¥ï¼åå§é
ç½®æä»¶åæ°,å½åç®å½çææ¶é´æ³çæä»¶å¤¹ |
| | | * ç¬¬äºæ¥ï¼åå§é
ç½®æä»¶åæ°,å½åç®å½çææ¶é´æ³çæä»¶å¤¹ |
| | | */ |
| | | public boolean initSystemConfig() { |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãå¼å§åå§ç³»ç»é
ç½®æä»¶..................", BackupLogger.INFO_TYPE); |
| | |
| | | // è·åç³»ç»æä»¶è·¯å¾ |
| | | String systemFileFolder = Global.getSystemConfig("local.dir", ""); |
| | | File newFile= new File(systemFileFolder); |
| | | // ç³»ç»éä»¶åæ¾ç®å½(å½å¤©éä»¶) |
| | | config.setProperty("DOCUMENT_ROOT", newFile.getAbsolutePath() + File.separator + "00000000-0000-0000-0000-000000000000" + File.separator + NUMBER_DATE); |
| | | // æ°æ®åºå¤ä»½ç®å½ï¼æ°æ®åºå¤ä»½æ ¹ç®å½+æ¶é´æä»¶å+.sqlï¼ |
| | | // ç³»ç»éä»¶åæ¾ç®å½ï¼../product-server-web/attachment/upload/ï¼ |
| | | config.setProperty("DOCUMENT_ROOT", newFile.getAbsolutePath()); |
| | | // æ°æ®åºå¤ä»½ç®å½ï¼æ°æ®åºå¤ä»½æ ¹ç®å½+æ¶é´æä»¶å+.sqlï¼ä¾å¦ï¼E://backup/database/20250101090000.sqlï¼ |
| | | config.setProperty("DATABASE_BACKUP", config.getProperty("DATABASE_ROOT") + File.separator + NUMBER_TIME + ".sql"); |
| | | // å¤ä»½ç®æ æä»¶ï¼ZIPå¤ä»½æ ¹ç®å½+æ¶é´æä»¶å+.zipï¼ |
| | | // å¤ä»½ZIPæä»¶ï¼ZIPå¤ä»½æ ¹ç®å½+æ¶é´æä»¶å+.zipï¼ä¾å¦ï¼E://backup/20250101090000.zipï¼ |
| | | config.setProperty("ZIPFILE_BACKUP", config.getProperty("ZIPFILE_ROOT") + File.separator + NUMBER_TIME + ".zip"); |
| | | // å建ZIPæä»¶æ ¹ç®å½ |
| | | File zipFileRoot = new File(config.getProperty("ZIPFILE_ROOT")); |
| | |
| | | return false; |
| | | } |
| | | } |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãDOCUMENT_ROOT=" + config.getProperty("DOCUMENT_ROOT"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãDATABASE_ROOT=" + config.getProperty("DATABASE_ROOT"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãDATABASE_BACKUP=" + config.getProperty("DATABASE_BACKUP"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãDOCUMENT_ROOT=" + config.getProperty("DOCUMENT_ROOT"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãDOCUMENT_BACKUP=" + config.getProperty("DOCUMENT_BACKUP"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãZIPFILE_ROOT=" + config.getProperty("ZIPFILE_ROOT"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãZIPFILE_BACKUP=" + config.getProperty("ZIPFILE_BACKUP"), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãåå§é
ç½®æä»¶ãåå§ç³»ç»é
ç½®æä»¶ç»æ.................", BackupLogger.INFO_TYPE); |
| | |
| | | } |
| | | |
| | | /** |
| | | * ç¬¬äºæ¥ï¼å¤ä»½æ°æ®åºæä»¶ |
| | | * ç¬¬ä¸æ¥ï¼å¤ä»½æ°æ®åºæä»¶ |
| | | */ |
| | | public boolean runExpDataBase() { |
| | | log.writeInfo("ãå¤ä»½æ°æ®åºãå¼å§å¤ä»½æ°æ®åº..................", BackupLogger.INFO_TYPE); |
| | |
| | | int exitCode = process.waitFor(); |
| | | if (exitCode == 0) { |
| | | log.writeInfo("ãå¤ä»½æ°æ®åºãæ°æ®åºå¤ä»½æåï¼" + backupFile.getAbsolutePath(), BackupLogger.INFO_TYPE); |
| | | // if (!"127.0.0.1".equals(databaseHost)) { |
| | | // è·åæ°æ®åºå¤ä»½æä»¶ |
| | | // return sftpTransferService(false); |
| | | // } |
| | | } else { |
| | | log.writeInfo("ãå¤ä»½æ°æ®åºãæ°æ®åºå¤ä»½å¤±è´¥ï¼éåºç : " + exitCode, BackupLogger.ERROR_TYPE); |
| | | } |
| | |
| | | return true; |
| | | } |
| | | |
| | | private static void addFolderToZip(File folder, String parentPath, ZipOutputStream zos) throws IOException { |
| | | File[] files = folder.listFiles(); |
| | | if (files != null) { |
| | | for (File file : files) { |
| | | if (file.isDirectory()) { |
| | | // éå½å¤çåç®å½ï¼ä¿æè·¯å¾ç»æ |
| | | addFolderToZip(file, parentPath + file.getName() + "/", zos); |
| | | } else { |
| | | // æ·»å æä»¶å°ZIPï¼ä¿æè·¯å¾ç»æ |
| | | addFileToZip(file, parentPath + file.getName(), zos); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | private static void addFileToZip(File file, String entryName, ZipOutputStream zos) throws IOException { |
| | | try (FileInputStream fis = new FileInputStream(file)) { |
| | | zos.putNextEntry(new ZipEntry(entryName)); |
| | | byte[] buffer = new byte[1024]; |
| | | int length; |
| | | while ((length = fis.read(buffer)) >= 0) { |
| | | zos.write(buffer, 0, length); |
| | | } |
| | | zos.closeEntry(); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * ç¬¬ä¸æ¥ï¼å缩å¤ä»½æä»¶ |
| | | */ |
| | | public boolean zipDataBackup() { |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãå¼å§å缩å¤ä»½æä»¶..................", BackupLogger.INFO_TYPE); |
| | | /** |
| | | * ç¬¬åæ¥ï¼æ§è¡å¯¹æ°æ®åºæä»¶ãå·¥ç¨ä»£ç ãä¸ä¼ æä»¶åå缩å¤ä»½ |
| | | * @return |
| | | */ |
| | | public boolean zipDataBackup() { |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãå¼å§å缩å¤ä»½æä»¶..................", BackupLogger.INFO_TYPE); |
| | | String documentPath = config.getProperty("DOCUMENT_ROOT"); |
| | | String databasePath = config.getProperty("DATABASE_BACKUP"); |
| | | String zipFilePath = config.getProperty("ZIPFILE_BACKUP"); |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãéä»¶åå¨ç®å½è·¯å¾ï¼" + documentPath, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãæ°æ®åºå¤ä»½å®æ´è·¯å¾ï¼" + databasePath, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãå¤ä»½å缩æä»¶å®æ´è·¯å¾ï¼" + zipFilePath, BackupLogger.INFO_TYPE); |
| | | try (FileOutputStream fos = new FileOutputStream(zipFilePath); |
| | | ZipOutputStream zos = new ZipOutputStream(fos)) { |
| | | |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãå缩系ç»éä»¶", BackupLogger.INFO_TYPE); |
| | | // å缩æä»¶å¤¹ï¼ä¿ç宿´è·¯å¾ç»æï¼ |
| | | // 注æï¼è¿éæä»¬ä¼ éäºæ ¹ç®å½åç§°ä½ä¸ºåå§parentPath |
| | | addFolderToZip(new File(documentPath), NUMBER_DATE + "/", zos); |
| | | |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãåç¼©æ°æ®åºå¤ä»½æä»¶", BackupLogger.INFO_TYPE); |
| | | // å缩SQLæä»¶ï¼æ¾å¨æå®è·¯å¾ä¸ï¼ |
| | | addFileToZip(new File(databasePath), "database/" + NUMBER_TIME + ".sql", zos); |
| | | |
| | | |
| | | try (FileOutputStream fos = new FileOutputStream(zipFilePath); |
| | | ZipOutputStream zos = new ZipOutputStream(fos)){ |
| | | StringBuilder sbSql = new StringBuilder(); |
| | | sbSql.append("SELECT SUBSTRING_INDEX(attachment_url, '/', -1) folder_name,attachment_title AS file_name,attachment_url AS folder_path \n"); |
| | | sbSql.append("FROM product_sys_attachments \n"); |
| | | sbSql.append("WHERE (created_utc_datetime > ? AND created_utc_datetime <= ?) \n"); |
| | | sbSql.append("OR (updated_utc_datetime > ? AND updated_utc_datetime <= ?) \n"); |
| | | DataTableEntity dtTable = baseDao.listTable(sbSql.toString(), new Object[] {STANDARD_START_TIME, STANDARD_FINAL_TIME, STANDARD_START_TIME, STANDARD_FINAL_TIME}); |
| | | if(dtTable != null && dtTable.getRows() > 0) { |
| | | Map<String, List<String>> groupFolderFile = new HashMap<>(); |
| | | for(int i = 0; i < dtTable.getRows(); i++) { |
| | | String folderName = dtTable.getFieldSetEntity(i).getString("folder_path"); |
| | | String fileName = dtTable.getFieldSetEntity(i).getString("file_name"); |
| | | if (groupFolderFile.containsKey(folderName)) { |
| | | groupFolderFile.get(folderName).add(fileName); |
| | | } else { |
| | | groupFolderFile.put(folderName, new ArrayList<String>(Arrays.asList(fileName))); |
| | | } |
| | | } |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãå缩系ç»å¢ééä»¶", BackupLogger.INFO_TYPE); |
| | | SystemBackupUtil.compressExistingFiles(groupFolderFile, documentPath, zos); |
| | | } |
| | | |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãåç¼©æ°æ®åºå¤ä»½æä»¶", BackupLogger.INFO_TYPE); |
| | | SystemBackupUtil.addFileToZip(new File(databasePath), "database/" + NUMBER_TIME + ".sql", zos); |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãåç¼©å®æ", BackupLogger.INFO_TYPE); |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | | return true; |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãå缩失败ï¼" + e.getMessage(), BackupLogger.ERROR_TYPE); |
| | | return false; |
| | | } |
| | | return true; |
| | | } |
| | | |
| | | } finally { |
| | | File file = new File(databasePath); |
| | | file.delete(); |
| | | log.writeInfo("ãå缩å¤ä»½æä»¶ãæ¸
çæ°æ®åºå¤ä»½æä»¶å®æ", BackupLogger.INFO_TYPE); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * SFTPè¿æ¥ï¼éè¿SFTPå°å¤ä»½æä»¶ä¸ä¼ å¤ç¨æº æ ä»mysqlæå¡å¨ä¸è·åå¤ä»½æä»¶ |
| | | * ç¬¬äºæ¥ï¼SFTPè¿æ¥ï¼éè¿SFTPå°å¤ä»½æä»¶ä¸ä¼ å¤ç¨æº æ ä»mysqlæå¡å¨ä¸è·åå¤ä»½æä»¶ |
| | | * @param isUpload æ¯å¦ä¸ä¼ |
| | | * @return |
| | | */ |
| | | public boolean sftpTransferService(boolean isUpload) { |
| | | String sftpTitle = null; |
| | | String localFilePath = null; |
| | | String sftpFilePath = null; |
| | | if(isUpload) { |
| | | sftpTitle = "ä¸ä¼ ç³»ç»å¤ä»½æä»¶"; |
| | | localFilePath = config.getProperty("ZIPFILE_BACKUP"); // æ¬å°æä»¶è·¯å¾ |
| | | sftpFilePath = config.getProperty("UPLOAD_BACKUP_DIR") + NUMBER_TIME + ".zip"; // SFTPæå¡æä»¶è·¯å¾ |
| | | } else { |
| | | // sftpTitle = "è·åæ°æ®åºå¤ä»½æä»¶"; |
| | | // localFilePath = config.getProperty("DATABASE_BACKUP"); // æ¬å°æä»¶è·¯å¾ |
| | | // sftpFilePath = config.getProperty("DATABASE_BACKUP"); // SFTPæå¡æä»¶è·¯å¾ |
| | | } |
| | | public boolean sftpTransferService() { |
| | | String localFilePath = config.getProperty("ZIPFILE_BACKUP"); // æ¬å°æä»¶è·¯å¾ |
| | | String sftpFilePath = config.getProperty("UPLOAD_BACKUP_DIR") + NUMBER_TIME + ".zip"; // SFTPæå¡æä»¶è·¯å¾; |
| | | |
| | | String host = config.getProperty("UPLOAD_SFTP_HOST"); // SFTPæå¡IPå°å |
| | | String port = config.getProperty("UPLOAD_SFTP_PORT"); // SSHç«¯å£ |
| | | String user = config.getProperty("UPLOAD_SFTP_USER"); // SFTPæå¡çç¨æ·å |
| | | String password = config.getProperty("UPLOAD_SFTP_PWD"); // SFTPæå¡çå¯ç |
| | | log.writeInfo(String.format("ã%sãå¼å§%s..................", sftpTitle, sftpTitle), BackupLogger.INFO_TYPE); |
| | | log.writeInfo(String.format("ã%sãSFTPæå¡å°åï¼", sftpTitle) + host, BackupLogger.INFO_TYPE); |
| | | log.writeInfo(String.format("ã%sãSFTPæå¡ç«¯å£ï¼", sftpTitle) + port, BackupLogger.INFO_TYPE); |
| | | log.writeInfo(String.format("ã%sãSFTPæå¡åå¨ç®å½ï¼", sftpTitle) + sftpFilePath, BackupLogger.INFO_TYPE); |
| | | log.writeInfo(String.format("ã%sãå½åæå¡åå¨ç®å½ï¼", sftpTitle) + localFilePath, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãå¼å§ä¸ä¼ ç³»ç»å¤ä»½æä»¶..................", BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãSFTPæå¡å°åï¼" + host, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãSFTPæå¡ç«¯å£ï¼" + port, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãSFTPæå¡åå¨ç®å½ï¼" + sftpFilePath, BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãå½åæå¡åå¨ç®å½ï¼" + localFilePath, BackupLogger.INFO_TYPE); |
| | | if (StringUtils.isEmpty(host) || StringUtils.isEmpty(port) || StringUtils.isEmpty(user) || StringUtils.isEmpty(password)) { |
| | | log.writeInfo(String.format("ã%sãSFTPä¿¡æ¯æªé
ç½®å®æ´ï¼ä¸äºè¿æ¥ä¼ è¾æä»¶", sftpTitle), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãSFTPä¿¡æ¯æªé
ç½®å®æ´ï¼ä¸äºè¿æ¥ä¼ è¾æä»¶", BackupLogger.INFO_TYPE); |
| | | return true; |
| | | } |
| | | try { |
| | |
| | | if (!remoteDir.startsWith("/")) { |
| | | remoteDir = "/" + remoteDir; |
| | | } |
| | | if(isUpload) { |
| | | // å建对åºç®å½æä»¶å¤¹ |
| | | createRemoteDirectory(sftpChannel, remoteDir); |
| | | sftpChannel.put(localFilePath, sftpFilePath, new SftpProgressMonitor() { |
| | | public void init(int op, String src, String dest, long max) { |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãå¼å§ä¼ è¾: " + src + " -> " + dest, BackupLogger.INFO_TYPE); |
| | | } |
| | | public boolean count(long count) { return true; } |
| | | public void end() { log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãä¼ è¾å®æ", BackupLogger.INFO_TYPE); } |
| | | }); |
| | | } else { |
| | | // å建对åºç®å½æä»¶å¤¹ |
| | | File fileDirectory = new File(remoteDir); |
| | | if (!fileDirectory.exists()) { |
| | | fileDirectory.mkdirs(); |
| | | // å建对åºç®å½æä»¶å¤¹ |
| | | createRemoteDirectory(sftpChannel, remoteDir); |
| | | sftpChannel.put(localFilePath, sftpFilePath, new SftpProgressMonitor() { |
| | | public void init(int op, String src, String dest, long max) { |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãå¼å§ä¼ è¾: " + src + " -> " + dest, BackupLogger.INFO_TYPE); |
| | | } |
| | | sftpChannel.get(localFilePath, sftpFilePath, new SftpProgressMonitor() { |
| | | public void init(int op, String src, String dest, long max) { |
| | | log.writeInfo("ãè·åæ°æ®åºå¤ä»½æä»¶ãå¼å§ä¼ è¾: " + src + " -> " + dest, BackupLogger.INFO_TYPE); |
| | | } |
| | | public boolean count(long count) { return true; } |
| | | public void end() { log.writeInfo("ãè·åæ°æ®åºå¤ä»½æä»¶ãä¼ è¾å®æ", BackupLogger.INFO_TYPE); } |
| | | }); |
| | | } |
| | | public boolean count(long count) { return true; } |
| | | public void end() { log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãä¼ è¾å®æ", BackupLogger.INFO_TYPE); } |
| | | }); |
| | | sftpChannel.exit(); |
| | | session.disconnect(); |
| | | log.writeInfo(String.format("ã%sã%sæå", sftpTitle, sftpTitle), BackupLogger.INFO_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãä¸ä¼ ç³»ç»å¤ä»½æä»¶æå", BackupLogger.INFO_TYPE); |
| | | } catch (JSchException | SftpException e) { |
| | | e.printStackTrace(); |
| | | log.writeInfo(String.format("ã%sã%s失败ï¼", sftpTitle, sftpTitle) + e.getMessage(), BackupLogger.ERROR_TYPE); |
| | | log.writeInfo("ãä¸ä¼ ç³»ç»å¤ä»½æä»¶ãä¸ä¼ ç³»ç»å¤ä»½æä»¶å¤±è´¥ï¼" + e.getMessage(), BackupLogger.ERROR_TYPE); |
| | | return false; |
| | | } |
| | | return true; |
| | | } |
| | | |
| | | /** |
| | | * éå½å建è¿ç¨ç®å½ |
| | | * SFTPéå½å建è¿ç¨ç®å½ |
| | | * @param sftpChannel |
| | | * @param remoteDir |
| | | * @throws SftpException |