ftp sql 同步封装

Administrator

2021-12-15 8d43111bd0e598bc0b2014cbfa69a32e74959dff

 src/main/java/org/springblade/modules/seinspect/controller/SeinspectController.java

@@ -37,6 +37,7 @@

import javax.validation.Valid;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 *  控制器
@@ -92,6 +93,7 @@
   @ApiOperationSupport(order = 4)
   @ApiOperation(value = "新增", notes = "传入seinspect")
   public R save(@Valid @RequestBody Seinspect seinspect) throws Exception {
      seinspect.setReviewtime(new Date());
      seinspectService.save(seinspect);
      String url = "";
      if (seinspect.getUrl()!=null&& !"".equals(seinspect.getUrl())){
@@ -105,20 +107,16 @@
      }
      //数据同步
      String s1 =
         "insert into sys_seinspect(id,realName,carid,sName,inspectman,deptName,reviewTime,insid,examination_type,url,jid,deptid,jurisdiction) " +
         "insert into sys_seinspect(id,reviewTime,content,result,url,examiner_dept_id,examiner_id,jurisdiction,security_id) " +
            "values(" + "'" + seinspect.getId() + "'" + "," +
            "'" + seinspect.getRealname() + "'" + "," +
            "'" + seinspect.getCarid() + "'" + "," +
            "'" + seinspect.getSname() + "'" + "," +
            "'" + seinspect.getInspectman() + "'" + "," +
            "'" + seinspect.getDeptname() + "'" + "," +
            "'" + seinspect.getReviewtime() + "'" + "," +
            "'" + seinspect.getInsid() + "'" + "," +
            "'" + seinspect.getExaminationType() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + seinspect.getContent() + "'" + "," +
            "'" + seinspect.getResult() + "'" + "," +
            "'" + seinspect.getUrl() + "'" + "," +
            "'" + seinspect.getJid() + "'" + "," +
            "'" + seinspect.getDeptid() + "'" + "," +
            "'" +seinspect.getJurisdiction() + "'" + ")";
            "'" + seinspect.getExaminerDeptId() + "'" + "," +
            "'" + seinspect.getExaminerId() + "'" + "," +
            "'" + seinspect.getJurisdiction() + "'" + "," +
            "'" + seinspect.getSecurityId() + "'" + ")";
      FtpUtil.sqlFileUpload(s1);
      return R.success("成功");
   }