mysql5.7不能使用 with

zhanghua

2023-03-10 9bfd0f697d407902d9d80d95e5c23943a556b79f

 ycl-platform/src/main/java/com/ycl/service/video/impl/VideoAlarmReportServiceImpl.java

@@ -9,6 +9,7 @@
import com.ycl.entity.video.VideoAlarmReport;
import com.ycl.mapper.video.VideoAlarmReportMapper;
import com.ycl.service.caseHandler.IViolationsService;
import com.ycl.service.oss.OssService;
import com.ycl.service.video.IVideoAlarmReportService;
import com.ycl.utils.MediaFileUtil;
import org.springframework.beans.factory.annotation.Autowired;
@@ -43,6 +44,9 @@

    private MediaFileUtil mediaFileUtil;
    private IViolationsService violationsService;

    @Autowired
    private OssService ossService;

    @Autowired
    public void setMediaFileUtil(MediaFileUtil mediaFileUtil) {
@@ -141,7 +145,6 @@
//                按照Base64编码解析数据
                byte[] data = DatatypeConverter.parseBase64Binary(alarmParam.getPicData());
                InputStream inputStream = new ByteArrayInputStream(data);

                try {
//                    如果List<AlarmDataParam>合理
                    if (alarmParam.getAlarmData()!=null && alarmParam.getAlarmData().size()!=0) {
@@ -169,10 +172,10 @@

                            ByteArrayOutputStream os = new ByteArrayOutputStream();
                            ImageIO.write(image, extension, os);
                            inputStream = new ByteArrayInputStream(os.toByteArray());
                            ByteArrayInputStream inputStream1 = new ByteArrayInputStream(os.toByteArray());

                    }
                    picData = mediaFileUtil.savePicture(inputStream, extension);
                    picData = ossService.uploadImages(inputStream, extension);
                } catch (Exception e) {
                    e.printStackTrace();
                }