From bf93d530532a5910dae6676d23e13aed607baef9 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Mon, 23 Aug 2021 08:40:26 +0800
Subject: [PATCH] 数据同步修改
---
src/main/java/org/springblade/modules/apply/controller/ApplyController.java | 100 +++++++++++++++----------------------------------
1 files changed, 31 insertions(+), 69 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 6ed35d6..c6d0d84 100644
--- a/src/main/java/org/springblade/modules/apply/controller/ApplyController.java
+++ b/src/main/java/org/springblade/modules/apply/controller/ApplyController.java
@@ -19,7 +19,6 @@
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.FTP.OutJson;
-import org.springblade.modules.FTP.monitor;
import org.springblade.modules.apply.entity.Apply;
import org.springblade.modules.apply.excel.ApplyExcel;
import org.springblade.modules.apply.excel.ApplyImporter;
@@ -147,16 +146,7 @@
"values(" + "'" + id + "'" + "," + "'" + apply.getUserId() + "'" + "," + "'" + formatStr +
"'" + "," + "'" + apply.getApplyStatus() + "'" + "," +"'" + apply.getIsExam() + "'" + ");" +
"update blade_user set is_apply = " + user1.getIsApply() + " " +"where id = " + "'" + user1.getId() + "'";
- String json = JSON.toJSONString(s);
- String response = String.valueOf((new Date()).getTime());
- OutJson.createJsonFile(json, "d:/", "w"+response);
- FileInputStream in = null;
- try {
- in = new FileInputStream(new File("D:\\" + "w"+response+".json"));
- } catch (FileNotFoundException e) {
- e.printStackTrace();
- }
- FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response+".json", in);
+ FtpUtil.sqlFileUpload(s);
}
@@ -463,16 +453,7 @@
String s =
"update sys_apply set apply_status = " + apply.getApplyStatus() + " " +"where id = " + "'" + apply.getId() + "';" +
"update blade_user set is_apply = " + user.getIsApply() + " " +"where id = " + "'" + user.getId() + "'";
- String json = JSON.toJSONString(s);
- String response = String.valueOf((new Date()).getTime());
- OutJson.createJsonFile(json, "d:/", "w"+response);
- FileInputStream in = null;
- try {
- in = new FileInputStream(new File("D:\\" + "w"+response+".json"));
- } catch (FileNotFoundException e) {
- e.printStackTrace();
- }
- FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response+".json", in);
+ FtpUtil.sqlFileUpload(s);
}
@@ -642,16 +623,7 @@
String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time) " +
"values(" + "'" + sid + "'" + "," + "'" + examPaper.getExamName() + "'" + "," + "'" + examPaper.getExamType() +
"'" + "," +"'" + format + "'" + ")";
- String json = JSON.toJSONString(s);
- String response = String.valueOf((new Date()).getTime());
- OutJson.createJsonFile(json, "d:/", "w"+response);
- FileInputStream in = null;
- try {
- in = new FileInputStream(new File("D:\\" + "w"+response+".json"));
- } catch (FileNotFoundException e) {
- e.printStackTrace();
- }
- FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response+".json", in);
+ FtpUtil.sqlFileUpload(s);
//修改报名信息
list.forEach(id ->{
@@ -664,16 +636,7 @@
String s1 =
"update sys_apply set exam_id = " + apply.getExamId() + "candidate_no = " + "'" + apply.getCandidateNo() + "'" +
" " +"where id = " + "'" + apply.getId() + "'";
- String json1 = JSON.toJSONString(s1);
- String response1 = String.valueOf((new Date()).getTime());
- OutJson.createJsonFile(json1, "d:/", "w"+response1);
- FileInputStream in1 = null;
- try {
- in1 = new FileInputStream(new File("D:\\" + "w"+response1+".json"));
- } catch (FileNotFoundException e) {
- e.printStackTrace();
- }
- FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response1+".json", in1);
+ FtpUtil.sqlFileUpload(s1);
});
}
@@ -702,16 +665,7 @@
String s = "insert into ksxt_exam(id,exam_name,exam_type,start_time) " +
"values(" + "'" + sid + "'" + "," + "'" + examPaper.getExamName() + "'" + "," + "'" + examPaper.getExamType() +
"'" + "," +"'" + format + "'" + ")";
- String json = JSON.toJSONString(s);
- String response = String.valueOf((new Date()).getTime());
- OutJson.createJsonFile(json, "d:/", "w"+response);
- FileInputStream in = null;
- try {
- in = new FileInputStream(new File("D:\\" + "w"+response+".json"));
- } catch (FileNotFoundException e) {
- e.printStackTrace();
- }
- FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response+".json", in);
+ FtpUtil.sqlFileUpload(s);
//修改报名信息
@@ -725,16 +679,7 @@
String s1 =
"update sys_apply set exam_id = " + apply.getExamId() + ",candidate_no = " + "'" + apply.getCandidateNo() + "'" +
" " +"where id = " + "'" + apply.getId() + "'";
- String json1 = JSON.toJSONString(s1);
- String response1 = String.valueOf((new Date()).getTime());
- OutJson.createJsonFile(json1, "d:/", "w"+response1);
- FileInputStream in1 = null;
- try {
- in1 = new FileInputStream(new File("D:\\" + "w"+response1+".json"));
- } catch (FileNotFoundException e) {
- e.printStackTrace();
- }
- FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response1+".json", in1);
+ FtpUtil.sqlFileUpload(s1);
});
}
}
@@ -783,23 +728,40 @@
//内网同步
Long sid = examScore.getId();
String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examScore.getExamTime());
- String s = "insert into ksxt_exam(id,exam_time,user_id,exam_id,apply_id) " +
+ String s = "insert into exam_score(id,exam_time,user_id,exam_id,apply_id) " +
"values(" + "'" + sid + "'" + "," + "'" +
format + "'" + "," + "'" +
examScore.getUserId() +"'" + "," +"'" +
examScore.getExamId() +"'" + "," +"'" +
examScore.getApplyId() + "'" + ")";
- String json = JSON.toJSONString(s);
- String response = String.valueOf((new Date()).getTime());
- OutJson.createJsonFile(json, "d:/", "w"+response);
- FileInputStream in = null;
+ FtpUtil.sqlFileUpload(s);
+ return examScore;
+ }
+
+
+
+ /**
+ * test
+ * @return
+ */
+ @GetMapping("/test")
+ public Object test(){
+ String s1 = "insert into exam_score(id,exam_id,apply_id) values(223,88,315)";
+ String s2 = "111222333";
+ String s3 = "select * from ksxt_exam";
+ FtpUtil.sqlFileUpload(s1);
+ FtpUtil.sqlFileUpload(s2);
+ String json1 = JSON.toJSONString(s3);
+ String response1 = String.valueOf((new Date()).getTime());
+ OutJson.createJsonFile(json1, localPath, "f"+response1);
+ FileInputStream in1 = null;
try {
- in = new FileInputStream(new File("D:\\" + "w"+response+".json"));
+ in1 = new FileInputStream(new File(localPath + "f"+response1+".json"));
} catch (FileNotFoundException e) {
e.printStackTrace();
}
- FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response+".json", in);
- return examScore;
+ FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/", "f"+response1+".json", in1);
+ return "成功";
}
--
Gitblit v1.9.3