dateutils.java

JAVA EXCEL操作API

/*
 * Created on 2004-3-22
 *
 * To change the template for this generated file go to
 * Window - Preferences - Java - Code Generation - Code and Comments
 */
package com.zosatapo.xls.util;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.TimeZone;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
/**
 * @author Administrator
 *
 * To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Generation - Code and Comments
 */
public class DateUtils
{
	//-----------------------------------------------------------------
	//-----------------------------------------------------------------
	public static String toString(java.util.Date date)
	{
		//yyyy-mm-dd
		DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
		formatter.setTimeZone(TimeZone.getDefault());
		return formatter.format(date);
	}
	public static String toString(java.sql.Date date)
	{
		//yyyy-mm-dd
		return date.toString();
	}
	public static String toString(java.sql.Time date)
	{
		//hh:mm:ss
		return date.toString();
	}
	public static String toString(java.sql.Timestamp date)
	{
		//yyyy-mm-dd hh:mm:ss
		String dateString = date.toString();
		int posIndex = dateString.lastIndexOf(".");
		return dateString.substring(0, posIndex);
	}
	//-----------------------------------------------------------------
	//-----------------------------------------------------------------
	public static java.sql.Date toDate(double xlsDate)
	{
		//System.err.println("[DateUtils#toDate]"+dateString);  
		java.util.Date javaDate = HSSFDateUtil.getJavaDate(xlsDate);
		java.sql.Date sqlDate = new java.sql.Date(javaDate.getTime());
		return sqlDate;
	}
	public static java.sql.Date toDate(String dateString)
	{
    dateString=dateString.trim();
    
    java.sql.Date resultDate = null;
		try
    {
      //try yyyy-mm-dd  --> Date    
      resultDate = java.sql.Date.valueOf(dateString);
    }
    catch(IllegalArgumentException ex)
    {
      try
      {
        //try yyyy/mm/dd  --> Date 
        int year;
        int month;
        int day;
        int firstDash;
        int secondDash;
        firstDash = dateString.indexOf('/');
        secondDash = dateString.indexOf('/', firstDash + 1);
        if ((firstDash > 0) & (secondDash > 0) & (secondDash < dateString.length() - 1))
        {
          year = Integer.parseInt(dateString.substring(0, firstDash)) - 1900;
          month = Integer.parseInt(dateString.substring(firstDash + 1, secondDash)) - 1;
          day = Integer.parseInt(dateString.substring(secondDash + 1));
        }
        else
        {
          throw new java.lang.IllegalArgumentException();
        }
    
        resultDate= new java.sql.Date(year, month, day);
      }
      catch(IllegalArgumentException ex0)
      {
        //try yyyymmdd  --> Date 
        int year;
        int month;
        int day;
        year = Integer.parseInt(dateString.substring(0, 4)) - 1900;
        month = Integer.parseInt(dateString.substring(4, 6)) - 1;
        day = Integer.parseInt(dateString.substring(6,8));   
        resultDate= new java.sql.Date(year, month, day);
      }

    }

		return resultDate;
	}
	public static java.sql.Time toTime(String dateString)
	{
		//System.err.println("[DateUtils#toTime]"+dateString+"|"); 
		java.sql.Time resultDate = java.sql.Time.valueOf(dateString.trim());
		return resultDate;
	}
	public static java.sql.Timestamp toTimestamp(String dateString)
	{
		//System.err.println("[DateUtils#toTimestamp]"+dateString); 
		java.sql.Timestamp resultDate =
			java.sql.Timestamp.valueOf(dateString.trim());
		return resultDate;
	}
	public static java.sql.Date toDate(java.sql.Timestamp ts)
	{
		return new java.sql.Date(ts.getTime());
	}
	public static java.sql.Time toTime(java.sql.Timestamp ts)
	{
		return new java.sql.Time(ts.getTime());
	}
}