net.sf.saxon.option.sql

Class SQLExtensionFunctions

java.lang.Object

net.sf.saxon.option.sql.SQLExtensionFunctions

public class SQLExtensionFunctions
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	NAMESPACE

Constructor Summary

Constructors

Constructor and Description
SQLExtensionFunctions()

Method Summary

Modifier and Type	Method and Description
static Sequence	close(XPathContext context, Item conn)
static Sequence	closeLocal(XPathContext context, java.sql.Connection connection)
static ObjectValue<java.sql.Connection>	connect(XPathContext context, One<StringValue> database, One<StringValue> driver, One<StringValue> user, One<StringValue> password, One<StringValue> autoCommit)
static MapItem	connectMap(XPathContext context, One<StringValue> database, One<StringValue> driver, One<StringValue> user, One<StringValue> password, One<StringValue> autoCommit)
static Sequence	query(XPathContext context, Item conn, One<StringValue> query)
static Sequence	query(XPathContext context, Item conn, One<StringValue> table, OneOrMore<Item> columns)
static Sequence	query(XPathContext context, Item conn, One<StringValue> table, OneOrMore<Item> columns, ZeroOrOne<StringValue> where)
static java.util.ArrayList<MapItem>	queryMap(XPathContext context, Item conn, One<StringValue> query)
static java.util.ArrayList<MapItem>	queryMap(XPathContext context, Item conn, One<StringValue> table, OneOrMore<Item> columns, ZeroOrOne<StringValue> where)
static java.util.ArrayList<MapItem>	queryMapLocal(XPathContext context, java.sql.Connection connection, One<StringValue> query)
static StringValue	queryString(One<StringValue> table, OneOrMore<Item> columns, ZeroOrOne<StringValue> where) Forms an SQL query from subparts

Methods inherited from class java.lang.Object

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

Field Detail

NAMESPACE

public static final java.lang.String NAMESPACE

See Also:

Constant Field Values

Constructor Detail

SQLExtensionFunctions

public SQLExtensionFunctions()

Method Detail

connect

public static ObjectValue<java.sql.Connection> connect(XPathContext context,
                                                       One<StringValue> database,
                                                       One<StringValue> driver,
                                                       One<StringValue> user,
                                                       One<StringValue> password,
                                                       One<StringValue> autoCommit)
                                                throws XPathException

Throws:

XPathException

queryString

public static StringValue queryString(One<StringValue> table,
                                      OneOrMore<Item> columns,
                                      ZeroOrOne<StringValue> where)
                               throws XPathException

Forms an SQL query from subparts

Parameters:

table - Database table to select from

columns - columns to choose ("*" means all)

where - selection criteria

Returns:

Completed SQL query string

Throws:

XPathException

query

public static Sequence query(XPathContext context,
                             Item conn,
                             One<StringValue> table,
                             OneOrMore<Item> columns)
                      throws XPathException

Throws:

XPathException

query

public static Sequence query(XPathContext context,
                             Item conn,
                             One<StringValue> table,
                             OneOrMore<Item> columns,
                             ZeroOrOne<StringValue> where)
                      throws XPathException

Throws:

XPathException

query

public static Sequence query(XPathContext context,
                             Item conn,
                             One<StringValue> query)
                      throws XPathException

Throws:

XPathException

close

public static Sequence close(XPathContext context,
                             Item conn)
                      throws XPathException

Throws:

XPathException

closeLocal

public static Sequence closeLocal(XPathContext context,
                                  java.sql.Connection connection)
                           throws XPathException

Throws:

XPathException

queryMap

public static java.util.ArrayList<MapItem> queryMap(XPathContext context,
                                                    Item conn,
                                                    One<StringValue> table,
                                                    OneOrMore<Item> columns,
                                                    ZeroOrOne<StringValue> where)
                                             throws XPathException

Throws:

XPathException

queryMap

public static java.util.ArrayList<MapItem> queryMap(XPathContext context,
                                                    Item conn,
                                                    One<StringValue> query)
                                             throws XPathException

Throws:

XPathException

queryMapLocal

public static java.util.ArrayList<MapItem> queryMapLocal(XPathContext context,
                                                         java.sql.Connection connection,
                                                         One<StringValue> query)
                                                  throws XPathException

Throws:

XPathException

connectMap

public static MapItem connectMap(XPathContext context,
                                 One<StringValue> database,
                                 One<StringValue> driver,
                                 One<StringValue> user,
                                 One<StringValue> password,
                                 One<StringValue> autoCommit)
                          throws XPathException

Throws:

XPathException