import javax.xml.datatype.DatatypeConstants;
import javax.xml.datatype.XMLGregorianCalendar;
import java.time.*;
import java.time.format.DateTimeFormatter;
import java.time.format.FormatStyle;
import java.util.*;

import javax.xml.datatype.DatatypeConstants;
import javax.xml.datatype.DatatypeFactory;
import javax.xml.datatype.XMLGregorianCalendar;
import java.util.Date;
import java.util.TimeZone;

import javax.xml.datatype.DatatypeConstants;
import javax.xml.datatype.XMLGregorianCalendar;

import java.sql.Timestamp;
import java.time.ZoneId;

import javax.xml.datatype.DatatypeConstants;
import javax.xml.datatype.XMLGregorianCalendar;

public class Demo {



    public static final ZoneId ZONE_ID = ZoneId.of("America/Chicago");
    public static Date convertDate2(XMLGregorianCalendar myXmlGregCal) {
        ZonedDateTime zdt = myXmlGregCal.toGregorianCalendar().toZonedDateTime();
        ZoneId zChicago = ZoneId.of("America/Chicago");
        ZonedDateTime zdtChicago = zdt.withZoneSameInstant(zChicago);
        Locale locale = Locale.US;
        DateTimeFormatter f = DateTimeFormatter.ofLocalizedDateTime(FormatStyle.FULL).withLocale(locale);
        String output = zdtChicago.format(f);

        // Parse the output string to LocalDateTime
        LocalDateTime localDateTime = LocalDateTime.parse(output, f);

        // Convert LocalDateTime to Date
        Instant instant = localDateTime.atZone(ZoneId.systemDefault()).toInstant();
        return Date.from(instant);
    }

    public static Date convertDate(XMLGregorianCalendar value) {
        if (value == null) {
            return null;
        } else {
            if (value.getXMLSchemaType() == DatatypeConstants.DATE) {
                return value.toGregorianCalendar().getTime();
            } else {
                LocalDateTime localDateTime = value.toGregorianCalendar().toZonedDateTime().withZoneSameInstant(ZONE_ID).toLocalDateTime();
                return Timestamp.valueOf(localDateTime);
            }
        }
    }

    public static void main(String[] args) {
        try {
            // Parse the XML date string into XMLGregorianCalendar
            XMLGregorianCalendar xmlDate = DatatypeFactory.newInstance().newXMLGregorianCalendar("2024-02-09T01:57:33.240-06:00");
            // Convert XMLGregorianCalendar to Date
            Date date = convertDate(xmlDate);
            // Print the result
          //  System.out.println("Date: " + date);
            System.out.println(convertDate2(xmlDate));
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

概述:

阅读日期从XML开始,假定它在美洲金枪鱼委的时间区。

将美洲金枪鱼委的时间区改为“America/Chicago”的时间区。

在数据库中储存“America/Chicago”时间区。

在从数据库中检索日期时,将其改为“America/Chicago”时段。

 public class Demo {
public static final TimeZone TIMEZONE = TimeZone.getTimeZone("America/Chicago");

// Convert XML date to "America/Chicago" timezone date
public static Date convertXmlDateToChicagoTime(XMLGregorianCalendar value) {
    if (value == null) {
        return null;
    } else {
        // Convert XML date to Date object
        Date date = value.toGregorianCalendar().getTime();
        // Set the timezone of the Date object to UTC
        value.setTimezone(DatatypeConstants.FIELD_UNDEFINED);
        // Convert Date object to "America/Chicago" timezone date
        return convertDateToTimezone(date, TIMEZONE);
    }
}

// Convert database date to "America/Chicago" timezone date
public static Date convertDbDateToChicagoTime(Date date) {
    return convertDateToTimezone(date, TIMEZONE);
}

// Convert date to the specified timezone
private static Date convertDateToTimezone(Date date, TimeZone timezone) {
    long timestamp = date.getTime();
    int offset = timezone.getOffset(timestamp);
    return new Date(timestamp - offset);
}

public static void main(String[] args) {
    try {
        // Assume the date read from XML is "2024-02-09T01:57:33.240-06:00"
        XMLGregorianCalendar xmlDate = DatatypeFactory.newInstance().newXMLGregorianCalendar("2024-02-09T01:57:33.240-06:00");
        // Convert XML date to "America/Chicago" timezone date
        Date chicagoTimeDate = convertXmlDateToChicagoTime(xmlDate);
        // Store chicagoTimeDate into the database...

        // Assume the date retrieved from the database is chicagoTimeDate
        Date retrievedDbDate = chicagoTimeDate;
        // Convert the date from the database to "America/Chicago" timezone date
        Date retrievedChicagoTimeDate = convertDbDateToChicagoTime(retrievedDbDate);

        // Now you can use retrievedChicagoTimeDate, which is represented in "America/Chicago" timezone
        System.out.println("Retrieved Date in Chicago Time: " + retrievedChicagoTimeDate);
    } catch (Exception e) {
        e.printStackTrace();
    }
}

该守则确保,不论从XML中读出日期的时间长短,都正确改为“America/Chicago”时间。 同样,从数据库检索的日期将在“America/Chicago”时间区退回,确保一致性。

Java Demo Class:

import javax.xml.datatype.DatatypeConstants;
import javax.xml.datatype.XMLGregorianCalendar;
import java.time.*;
import java.time.format.DateTimeFormatter;
import java.time.format.FormatStyle;
import java.util.*;

import javax.xml.datatype.DatatypeFactory;
import java.util.Date;

import java.sql.Timestamp;
import java.time.ZoneId;

public class Demo {

  public static final ZoneId ZONE_ID = ZoneId.of("America/Chicago");
  public static final ZoneId ZONE_ID_UTC = ZoneId.of("UTC");

  public static Date convertDate2(XMLGregorianCalendar value) {

    ZonedDateTime dateTimeWithDeliberatelyWrongTimeZone;

    if (value.getTimezone() == DatatypeConstants.FIELD_UNDEFINED) {
      dateTimeWithDeliberatelyWrongTimeZone = value.toGregorianCalendar()
        .toZonedDateTime()
        .withZoneSameInstant(ZONE_ID_UTC) // Assume UTC time
        .withZoneSameLocal(ZONE_ID); // Convert to CST
    } else {
      dateTimeWithDeliberatelyWrongTimeZone = value.toGregorianCalendar()
        .toZonedDateTime()
        .withZoneSameInstant(ZONE_ID)
        // Preserve date and time of day when converting to default time zone
        .withZoneSameLocal(ZoneId.systemDefault());
    }
    return Date.from(dateTimeWithDeliberatelyWrongTimeZone.toInstant());
  }

  public static Date convertDate(XMLGregorianCalendar value) {
    if (value == null) {
      return null;
    } else {
      if (value.getXMLSchemaType() == DatatypeConstants.DATE) {
        return value.toGregorianCalendar().getTime();
      } else {
        LocalDateTime localDateTime = value.toGregorianCalendar().toZonedDateTime().withZoneSameInstant(ZONE_ID).toLocalDateTime();
        return Timestamp.valueOf(localDateTime);
      }
    }
  }

  public static void main(String[] args) {
    try {
      // Parse the XML date string into XMLGregorianCalendar
      XMLGregorianCalendar xmlDate = DatatypeFactory.newInstance().newXMLGregorianCalendar("2024-02-09T01:57:33.240");
      // Convert XMLGregorianCalendar to Date
      Date date = convertDate(xmlDate);
      // Print the result
      // System.out.println("Date: " + date);
      System.out.println(convertDate2(xmlDate));
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}