From af562a2d0264ed4a81ce00699be85d16609e8a9b Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期二, 27 九月 2022 10:30:09 +0800
Subject: [PATCH] 更新
---
src/main/java/com/whyc/service/SoftwareService.java | 24 +++++++++++++-----------
1 files changed, 13 insertions(+), 11 deletions(-)
diff --git a/src/main/java/com/whyc/service/SoftwareService.java b/src/main/java/com/whyc/service/SoftwareService.java
index 8da3d19..f820dba 100644
--- a/src/main/java/com/whyc/service/SoftwareService.java
+++ b/src/main/java/com/whyc/service/SoftwareService.java
@@ -108,18 +108,20 @@
Cell cell = sheet.getRow(8 + i).getCell(2);
cell.setCellType(Cell.CELL_TYPE_STRING);
String stringCellValue = cell.getStringCellValue();
- int length = stringCellValue.length();
- if(length == 9){
- stringCellValue = "0"+stringCellValue;
- }else if(length < 9){
- int centerZeroNum = 10 - length -1;
- StringBuilder centerZeroStr = new StringBuilder();
- for (int j = 0; j < centerZeroNum; j++) {
- centerZeroStr.append("0");
+ if(!stringCellValue.equals("")) {
+ int length = stringCellValue.length();
+ if (length == 9) {
+ stringCellValue = "0" + stringCellValue;
+ } else if (length < 9) {
+ int centerZeroNum = 10 - length - 1;
+ StringBuilder centerZeroStr = new StringBuilder();
+ for (int j = 0; j < centerZeroNum; j++) {
+ centerZeroStr.append("0");
+ }
+ String strFront = stringCellValue.substring(0, 3);
+ String strBehind = stringCellValue.substring(3);
+ stringCellValue = "0" + strFront + centerZeroStr + strBehind;
}
- String strFront = stringCellValue.substring(0, 3);
- String strBehind = stringCellValue.substring(3);
- stringCellValue = "0"+strFront+centerZeroStr+strBehind;
}
software.setApplyMaterialCode(stringCellValue);
software.setApplyModel(sheet.getRow(8+i).getCell(4).getStringCellValue());
--
Gitblit v1.9.1