532 lines · 19.1 KB · Java
RawDownload
/* * Copyright (c) 1996, 2011, Oracle and/or its affiliates. All rights reserved. * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * This code is free software; you can redistribute it and/or modify it * under the terms of the GNU General Public License version 2 only, as * published by the Free Software Foundation.  Oracle designates this * particular file as subject to the "Classpath" exception as provided * by Oracle in the LICENSE file that accompanied this code. * * This code is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or * FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License * version 2 for more details (a copy is included in the LICENSE file that * accompanied this code). * * You should have received a copy of the GNU General Public License version * 2 along with this work; if not, write to the Free Software Foundation, * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA. * * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA * or visit www.oracle.com if you need additional information or have any * questions. */ package java.sql; import java.util.StringTokenizer; /** * <P>A thin wrapper around <code>java.util.Date</code> that allows * the JDBC API to identify this as an SQL <code>TIMESTAMP</code> value. * It adds the ability * to hold the SQL <code>TIMESTAMP</code> fractional seconds value, by allowing * the specification of fractional seconds to a precision of nanoseconds. * A Timestamp also provides formatting and * parsing operations to support the JDBC escape syntax for timestamp values. * * <p>The precision of a Timestamp object is calculated to be either: * <ul> * <li><code>19 </code>, which is the number of characters in yyyy-mm-dd hh:mm:ss * <li> <code> 20 + s </code>, which is the number * of characters in the yyyy-mm-dd hh:mm:ss.[fff...] and <code>s</code> represents  the scale of the given Timestamp, * its fractional seconds precision. *</ul> * * <P><B>Note:</B> This type is a composite of a <code>java.util.Date</code> and a * separate nanoseconds value. Only integral seconds are stored in the * <code>java.util.Date</code> component. The fractional seconds - the nanos - are * separate.  The <code>Timestamp.equals(Object)</code> method never returns * <code>true</code> when passed an object * that isn't an instance of <code>java.sql.Timestamp</code>, * because the nanos component of a date is unknown. * As a result, the <code>Timestamp.equals(Object)</code> * method is not symmetric with respect to the * <code>java.util.Date.equals(Object)</code> * method.  Also, the <code>hashCode</code> method uses the underlying * <code>java.util.Date</code> * implementation and therefore does not include nanos in its computation. * <P> * Due to the differences between the <code>Timestamp</code> class * and the <code>java.util.Date</code> * class mentioned above, it is recommended that code not view * <code>Timestamp</code> values generically as an instance of * <code>java.util.Date</code>.  The * inheritance relationship between <code>Timestamp</code> * and <code>java.util.Date</code> really * denotes implementation inheritance, and not type inheritance. */public class Timestamp extends java.util.Date {     /**     * Constructs a <code>Timestamp</code> object initialized     * with the given values.     *     * @param year the year minus 1900     * @param month 0 to 11     * @param date 1 to 31     * @param hour 0 to 23     * @param minute 0 to 59     * @param second 0 to 59     * @param nano 0 to 999,999,999     * @deprecated instead use the constructor <code>Timestamp(long millis)</code>     * @exception IllegalArgumentException if the nano argument is out of bounds     */    @Deprecated    public Timestamp(int year, int month, int date,                     int hour, int minute, int second, int nano) {        super(year, month, date, hour, minute, second);        if (nano > 999999999 || nano < 0) {            throw new IllegalArgumentException("nanos > 999999999 or < 0");        }        nanos = nano;    }     /**     * Constructs a <code>Timestamp</code> object     * using a milliseconds time value. The     * integral seconds are stored in the underlying date value; the     * fractional seconds are stored in the <code>nanos</code> field of     * the <code>Timestamp</code> object.     *     * @param time milliseconds since January 1, 1970, 00:00:00 GMT.     *        A negative number is the number of milliseconds before     *         January 1, 1970, 00:00:00 GMT.     * @see java.util.Calendar     */    public Timestamp(long time) {        super((time/1000)*1000);        nanos = (int)((time%1000) * 1000000);        if (nanos < 0) {            nanos = 1000000000 + nanos;            super.setTime(((time/1000)-1)*1000);        }    }     /**     * Sets this <code>Timestamp</code> object to represent a point in time that is     * <tt>time</tt> milliseconds after January 1, 1970 00:00:00 GMT.     *     * @param time   the number of milliseconds.     * @see #getTime     * @see #Timestamp(long time)     * @see java.util.Calendar     */    public void setTime(long time) {        super.setTime((time/1000)*1000);        nanos = (int)((time%1000) * 1000000);        if (nanos < 0) {            nanos = 1000000000 + nanos;            super.setTime(((time/1000)-1)*1000);        }    }     /**     * Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT     * represented by this <code>Timestamp</code> object.     *     * @return  the number of milliseconds since January 1, 1970, 00:00:00 GMT     *          represented by this date.     * @see #setTime     */    public long getTime() {        long time = super.getTime();        return (time + (nanos / 1000000));    }      /**     * @serial     */    private int nanos;     /**     * Converts a <code>String</code> object in JDBC timestamp escape format to a     * <code>Timestamp</code> value.     *     * @param s timestamp in format <code>yyyy-[m]m-[d]d hh:mm:ss[.f...]</code>.  The     * fractional seconds may be omitted. The leading zero for <code>mm</code>     * and <code>dd</code> may also be omitted.     *     * @return corresponding <code>Timestamp</code> value     * @exception java.lang.IllegalArgumentException if the given argument     * does not have the format <code>yyyy-[m]m-[d]d hh:mm:ss[.f...]</code>     */    public static Timestamp valueOf(String s) {        final int YEAR_LENGTH = 4;        final int MONTH_LENGTH = 2;        final int DAY_LENGTH = 2;        final int MAX_MONTH = 12;        final int MAX_DAY = 31;        String date_s;        String time_s;        String nanos_s;        int year = 0;        int month = 0;        int day = 0;        int hour;        int minute;        int second;        int a_nanos = 0;        int firstDash;        int secondDash;        int dividingSpace;        int firstColon = 0;        int secondColon = 0;        int period = 0;        String formatError = "Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]";        String zeros = "000000000";        String delimiterDate = "-";        String delimiterTime = ":";         if (s == null) throw new java.lang.IllegalArgumentException("null string");         // Split the string into date and time components        s = s.trim();        dividingSpace = s.indexOf(' ');        if (dividingSpace > 0) {            date_s = s.substring(0,dividingSpace);            time_s = s.substring(dividingSpace+1);        } else {            throw new java.lang.IllegalArgumentException(formatError);        }         // Parse the date        firstDash = date_s.indexOf('-');        secondDash = date_s.indexOf('-', firstDash+1);         // Parse the time        if (time_s == null)            throw new java.lang.IllegalArgumentException(formatError);        firstColon = time_s.indexOf(':');        secondColon = time_s.indexOf(':', firstColon+1);        period = time_s.indexOf('.', secondColon+1);         // Convert the date        boolean parsedDate = false;        if ((firstDash > 0) && (secondDash > 0) && (secondDash < date_s.length() - 1)) {            String yyyy = date_s.substring(0, firstDash);            String mm = date_s.substring(firstDash + 1, secondDash);            String dd = date_s.substring(secondDash + 1);            if (yyyy.length() == YEAR_LENGTH &&                    (mm.length() >= 1 && mm.length() <= MONTH_LENGTH) &&                    (dd.length() >= 1 && dd.length() <= DAY_LENGTH)) {                 year = Integer.parseInt(yyyy);                 month = Integer.parseInt(mm);                 day = Integer.parseInt(dd);                 if ((month >= 1 && month <= MAX_MONTH) && (day >= 1 && day <= MAX_DAY)) {                    parsedDate = true;                }            }        }        if (! parsedDate) {            throw new java.lang.IllegalArgumentException(formatError);        }         // Convert the time; default missing nanos        if ((firstColon > 0) & (secondColon > 0) &            (secondColon < time_s.length()-1)) {            hour = Integer.parseInt(time_s.substring(0, firstColon));            minute =                Integer.parseInt(time_s.substring(firstColon+1, secondColon));            if ((period > 0) & (period < time_s.length()-1)) {                second =                    Integer.parseInt(time_s.substring(secondColon+1, period));                nanos_s = time_s.substring(period+1);                if (nanos_s.length() > 9)                    throw new java.lang.IllegalArgumentException(formatError);                if (!Character.isDigit(nanos_s.charAt(0)))                    throw new java.lang.IllegalArgumentException(formatError);                nanos_s = nanos_s + zeros.substring(0,9-nanos_s.length());                a_nanos = Integer.parseInt(nanos_s);            } else if (period > 0) {                throw new java.lang.IllegalArgumentException(formatError);            } else {                second = Integer.parseInt(time_s.substring(secondColon+1));            }        } else {            throw new java.lang.IllegalArgumentException(formatError);        }         return new Timestamp(year - 1900, month - 1, day, hour, minute, second, a_nanos);    }     /**     * Formats a timestamp in JDBC timestamp escape format.     *         <code>yyyy-mm-dd hh:mm:ss.fffffffff</code>,     * where <code>ffffffffff</code> indicates nanoseconds.     * <P>     * @return a <code>String</code> object in     *           <code>yyyy-mm-dd hh:mm:ss.fffffffff</code> format     */    public String toString () {         int year = super.getYear() + 1900;        int month = super.getMonth() + 1;        int day = super.getDate();        int hour = super.getHours();        int minute = super.getMinutes();        int second = super.getSeconds();        String yearString;        String monthString;        String dayString;        String hourString;        String minuteString;        String secondString;        String nanosString;        String zeros = "000000000";        String yearZeros = "0000";        StringBuffer timestampBuf;         if (year < 1000) {            // Add leading zeros            yearString = "" + year;            yearString = yearZeros.substring(0, (4-yearString.length())) +                yearString;        } else {            yearString = "" + year;        }        if (month < 10) {            monthString = "0" + month;        } else {            monthString = Integer.toString(month);        }        if (day < 10) {            dayString = "0" + day;        } else {            dayString = Integer.toString(day);        }        if (hour < 10) {            hourString = "0" + hour;        } else {            hourString = Integer.toString(hour);        }        if (minute < 10) {            minuteString = "0" + minute;        } else {            minuteString = Integer.toString(minute);        }        if (second < 10) {            secondString = "0" + second;        } else {            secondString = Integer.toString(second);        }        if (nanos == 0) {            nanosString = "0";        } else {            nanosString = Integer.toString(nanos);             // Add leading zeros            nanosString = zeros.substring(0, (9-nanosString.length())) +                nanosString;             // Truncate trailing zeros            char[] nanosChar = new char[nanosString.length()];            nanosString.getChars(0, nanosString.length(), nanosChar, 0);            int truncIndex = 8;            while (nanosChar[truncIndex] == '0') {                truncIndex--;            }             nanosString = new String(nanosChar, 0, truncIndex + 1);        }         // do a string buffer here instead.        timestampBuf = new StringBuffer(20+nanosString.length());        timestampBuf.append(yearString);        timestampBuf.append("-");        timestampBuf.append(monthString);        timestampBuf.append("-");        timestampBuf.append(dayString);        timestampBuf.append(" ");        timestampBuf.append(hourString);        timestampBuf.append(":");        timestampBuf.append(minuteString);        timestampBuf.append(":");        timestampBuf.append(secondString);        timestampBuf.append(".");        timestampBuf.append(nanosString);         return (timestampBuf.toString());    }     /**     * Gets this <code>Timestamp</code> object's <code>nanos</code> value.     *     * @return this <code>Timestamp</code> object's fractional seconds component     * @see #setNanos     */    public int getNanos() {        return nanos;    }     /**     * Sets this <code>Timestamp</code> object's <code>nanos</code> field     * to the given value.     *     * @param n the new fractional seconds component     * @exception java.lang.IllegalArgumentException if the given argument     *            is greater than 999999999 or less than 0     * @see #getNanos     */    public void setNanos(int n) {        if (n > 999999999 || n < 0) {            throw new IllegalArgumentException("nanos > 999999999 or < 0");        }        nanos = n;    }     /**     * Tests to see if this <code>Timestamp</code> object is     * equal to the given <code>Timestamp</code> object.     *     * @param ts the <code>Timestamp</code> value to compare with     * @return <code>true</code> if the given <code>Timestamp</code>     *         object is equal to this <code>Timestamp</code> object;     *         <code>false</code> otherwise     */    public boolean equals(Timestamp ts) {        if (super.equals(ts)) {            if  (nanos == ts.nanos) {                return true;            } else {                return false;            }        } else {            return false;        }    }     /**     * Tests to see if this <code>Timestamp</code> object is     * equal to the given object.     *     * This version of the method <code>equals</code> has been added     * to fix the incorrect     * signature of <code>Timestamp.equals(Timestamp)</code> and to preserve backward     * compatibility with existing class files.     *     * Note: This method is not symmetric with respect to the     * <code>equals(Object)</code> method in the base class.     *     * @param ts the <code>Object</code> value to compare with     * @return <code>true</code> if the given <code>Object</code> is an instance     *         of a <code>Timestamp</code> that     *         is equal to this <code>Timestamp</code> object;     *         <code>false</code> otherwise     */    public boolean equals(java.lang.Object ts) {      if (ts instanceof Timestamp) {        return this.equals((Timestamp)ts);      } else {        return false;      }    }     /**     * Indicates whether this <code>Timestamp</code> object is     * earlier than the given <code>Timestamp</code> object.     *     * @param ts the <code>Timestamp</code> value to compare with     * @return <code>true</code> if this <code>Timestamp</code> object is earlier;     *        <code>false</code> otherwise     */    public boolean before(Timestamp ts) {        return compareTo(ts) < 0;    }     /**     * Indicates whether this <code>Timestamp</code> object is     * later than the given <code>Timestamp</code> object.     *     * @param ts the <code>Timestamp</code> value to compare with     * @return <code>true</code> if this <code>Timestamp</code> object is later;     *        <code>false</code> otherwise     */    public boolean after(Timestamp ts) {        return compareTo(ts) > 0;    }     /**     * Compares this <code>Timestamp</code> object to the given     * <code>Timestamp</code> object.     *     * @param   ts   the <code>Timestamp</code> object to be compared to     *                this <code>Timestamp</code> object     * @return  the value <code>0</code> if the two <code>Timestamp</code>     *          objects are equal; a value less than <code>0</code> if this     *          <code>Timestamp</code> object is before the given argument;     *          and a value greater than <code>0</code> if this     *          <code>Timestamp</code> object is after the given argument.     * @since   1.4     */    public int compareTo(Timestamp ts) {        long thisTime = this.getTime();        long anotherTime = ts.getTime();        int i = (thisTime<anotherTime ? -1 :(thisTime==anotherTime?0 :1));        if (i == 0) {            if (nanos > ts.nanos) {                    return 1;            } else if (nanos < ts.nanos) {                return -1;            }        }        return i;     }     /**     * Compares this <code>Timestamp</code> object to the given     * <code>Date</code> object.     *     * @param o the <code>Date</code> to be compared to     *          this <code>Timestamp</code> object     * @return  the value <code>0</code> if this <code>Timestamp</code> object     *          and the given object are equal; a value less than <code>0</code>     *          if this  <code>Timestamp</code> object is before the given argument;     *          and a value greater than <code>0</code> if this     *          <code>Timestamp</code> object is after the given argument.

Lines 1–500 of 532.