ftp sql 同步封装

Administrator

2021-12-15 8d43111bd0e598bc0b2014cbfa69a32e74959dff

 src/main/java/org/springblade/modules/coinspect/controller/CoinspectController.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 = "传入coinspect")
   public R save(@Valid @RequestBody Coinspect coinspect) throws Exception {
      coinspect.setReviewtime(new Date());
      coinspectService.save(coinspect);
      String url = "";
      if (coinspect.getUrl()!=null && !"".equals(coinspect.getUrl())){
@@ -105,13 +107,12 @@
      }
      //数据同步
      String s1 =
         "insert into sys_coinspect(id,name,sName,deptName,reviewTime,insid,results,url) " +
         "insert into sys_coinspect(id,examiner_id,reviewed_dept_id,examiner_dept_id,reviewTime,insid,results,url) " +
            "values(" + "'" + coinspect.getId() + "'" + "," +
            "'" + coinspect.getName() + "'" + "," +
            "'" + coinspect.getSname() + "'" + "," +
            "'" + coinspect.getSname() + "'" + "," +
            "'" + coinspect.getDeptname() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd").format(coinspect.getReviewtime()) + "'" + "," +
            "'" + coinspect.getExaminerId() + "'" + "," +
            "'" + coinspect.getReviewedDeptId() + "'" + "," +
            "'" + coinspect.getExaminerDeptId() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + coinspect.getInsid() + "'" + "," +
            "'" + coinspect.getResults() + "'" + "," +
            "'" + coinspect.getUrl() + "'" + ")";