From e7c3ff19f5abea1f1510503b46f99c6ad3870410 Mon Sep 17 00:00:00 2001
From: chenjiahe <763432473@qq.com>
Date: 星期五, 19 八月 2022 18:28:46 +0800
Subject: [PATCH] 判断excel文件
---
src/main/java/com/hx/util/DateUtil.java | 39 ++++++++++++++++++++++++++++++++++++++-
1 files changed, 38 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/hx/util/DateUtil.java b/src/main/java/com/hx/util/DateUtil.java
index 374e228..9b18d81 100644
--- a/src/main/java/com/hx/util/DateUtil.java
+++ b/src/main/java/com/hx/util/DateUtil.java
@@ -51,6 +51,17 @@
return df.format(date);
}
+ /**鏃堕棿鎴宠浆鏃堕棿
+ * @param timestamp 鏃堕棿鎴�
+ * @param format 鏃堕棿鏍煎紡
+ * @return 杩斿洖鐨勬椂闂存牸寮忓瓧绗︿覆
+ */
+ public static Date timestampToDate(long timestamp, String format) {
+ SimpleDateFormat sdf= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ String sd = sdf.format(new Date(timestamp)); // 鏃堕棿鎴宠浆鎹㈡垚鏃堕棿
+ return DateUtil.parseString(sd,"yyyy-MM-dd HH:mm:ss");
+ }
+
/**
* 杞崲鎴恲yyyMMdd鏍煎紡鐨勬棩鏈熷瓧绗︿覆
*
@@ -191,6 +202,20 @@
return Format_14.format(date);
}
+
+ /**
+ * 褰撳墠鏃堕棿涔嬪墠鐨勬椂闂翠笌褰撳墠鏃堕棿鐩稿樊澶氬皯绉�
+ * @param startDate 褰撳墠鏃堕棿涔嬪墠鐨勬椂闂�
+ * @return
+ */
+ public static int calLastedTime(Date startDate) {
+ long nowDate = new Date().getTime();
+ long startDateTime = startDate.getTime();
+ int diffSeconds = (int) ((nowDate - startDateTime) / 1000);
+ return diffSeconds;
+ }
+
+
/**
* 杞崲鎴恲yyyMMddHHmmssSSS鏍煎紡鐨勬棩鏈熷瓧绗︿覆
*
@@ -277,6 +302,18 @@
}
}
+ /**鏃堕棿涓婄鍙犲姞
+ * @Author: ChenJiaHe
+ * @param dateTime 鏃堕棿
+ * @param second 绉�
+ * @return
+ */
+ public static Date addSecond(Date dateTime,int second){
+ Calendar c = Calendar.getInstance();
+ c.setTime(dateTime);
+ c.add(Calendar.SECOND, second);
+ return c.getTime();
+ }
/**鏃堕棿涓婂垎閽熷彔鍔�
* @Author: ChenJiaHe
@@ -445,7 +482,7 @@
}
boolean status = false;
if(formatDate(startTime,"yyyyMMdd").equals(formatDate(endTime,"yyyyMMdd"))){
- status = false;
+ status = true;
}
return status;
}
--
Gitblit v1.8.0