From d61bf5ea439a992bb1200f9da274387a0d5536f5 Mon Sep 17 00:00:00 2001
From: yaowanxin <3588231647@qq.com>
Date: 星期四, 24 七月 2025 22:10:58 +0800
Subject: [PATCH] 判断文件是否为空1

---
 src/main/java/com/chinaztt/mes/docx/service/impl/DocxServiceImpl.java |   14 ++++++++++++--
 1 files changed, 12 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/chinaztt/mes/docx/service/impl/DocxServiceImpl.java b/src/main/java/com/chinaztt/mes/docx/service/impl/DocxServiceImpl.java
index 1843c1a..f3335d8 100644
--- a/src/main/java/com/chinaztt/mes/docx/service/impl/DocxServiceImpl.java
+++ b/src/main/java/com/chinaztt/mes/docx/service/impl/DocxServiceImpl.java
@@ -3,6 +3,7 @@
 import cn.hutool.core.io.FileUtil;
 import cn.hutool.core.util.ObjectUtil;
 import com.chinaztt.mes.docx.dto.GetFileDto;
+import com.chinaztt.mes.docx.dto.ThicknessData;
 import com.chinaztt.mes.docx.service.DocxService;
 import com.chinaztt.mes.docx.util.R;
 import com.chinaztt.mes.docx.util.TakeWords;
@@ -11,7 +12,7 @@
 import org.springframework.stereotype.Service;
 
 import java.io.*;
-import java.sql.SQLException;
+import java.sql.*;
 import java.util.ArrayList;
 import java.util.List;
 import java.util.Objects;
@@ -22,12 +23,15 @@
     @Override
     public R<?> getFile(GetFileDto getFileDto) throws IOException, SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException, TesseractException {
         File file = getFileStart(getFileDto.getFilePath(), getFileDto.getFileExtension());
-        if (!file.exists()) {
+        if (file != null && !file.exists()) {
             return R.failed("鏈煡璇㈠埌璇ヨ矾寰勶細" + getFileDto.getFilePath() + "涓嬪瓨鍦細" + getFileDto.getFileExtension() + "缁撳熬鐨勬枃浠讹紒");
         }
         switch (getFileDto.getFileExtension()) {
             case ".docx":
                 return R.ok(TakeWords.readWordFile(file));
+            //鍚庣紑涓�.xls鐨勬枃浠�
+            case ".xls":
+                return R.ok(TakeWords.readExcelxlsFile(file));
             case ".xlsx":
                 try {
                     return R.ok(TakeWords.readExcelFile(file));
@@ -48,6 +52,11 @@
                     return R.failed("鏈厤缃�.db閲囬泦鏂囦欢鍚嶇О锛�");
                 }
                 return R.ok(TakeWords.readDbFile(file, getFileDto));
+            case ".mysql":
+                if (ObjectUtil.isEmpty(getFileDto.getDbFileName()) || Objects.equals(getFileDto.getDbFileName(), "null")) {
+                    return R.failed("鏈厤缃�.mysql閲囬泦鏂囦欢鍚嶇О锛�");
+                }
+                return R.ok(TakeWords.getMysqlFile(getFileDto));
             case ".png":
                 return R.ok(TakeWords.readPngFile(file));
             default:
@@ -80,6 +89,7 @@
         }
     }
 
+
     public static File getLatestFile(List<File> files) {
         File latestFile = null;
         long latestTime = 0;

--
Gitblit v1.9.3