获取存储过程信息DatabaseMetaData : 数据库元数据 « 数据库 « Java 教程

En
Java 教程
1. 语言基础
2. 数据类型
3. 操作符
4. 流程控制
5. 类定义
6. 开发相关
7. 反射
8. 正则表达式
9. 集合
10. 线
11. 文件
12. 泛型
13. 本土化
14. Swing
15. Swing事件
16. 二维图形
17. SWT
18. SWT 二维图形
19. 网络
20. 数据库
21. Hibernate
22. JPA
23. JSP
24. JSTL
25. Servlet
26. Web服务SOA
27. EJB3
28. Spring
29. PDF
30. 电子邮件
31. 基于J2ME
32. J2EE应用
33. XML
34. 设计模式
35. 日志
36. 安全
37. Apache工具
38. 蚂蚁编译
39. JUnit单元测试
Java
Java 教程 » 数据库 » 数据库元数据 
20. 30. 13. 获取存储过程信息DatabaseMetaData
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

public class Main {
  public static void main(String[] argsthrows Exception {
    Connection conn = getConnection();

    DatabaseMetaData mtdt = conn.getMetaData();
    
    System.out.println(mtdt.getProcedureTerm());
    
    ResultSet rs = mtdt.getProcedures(conn.getCatalog(),"%""%");
    
    ResultSetMetaData rsmd = rs.getMetaData();
    int numCols = rsmd.getColumnCount();
    for (int i = 1; i <= numCols; i++) {
      if (i > 1)
        System.out.print(", ");
      System.out.print(rsmd.getColumnLabel(i));
    }
    System.out.println("");
    while (rs.next()) {
      for (int i = 1; i <= numCols; i++) {
        if (i > 1)
          System.out.print(", ");
        System.out.print(rs.getString(i));
      }
      System.out.println("");
    }
    conn.close();
  }

  private static Connection getConnection() throws Exception {
    Class.forName("org.hsqldb.jdbcDriver");
    String url = "jdbc:hsqldb:mem:data/tutorial";

    return DriverManager.getConnection(url, "sa""");
  }
}
PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME, NUM_INPUT_PARAMS, NUM_OUTPUT_PARAMS, NUM_RESULT_SETS, REMARKS, PROCEDURE_TYPE, ORIGIN, SPECIFIC_NAME
null, PUBLIC, ABS, 1, 0, 1, Returns the absolute value of the given double value., 2, ALIAS, org.hsqldb.Library.abs(double)
null, PUBLIC, ACOS, 1, 0, 1, Returns the arc cosine of an angle, in the range of 0.0 through pi. Special case: 
  • If the argument is NaN or its absolute value is greater than 1, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.acos(double) null, PUBLIC, ASCII, 1, 0, 1, Returns the Unicode code value of the leftmost character of s as an int. This is the same as the ASCII value if the string contains only ASCII characters., 2, ALIAS, org.hsqldb.Library.ascii(java.lang.String) null, PUBLIC, ASIN, 1, 0, 1, Returns the arc sine of an angle, in the range of -pi/2 through pi/2. Special cases:

  • If the argument is NaN or its absolute value is greater than 1, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.asin(double) null, PUBLIC, ATAN, 1, 0, 1, Returns the arc tangent of an angle, in the range of -pi/2 through pi/2. Special cases:

  • If the argument is NaN, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.atan(double) null, PUBLIC, ATAN2, 2, 0, 1, Converts rectangular coordinates (xy) to polar (r, theta). This method computes the phase theta by computing an arc tangent of y/x in the range of -pi to pi. Special cases:

  • If either argument is NaN, then the result is NaN.
  • If the first argument is positive zero and the second argument is positive, or the first argument is positive and finite and the second argument is positive infinity, then the result is positive zero.
  • If the first argument is negative zero and the second argument is positive, or the first argument is negative and finite and the second argument is positive infinity, then the result is negative zero.
  • If the first argument is positive zero and the second argument is negative, or the first argument is positive and finite and the second argument is negative infinity, then the result is the double value closest to pi.
  • If the first argument is negative zero and the second argument is negative, or the first argument is negative and finite and the second argument is negative infinity, then the result is the double value closest to -pi.
  • If the first argument is positive and the second argument is positive zero or negative zero, or the first argument is positive infinity and the second argument is finite, then the result is the double value closest to pi/2.
  • If the first argument is negative and the second argument is positive zero or negative zero, or the first argument is negative infinity and the second argument is finite, then the result is the double value closest to -pi/2.
  • If both arguments are positive infinity, then the result is the double value closest to pi/4.
  • If the first argument is positive infinity and the second argument is negative infinity, then the result is the double value closest to 3*pi/4.
  • If the first argument is negative infinity and the second argument is positive infinity, then the result is the double value closest to -pi/4.
  • If both arguments are negative infinity, then the result is the double value closest to -3*pi/4.

A result must be within 2 ulps of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.atan2(double,double) null, PUBLIC, BITAND, 2, 0, 1, Returns the bit-wise logical and of the given integer values., 2, ALIAS, org.hsqldb.Library.bitand(int,int) null, PUBLIC, BITOR, 2, 0, 1, Returns the bit-wise logical xor of the given integer values., 2, ALIAS, org.hsqldb.Library.bitor(int,int) null, PUBLIC, BITXOR, 2, 0, 1, null, 2, ALIAS, org.hsqldb.Library.bitxor(int,int) null, PUBLIC, BIT_LENGTH, 1, 0, 1, Returns the number of bits in the given String. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.bitLength(java.lang.String) null, PUBLIC, CEILING, 1, 0, 1, Returns the smallest (closest to negative infinity) double value that is not less than the argument and is equal to a mathematical integer. Special cases:

  • If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
  • If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.
  • If the argument value is less than zero but greater than -1.0, then the result is negative zero.
Note that the value of Math.ceil(x) is exactly the value of -Math.floor(-x)., 2, ALIAS, java.lang.Math.ceil(double) null, PUBLIC, CHAR, 1, 0, 1, Returns the character string corresponding to the given ASCII (or Unicode) value. Note:

In some SQL CLI implementations, a null is returned if the range is outside 0..255. In HSQLDB, the corresponding Unicode character is returned unchecked., 2, ALIAS, org.hsqldb.Library.character(int) null, PUBLIC, CHARACTER_LENGTH, 1, 0, 1, Returns the number of characters in the given String. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.length(java.lang.String) null, PUBLIC, CHAR_LENGTH, 1, 0, 1, Returns the number of characters in the given String. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.length(java.lang.String) null, PUBLIC, CONCAT, 2, 0, 1, Returns a String object that is the result of an SQL-style concatenation of the given String objects.

Note: by SQL-style, it is meant:

  • if both String objects are null, return null
  • if only one string is null, return the other
  • if both String objects are non-null, return as a String object the character sequence obtained by listing, in left to right order, the characters of the first string followed by the characters of the second
, 2, ALIAS, org.hsqldb.Library.concat(java.lang.String,java.lang.String) null, PUBLIC, COS, 1, 0, 1, Returns the trigonometric cosine of an angle. Special cases:
  • If the argument is NaN or an infinity, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.cos(double) null, PUBLIC, COT, 1, 0, 1, Returns the cotangent of the given double value expressed in radians., 2, ALIAS, org.hsqldb.Library.cot(double) null, PUBLIC, CURDATE, 1, 0, 1, null, 2, ALIAS, org.hsqldb.Library.curdate(java.sql.Connection) null, PUBLIC, CURTIME, 1, 0, 1, null, 2, ALIAS, org.hsqldb.Library.curtime(java.sql.Connection) null, PUBLIC, DATABASE, 1, 0, 1, Returns the name of the database corresponding to this connection., 2, ALIAS, org.hsqldb.Library.database(java.sql.Connection) null, PUBLIC, DATEDIFF, 3, 0, 1, Returns the number of date and time boundaries crossed between two specified datetime values., 2, ALIAS, org.hsqldb.Library.datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp) null, PUBLIC, DAY, 1, 0, 1, Returns the day of the month from the given date value, as an integer value in the range of 1-31., 2, ALIAS, org.hsqldb.Library.dayofmonth(java.sql.Date) null, PUBLIC, DAYNAME, 1, 0, 1, Returns a character string containing the name of the day (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday ) for the day portion of the given java.sql.Date., 2, ALIAS, org.hsqldb.Library.dayname(java.sql.Date) null, PUBLIC, DAYOFMONTH, 1, 0, 1, Returns the day of the month from the given date value, as an integer value in the range of 1-31., 2, ALIAS, org.hsqldb.Library.dayofmonth(java.sql.Date) null, PUBLIC, DAYOFWEEK, 1, 0, 1, Returns the day of the week from the given date value, as an integer value in the range 1-7, where 1 represents Sunday., 2, ALIAS, org.hsqldb.Library.dayofweek(java.sql.Date) null, PUBLIC, DAYOFYEAR, 1, 0, 1, Returns the day of the year from the given date value, as an integer value in the range 1-366., 2, ALIAS, org.hsqldb.Library.dayofyear(java.sql.Date) null, PUBLIC, DEGREES, 1, 0, 1, Converts an angle measured in radians to an approximately equivalent angle measured in degrees. The conversion from radians to degrees is generally inexact; users should not expect cos(toRadians(90.0)) to exactly equal 0.0., 2, ALIAS, java.lang.Math.toDegrees(double) null, PUBLIC, DIFFERENCE, 2, 0, 1, Returns a count of the characters that do not match when comparing the 4 digit numeric SOUNDEX character sequences for the given String objects. If either String object is null, zero is returned., 2, ALIAS, org.hsqldb.Library.difference(java.lang.String,java.lang.String) null, PUBLIC, EXP, 1, 0, 1, Returns Euler's number e raised to the power of a double value. Special cases:

  • If the argument is NaN, the result is NaN.
  • If the argument is positive infinity, then the result is positive infinity.
  • If the argument is negative infinity, then the result is positive zero.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.exp(double) null, PUBLIC, FLOOR, 1, 0, 1, Returns the largest (closest to positive infinity) double value that is not greater than the argument and is equal to a mathematical integer. Special cases:

  • If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
  • If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.
, 2, ALIAS, java.lang.Math.floor(double) null, PUBLIC, HEXTORAW, 1, 0, 1, Converts a String of hexidecimal digit characters to a raw binary value, represented as a String.

The given String object must consist of a sequence of 4 digit hexidecimal character substrings.

If its length is not evenly divisible by 4, null is returned. If any any of its 4 character subsequences cannot be parsed as a 4 digit, base 16 value, then a NumberFormatException is thrown. This conversion has the effect of reducing the character count 4:1., 2, ALIAS, org.hsqldb.Library.hexToRaw(java.lang.String) null, PUBLIC, HOUR, 1, 0, 1, Returns the hour from the given time value, as an integer value in the range of 0-23., 2, ALIAS, org.hsqldb.Library.hour(java.sql.Time) null, PUBLIC, IDENTITY, 0, 0, 1, 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, 2, ALIAS, org.hsqldb.Library.identity() null, PUBLIC, INSERT, 4, 0, 1, Returns a character sequence which is the result of writing the first length number of characters from the second given String over the first string. The start position in the first string where the characters are overwritten is given by start.

Note: In order of precedence, boundry conditions are handled as follows:

  • if either supplied String is null, then the other is returned; the check starts with the first given String.
  • if start is less than one, s1 is returned
  • if length is less than or equal to zero, s1 is returned
  • if the length of s2 is zero, s1 is returned
  • if start is greater than the length of s1, s1 is returned
  • if length is such that, taken together with start, the indicated interval extends beyond the end of s1, then the insertion is performed precisely as if upon a copy of s1 extended in length to just include the indicated interval
, 2, ALIAS, org.hsqldb.Library.insert(java.lang.String,int,int,java.lang.String) null, PUBLIC, LCASE, 1, 0, 1, Returns a copy of the given String, with all upper case characters converted to lower case. This uses the default Java String conversion., 2, ALIAS, org.hsqldb.Library.lcase(java.lang.String) null, PUBLIC, LEFT, 2, 0, 1, Returns the leftmost count characters from the given String.

Note: boundry conditions are handled in the following order of precedence:

  • if s is null, then null is returned
  • if count is less than 1, then a zero-length String is returned
  • if count is greater than the length of s, then a copy of s is returned
, 2, ALIAS, org.hsqldb.Library.left(java.lang.String,int) null, PUBLIC, LENGTH, 1, 0, 1, Returns the number of characters in the given String. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.length(java.lang.String) null, PUBLIC, LOCATE, 3, 0, 1, Returns the starting position of the first occurrence of the given search String object within the given String object, s. The search for the first occurrence of search begins with the first character position in s, unless the optional argument, start, is specified (non-null). If start is specified, the search begins with the character position indicated by the value of start, where the first character position in s is indicated by the value 1. If search is not found within s, the value 0 is returned., 2, ALIAS, org.hsqldb.Library.locate(java.lang.String,java.lang.String,java.lang.Integer) null, PUBLIC, LOG, 1, 0, 1, Returns the natural logarithm (base e) of a double value. Special cases:
  • If the argument is NaN or less than zero, then the result is NaN.
  • If the argument is positive infinity, then the result is positive infinity.
  • If the argument is positive zero or negative zero, then the result is negative infinity.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.log(double) null, PUBLIC, LOG10, 1, 0, 1, Returns the base 10 logarithm of the given double value., 2, ALIAS, org.hsqldb.Library.log10(double) null, PUBLIC, LOWER, 1, 0, 1, Returns a copy of the given String, with all upper case characters converted to lower case. This uses the default Java String conversion., 2, ALIAS, org.hsqldb.Library.lcase(java.lang.String) null, PUBLIC, LTRIM, 1, 0, 1, Returns the characters of the given String, with the leading spaces removed. Characters such as TAB are not removed., 2, ALIAS, org.hsqldb.Library.ltrim(java.lang.String) null, PUBLIC, MINUTE, 1, 0, 1, Returns the minute from the given time value, as integer value in the range of 0-59., 2, ALIAS, org.hsqldb.Library.minute(java.sql.Time) null, PUBLIC, MOD, 2, 0, 1, Returns the remainder (modulus) of the first given integer divided by the second.

, 2, ALIAS, org.hsqldb.Library.mod(int,int) null, PUBLIC, MONTH, 1, 0, 1, Returns the month from the given date value, as an integer value in the range of 1-12 or 0-11.

If the sql_month database property is set true, then the range is 1-12, else 0-11, 2, ALIAS, org.hsqldb.Library.month(java.sql.Date) null, PUBLIC, MONTHNAME, 1, 0, 1, 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., 2, ALIAS, org.hsqldb.Library.monthname(java.sql.Date) null, PUBLIC, NOW, 1, 0, 1, null, 2, ALIAS, org.hsqldb.Library.now(java.sql.Connection) null, PUBLIC, OCTET_LENGTH, 1, 0, 1, Returns the number of bytes in the given String. This includes trailing blanks., 2, ALIAS, org.hsqldb.Library.octetLength(java.lang.String) null, PUBLIC, PI, 0, 0, 1, Returns the constant value, pi., 2, ALIAS, org.hsqldb.Library.pi() null, PUBLIC, POWER, 2, 0, 1, Returns of value of the first argument raised to the power of the second argument. Special cases:

  • If the second argument is positive or negative zero, then the result is 1.0.
  • If the second argument is 1.0, then the result is the same as the first argument.
  • If the second argument is NaN, then the result is NaN.
  • If the first argument is NaN and the second argument is nonzero, then the result is NaN.
  • If the absolute value of the first argument is greater than 1 and the second argument is positive infinity, or the absolute value of the first argument is less than 1 and the second argument is negative infinity, then the result is positive infinity.
  • If the absolute value of the first argument is greater than 1 and the second argument is negative infinity, or the absolute value of the first argument is less than 1 and the second argument is positive infinity, then the result is positive zero.
  • If the absolute value of the first argument equals 1 and the second argument is infinite, then the result is NaN.
  • If the first argument is positive zero and the second argument is greater than zero, or the first argument is positive infinity and the second argument is less than zero, then the result is positive zero.
  • If the first argument is positive zero and the second argument is less than zero, or the first argument is positive infinity and the second argument is greater than zero, then the result is positive infinity.
  • If the first argument is negative zero and the second argument is greater than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is less than zero but not a finite odd integer, then the result is positive zero.
  • If the first argument is negative zero and the second argument is a positive finite odd integer, or the first argument is negative infinity and the second argument is a negative finite odd integer, then the result is negative zero.
  • If the first argument is negative zero and the second argument is less than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is greater than zero but not a finite odd integer, then the result is positive infinity.
  • If the first argument is negative zero and the second argument is a negative finite odd integer, or the first argument is negative infinity and the second argument is a positive finite odd integer, then the result is negative infinity.
  • If the first argument is less than zero and the second argument is a finite even integer, then the result is equal to the result of raising the absolute value of the first argument to the power of the second argument.
  • If the first argument is less than zero and the second argument is a finite odd integer, then the result is equal to the negative of the result of raising the absolute value of the first argument to the power of the second argument.
  • If the first argument is finite and less than zero and the second argument is finite and not an integer, then the result is NaN.
  • If both arguments are integers, then the result is exactly equal to the mathematical result of raising the first argument to the power of the second argument if that result can in fact be represented exactly as a double value.

(In the foregoing descriptions, a floating-point value is considered to be an integer if and only if it is a fixed point of the method {@link #ceil ceil} or, equivalently, a fixed point of the method {@link #floor floor}. A value is a fixed point of a one-argument method if and only if the result of applying the method to the value is equal to the value.)

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.pow(double,double) null, PUBLIC, QUARTER, 1, 0, 1, Returns the quarter of the year in the given date value, as an integer value in the range of 1-4., 2, ALIAS, org.hsqldb.Library.quarter(java.sql.Date) null, PUBLIC, RADIANS, 1, 0, 1, Converts an angle measured in degrees to an approximately equivalent angle measured in radians. The conversion from degrees to radians is generally inexact., 2, ALIAS, java.lang.Math.toRadians(double) null, PUBLIC, RAND, 0, 0, 1, Returns a double value with a positive sign, greater than or equal to 0.0 and less than 1.0. Returned values are chosen pseudorandomly with (approximately) uniform distribution from that range.

When this method is first called, it creates a single new pseudorandom-number generator, exactly as if by the expression

new java.util.Random
This new pseudorandom-number generator is used thereafter for all calls to this method and is used nowhere else.

This method is properly synchronized to allow correct use by more than one thread. However, if many threads need to generate pseudorandom numbers at a great rate, it may reduce contention for each thread to have its own pseudorandom-number generator., 2, ALIAS, java.lang.Math.random() null, PUBLIC, RAWTOHEX, 1, 0, 1, Converts a raw binary value, as represented by the given String, to the equivalent String of hexidecimal digit characters.

This conversion has the effect of expanding the character count 1:4., 2, ALIAS, org.hsqldb.Library.rawToHex(java.lang.String) null, PUBLIC, REPEAT, 2, 0, 1, Returns a String composed of the given String, repeated count times., 2, ALIAS, org.hsqldb.Library.repeat(java.lang.String,java.lang.Integer) null, PUBLIC, REPLACE, 3, 0, 1, Replaces all occurrences of replace in s with the String object: with, 2, ALIAS, org.hsqldb.Library.replace(java.lang.String,java.lang.String,java.lang.String) null, PUBLIC, RIGHT, 2, 0, 1, Returns the rightmost count characters of the given String, s. Note: boundry conditions are handled in the following order of precedence:

  • if s is null, null is returned
  • if count is less than one, a zero-length String is returned
  • if count is greater than the length of s, a copy of s is returned
, 2, ALIAS, org.hsqldb.Library.right(java.lang.String,int) null, PUBLIC, ROUND, 2, 0, 1, Returns the given double value, rounded to the given int places right of the decimal point. If the supplied rounding place value is negative, rounding is performed to the left of the decimal point, using its magnitude (absolute value)., 2, ALIAS, org.hsqldb.Library.round(double,int) null, PUBLIC, ROUNDMAGIC, 1, 0, 1, Retrieves a magically rounded double value produced from the given double value. This method provides special handling for numbers close to zero and performs rounding only for numbers within a specific range, returning precisely the given value if it does not lie in this range.

Special handling includes:

  • input in the interval -0.0000000000001..0.0000000000001 returns 0.0
  • input outside the interval -1000000000000..1000000000000 returns input unchanged
  • input is converted to String form
  • input with a String form length greater than 16 returns input unchaged
  • String form with last four characters of '...000x' where x != '.' is converted to '...0000'
  • String form with last four characters of '...9999' is converted to '...999999'
  • the java.lang.Double.doubleValue of the String form is returned
, 2, ALIAS, org.hsqldb.Library.roundMagic(double) null, PUBLIC, RTRIM, 1, 0, 1, Returns the characters of the given String, with trailing spaces removed., 2, ALIAS, org.hsqldb.Library.rtrim(java.lang.String) null, PUBLIC, SECOND, 1, 0, 1, Returns the second of the given time value, as an integer value in the range of 0-59., 2, ALIAS, org.hsqldb.Library.second(java.sql.Time) null, PUBLIC, SIGN, 1, 0, 1, Returns an indicator of the sign of the given double value. If the value is less than zero, -1 is returned. If the value equals zero, 0 is returned. If the value is greater than zero, 1 is returned., 2, ALIAS, org.hsqldb.Library.sign(double) null, PUBLIC, SIN, 1, 0, 1, Returns the trigonometric sine of an angle. Special cases:
  • If the argument is NaN or an infinity, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.sin(double) null, PUBLIC, SOUNDEX, 1, 0, 1, Returns a four character code representing the sound of the given String. Non-ASCCI characters in the input String are ignored.

This method was rewritten for HSQLDB by fredt@users to comply with the description at http://www.nara.gov/genealogy/coding.html.

, 2, ALIAS, org.hsqldb.Library.soundex(java.lang.String) null, PUBLIC, SPACE, 1, 0, 1, Returns a String consisting of count spaces, or null if count is less than zero.

, 2, ALIAS, org.hsqldb.Library.space(int) null, PUBLIC, SQRT, 1, 0, 1, Returns the correctly rounded positive square root of a double value. Special cases:

  • If the argument is NaN or less than zero, then the result is NaN.
  • If the argument is positive infinity, then the result is positive infinity.
  • If the argument is positive zero or negative zero, then the result is the same as the argument.
Otherwise, the result is the double value closest to the true mathematical square root of the argument value., 2, ALIAS, java.lang.Math.sqrt(double) null, PUBLIC, SUBSTR, 3, 0, 1, Returns the characters from the given String, staring at the indicated one-based start position and extending the (optional) indicated length. If length is not specified (is null), the remainder of s is implied., 2, ALIAS, org.hsqldb.Library.substring(java.lang.String,int,java.lang.Integer) null, PUBLIC, SUBSTRING, 3, 0, 1, Returns the characters from the given String, staring at the indicated one-based start position and extending the (optional) indicated length. If length is not specified (is null), the remainder of s is implied., 2, ALIAS, org.hsqldb.Library.substring(java.lang.String,int,java.lang.Integer) null, PUBLIC, TAN, 1, 0, 1, Returns the trigonometric tangent of an angle. Special cases:
  • If the argument is NaN or an infinity, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, ALIAS, java.lang.Math.tan(double) null, PUBLIC, TO_CHAR, 2, 0, 1, null, 2, ALIAS, org.hsqldb.Library.to_char(java.util.Date,java.lang.String) null, PUBLIC, TRUNCATE, 2, 0, 1, Returns the given double value, truncated to the given int places right of the decimal point. If the given place value is negative, the given double value is truncated to the left of the decimal point, using the magnitude (aboslute value) of the place value., 2, ALIAS, org.hsqldb.Library.truncate(double,int) null, PUBLIC, UCASE, 1, 0, 1, Returns a copy of the given String, with all lower case characters converted to upper case using the default Java method., 2, ALIAS, org.hsqldb.Library.ucase(java.lang.String) null, PUBLIC, UPPER, 1, 0, 1, Returns a copy of the given String, with all lower case characters converted to upper case using the default Java method., 2, ALIAS, org.hsqldb.Library.ucase(java.lang.String) null, PUBLIC, USER, 1, 0, 1, Returns the user's authorization name (the user's name as known to this database)., 2, ALIAS, org.hsqldb.Library.user(java.sql.Connection) null, PUBLIC, WEEK, 1, 0, 1, Returns the week of the year from the given date value, as an integer value in the range of 1-53., 2, ALIAS, org.hsqldb.Library.week(java.sql.Date) null, PUBLIC, YEAR, 1, 0, 1, Returns the year from the given date value, as an integer value in the range of 1-9999., 2, ALIAS, org.hsqldb.Library.year(java.sql.Date) null, PUBLIC, java.lang.Math.IEEEremainder, 2, 0, 1, Computes the remainder operation on two arguments as prescribed by the IEEE 754 standard. The remainder value is mathematically equal to f1 - f2 × n, where n is the mathematical integer closest to the exact mathematical value of the quotient f1/f2, and if two mathematical integers are equally close to f1/f2, then n is the integer that is even. If the remainder is zero, its sign is the same as the sign of the first argument. Special cases:

  • If either argument is NaN, or the first argument is infinite, or the second argument is positive zero or negative zero, then the result is NaN.
  • If the first argument is finite and the second argument is infinite, then the result is the same as the first argument.
, 2, BUILTIN ROUTINE, java.lang.Math.IEEEremainder(double,double) null, PUBLIC, java.lang.Math.abs, 1, 0, 1, Returns the absolute value of a double value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned. Special cases:
  • If the argument is positive zero or negative zero, the result is positive zero.
  • If the argument is infinite, the result is positive infinity.
  • If the argument is NaN, the result is NaN.
In other words, the result is the same as the value of the expression:

Double.longBitsToDouble((Double.doubleToLongBits(a)<<1)>>>1), 2, BUILTIN ROUTINE, java.lang.Math.abs(double) null, PUBLIC, java.lang.Math.abs, 1, 0, 1, Returns the absolute value of a float value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned. Special cases:

  • If the argument is positive zero or negative zero, the result is positive zero.
  • If the argument is infinite, the result is positive infinity.
  • If the argument is NaN, the result is NaN.
In other words, the result is the same as the value of the expression:

Float.intBitsToFloat(0x7fffffff & Float.floatToIntBits(a))
, 2, BUILTIN ROUTINE, java.lang.Math.abs(float) null, PUBLIC, java.lang.Math.abs, 1, 0, 1, Returns the absolute value of an int value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned.

Note that if the argument is equal to the value of Integer.MIN_VALUE, the most negative representable int value, the result is that same value, which is negative., 2, BUILTIN ROUTINE, java.lang.Math.abs(int) null, PUBLIC, java.lang.Math.abs, 1, 0, 1, Returns the absolute value of a long value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned.

Note that if the argument is equal to the value of Long.MIN_VALUE, the most negative representable long value, the result is that same value, which is negative., 2, BUILTIN ROUTINE, java.lang.Math.abs(long) null, PUBLIC, java.lang.Math.acos, 1, 0, 1, Returns the arc cosine of an angle, in the range of 0.0 through pi. Special case:

  • If the argument is NaN or its absolute value is greater than 1, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.acos(double) null, PUBLIC, java.lang.Math.asin, 1, 0, 1, Returns the arc sine of an angle, in the range of -pi/2 through pi/2. Special cases:

  • If the argument is NaN or its absolute value is greater than 1, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.asin(double) null, PUBLIC, java.lang.Math.atan, 1, 0, 1, Returns the arc tangent of an angle, in the range of -pi/2 through pi/2. Special cases:

  • If the argument is NaN, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.atan(double) null, PUBLIC, java.lang.Math.atan2, 2, 0, 1, Converts rectangular coordinates (xy) to polar (r, theta). This method computes the phase theta by computing an arc tangent of y/x in the range of -pi to pi. Special cases:

  • If either argument is NaN, then the result is NaN.
  • If the first argument is positive zero and the second argument is positive, or the first argument is positive and finite and the second argument is positive infinity, then the result is positive zero.
  • If the first argument is negative zero and the second argument is positive, or the first argument is negative and finite and the second argument is positive infinity, then the result is negative zero.
  • If the first argument is positive zero and the second argument is negative, or the first argument is positive and finite and the second argument is negative infinity, then the result is the double value closest to pi.
  • If the first argument is negative zero and the second argument is negative, or the first argument is negative and finite and the second argument is negative infinity, then the result is the double value closest to -pi.
  • If the first argument is positive and the second argument is positive zero or negative zero, or the first argument is positive infinity and the second argument is finite, then the result is the double value closest to pi/2.
  • If the first argument is negative and the second argument is positive zero or negative zero, or the first argument is negative infinity and the second argument is finite, then the result is the double value closest to -pi/2.
  • If both arguments are positive infinity, then the result is the double value closest to pi/4.
  • If the first argument is positive infinity and the second argument is negative infinity, then the result is the double value closest to 3*pi/4.
  • If the first argument is negative infinity and the second argument is positive infinity, then the result is the double value closest to -pi/4.
  • If both arguments are negative infinity, then the result is the double value closest to -3*pi/4.

A result must be within 2 ulps of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.atan2(double,double) null, PUBLIC, java.lang.Math.cbrt, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.cbrt(double) null, PUBLIC, java.lang.Math.ceil, 1, 0, 1, Returns the smallest (closest to negative infinity) double value that is not less than the argument and is equal to a mathematical integer. Special cases:

  • If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
  • If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.
  • If the argument value is less than zero but greater than -1.0, then the result is negative zero.
Note that the value of Math.ceil(x) is exactly the value of -Math.floor(-x)., 2, BUILTIN ROUTINE, java.lang.Math.ceil(double) null, PUBLIC, java.lang.Math.cos, 1, 0, 1, Returns the trigonometric cosine of an angle. Special cases:
  • If the argument is NaN or an infinity, then the result is NaN.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.cos(double) null, PUBLIC, java.lang.Math.cosh, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.cosh(double) null, PUBLIC, java.lang.Math.exp, 1, 0, 1, Returns Euler's number e raised to the power of a double value. Special cases:

  • If the argument is NaN, the result is NaN.
  • If the argument is positive infinity, then the result is positive infinity.
  • If the argument is negative infinity, then the result is positive zero.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.exp(double) null, PUBLIC, java.lang.Math.expm1, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.expm1(double) null, PUBLIC, java.lang.Math.floor, 1, 0, 1, Returns the largest (closest to positive infinity) double value that is not greater than the argument and is equal to a mathematical integer. Special cases:

  • If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
  • If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.
, 2, BUILTIN ROUTINE, java.lang.Math.floor(double) null, PUBLIC, java.lang.Math.hypot, 2, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.hypot(double,double) null, PUBLIC, java.lang.Math.log, 1, 0, 1, Returns the natural logarithm (base e) of a double value. Special cases:
  • If the argument is NaN or less than zero, then the result is NaN.
  • If the argument is positive infinity, then the result is positive infinity.
  • If the argument is positive zero or negative zero, then the result is negative infinity.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.log(double) null, PUBLIC, java.lang.Math.log10, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.log10(double) null, PUBLIC, java.lang.Math.log1p, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.log1p(double) null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two double values. That is, the result is the argument closer to positive infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other negative zero, the result is positive zero., 2, BUILTIN ROUTINE, java.lang.Math.max(double,double) null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two float values. That is, the result is the argument closer to positive infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other negative zero, the result is positive zero., 2, BUILTIN ROUTINE, java.lang.Math.max(float,float) null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two int values. That is, the result is the argument closer to the value of Integer.MAX_VALUE. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.max(int,int) null, PUBLIC, java.lang.Math.max, 2, 0, 1, Returns the greater of two long values. That is, the result is the argument closer to the value of Long.MAX_VALUE. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.max(long,long) null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two double values. That is, the result is the value closer to negative infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other is negative zero, the result is negative zero., 2, BUILTIN ROUTINE, java.lang.Math.min(double,double) null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two float values. That is, the result is the value closer to negative infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other is negative zero, the result is negative zero., 2, BUILTIN ROUTINE, java.lang.Math.min(float,float) null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two int values. That is, the result the argument closer to the value of Integer.MIN_VALUE. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.min(int,int) null, PUBLIC, java.lang.Math.min, 2, 0, 1, Returns the smaller of two long values. That is, the result is the argument closer to the value of Long.MIN_VALUE. If the arguments have the same value, the result is that same value., 2, BUILTIN ROUTINE, java.lang.Math.min(long,long) null, PUBLIC, java.lang.Math.pow, 2, 0, 1, Returns of value of the first argument raised to the power of the second argument. Special cases:

  • If the second argument is positive or negative zero, then the result is 1.0.
  • If the second argument is 1.0, then the result is the same as the first argument.
  • If the second argument is NaN, then the result is NaN.
  • If the first argument is NaN and the second argument is nonzero, then the result is NaN.
  • If the absolute value of the first argument is greater than 1 and the second argument is positive infinity, or the absolute value of the first argument is less than 1 and the second argument is negative infinity, then the result is positive infinity.
  • If the absolute value of the first argument is greater than 1 and the second argument is negative infinity, or the absolute value of the first argument is less than 1 and the second argument is positive infinity, then the result is positive zero.
  • If the absolute value of the first argument equals 1 and the second argument is infinite, then the result is NaN.
  • If the first argument is positive zero and the second argument is greater than zero, or the first argument is positive infinity and the second argument is less than zero, then the result is positive zero.
  • If the first argument is positive zero and the second argument is less than zero, or the first argument is positive infinity and the second argument is greater than zero, then the result is positive infinity.
  • If the first argument is negative zero and the second argument is greater than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is less than zero but not a finite odd integer, then the result is positive zero.
  • If the first argument is negative zero and the second argument is a positive finite odd integer, or the first argument is negative infinity and the second argument is a negative finite odd integer, then the result is negative zero.
  • If the first argument is negative zero and the second argument is less than zero but not a finite odd integer, or the first argument is negative infinity and the second argument is greater than zero but not a finite odd integer, then the result is positive infinity.
  • If the first argument is negative zero and the second argument is a negative finite odd integer, or the first argument is negative infinity and the second argument is a positive finite odd integer, then the result is negative infinity.
  • If the first argument is less than zero and the second argument is a finite even integer, then the result is equal to the result of raising the absolute value of the first argument to the power of the second argument.
  • If the first argument is less than zero and the second argument is a finite odd integer, then the result is equal to the negative of the result of raising the absolute value of the first argument to the power of the second argument.
  • If the first argument is finite and less than zero and the second argument is finite and not an integer, then the result is NaN.
  • If both arguments are integers, then the result is exactly equal to the mathematical result of raising the first argument to the power of the second argument if that result can in fact be represented exactly as a double value.

(In the foregoing descriptions, a floating-point value is considered to be an integer if and only if it is a fixed point of the method {@link #ceil ceil} or, equivalently, a fixed point of the method {@link #floor floor}. A value is a fixed point of a one-argument method if and only if the result of applying the method to the value is equal to the value.)

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.pow(double,double) null, PUBLIC, java.lang.Math.random, 0, 0, 1, Returns a double value with a positive sign, greater than or equal to 0.0 and less than 1.0. Returned values are chosen pseudorandomly with (approximately) uniform distribution from that range.

When this method is first called, it creates a single new pseudorandom-number generator, exactly as if by the expression

new java.util.Random
This new pseudorandom-number generator is used thereafter for all calls to this method and is used nowhere else.

This method is properly synchronized to allow correct use by more than one thread. However, if many threads need to generate pseudorandom numbers at a great rate, it may reduce contention for each thread to have its own pseudorandom-number generator., 2, BUILTIN ROUTINE, java.lang.Math.random() null, PUBLIC, java.lang.Math.rint, 1, 0, 1, Returns the double value that is closest in value to the argument and is equal to a mathematical integer. If two double values that are mathematical integers are equally close, the result is the integer value that is even. Special cases:

  • If the argument value is already equal to a mathematical integer, then the result is the same as the argument.
  • If the argument is NaN or an infinity or positive zero or negative zero, then the result is the same as the argument.
, 2, BUILTIN ROUTINE, java.lang.Math.rint(double) null, PUBLIC, java.lang.Math.round, 1, 0, 1, Returns the closest long to the argument. The result is rounded to an integer by adding 1/2, taking the floor of the result, and casting the result to type long. In other words, the result is equal to the value of the expression:

(long)Math.floor(a + 0.5d)

Special cases:

  • If the argument is NaN, the result is 0.
  • If the argument is negative infinity or any value less than or equal to the value of Long.MIN_VALUE, the result is equal to the value of Long.MIN_VALUE.
  • If the argument is positive infinity or any value greater than or equal to the value of Long.MAX_VALUE, the result is equal to the value of Long.MAX_VALUE.
, 2, BUILTIN ROUTINE, java.lang.Math.round(double) null, PUBLIC, java.lang.Math.round, 1, 0, 1, Returns the closest int to the argument. The result is rounded to an integer by adding 1/2, taking the floor of the result, and casting the result to type int. In other words, the result is equal to the value of the expression:

(int)Math.floor(a + 0.5f)

Special cases:

  • If the argument is NaN, the result is 0.
  • If the argument is negative infinity or any value less than or equal to the value of Integer.MIN_VALUE, the result is equal to the value of Integer.MIN_VALUE.
  • If the argument is positive infinity or any value greater than or equal to the value of Integer.MAX_VALUE, the result is equal to the value of Integer.MAX_VALUE.
, 2, BUILTIN ROUTINE, java.lang.Math.round(float) null, PUBLIC, java.lang.Math.signum, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.signum(double) null, PUBLIC, java.lang.Math.signum, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.signum(float) null, PUBLIC, java.lang.Math.sin, 1, 0, 1, Returns the trigonometric sine of an angle. Special cases:
  • If the argument is NaN or an infinity, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.sin(double) null, PUBLIC, java.lang.Math.sinh, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.sinh(double) null, PUBLIC, java.lang.Math.sqrt, 1, 0, 1, Returns the correctly rounded positive square root of a double value. Special cases:

  • If the argument is NaN or less than zero, then the result is NaN.
  • If the argument is positive infinity, then the result is positive infinity.
  • If the argument is positive zero or negative zero, then the result is the same as the argument.
Otherwise, the result is the double value closest to the true mathematical square root of the argument value., 2, BUILTIN ROUTINE, java.lang.Math.sqrt(double) null, PUBLIC, java.lang.Math.tan, 1, 0, 1, Returns the trigonometric tangent of an angle. Special cases:
  • If the argument is NaN or an infinity, then the result is NaN.
  • If the argument is zero, then the result is a zero with the same sign as the argument.

A result must be within 1 ulp of the correctly rounded result. Results must be semi-monotonic., 2, BUILTIN ROUTINE, java.lang.Math.tan(double) null, PUBLIC, java.lang.Math.tanh, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.tanh(double) null, PUBLIC, java.lang.Math.toDegrees, 1, 0, 1, Converts an angle measured in radians to an approximately equivalent angle measured in degrees. The conversion from radians to degrees is generally inexact; users should not expect cos(toRadians(90.0)) to exactly equal 0.0., 2, BUILTIN ROUTINE, java.lang.Math.toDegrees(double) null, PUBLIC, java.lang.Math.toRadians, 1, 0, 1, Converts an angle measured in degrees to an approximately equivalent angle measured in radians. The conversion from degrees to radians is generally inexact., 2, BUILTIN ROUTINE, java.lang.Math.toRadians(double) null, PUBLIC, java.lang.Math.ulp, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.ulp(double) null, PUBLIC, java.lang.Math.ulp, 1, 0, 1, null, 2, BUILTIN ROUTINE, java.lang.Math.ulp(float) null, PUBLIC, org.hsqldb.Library.abs, 1, 0, 1, Returns the absolute value of the given double value., 2, BUILTIN ROUTINE, org.hsqldb.Library.abs(double) null, PUBLIC, org.hsqldb.Library.ascii, 1, 0, 1, Returns the Unicode code value of the leftmost character of s as an int. This is the same as the ASCII value if the string contains only ASCII characters., 2, BUILTIN ROUTINE, org.hsqldb.Library.ascii(java.lang.String) null, PUBLIC, org.hsqldb.Library.bitLength, 1, 0, 1, Returns the number of bits in the given String. This includes trailing blanks., 2, BUILTIN ROUTINE, org.hsqldb.Library.bitLength(java.lang.String) null, PUBLIC, org.hsqldb.Library.bitand, 2, 0, 1, Returns the bit-wise logical and of the given integer values., 2, BUILTIN ROUTINE, org.hsqldb.Library.bitand(int,int) null, PUBLIC, org.hsqldb.Library.bitor, 2, 0, 1, Returns the bit-wise logical xor of the given integer values., 2, BUILTIN ROUTINE, org.hsqldb.Library.bitor(int,int) null, PUBLIC, org.hsqldb.Library.bitxor, 2, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.bitxor(int,int) null, PUBLIC, org.hsqldb.Library.character, 1, 0, 1, Returns the character string corresponding to the given ASCII (or Unicode) value. Note:

In some SQL CLI implementations, a null is returned if the range is outside 0..255. In HSQLDB, the corresponding Unicode character is returned unchecked., 2, BUILTIN ROUTINE, org.hsqldb.Library.character(int) null, PUBLIC, org.hsqldb.Library.concat, 2, 0, 1, Returns a String object that is the result of an SQL-style concatenation of the given String objects.

Note: by SQL-style, it is meant:

  • if both String objects are null, return null
  • if only one string is null, return the other
  • if both String objects are non-null, return as a String object the character sequence obtained by listing, in left to right order, the characters of the first string followed by the characters of the second
, 2, BUILTIN ROUTINE, org.hsqldb.Library.concat(java.lang.String,java.lang.String) null, PUBLIC, org.hsqldb.Library.cot, 1, 0, 1, Returns the cotangent of the given double value expressed in radians., 2, BUILTIN ROUTINE, org.hsqldb.Library.cot(double) null, PUBLIC, org.hsqldb.Library.curdate, 1, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.curdate(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.curtime, 1, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.curtime(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.database, 1, 0, 1, Returns the name of the database corresponding to this connection., 2, BUILTIN ROUTINE, org.hsqldb.Library.database(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.datediff, 3, 0, 1, Returns the number of date and time boundaries crossed between two specified datetime values., 2, BUILTIN ROUTINE, org.hsqldb.Library.datediff(java.lang.String,java.sql.Timestamp,java.sql.Timestamp) null, PUBLIC, org.hsqldb.Library.dayname, 1, 0, 1, Returns a character string containing the name of the day (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday ) for the day portion of the given java.sql.Date., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayname(java.sql.Date) null, PUBLIC, org.hsqldb.Library.dayofmonth, 1, 0, 1, Returns the day of the month from the given date value, as an integer value in the range of 1-31., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayofmonth(java.sql.Date) null, PUBLIC, org.hsqldb.Library.dayofweek, 1, 0, 1, Returns the day of the week from the given date value, as an integer value in the range 1-7, where 1 represents Sunday., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayofweek(java.sql.Date) null, PUBLIC, org.hsqldb.Library.dayofyear, 1, 0, 1, Returns the day of the year from the given date value, as an integer value in the range 1-366., 2, BUILTIN ROUTINE, org.hsqldb.Library.dayofyear(java.sql.Date) null, PUBLIC, org.hsqldb.Library.difference, 2, 0, 1, Returns a count of the characters that do not match when comparing the 4 digit numeric SOUNDEX character sequences for the given String objects. If either String object is null, zero is returned., 2, BUILTIN ROUTINE, org.hsqldb.Library.difference(java.lang.String,java.lang.String) null, PUBLIC, org.hsqldb.Library.getAutoCommit, 1, 0, 1, Retrieves the autocommit status of this connection.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getAutoCommit(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.getDatabaseMajorVersion, 0, 0, 1, Retrieves the major version number of this database.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseMajorVersion() null, PUBLIC, org.hsqldb.Library.getDatabaseMinorVersion, 0, 0, 1, Retrieves the major version number of this database.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseMinorVersion() null, PUBLIC, org.hsqldb.Library.getDatabaseProductName, 0, 0, 1, Retrieves the name of this database product.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseProductName() null, PUBLIC, org.hsqldb.Library.getDatabaseProductVersion, 0, 0, 1, Retrieves the version number of this database product.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.getDatabaseProductVersion() null, PUBLIC, org.hsqldb.Library.hexToRaw, 1, 0, 1, Converts a String of hexidecimal digit characters to a raw binary value, represented as a String.

The given String object must consist of a sequence of 4 digit hexidecimal character substrings.

If its length is not evenly divisible by 4, null is returned. If any any of its 4 character subsequences cannot be parsed as a 4 digit, base 16 value, then a NumberFormatException is thrown. This conversion has the effect of reducing the character count 4:1., 2, BUILTIN ROUTINE, org.hsqldb.Library.hexToRaw(java.lang.String) null, PUBLIC, org.hsqldb.Library.hour, 1, 0, 1, Returns the hour from the given time value, as an integer value in the range of 0-23., 2, BUILTIN ROUTINE, org.hsqldb.Library.hour(java.sql.Time) null, PUBLIC, org.hsqldb.Library.identity, 0, 0, 1, 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, 2, BUILTIN ROUTINE, org.hsqldb.Library.identity() null, PUBLIC, org.hsqldb.Library.insert, 4, 0, 1, Returns a character sequence which is the result of writing the first length number of characters from the second given String over the first string. The start position in the first string where the characters are overwritten is given by start.

Note: In order of precedence, boundry conditions are handled as follows:

  • if either supplied String is null, then the other is returned; the check starts with the first given String.
  • if start is less than one, s1 is returned
  • if length is less than or equal to zero, s1 is returned
  • if the length of s2 is zero, s1 is returned
  • if start is greater than the length of s1, s1 is returned
  • if length is such that, taken together with start, the indicated interval extends beyond the end of s1, then the insertion is performed precisely as if upon a copy of s1 extended in length to just include the indicated interval
, 2, BUILTIN ROUTINE, org.hsqldb.Library.insert(java.lang.String,int,int,java.lang.String) null, PUBLIC, org.hsqldb.Library.isReadOnlyConnection, 1, 0, 1, Retrieves whether this connection is in read-only mode.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.isReadOnlyConnection(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.isReadOnlyDatabase, 1, 0, 1, Retrieves whether this database is in read-only mode.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.isReadOnlyDatabase(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.isReadOnlyDatabaseFiles, 1, 0, 1, Retrieves whether the files of this database are in read-only mode., 2, BUILTIN ROUTINE, org.hsqldb.Library.isReadOnlyDatabaseFiles(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.lcase, 1, 0, 1, Returns a copy of the given String, with all upper case characters converted to lower case. This uses the default Java String conversion., 2, BUILTIN ROUTINE, org.hsqldb.Library.lcase(java.lang.String) null, PUBLIC, org.hsqldb.Library.left, 2, 0, 1, Returns the leftmost count characters from the given String.

Note: boundry conditions are handled in the following order of precedence:

  • if s is null, then null is returned
  • if count is less than 1, then a zero-length String is returned
  • if count is greater than the length of s, then a copy of s is returned
, 2, BUILTIN ROUTINE, org.hsqldb.Library.left(java.lang.String,int) null, PUBLIC, org.hsqldb.Library.length, 1, 0, 1, Returns the number of characters in the given String. This includes trailing blanks., 2, BUILTIN ROUTINE, org.hsqldb.Library.length(java.lang.String) null, PUBLIC, org.hsqldb.Library.locate, 3, 0, 1, Returns the starting position of the first occurrence of the given search String object within the given String object, s. The search for the first occurrence of search begins with the first character position in s, unless the optional argument, start, is specified (non-null). If start is specified, the search begins with the character position indicated by the value of start, where the first character position in s is indicated by the value 1. If search is not found within s, the value 0 is returned., 2, BUILTIN ROUTINE, org.hsqldb.Library.locate(java.lang.String,java.lang.String,java.lang.Integer) null, PUBLIC, org.hsqldb.Library.log10, 1, 0, 1, Returns the base 10 logarithm of the given double value., 2, BUILTIN ROUTINE, org.hsqldb.Library.log10(double) null, PUBLIC, org.hsqldb.Library.ltrim, 1, 0, 1, Returns the characters of the given String, with the leading spaces removed. Characters such as TAB are not removed., 2, BUILTIN ROUTINE, org.hsqldb.Library.ltrim(java.lang.String) null, PUBLIC, org.hsqldb.Library.minute, 1, 0, 1, Returns the minute from the given time value, as integer value in the range of 0-59., 2, BUILTIN ROUTINE, org.hsqldb.Library.minute(java.sql.Time) null, PUBLIC, org.hsqldb.Library.mod, 2, 0, 1, Returns the remainder (modulus) of the first given integer divided by the second.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.mod(int,int) null, PUBLIC, org.hsqldb.Library.month, 1, 0, 1, Returns the month from the given date value, as an integer value in the range of 1-12 or 0-11.

If the sql_month database property is set true, then the range is 1-12, else 0-11, 2, BUILTIN ROUTINE, org.hsqldb.Library.month(java.sql.Date) null, PUBLIC, org.hsqldb.Library.monthname, 1, 0, 1, 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., 2, BUILTIN ROUTINE, org.hsqldb.Library.monthname(java.sql.Date) null, PUBLIC, org.hsqldb.Library.now, 1, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.now(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.octetLength, 1, 0, 1, Returns the number of bytes in the given String. This includes trailing blanks., 2, BUILTIN ROUTINE, org.hsqldb.Library.octetLength(java.lang.String) null, PUBLIC, org.hsqldb.Library.pi, 0, 0, 1, Returns the constant value, pi., 2, BUILTIN ROUTINE, org.hsqldb.Library.pi() null, PUBLIC, org.hsqldb.Library.position, 2, 0, 1, Returns the starting position of the first occurrence of the given search String object within the given String object, s., 2, BUILTIN ROUTINE, org.hsqldb.Library.position(java.lang.String,java.lang.String) null, PUBLIC, org.hsqldb.Library.quarter, 1, 0, 1, Returns the quarter of the year in the given date value, as an integer value in the range of 1-4., 2, BUILTIN ROUTINE, org.hsqldb.Library.quarter(java.sql.Date) null, PUBLIC, org.hsqldb.Library.rand, 1, 0, 1, Returns the next pseudorandom, uniformly distributed double value between 0.0 and 1.0 from a single, system-wide random number generator's sequence, optionally re-seeding (and thus resetting) the generator sequence. If the seed value is null, then the underlying random number generator retrieves the next value in its current sequence, else the seed alters the state of the generator object so as to be in exactly the same state as if it had just been created with the seed value., 2, BUILTIN ROUTINE, org.hsqldb.Library.rand(java.lang.Integer) null, PUBLIC, org.hsqldb.Library.rawToHex, 1, 0, 1, Converts a raw binary value, as represented by the given String, to the equivalent String of hexidecimal digit characters.

This conversion has the effect of expanding the character count 1:4., 2, BUILTIN ROUTINE, org.hsqldb.Library.rawToHex(java.lang.String) null, PUBLIC, org.hsqldb.Library.repeat, 2, 0, 1, Returns a String composed of the given String, repeated count times., 2, BUILTIN ROUTINE, org.hsqldb.Library.repeat(java.lang.String,java.lang.Integer) null, PUBLIC, org.hsqldb.Library.replace, 3, 0, 1, Replaces all occurrences of replace in s with the String object: with, 2, BUILTIN ROUTINE, org.hsqldb.Library.replace(java.lang.String,java.lang.String,java.lang.String) null, PUBLIC, org.hsqldb.Library.right, 2, 0, 1, Returns the rightmost count characters of the given String, s. Note: boundry conditions are handled in the following order of precedence:

  • if s is null, null is returned
  • if count is less than one, a zero-length String is returned
  • if count is greater than the length of s, a copy of s is returned
, 2, BUILTIN ROUTINE, org.hsqldb.Library.right(java.lang.String,int) null, PUBLIC, org.hsqldb.Library.round, 2, 0, 1, Returns the given double value, rounded to the given int places right of the decimal point. If the supplied rounding place value is negative, rounding is performed to the left of the decimal point, using its magnitude (absolute value)., 2, BUILTIN ROUTINE, org.hsqldb.Library.round(double,int) null, PUBLIC, org.hsqldb.Library.roundMagic, 1, 0, 1, Retrieves a magically rounded double value produced from the given double value. This method provides special handling for numbers close to zero and performs rounding only for numbers within a specific range, returning precisely the given value if it does not lie in this range.

Special handling includes:

  • input in the interval -0.0000000000001..0.0000000000001 returns 0.0
  • input outside the interval -1000000000000..1000000000000 returns input unchanged
  • input is converted to String form
  • input with a String form length greater than 16 returns input unchaged
  • String form with last four characters of '...000x' where x != '.' is converted to '...0000'
  • String form with last four characters of '...9999' is converted to '...999999'
  • the java.lang.Double.doubleValue of the String form is returned
, 2, BUILTIN ROUTINE, org.hsqldb.Library.roundMagic(double) null, PUBLIC, org.hsqldb.Library.rtrim, 1, 0, 1, Returns the characters of the given String, with trailing spaces removed., 2, BUILTIN ROUTINE, org.hsqldb.Library.rtrim(java.lang.String) null, PUBLIC, org.hsqldb.Library.second, 1, 0, 1, Returns the second of the given time value, as an integer value in the range of 0-59., 2, BUILTIN ROUTINE, org.hsqldb.Library.second(java.sql.Time) null, PUBLIC, org.hsqldb.Library.sign, 1, 0, 1, Returns an indicator of the sign of the given double value. If the value is less than zero, -1 is returned. If the value equals zero, 0 is returned. If the value is greater than zero, 1 is returned., 2, BUILTIN ROUTINE, org.hsqldb.Library.sign(double) null, PUBLIC, org.hsqldb.Library.soundex, 1, 0, 1, Returns a four character code representing the sound of the given String. Non-ASCCI characters in the input String are ignored.

This method was rewritten for HSQLDB by fredt@users to comply with the description at http://www.nara.gov/genealogy/coding.html.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.soundex(java.lang.String) null, PUBLIC, org.hsqldb.Library.space, 1, 0, 1, Returns a String consisting of count spaces, or null if count is less than zero.

, 2, BUILTIN ROUTINE, org.hsqldb.Library.space(int) null, PUBLIC, org.hsqldb.Library.substring, 3, 0, 1, Returns the characters from the given String, staring at the indicated one-based start position and extending the (optional) indicated length. If length is not specified (is null), the remainder of s is implied., 2, BUILTIN ROUTINE, org.hsqldb.Library.substring(java.lang.String,int,java.lang.Integer) null, PUBLIC, org.hsqldb.Library.to_char, 2, 0, 1, null, 2, BUILTIN ROUTINE, org.hsqldb.Library.to_char(java.util.Date,java.lang.String) null, PUBLIC, org.hsqldb.Library.trim, 4, 0, 1, Retrieves a character sequence derived from s with the leading, trailing or both leading and trailing occurances of trimstr removed, 2, BUILTIN ROUTINE, org.hsqldb.Library.trim(java.lang.String,java.lang.String,boolean,boolean) null, PUBLIC, org.hsqldb.Library.truncate, 2, 0, 1, Returns the given double value, truncated to the given int places right of the decimal point. If the given place value is negative, the given double value is truncated to the left of the decimal point, using the magnitude (aboslute value) of the place value., 2, BUILTIN ROUTINE, org.hsqldb.Library.truncate(double,int) null, PUBLIC, org.hsqldb.Library.ucase, 1, 0, 1, Returns a copy of the given String, with all lower case characters converted to upper case using the default Java method., 2, BUILTIN ROUTINE, org.hsqldb.Library.ucase(java.lang.String) null, PUBLIC, org.hsqldb.Library.user, 1, 0, 1, Returns the user's authorization name (the user's name as known to this database)., 2, BUILTIN ROUTINE, org.hsqldb.Library.user(java.sql.Connection) null, PUBLIC, org.hsqldb.Library.week, 1, 0, 1, Returns the week of the year from the given date value, as an integer value in the range of 1-53., 2, BUILTIN ROUTINE, org.hsqldb.Library.week(java.sql.Date) null, PUBLIC, org.hsqldb.Library.year, 1, 0, 1, Returns the year from the given date value, as an integer value in the range of 1-9999., 2, BUILTIN ROUTINE, org.hsqldb.Library.year(java.sql.Date)

20. 30. 数据库元数据
20. 30. 1. 数据库元数据
20. 30. 2. 从数据库获取表名称
20. 30. 3. 从数据库获取查看名称
20. 30. 4. 从数据库获取表和视图名称
20. 30. 5. DatabaseMetaData方法和数据库信息
20. 30. 6. 获取数据库信息DatabaseMetaData
20. 30. 7. DatabaseMetaData Methods for Information on the Database's Supported Features
20. 30. 8. DatabaseMetaData Methods for Information on the Database's Limitations
20. 30. 9. 显示数据库限制
20. 30. 10. DatabaseMetaData Methods for Information on the Database's Contents
20. 30. 11. 为当前连接显示数据库内容
20. 30. 12. 获取表信息DatabaseMetaData
20. 30. 13. 获取存储过程信息DatabaseMetaData
20. 30. 14. 列出数据库所有非SQL92关键词
20. 30. 15. Listing the String Functions Supported by a Database: retrieves a list of string functions that a database supports.
20. 30. 16. 数据库数值函数的支持
20. 30. 17. 系统功能的支持
20. 30. 18. 数据库时间和日期功能的支持
20. 30. 19. 获取一个数据库允许的最大表名称长度
20. 30. 20. 数据库可用的SQL数据类型
20. 30. 21. 数据库支持的系统功能
20. 30. 22. 获取最大并发连接
20. 30. 23. 获取数据库表名最大长度
20. 30. 24. 数值函数支持
20. 30. 25. 是否数据库支持批量更新
20. 30. 26. Get data types supported by database
20. 30. 27. Get date time functions supported by database
20. 30. 28. 检测一个表是否存在
20. 30. 29. 获取字符串函数支持
www.java2java.com | Contact Us
Copyright 2010 - 2030 Java Source and Support. All rights reserved.
All other trademarks are property of their respective owners.