org_hsqldb_library.properties

hsqldb是100％java实现的数据库,是一个开放源代码的JAVA数据库 l 具有标准的SQL语法和JAVA接口 l HSQLDB可以自由使用和分发 l 非常简洁和快速的

soundex(java.lang.String)@0=the 4 character <code>SOUNDEX</code> value for the given <code>String</code>
soundex(java.lang.String)@1=s - the <code>String</code> for which to calculate the 4 character <code>SOUNDEX</code> value
space(int)=Returns a <code>String</code> consisting of <code>count</code> spaces, or <code>null</code> if <code>count</code> is less than zero. <p>
space(int)@0=a <code>String</code> of <code>count</code> spaces
space(int)@1=count - the number of spaces to produce
substring(java.lang.String,int,java.lang.Integer)=Returns the characters from the given <code>String</code>, staring at the indicated one-based <code>start</code> position and extending the (optional) indicated <code>length</code>. If <code>length</code> is not specified (is <code>null</code>), the remainder of <code>s</code> is implied.
substring(java.lang.String,int,java.lang.Integer)@0=the indicted substring of <code>s</code>.
substring(java.lang.String,int,java.lang.Integer)@1=s - the <code>String</code> from which to produce the indicated substring
substring(java.lang.String,int,java.lang.Integer)@2=start - the starting position of the desired substring
substring(java.lang.String,int,java.lang.Integer)@3=length - the length of the desired substring
ucase(java.lang.String)=Returns a copy of the given <code>String</code>, with all lower case characters converted to upper case using the default Java method.
ucase(java.lang.String)@0=an upper case version of <code>s</code>
ucase(java.lang.String)@1=s - the <code>String</code> from which to produce an upper case version
curdate()=Returns the current date as a date value.
curdate()@0=a date value representing the current date
curtime()=Returns the current local time as a time value.
curtime()@0=a time value representing the current local time
dayname(java.sql.Date)=Returns a character string containing the name of the day (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday ) for the day portion of the given <code>java.sql.Date</code>.
dayname(java.sql.Date)@0=the name of the day corresponding to the given <code>java.sql.Date</code>
dayname(java.sql.Date)@1=d - the date value from which to extract the day name
dayofmonth(java.sql.Date)=Returns the day of the month from the given date value, as an integer value in the range of 1-31.
dayofmonth(java.sql.Date)@0=the day of the month from the given date value
dayofmonth(java.sql.Date)@1=d - the date value from which to extract the day of month
dayofweek(java.sql.Date)=Returns the day of the week from the given date value, as an integer value in the range 1-7, where 1 represents Sunday.
dayofweek(java.sql.Date)@0=the day of the week from the given date value
dayofweek(java.sql.Date)@1=d - the date value from which to extract the day of week
dayofyear(java.sql.Date)=Returns the day of the year from the given date value, as an integer value in the range 1-366.
dayofyear(java.sql.Date)@0=the day of the year from the given date value
dayofyear(java.sql.Date)@1=d - the date value from which to extract the day of year
hour(java.sql.Time)=Returns the hour from the given time value, as an integer value in the range of 0-23.
hour(java.sql.Time)@0=the hour of day from the given time value
hour(java.sql.Time)@1=t - the time value from which to extract the hour of day
minute(java.sql.Time)=Returns the minute from the given time value, as integer value in the range of 0-59.
minute(java.sql.Time)@0=the minute value from the given time value
minute(java.sql.Time)@1=t - the time value from which to extract the minute value
month(java.sql.Date)=Returns the month from the given date value, as an integer value in the range of 1-12 or 0-11. <p> If the sql_month database property is set <code>true</code>, then the range is 1-12, else 0-11
month(java.sql.Date)@0=the month value from the given date value
month(java.sql.Date)@1=d - the date value from which to extract the month value
monthname(java.sql.Date)=Returns a character string containing the name of month (January, February, March, April, May, June, July, August, September, October, November, December) for the month portion of the given date value.
monthname(java.sql.Date)@0=a String representing the month name from the given date value
monthname(java.sql.Date)@1=d - the date value from which to extract the month name
now()=Returns the current date and time as a timestamp value.
now()@0=a timestamp value representing the current date and time
quarter(java.sql.Date)=Returns the quarter of the year in the given date value, as an integer value in the range of 1-4.
quarter(java.sql.Date)@0=an integer representing the quater of the year from the given date value
quarter(java.sql.Date)@1=d - the date value from which to extract the quarter of the year
second(java.sql.Time)=Returns the second of the given time value, as an integer value in the range of 0-59.
second(java.sql.Time)@0=an integer representing the second of the hour from the given time value
second(java.sql.Time)@1=d - the date value from which to extract the second of the hour
week(java.sql.Date)=Returns the week of the year from the given date value, as an integer value in the range of 1-53.
week(java.sql.Date)@0=an integer representing the week of the year from the given date value
week(java.sql.Date)@1=d - the date value from which to extract the week of the year
year(java.sql.Date)=Returns the year from the given date value, as an integer value in the range of 1-9999.
year(java.sql.Date)@0=an integer value representing the year from the given date value
year(java.sql.Date)@1=d - the date value from which to extract the year
database(java.sql.Connection)=Returns the name of the database corresponding to this connection.
database(java.sql.Connection)@0=the name of the database for the given connection
database(java.sql.Connection)@1=conn - the connection for which to retrieve the database name
user(java.sql.Connection)=Returns the user's authorization name (the user's name as known to this database).
user(java.sql.Connection)@0=the user's name as known to the database
user(java.sql.Connection)@1=conn - the connection for which to retrieve the user name
identity()=Retrieves the last auto-generated integer indentity value used by this connection. As of 1.7.1 this is a dummy function. The return value is supplied directly by Function.java
identity()@0=the connection's the last generated integer identity value
getAutoCommit(java.sql.Connection)=Retrieves the autocommit status of this connection. <p>
getAutoCommit(java.sql.Connection)@0=a boolean value representing the connection's autocommit status
getAutoCommit(java.sql.Connection)@1=conn - the <code>Connection</code> object for which to retrieve the current autocommit status
getDatabaseProductName()=Retrieves the name of this database product. <p>
getDatabaseProductName()@0=database product name as a <code>String</code> object
getDatabaseProductVersion()=Retrieves the version number of this database product. <p>
getDatabaseProductVersion()@0=database version number as a <code>String</code> object
getDatabaseMajorVersion()=Retrieves the major version number of this database. <p>
getDatabaseMajorVersion()@0=the database's major version as an <code>int</code> value
getDatabaseMinorVersion()=Retrieves the major version number of this database. <p>
getDatabaseMinorVersion()@0=the database's major version as an <code>int</code> value
isReadOnlyConnection(java.sql.Connection)=Retrieves whether this connection is in read-only mode. <p>
isReadOnlyConnection(java.sql.Connection)@0=<code>true</code> if connection is read-only and <code>false</code> otherwise
isReadOnlyConnection(java.sql.Connection)@1=conn - the <code>Connection</code> object for which to retrieve the current read-only status
isReadOnlyDatabase(java.sql.Connection)=Retrieves whether this database is in read-only mode. <p>
isReadOnlyDatabase(java.sql.Connection)@0=<code>true</code> if so; <code>false</code> otherwise
isReadOnlyDatabase(java.sql.Connection)@1=c the <code>Connection</code> object for which to retrieve the current database read-only status
#Since 1.7.2
bitLength(java.lang.String)=Returns the number of bits in the given <code>String</code>. This includes trailing blanks.
bitLength(java.lang.String)@0=the bit length of <code>s</code>, including trailing blanks
bitLength(java.lang.String)@1=The <code>String</code> for which to retrieve the bit length
datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp)=Returns the number of date and time boundaries crossed between two specified datetime values.
datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp)@0=the number of date and time boundaries crossed between two specified dates, as a Long value
datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp)@1=datepart - Specifies the unit in which the interval is to be measured
datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp)@2=startdate - The starting datetime value for the interval. This value is subtracted from enddate to return the number of date-parts between the two arguments.
datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp)@3=enddate - The ending datetime for the interval. startdate is subtracted from this value to return the number of date-parts between the two arguments
isReadOnlyDatabaseFiles(java.sql.Connection)=Retrieves whether the files of this database are in read-only mode.
isReadOnlyDatabaseFiles(java.sql.Connection)@0=<code>true</code> if so; <code>false</code> otherwise
isReadOnlyDatabaseFiles(java.sql.Connection)@1=c the <code>Connection</code> object for which to retrieve the current database files read-only status
octetLength(java.lang.String)=Returns the number of bytes in the given <code>String</code>. This includes trailing blanks.
octetLength(java.lang.String)@0=the octent length of <code>s</code>, including trailing blanks
octetLength(java.lang.String)@1=The <code>String</code> for which to retrieve the octent length
position(java.lang.String,java.lang.String)=Returns the starting position of the first occurrence of the given <code>search</code> <code>String</code> object within the given <code>String</code> object, <code>s</code>.
position(java.lang.String,java.lang.String)@0=the one-based starting position of the first occurrence of <code>search</code> within <code>s</code>, or 0 if not found
position(java.lang.String,java.lang.String)@1=search - the <code>String</code> occurence to find in <code>s</code>
position(java.lang.String,java.lang.String)@2=s - the <code>String</code> within which to find the first occurence of <code>search</code>
trim(java.lang.String,java.lang.String,boolean,boolean)=Retrieves a character sequence derived from <code>s</code> with the leading, trailing or both leading and trailing occurances of <code>trimstr</code> removed
trim(java.lang.String,java.lang.String,boolean,boolean)@0=The character sequence <code>s</code>, with either the leading or trailing occurrences of <code>trimstr</code> removed
trim(java.lang.String,java.lang.String,boolean,boolean)@1=s - the character sequence from which to remove occurrences of <code>trimstr</code>
trim(java.lang.String,java.lang.String,boolean,boolean)@2=trimstr - the character sequence whose occurances are to be removed from <code>s</code>
trim(java.lang.String,java.lang.String,boolean,boolean)@3=leading - if true, then leading occurences are removed
trim(java.lang.String,java.lang.String,boolean,boolean)@4=trailing - if true, then trailing occurences are removed