From 8d43111bd0e598bc0b2014cbfa69a32e74959dff Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 15 Dec 2021 19:24:05 +0800
Subject: [PATCH] ftp sql 同步封装
---
src/main/java/org/springblade/modules/apply/controller/ApplyController.java | 26 ++++++++++++++++----------
1 files changed, 16 insertions(+), 10 deletions(-)
diff --git a/src/main/java/org/springblade/modules/apply/controller/ApplyController.java b/src/main/java/org/springblade/modules/apply/controller/ApplyController.java
index 278c5b2..8ac63f0 100644
--- a/src/main/java/org/springblade/modules/apply/controller/ApplyController.java
+++ b/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 "成功";
}
--
Gitblit v1.9.3