feat: 新增将日期区间转为日期时间区间的方法

- 重载 `DateTimeTools#toDateTimeRange` - 对新增的方法进行单元测试 - 简化单元测试代码
2025-08-05 17:28:24 +08:00
10 changed files with 217 additions and 75 deletions
--- a/README.md
+++ b/README.md
@@ -77,7 +77,7 @@ System.out.println(result); // Output: Return string
 ```java
 public final class LoginException
        extends RuntimeException
-        implements IMultiTypesException<LoginException.Type> {
+        implements IMultiTypesException<LoginException, LoginException.Type, String> {
    private static final long serialVersionUID = 881293090625085616L;
    private final Type type;
    private LoginException(@Nonnull Type type, @Nonnull String message) {
@@ -104,7 +104,7 @@ public final class LoginException

    // ...

-    public enum Type implements IExceptionType<String>, IExceptionFactory<LoginException> {
+    public enum Type implements IExceptionType<LoginException, String> {
        DEFAULT("00", "当前会话未登录"),
        NOT_TOKEN("10", "未提供token"),
        INVALID_TOKEN("20", "token无效"),
--- a/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/IExceptionFactory.java
+++ b/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/IExceptionFactory.java
@@ -20,8 +20,7 @@ import javax.annotation.Nonnull;
 /**
 * 异常工厂
 *
- * @param <X> 异常类型
- * @author ZhouXY108 <luquanlion@outlook.com>
+ * @author ZhouXY
 */
 public interface IExceptionFactory<X extends Exception> {
    /**
--- a/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/IExceptionType.java
+++ b/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/IExceptionType.java
@@ -1,39 +0,0 @@
-/*
- * Copyright 2025 the original author or authors.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- *      https://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-package xyz.zhouxy.plusone.commons.exception;
-
-import xyz.zhouxy.plusone.commons.annotation.Virtual;
-import xyz.zhouxy.plusone.commons.base.IWithCode;
-
-/**
- * 异常场景
- *
- * @param <TCode> 场景编码
- * @author ZhouXY108 <luquanlion@outlook.com>
- */
-public interface IExceptionType<TCode> extends IWithCode<TCode> {
-
-    /**
-     * 默认异常信息
-     */
-    String getDefaultMessage();
-
-    @Virtual
-    default String getDescription() {
-        return getDefaultMessage();
-    }
-
-}
--- a/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/IMultiTypesException.java
+++ b/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/IMultiTypesException.java
@@ -15,8 +15,13 @@
 */
 package xyz.zhouxy.plusone.commons.exception;

+import java.io.Serializable;
+
 import javax.annotation.Nonnull;

+import xyz.zhouxy.plusone.commons.annotation.Virtual;
+import xyz.zhouxy.plusone.commons.base.IWithCode;
+
 /**
 * IMultiTypesException
 *
@@ -33,7 +38,7 @@ import javax.annotation.Nonnull;
 * <pre>
 * public final class LoginException
 *         extends RuntimeException
- *         implements IMultiTypesException&lt;LoginException.Type&gt; {
+ *         implements IMultiTypesException&lt;LoginException, LoginException.Type, String&gt; {
 *     private static final long serialVersionUID = 881293090625085616L;
 *     private final Type type;
 *     private LoginException(&#64;Nonnull Type type, &#64;Nonnull String message) {
@@ -60,7 +65,7 @@ import javax.annotation.Nonnull;
 *
 *     // ...
 *
- *     public enum Type implements IExceptionType&lt;String&gt;, IExceptionFactory&lt;LoginException&gt; {
+ *     public enum Type implements IExceptionType&lt;LoginException, String&gt; {
 *         DEFAULT("00", "当前会话未登录"),
 *         NOT_TOKEN("10", "未提供token"),
 *         INVALID_TOKEN("20", "token无效"),
@@ -117,11 +122,15 @@ import javax.annotation.Nonnull;
 * throw LoginException.Type.TOKEN_TIMEOUT.create();
 * </pre>
 *
+ * @param <X> 具体异常类
 * @param <T> 异常场景
 * @author ZhouXY108 <luquanlion@outlook.com>
 * @since 1.0.0
 */
-public interface IMultiTypesException<T extends IExceptionType<?>> {
+public interface IMultiTypesException<
+        X extends Exception,
+        T extends IMultiTypesException.IExceptionType<X, TCode>,
+        TCode extends Serializable> {

    /**
     * 异常类型
@@ -130,4 +139,31 @@ public interface IMultiTypesException<T extends IExceptionType<?>> {
     */
    @Nonnull
    T getType();
+
+    /**
+     * 获取异常类型编码
+     *
+     * @return 异常类型编码
+     */
+    default @Nonnull TCode getTypeCode() {
+        return getType().getCode();
+    }
+
+    /**
+     * 异常类型
+     */
+    public static interface IExceptionType<X extends Exception, TCode extends Serializable>
+            extends IWithCode<TCode>, IExceptionFactory<X> {
+
+        /**
+         * 默认异常信息
+         */
+        String getDefaultMessage();
+
+        @Virtual
+        default String getDescription() {
+            return getDefaultMessage();
+        }
+
+    }
 }
--- a/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/ParsingFailureException.java
+++ b/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/ParsingFailureException.java
@@ -21,6 +21,7 @@ import java.time.format.DateTimeParseException;
 import javax.annotation.Nonnull;

 import xyz.zhouxy.plusone.commons.exception.business.RequestParamsException;
+import xyz.zhouxy.plusone.commons.exception.IMultiTypesException.IExceptionType;

 /**
 * 解析失败异常
@@ -38,7 +39,7 @@ import xyz.zhouxy.plusone.commons.exception.business.RequestParamsException;
 */
 public final class ParsingFailureException
        extends Exception
-        implements IMultiTypesException<ParsingFailureException.Type> {
+        implements IMultiTypesException<ParsingFailureException, ParsingFailureException.Type, String> {
    private static final long serialVersionUID = 795996090625132616L;

    private final Type type;
@@ -170,7 +171,7 @@ public final class ParsingFailureException
    /** XML 解析失败 */
    public static final Type XML_PARSING_FAILURE = Type.XML_PARSING_FAILURE;

-    public enum Type implements IExceptionType<String>, IExceptionFactory<ParsingFailureException> {
+    public enum Type implements IExceptionType<ParsingFailureException, String> {
        DEFAULT("00", "解析失败"),
        NUMBER_PARSING_FAILURE("10", "数字转换失败"),
        DATE_TIME_PARSING_FAILURE("20", "时间解析失败"),
--- a/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/business/InvalidInputException.java
+++ b/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/exception/business/InvalidInputException.java
@@ -18,8 +18,7 @@ package xyz.zhouxy.plusone.commons.exception.business;

 import javax.annotation.Nonnull;

-import xyz.zhouxy.plusone.commons.exception.IExceptionFactory;
-import xyz.zhouxy.plusone.commons.exception.IExceptionType;
+import xyz.zhouxy.plusone.commons.exception.IMultiTypesException.IExceptionType;
 import xyz.zhouxy.plusone.commons.exception.IMultiTypesException;

 /**
@@ -36,7 +35,7 @@ import xyz.zhouxy.plusone.commons.exception.IMultiTypesException;
 */
 public final class InvalidInputException
        extends RequestParamsException
-        implements IMultiTypesException<InvalidInputException.Type> {
+        implements IMultiTypesException<InvalidInputException, InvalidInputException.Type, String> {
    private static final long serialVersionUID = -28994090625082516L;

    private final Type type;
@@ -110,7 +109,7 @@ public final class InvalidInputException
        return this.type;
    }

-    public enum Type implements IExceptionType<String>, IExceptionFactory<InvalidInputException> {
+    public enum Type implements IExceptionType<InvalidInputException, String> {
        DEFAULT("00", "用户输入内容非法"),
        CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS("01", "包含非法恶意跳转链接"),
        CONTAINS_ILLEGAL_WORDS("02", "包含违禁敏感词"),
--- a/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/util/DateTimeTools.java
+++ b/plusone-commons/src/main/java/xyz/zhouxy/plusone/commons/util/DateTimeTools.java
@@ -27,11 +27,11 @@ import java.time.Year;
 import java.time.YearMonth;
 import java.time.ZoneId;
 import java.time.ZonedDateTime;
-import java.time.chrono.IsoChronology;
 import java.util.Calendar;
 import java.util.Date;
 import java.util.TimeZone;

+import com.google.common.collect.BoundType;
 import com.google.common.collect.Range;

 import xyz.zhouxy.plusone.commons.time.Quarter;
@@ -673,6 +673,44 @@ public class DateTimeTools {
        return Range.closedOpen(date.atStartOfDay(zone), startOfNextDate(date, zone));
    }

+    /**
+     * 将指定日期范围转为日期时间范围
+     *
+     * @param dateRange 日期范围
+     * @return 对应的日期时间范围
+     */
+    public static Range<LocalDateTime> toDateTimeRange(Range<LocalDate> dateRange) {
+        BoundType lowerBoundType = dateRange.lowerBoundType();
+        LocalDateTime lowerEndpoint = lowerBoundType == BoundType.CLOSED
+                ? dateRange.lowerEndpoint().atStartOfDay()
+                : dateRange.lowerEndpoint().plusDays(1).atStartOfDay();
+        BoundType upperBoundType = dateRange.upperBoundType();
+        LocalDateTime upperEndpoint = upperBoundType == BoundType.CLOSED
+                ? dateRange.upperEndpoint().plusDays(1).atStartOfDay()
+                : dateRange.upperEndpoint().atStartOfDay();
+
+        return Range.closedOpen(lowerEndpoint, upperEndpoint);
+    }
+
+    /**
+     * 将指定日期范围转为日期时间范围
+     *
+     * @param dateRange 日期范围
+     * @return 对应的日期时间范围
+     */
+    public static Range<ZonedDateTime> toDateTimeRange(Range<LocalDate> dateRange, ZoneId zone) {
+        BoundType lowerBoundType = dateRange.lowerBoundType();
+        ZonedDateTime lowerEndpoint = lowerBoundType == BoundType.CLOSED
+                ? dateRange.lowerEndpoint().atStartOfDay(zone)
+                : dateRange.lowerEndpoint().plusDays(1).atStartOfDay(zone);
+        BoundType upperBoundType = dateRange.upperBoundType();
+        ZonedDateTime upperEndpoint = upperBoundType == BoundType.CLOSED
+                ? dateRange.upperEndpoint().plusDays(1).atStartOfDay(zone)
+                : dateRange.upperEndpoint().atStartOfDay(zone);
+
+        return Range.closedOpen(lowerEndpoint, upperEndpoint);
+    }
+
    /**
     * 判断指定年份是否为闰年
     *
@@ -680,7 +718,7 @@ public class DateTimeTools {
     * @return 指定年份是否为闰年
     */
    public static boolean isLeapYear(int year) {
-        return IsoChronology.INSTANCE.isLeapYear(year);
+        return Year.isLeap(year);
    }

    // ================================
--- a/plusone-commons/src/test/java/xyz/zhouxy/plusone/commons/exception/test/InvalidInputExceptionTests.java
+++ b/plusone-commons/src/test/java/xyz/zhouxy/plusone/commons/exception/test/InvalidInputExceptionTests.java
@@ -38,6 +38,7 @@ public class InvalidInputExceptionTests {
            throw InvalidInputException.Type.CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS.create();
        });
        assertSame(InvalidInputException.Type.CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS, e.getType());
+        assertEquals(InvalidInputException.Type.CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS.getCode(), e.getTypeCode());
        assertEquals(InvalidInputException.Type.CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS.getDefaultMessage(), e.getMessage());
        assertNull(e.getCause());
    }
@@ -49,6 +50,7 @@ public class InvalidInputExceptionTests {
            throw InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.create(message);
        });
        assertSame(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS, e.getType());
+        assertEquals(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -60,6 +62,7 @@ public class InvalidInputExceptionTests {
            throw InvalidInputException.Type.PICTURE_CONTAINS_ILLEGAL_INFORMATION.create(message);
        });
        assertSame(InvalidInputException.Type.PICTURE_CONTAINS_ILLEGAL_INFORMATION, e.getType());
+        assertEquals(InvalidInputException.Type.PICTURE_CONTAINS_ILLEGAL_INFORMATION.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -74,6 +77,7 @@ public class InvalidInputExceptionTests {
            });

            assertSame(InvalidInputException.Type.INFRINGE_COPYRIGHT, e.getType());
+            assertEquals(InvalidInputException.Type.INFRINGE_COPYRIGHT.getCode(), e.getTypeCode());
            log.info("{}", e.getMessage());
            assertEquals(nfe.toString(), e.getMessage());
            assertSame(nfe, e.getCause());
@@ -88,6 +92,7 @@ public class InvalidInputExceptionTests {
        });

        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -101,6 +106,7 @@ public class InvalidInputExceptionTests {
            throw InvalidInputException.Type.CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS.create(message, nfe);
        });
        assertSame(InvalidInputException.Type.CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS, e.getType());
+        assertEquals(InvalidInputException.Type.CONTAINS_ILLEGAL_AND_MALICIOUS_LINKS.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertSame(nfe, e.getCause());
    }
@@ -114,6 +120,7 @@ public class InvalidInputExceptionTests {
            throw InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.create(message, nfe);
        });
        assertSame(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS, e.getType());
+        assertEquals(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertSame(nfe, e.getCause());
    }
@@ -127,6 +134,7 @@ public class InvalidInputExceptionTests {
            throw InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.create(message, npe);
        });
        assertSame(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS, e.getType());
+        assertEquals(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -140,6 +148,7 @@ public class InvalidInputExceptionTests {
            throw InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.create(message, nfe);
        });
        assertSame(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS, e.getType());
+        assertEquals(InvalidInputException.Type.CONTAINS_ILLEGAL_WORDS.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -158,6 +167,7 @@ public class InvalidInputExceptionTests {
            throw new InvalidInputException();
        });
        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertEquals(InvalidInputException.Type.DEFAULT.getDefaultMessage(), e.getMessage());
        assertNull(e.getCause());
    }
@@ -169,6 +179,7 @@ public class InvalidInputExceptionTests {
            throw new InvalidInputException(message);
        });
        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -180,6 +191,7 @@ public class InvalidInputExceptionTests {
            throw new InvalidInputException(message);
        });
        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -194,6 +206,7 @@ public class InvalidInputExceptionTests {
            });

            assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+            assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
            log.info("{}", e.getMessage());
            assertEquals(nfe.toString(), e.getMessage());
            assertSame(nfe, e.getCause());
@@ -208,6 +221,7 @@ public class InvalidInputExceptionTests {
        });

        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -221,6 +235,7 @@ public class InvalidInputExceptionTests {
            throw new InvalidInputException(message, nfe);
        });
        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertSame(nfe, e.getCause());
    }
@@ -234,6 +249,7 @@ public class InvalidInputExceptionTests {
            throw new InvalidInputException(message, nfe);
        });
        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertSame(nfe, e.getCause());
    }
@@ -247,6 +263,7 @@ public class InvalidInputExceptionTests {
            throw new InvalidInputException(message, npe);
        });
        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -260,6 +277,7 @@ public class InvalidInputExceptionTests {
            throw new InvalidInputException(message, nfe);
        });
        assertSame(InvalidInputException.Type.DEFAULT, e.getType());
+        assertEquals(InvalidInputException.Type.DEFAULT.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
--- a/plusone-commons/src/test/java/xyz/zhouxy/plusone/commons/exception/test/ParsingFailureExceptionTests.java
+++ b/plusone-commons/src/test/java/xyz/zhouxy/plusone/commons/exception/test/ParsingFailureExceptionTests.java
@@ -41,6 +41,7 @@ public class ParsingFailureExceptionTests {
            throw ParsingFailureException.DATE_TIME_PARSING_FAILURE.create();
        });
        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getDefaultMessage(), e.getMessage());
        assertNull(e.getCause());
    }
@@ -52,6 +53,7 @@ public class ParsingFailureExceptionTests {
            throw ParsingFailureException.JSON_PARSING_FAILURE.create(message);
        });
        assertSame(ParsingFailureException.Type.JSON_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.Type.JSON_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -63,6 +65,7 @@ public class ParsingFailureExceptionTests {
            throw ParsingFailureException.XML_PARSING_FAILURE.create(message);
        });
        assertSame(ParsingFailureException.XML_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.XML_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -77,6 +80,7 @@ public class ParsingFailureExceptionTests {
            });

            assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+            assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
            log.info("{}", e.getMessage());
            assertEquals(nfe.toString(), e.getMessage());
            assertSame(nfe, e.getCause());
@@ -91,6 +95,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -104,6 +109,7 @@ public class ParsingFailureExceptionTests {
            throw ParsingFailureException.NUMBER_PARSING_FAILURE.create(message, nfe);
        });
        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertSame(nfe, e.getCause());
    }
@@ -117,6 +123,7 @@ public class ParsingFailureExceptionTests {
            throw ParsingFailureException.DATE_TIME_PARSING_FAILURE.create(message, nfe);
        });
        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertSame(nfe, e.getCause());
    }
@@ -130,6 +137,7 @@ public class ParsingFailureExceptionTests {
            throw ParsingFailureException.DATE_TIME_PARSING_FAILURE.create(message, npe);
        });
        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -143,6 +151,7 @@ public class ParsingFailureExceptionTests {
            throw ParsingFailureException.DATE_TIME_PARSING_FAILURE.create(message, nfe);
        });
        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -166,6 +175,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(dtpe.getMessage(), e.getMessage());
        assertSame(dtpe, e.getCause());
    }
@@ -179,6 +189,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getDefaultMessage(), e.getMessage());
        assertNull(e.getCause());
    }
@@ -195,6 +206,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertSame(dtpe, e.getCause());
    }
@@ -211,6 +223,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertSame(dtpe, e.getCause());
    }
@@ -225,6 +238,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -239,6 +253,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.DATE_TIME_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.DATE_TIME_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
@@ -262,6 +277,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(dtpe.getMessage(), e.getMessage());
        assertSame(dtpe, e.getCause());
    }
@@ -275,6 +291,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getDefaultMessage(), e.getMessage());
        assertNull(e.getCause());
    }
@@ -291,6 +308,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertSame(dtpe, e.getCause());
    }
@@ -307,6 +325,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertSame(dtpe, e.getCause());
    }
@@ -321,6 +340,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertEquals(message, e.getMessage());
        assertNull(e.getCause());
    }
@@ -335,6 +355,7 @@ public class ParsingFailureExceptionTests {
        });

        assertSame(ParsingFailureException.NUMBER_PARSING_FAILURE, e.getType());
+        assertEquals(ParsingFailureException.NUMBER_PARSING_FAILURE.getCode(), e.getTypeCode());
        assertNull(e.getMessage());
        assertNull(e.getCause());
    }
--- a/plusone-commons/src/test/java/xyz/zhouxy/plusone/commons/util/DateTimeToolsTests.java
+++ b/plusone-commons/src/test/java/xyz/zhouxy/plusone/commons/util/DateTimeToolsTests.java
@@ -43,6 +43,7 @@ import org.junit.jupiter.api.Test;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;

+import com.google.common.collect.BoundType;
 import com.google.common.collect.Range;

 import xyz.zhouxy.plusone.commons.time.Quarter;
@@ -83,24 +84,6 @@ class DateTimeToolsTests {
        CALENDAR.setTime(DATE);
    }

-    // Joda
-    static final org.joda.time.LocalDateTime JODA_LOCAL_DATE_TIME
-            = new org.joda.time.LocalDateTime(2024, 12, 29, 12, 58, 30, 333);
-    static final org.joda.time.LocalDate JODA_LOCAL_DATE = JODA_LOCAL_DATE_TIME.toLocalDate();
-    static final org.joda.time.LocalTime JODA_LOCAL_TIME = JODA_LOCAL_DATE_TIME.toLocalTime();
-
-    // Joda - 2024-12-29 12:58:30.333 SystemDefaultZone
-    static final org.joda.time.DateTimeZone JODA_SYS_ZONE = org.joda.time.DateTimeZone.getDefault();
-    static final org.joda.time.DateTime JODA_DATE_TIME_WITH_SYS_ZONE = JODA_LOCAL_DATE_TIME.toDateTime(JODA_SYS_ZONE);
-    static final org.joda.time.Instant JODA_INSTANT_WITH_SYS_ZONE = JODA_DATE_TIME_WITH_SYS_ZONE.toInstant();
-    static final long JODA_INSTANT_MILLIS = JODA_INSTANT_WITH_SYS_ZONE.getMillis();
-
-    // Joda - 2024-12-29 12:58:30.333 GMT+04:00
-    static final org.joda.time.DateTimeZone JODA_ZONE = org.joda.time.DateTimeZone.forID("GMT+04:00");
-    static final org.joda.time.DateTime JODA_DATE_TIME = JODA_LOCAL_DATE_TIME.toDateTime(JODA_ZONE);
-    static final org.joda.time.Instant JODA_INSTANT = JODA_DATE_TIME.toInstant();
-    static final long JODA_MILLIS = JODA_INSTANT.getMillis();
-
    // ================================
    // #region - toDate
    // ================================
@@ -109,9 +92,7 @@ class DateTimeToolsTests {
    void toDate_timeMillis() {
        assertNotEquals(SYS_DATE, DATE);
        log.info("SYS_DATE: {}, DATE: {}", SYS_DATE, DATE);
-        assertEquals(SYS_DATE, JODA_DATE_TIME_WITH_SYS_ZONE.toDate());
        assertEquals(SYS_DATE, DateTimeTools.toDate(INSTANT_MILLIS));
-        assertEquals(DATE, JODA_DATE_TIME.toDate());
        assertEquals(DATE, DateTimeTools.toDate(MILLIS));
    }

@@ -397,7 +378,7 @@ class DateTimeToolsTests {
    // ================================

    @Test
-    void startDateTimeRange() {
+    void toDateTimeRange_specifiedDate() {
        Range<LocalDateTime> localDateTimeRange = DateTimeTools.toDateTimeRange(LOCAL_DATE);
        assertEquals(LOCAL_DATE.atStartOfDay(), localDateTimeRange.lowerEndpoint());
        assertEquals(LocalDate.of(2024, 12, 30).atStartOfDay(), localDateTimeRange.upperEndpoint());
@@ -411,6 +392,94 @@ class DateTimeToolsTests {
        assertFalse(zonedDateTimeRange.contains(LocalDate.of(2024, 12, 30).atStartOfDay().atZone(SYS_ZONE_ID)));
    }

+    @Test
+    void toDateTimeRange_dateRange_openRange() {
+        // (2000-01-01..2025-10-01) -> [2000-01-02T00:00..2025-10-01T00:00)
+        Range<LocalDate> dateRange = Range.open(
+                LocalDate.of(2000, 1, 1),
+                LocalDate.of(2025, 10, 1));
+
+        Range<LocalDateTime> localDateTimeRange = DateTimeTools.toDateTimeRange(dateRange);
+        assertEquals(BoundType.CLOSED, localDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 2, 0, 0), localDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, localDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 1, 0, 0), localDateTimeRange.upperEndpoint());
+        log.info(localDateTimeRange.toString());
+
+        Range<ZonedDateTime> zonedDateTimeRange = DateTimeTools.toDateTimeRange(dateRange, ZONE_ID);
+        assertEquals(BoundType.CLOSED, zonedDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 2, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, zonedDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 1, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.upperEndpoint());
+        log.info(zonedDateTimeRange.toString());
+    }
+
+    @Test
+    void toDateTimeRange_dateRange_openClosedRange() {
+        // (2000-01-01..2025-10-01] -> [2025-01-02T00-00..2025-10-02 00:00)
+        Range<LocalDate> dateRange = Range.openClosed(
+                LocalDate.of(2000, 1, 1),
+                LocalDate.of(2025, 10, 1));
+
+        Range<LocalDateTime> localDateTimeRange = DateTimeTools.toDateTimeRange(dateRange);
+        assertEquals(BoundType.CLOSED, localDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 2, 0, 0), localDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, localDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 2, 0, 0), localDateTimeRange.upperEndpoint());
+        log.info(localDateTimeRange.toString());
+
+        Range<ZonedDateTime> zonedDateTimeRange = DateTimeTools.toDateTimeRange(dateRange, ZONE_ID);
+        assertEquals(BoundType.CLOSED, zonedDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 2, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, zonedDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 2, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.upperEndpoint());
+        log.info(zonedDateTimeRange.toString());
+    }
+
+    @Test
+    void toDateTimeRange_dateRange_closedRange() {
+        // [2000-01-01..2025-10-01] -> [2025-01-01T00-00..2025-10-02 00:00)
+        Range<LocalDate> dateRange = Range.closed(
+                LocalDate.of(2000, 1, 1),
+                LocalDate.of(2025, 10, 1));
+
+        Range<LocalDateTime> localDateTimeRange = DateTimeTools.toDateTimeRange(dateRange);
+        assertEquals(BoundType.CLOSED, localDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 1, 0, 0), localDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, localDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 2, 0, 0), localDateTimeRange.upperEndpoint());
+        log.info(localDateTimeRange.toString());
+
+        Range<ZonedDateTime> zonedDateTimeRange = DateTimeTools.toDateTimeRange(dateRange, ZONE_ID);
+        assertEquals(BoundType.CLOSED, zonedDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 1, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, zonedDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 2, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.upperEndpoint());
+        log.info(zonedDateTimeRange.toString());
+    }
+
+    @Test
+    void toDateTimeRange_dateRange_closedOpenRange() {
+        // [2025-01-01..2025-10-01) -> [2025-01-01T00-00..2025-10-01 00:00)
+        Range<LocalDate> dateRange = Range.closedOpen(
+                LocalDate.of(2000, 1, 1),
+                LocalDate.of(2025, 10, 1));
+
+        Range<LocalDateTime> localDateTimeRange = DateTimeTools.toDateTimeRange(dateRange);
+        assertEquals(BoundType.CLOSED, localDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 1, 0, 0), localDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, localDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 1, 0, 0), localDateTimeRange.upperEndpoint());
+        log.info(localDateTimeRange.toString());
+
+        Range<ZonedDateTime> zonedDateTimeRange = DateTimeTools.toDateTimeRange(dateRange, ZONE_ID);
+        assertEquals(BoundType.CLOSED, zonedDateTimeRange.lowerBoundType());
+        assertEquals(LocalDateTime.of(2000, 1, 1, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.lowerEndpoint());
+        assertEquals(BoundType.OPEN, zonedDateTimeRange.upperBoundType());
+        assertEquals(LocalDateTime.of(2025, 10, 1, 0, 0).atZone(ZONE_ID), zonedDateTimeRange.upperEndpoint());
+        log.info(zonedDateTimeRange.toString());
+    }
+
    // ================================
    // #endregion - others
    // ================================