ftp sql 同步封装

Administrator

2021-12-15 8d43111bd0e598bc0b2014cbfa69a32e74959dff

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

@@ -22,18 +22,22 @@
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import lombok.AllArgsConstructor;
import org.springblade.common.config.FtpConfig;
import org.springblade.common.utils.arg;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.seinspect.entity.Seinspect;
import org.springblade.modules.seinspect.service.ISeinspectService;
import org.springblade.modules.seinspect.vo.SeinspectVO;
import org.springframework.web.bind.annotation.*;

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

/**
 *  控制器
@@ -89,8 +93,32 @@
   @ApiOperationSupport(order = 4)
   @ApiOperation(value = "新增", notes = "传入seinspect")
   public R save(@Valid @RequestBody Seinspect seinspect) throws Exception {
      arg.test01(arg.url+"/seinspect/save",seinspect);
      return R.status(seinspectService.save(seinspect));
      seinspect.setReviewtime(new Date());
      seinspectService.save(seinspect);
      String url = "";
      if (seinspect.getUrl()!=null&& !"".equals(seinspect.getUrl())){
         String[] split = seinspect.getUrl().split(",");
         for (int i = 0; i < split.length; i++) {
            String s = split[i].substring(26, split[i].length());
            url += FtpConfig.ip + s + ",";
         }
         String substring = url.substring(0, url.length() - 1);
         seinspect.setUrl(substring);
      }
      //数据同步
      String s1 =
         "insert into sys_seinspect(id,reviewTime,content,result,url,examiner_dept_id,examiner_id,jurisdiction,security_id) " +
            "values(" + "'" + seinspect.getId() + "'" + "," +
            "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
            "'" + seinspect.getContent() + "'" + "," +
            "'" + seinspect.getResult() + "'" + "," +
            "'" + seinspect.getUrl() + "'" + "," +
            "'" + seinspect.getExaminerDeptId() + "'" + "," +
            "'" + seinspect.getExaminerId() + "'" + "," +
            "'" + seinspect.getJurisdiction() + "'" + "," +
            "'" + seinspect.getSecurityId() + "'" + ")";
      FtpUtil.sqlFileUpload(s1);
      return R.success("成功");
   }

   /**
@@ -100,7 +128,7 @@
   @ApiOperationSupport(order = 5)
   @ApiOperation(value = "修改", notes = "传入seinspect")
   public R update(@Valid @RequestBody Seinspect seinspect) throws Exception {
      arg.test01(arg.url+"/seinspect/update",seinspect);
      //arg.test01(arg.url+"/seinspect/update",seinspect);
      return R.status(seinspectService.updateById(seinspect));
   }

@@ -122,7 +150,7 @@
   @ApiOperationSupport(order = 8)
   @ApiOperation(value = "删除", notes = "传入ids")
   public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
      arg.sendPostRemoveByIds(arg.url+"/seinspect/remove",ids);
      //arg.sendPostRemoveByIds(arg.url+"/seinspect/remove",ids);
      return R.status(seinspectService.removeByIds(Func.toLongList(ids)));
   }