ftp sql 同步封装

Administrator

2021-12-15 8d43111bd0e598bc0b2014cbfa69a32e74959dff

 src/main/java/org/springblade/modules/apply/controller/ApplyController.java

@@ -10,7 +10,6 @@
import net.sourceforge.pinyin4j.format.HanyuPinyinOutputFormat;
import net.sourceforge.pinyin4j.format.HanyuPinyinToneType;
import net.sourceforge.pinyin4j.format.exception.BadHanyuPinyinOutputFormatCombination;
import org.springblade.common.utils.arg;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
@@ -33,6 +32,7 @@
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.training.vo.TrainingRegistrationVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

@@ -44,7 +44,7 @@
import java.text.SimpleDateFormat;
import java.util.*;

import static org.springblade.common.constant.FtpConstant.*;
import static org.springblade.common.config.FtpConfig.*;

/**
 * @author zhongrj
@@ -56,12 +56,16 @@
@RequestMapping("/apply")
public class ApplyController {

//   @Autowired
   private final ApplyService applyService;

//   @Autowired
   private final ExamPaperService examPaperService;

//   @Autowired
   private final IUserService userService;

//   @Autowired
   private final ExamScoreService examScoreService;

   /**
@@ -698,19 +702,21 @@
      examScore.setExamId(apply.getExamId().toString());
      examScore.setUserId(apply.getUserId().toString());
      examScore.setApplyId(apply.getId());
      examScore.setCandidateNo(apply.getCandidateNo());
      examScore.setExamTime(new Date());
      //新增考试成绩
      examScoreService.save(examScore);
      //内网同步
      Long sid = examScore.getId();
      String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examScore.getExamTime());
//      String s = "insert into exam_score(id,exam_time,user_id,exam_id,apply_id) " +
//         "values(" + "'" + sid + "'" + "," + "'" +
//         format + "'" + "," + "'" +
//         examScore.getUserId() +"'" + ","  +"'" +
//         examScore.getExamId() +"'" + ","  +"'" +
//         examScore.getApplyId() + "'" + ")";
//      FtpUtil.sqlFileUpload(s);
      String s = "insert into exam_score(id,candidate_no,exam_time,user_id,exam_id,apply_id) " +
         "values(" + "'" + sid + "'" +
         "," + "'" + examScore.getCandidateNo() + "'" +
         "," + "'" + format + "'" +
         "," + "'" + examScore.getUserId() +"'" +
         ","  +"'" + examScore.getExamId() +"'" +
         ","  +"'" + examScore.getApplyId() + "'" + ")";
      FtpUtil.sqlFileUpload(s);
      return examScore;
   }

@@ -737,7 +743,7 @@
      } catch (FileNotFoundException e) {
         e.printStackTrace();
      }
      FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/",  "f"+response1+".json", in1);
      FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, ftpPath, "/",  "f"+response1+".json", in1);
      return "成功";
   }