org.sqlite

クラス Function

java.lang.Object

org.sqlite.Function

直系の既知のサブクラス:

Function.Aggregate

public abstract class Function
extends Object

Provides an interface for creating SQLite user-defined functions.

A subclass of org.sqlite.Function can be registered with Function.create() and called by the name it was given. All functions must implement xFunc(), which is called when SQLite runs the custom function.

Eg.

      Class.forName("org.sqlite.JDBC");
      Connection conn = DriverManager.getConnection("jdbc:sqlite:");

      Function.create(conn, "myFunc", new Function() {
          protected void xFunc() {
              System.out.println("myFunc called!");
          }
      });

      conn.createStatement().execute("select myFunc();");
  

Arguments passed to a custom function can be accessed using the protected functions provided. args() returns the number of arguments passed, while value_<type>(int) returns the value of the specific argument. Similarly a function can return a value using the result(<type>) function.

Aggregate functions are not yet supported, but coming soon.

ネストされたクラスの概要

ネストされたクラス

修飾子とタイプ	クラスと説明
static class	Function.Aggregate Provides an interface for creating SQLite user-defined aggregate functions.

コンストラクタの概要

コンストラクタ

コンストラクタと説明
Function()

メソッドの概要

メソッド

修飾子とタイプ	メソッドと説明
protected int	args() Returns the number of arguments passed to the function.
static void	create(Connection conn, String name, Function f) Registers a given function with the connection.
static void	destroy(Connection conn, String name) Removes a named function from the given connection.
protected void	error(String err) Called by xFunc to throw an error.
protected void	result() Called by xFunc to return a value.
protected void	result(byte[] value) Called by xFunc to return a value.
protected void	result(double value) Called by xFunc to return a value.
protected void	result(int value) Called by xFunc to return a value.
protected void	result(long value) Called by xFunc to return a value.
protected void	result(String value) Called by xFunc to return a value.
protected byte[]	value_blob(int arg) Called by xFunc to access the value of an argument.
protected int	value_bytes(int arg) Called by xFunc to access the value of an argument.
protected double	value_double(int arg) Called by xFunc to access the value of an argument.
protected int	value_int(int arg) Called by xFunc to access the value of an argument.
protected long	value_long(int arg) Called by xFunc to access the value of an argument.
protected String	value_text(int arg) Called by xFunc to access the value of an argument.
protected int	value_type(int arg) Called by xFunc to access the value of an argument.
protected abstract void	xFunc() Called by SQLite as a custom function.

クラスから継承されたメソッド java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

コンストラクタの詳細

Function

public Function()

メソッドの詳細

create

public static final void create(Connection conn,
          String name,
          Function f)
                         throws SQLException

Registers a given function with the connection.

パラメータ:

conn - The connection.

name - The name of the function.

f - The function to register.

例外:

SQLException

destroy

public static final void destroy(Connection conn,
           String name)
                          throws SQLException

Removes a named function from the given connection.

パラメータ:

conn - The connection to remove the function from.

name - The name of the function.

例外:

SQLException

xFunc

protected abstract void xFunc()
                       throws SQLException

Called by SQLite as a custom function. Should access arguments through value_*(int), return results with result(*) and throw errors with error(String).

例外:

SQLException

args

protected final int args()
                  throws SQLException

Returns the number of arguments passed to the function. Can only be called from xFunc().

例外:

SQLException

result

protected final void result(byte[] value)
                     throws SQLException

Called by xFunc to return a value.

パラメータ:

value -

例外:

SQLException

result

protected final void result(double value)
                     throws SQLException

Called by xFunc to return a value.

パラメータ:

value -

例外:

SQLException

result

protected final void result(int value)
                     throws SQLException

Called by xFunc to return a value.

パラメータ:

value -

例外:

SQLException

result

protected final void result(long value)
                     throws SQLException

Called by xFunc to return a value.

パラメータ:

value -

例外:

SQLException

result

protected final void result()
                     throws SQLException

Called by xFunc to return a value.

例外:

SQLException

result

protected final void result(String value)
                     throws SQLException

Called by xFunc to return a value.

パラメータ:

value -

例外:

SQLException

error

protected final void error(String err)
                    throws SQLException

Called by xFunc to throw an error.

パラメータ:

err -

例外:

SQLException

value_bytes

protected final int value_bytes(int arg)
                         throws SQLException

Called by xFunc to access the value of an argument.

パラメータ:

arg -

例外:

SQLException

value_text

protected final String value_text(int arg)
                           throws SQLException

Called by xFunc to access the value of an argument.

パラメータ:

arg -

例外:

SQLException

value_blob

protected final byte[] value_blob(int arg)
                           throws SQLException

Called by xFunc to access the value of an argument.

パラメータ:

arg -

例外:

SQLException

value_double

protected final double value_double(int arg)
                             throws SQLException

Called by xFunc to access the value of an argument.

パラメータ:

arg -

例外:

SQLException

value_int

protected final int value_int(int arg)
                       throws SQLException

Called by xFunc to access the value of an argument.

パラメータ:

arg -

例外:

SQLException

value_long

protected final long value_long(int arg)
                         throws SQLException

Called by xFunc to access the value of an argument.

パラメータ:

arg -

例外:

SQLException

value_type

protected final int value_type(int arg)
                        throws SQLException

Called by xFunc to access the value of an argument.

パラメータ:

arg -

例外:

SQLException