| | |
| | | applyService.updateById(apply); |
| | | |
| | | String s1 = |
| | | "update sys_apply set exam_id = " + apply.getExamId() + "candidate_no = " + "'" + apply.getCandidateNo() + "'" + |
| | | "update sys_apply set exam_id = " + apply.getExamId() + ",candidate_no = " + "'" + apply.getCandidateNo() + "'" + |
| | | " " +"where id = " + "'" + apply.getId() + "'"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | }); |
| | |
| | | "values(" + "'" + sid + "'" + "," + "'" + examPaper.getExamName() + "'" + "," + "'" + examPaper.getExamType() + |
| | | "'" + "," +"'" + format + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s); |
| | | |
| | | |
| | | //修改报名信息 |
| | | applyIds.forEach(id ->{ |
| | |
| | | String s3 = "select * from ksxt_exam"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | FtpUtil.sqlFileUpload(s2); |
| | | // FtpUtil.sqlFileUpload(s3); |
| | | String json1 = JSON.toJSONString(s3); |
| | | String response1 = String.valueOf((new Date()).getTime()); |
| | | OutJson.createJsonFile(json1, localPath, "f"+response1); |