|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.informix.lang.Interval
com.informix.lang.IntervalYM
This class represents year-to-month INTERVAL SQL data types in Java. This class was created because the Sun JDBC specification did not include such a class.
Timestamp
Field Summary |
Fields inherited from class com.informix.lang.Interval |
TU_DAY, TU_F1, TU_F2, TU_F3, TU_F4, TU_F5, TU_FRAC, TU_HOUR, TU_MINUTE, TU_MONTH, TU_SECOND, TU_YEAR |
Constructor Summary | |
IntervalYM()
Default Constructor with a default qualifier of leading field precision = 4 start code = TU_YEAR end code = TU_MONTH |
|
IntervalYM(java.sql.Connection conn)
Default Constructor with the default qualifier. |
|
IntervalYM(int years,
int months)
Creates an Interval from a number of years and months. |
|
IntervalYM(int years,
int months,
java.sql.Connection conn)
Creates an Interval from a number of years and months. |
|
IntervalYM(int months,
short qual)
Creates an Interval from a number of months and a qualifier. |
|
IntervalYM(int months,
short qual,
java.sql.Connection conn)
Creates an Interval from a number of months and a qualifier. |
|
IntervalYM(java.lang.String str)
Creates an Interval from a string and a default qualifier of leading field precision = 4 start code = TU_YEAR end code = TU_MONTH |
|
IntervalYM(java.lang.String str,
java.sql.Connection conn)
Creates an Interval from a string and the default qualifier. |
|
IntervalYM(java.lang.String str,
int len,
byte startCode,
byte endCode)
Creates an Interval from a string and qualifier information. |
|
IntervalYM(java.lang.String str,
int len,
byte startCode,
byte endCode,
java.sql.Connection conn)
Creates an Interval from a string and qualifier information. |
|
IntervalYM(java.lang.String str,
short qual)
Creates an Interval from a string and the qualifier. |
|
IntervalYM(java.lang.String str,
short qual,
java.sql.Connection conn)
Creates an Interval from a string and the qualifier. |
|
IntervalYM(java.sql.Timestamp t1,
java.sql.Timestamp t2)
Creates an Interval object from two timestamps. |
|
IntervalYM(java.sql.Timestamp t1,
java.sql.Timestamp t2,
java.sql.Connection conn)
Creates an Interval object from two timestamps. |
Method Summary | |
boolean |
equals(java.lang.Object other)
Compares two Intervals for equality. |
void |
fromString(java.lang.String str)
Sets the values for the Interval from a string. |
long |
getMonths()
Returns the number of months in the interval. |
boolean |
greaterThan(IntervalYM other)
Compares this Interval with another to see if it is greater (longer in time) than the other. |
boolean |
lessThan(IntervalYM other)
Compares this Interval with another to see if it is less (shorter in time) than the other. |
void |
set(int years,
int months)
Sets the value of the Interval from years and months. |
void |
set(java.lang.String str)
Set the value of the Interval from a string. |
void |
set(java.sql.Timestamp t1,
java.sql.Timestamp t2)
Sets the value of the Interval from two Timestamps. |
void |
setQualifier(byte len,
byte startCode,
byte endCode)
Sets the qualifier from its constituent pieces. |
void |
setQualifier(short qualifier)
Sets the qualifier from an existing qualifier. |
java.lang.String |
toString()
Returns a string representation of the Interval in the following format: yyyy-mm The presence of the various fields depends upon the qualifier. |
Methods inherited from class com.informix.lang.Interval |
getEndCode, getEndCode, getFieldName, getIfxTypeName, getLength, getQualifier, getQualifier, getScale, getStartCode, getStartCode, getStaticEndCode, getStaticStartCode, goodQualifier, setConnection |
Methods inherited from class java.lang.Object |
getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
public IntervalYM() throws java.sql.SQLException
java.sql.SQLException
public IntervalYM(java.sql.Connection conn) throws java.sql.SQLException
java.sql.SQLException
public IntervalYM(java.sql.Timestamp t1, java.sql.Timestamp t2) throws java.sql.SQLException
t1
- First timestamp.t2
- Second timestamp.
java.sql.SQLException
public IntervalYM(java.sql.Timestamp t1, java.sql.Timestamp t2, java.sql.Connection conn) throws java.sql.SQLException
t1
- First timestamp.t2
- Second timestamp.conn
- Connection object
java.sql.SQLException
public IntervalYM(int years, int months) throws java.sql.SQLException
years
- Number of years.months
- Number of months.
java.sql.SQLException
public IntervalYM(int years, int months, java.sql.Connection conn) throws java.sql.SQLException
years
- Number of years.months
- Number of months.conn
- Connection object.
java.sql.SQLException
public IntervalYM(int months, short qual) throws java.sql.SQLException
months
- Number of months.qual
- Interval qualifier.
java.sql.SQLException
public IntervalYM(int months, short qual, java.sql.Connection conn) throws java.sql.SQLException
months
- Number of months.qual
- Interval qualifier.conn
- Connection object
java.sql.SQLException
public IntervalYM(java.lang.String str) throws java.sql.SQLException
str
- String representation of an Interval value.
java.sql.SQLException
public IntervalYM(java.lang.String str, java.sql.Connection conn) throws java.sql.SQLException
str
- String representation of an Interval value.conn
- Connection object
java.sql.SQLException
public IntervalYM(java.lang.String str, short qual) throws java.sql.SQLException
str
- String representation of an Interval value.qual
- Interval qualifier.
java.sql.SQLException
public IntervalYM(java.lang.String str, short qual, java.sql.Connection conn) throws java.sql.SQLException
str
- String representation of an Interval value.qual
- Interval qualifier.conn
- Connection object
java.sql.SQLException
public IntervalYM(java.lang.String str, int len, byte startCode, byte endCode) throws java.sql.SQLException
str
- The string representation of the year to month Interval.len
- The total length of the qualifier.startCode
- The starting time unit value (TU_XXX).endCode
- The ending time unit value (TU_XXX).
java.sql.SQLException
public IntervalYM(java.lang.String str, int len, byte startCode, byte endCode, java.sql.Connection conn) throws java.sql.SQLException
str
- The string representation of the year to month Interval.len
- The total length of the qualifier.startCode
- The starting time unit value (TU_XXX).endCode
- The ending time unit value (TU_XXX).conn
- Connection object
java.sql.SQLException
Method Detail |
public void set(java.sql.Timestamp t1, java.sql.Timestamp t2)
t1
- First timestamp.t2
- Second timestamp.public void set(int years, int months)
years
- Number of years.months
- Number of months.public void set(java.lang.String str) throws java.sql.SQLException
str
- A valid string representing a year to month INTERVAL.
java.sql.SQLException
public java.lang.String toString()
public void fromString(java.lang.String str) throws java.sql.SQLException
str
- String representation of an Interval value in y-m format.
java.sql.SQLException
public long getMonths()
public boolean equals(java.lang.Object other)
other
- The IntervalYM object to which this Interval is compared.
public boolean greaterThan(IntervalYM other)
other
- The IntervalYM object to which this Interval is compared.
public boolean lessThan(IntervalYM other)
other
- The IntervalYM object to which this Interval is compared.
public void setQualifier(byte len, byte startCode, byte endCode) throws java.sql.SQLException
len
- The total length of the qualifier.startCode
- The starting time unit value (TU_XXX).endCode
- The ending time unit value (TU_XXX).
java.sql.SQLException
public void setQualifier(short qualifier) throws java.sql.SQLException
qualifier
- Qualifier value.
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |