org.openanzo.common.rdb.sql
Class XMLSQL

java.lang.Object
  org.openanzo.common.rdb.sql.XMLSQL

public class XMLSQL
extends java.lang.Object

XMLSQL provides wrappers around SQL queries and transforms ResultSets into java objects

Author:

Generated Source from org.openanzo.jdbc.utils.opgen.jet

Nested Class Summary

static class	XMLSQL.BatchStoreLongXML Batch operation for adding parameters to the StoreLongXML prepared statement
static class	XMLSQL.BatchStoreXML Batch operation for adding parameters to the StoreXML prepared statement
static interface	XMLSQL.StoreLongXMLParams Interface for managing the parameters to the storeLongXML prepared statement.
static class	XMLSQL.StoreLongXMLParamsImpl Default implementation of StoreLongXMLParams
static interface	XMLSQL.StoreXMLParams Interface for managing the parameters to the storeXML prepared statement.
static class	XMLSQL.StoreXMLParamsImpl Default implementation of StoreXMLParams

Field Summary

static java.lang.String	fetchXMLLiteralNodeID Constant "fetchXMLLiteralNodeID" used to reference prepared statement xml.fetchXMLLiteralNodeID SELECT ID FROM ${a} WHERE HASH = ?
static java.lang.String	fetchXMLNodeID Constant "fetchXMLNodeID" used to reference prepared statement xml.fetchXMLNodeID SELECT ID FROM ${a} WHERE VALUE =?
static java.lang.String	fetchXMLValue Constant "fetchXMLValue" used to reference prepared statement xml.fetchXMLValue SELECT VALUE FROM ${a} WHERE ID = ?
static java.lang.String	storeLongXML Constant "storeLongXML" used to reference prepared statement xml.storeLongXML INSERT INTO ${a} (ID, VALUE, HASH) VALUES(?, ?, ?)
static java.lang.String	storeXML Constant "storeXML" used to reference prepared statement xml.storeXML INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)

Constructor Summary

XMLSQL()

Method Summary

static java.lang.Long	fetchXMLLiteralNodeID(PreparedStatementCache sqlCache, long hash, java.lang.String longLiteralNodeTableName) Runs the fetchXMLLiteralNodeID prepared statement.
static java.lang.Long	fetchXMLNodeID(PreparedStatementCache sqlCache, java.lang.String value, java.lang.String literalNodeTableName) Runs the fetchXMLNodeID prepared statement.
static java.lang.String	fetchXMLValue(PreparedStatementCache sqlCache, long id, java.lang.String xmlNodeTableName) Runs the fetchXMLValue prepared statement.
static void	prepareFetchXMLLiteralNodeID(java.sql.PreparedStatement ps, long hash) Sets the input parameters for the fetchXMLLiteralNodeID prepared statement.
static void	prepareFetchXMLNodeID(java.sql.PreparedStatement ps, java.lang.String value) Sets the input parameters for the fetchXMLNodeID prepared statement.
static void	prepareFetchXMLValue(java.sql.PreparedStatement ps, long id) Sets the input parameters for the fetchXMLValue prepared statement.
static void	prepareStoreLongXML(java.sql.PreparedStatement ps, long id, java.lang.String value, long hash) Sets the input parameters for the storeLongXML prepared statement.
static void	prepareStoreXML(java.sql.PreparedStatement ps, long id, java.lang.String value) Sets the input parameters for the storeXML prepared statement.
static void	storeLongXML(PreparedStatementCache sqlCache, long id, java.lang.String value, long hash, java.lang.String bulkLiteralTableName) Runs the storeLongXML prepared statement.
static void	storeLongXML(PreparedStatementCache sqlCache, XMLSQL.StoreLongXMLParams params, java.lang.String bulkLiteralTableName) Runs the storeLongXML prepared statement.
static void	storeXML(PreparedStatementCache sqlCache, long id, java.lang.String value, java.lang.String bulkLiteralTableName) Runs the storeXML prepared statement.
static void	storeXML(PreparedStatementCache sqlCache, XMLSQL.StoreXMLParams params, java.lang.String bulkLiteralTableName) Runs the storeXML prepared statement.

Methods inherited from class java.lang.Object

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

Field Detail

fetchXMLValue

public static final java.lang.String fetchXMLValue

Constant "fetchXMLValue" used to reference prepared statement xml.fetchXMLValue SELECT VALUE FROM ${a} WHERE ID = ?

See Also:

Constant Field Values

fetchXMLNodeID

public static final java.lang.String fetchXMLNodeID

Constant "fetchXMLNodeID" used to reference prepared statement xml.fetchXMLNodeID SELECT ID FROM ${a} WHERE VALUE =?

See Also:

Constant Field Values

fetchXMLLiteralNodeID

public static final java.lang.String fetchXMLLiteralNodeID

Constant "fetchXMLLiteralNodeID" used to reference prepared statement xml.fetchXMLLiteralNodeID SELECT ID FROM ${a} WHERE HASH = ?

See Also:

Constant Field Values

storeXML

public static final java.lang.String storeXML

Constant "storeXML" used to reference prepared statement xml.storeXML INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)

See Also:

Constant Field Values

storeLongXML

public static final java.lang.String storeLongXML

Constant "storeLongXML" used to reference prepared statement xml.storeLongXML INSERT INTO ${a} (ID, VALUE, HASH) VALUES(?, ?, ?)

See Also:

Constant Field Values

Constructor Detail

XMLSQL

public XMLSQL()

Method Detail

fetchXMLValue

public static java.lang.String fetchXMLValue(PreparedStatementCache sqlCache,
                                             long id,
                                             java.lang.String xmlNodeTableName)
                                      throws RdbException

Runs the fetchXMLValue prepared statement. SELECT VALUE FROM ${a} WHERE ID = ?

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

xmlNodeTableName - template parameter

Returns:

String

Throws:

RdbException

prepareFetchXMLValue

public static void prepareFetchXMLValue(java.sql.PreparedStatement ps,
                                        long id)
                                 throws java.sql.SQLException

Sets the input parameters for the fetchXMLValue prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

Throws:

java.sql.SQLException

fetchXMLNodeID

public static java.lang.Long fetchXMLNodeID(PreparedStatementCache sqlCache,
                                            java.lang.String value,
                                            java.lang.String literalNodeTableName)
                                     throws RdbException

Runs the fetchXMLNodeID prepared statement. SELECT ID FROM ${a} WHERE VALUE =?

Parameters:

sqlCache - factory and cache of PreparedStatments

value - template parameter

literalNodeTableName - template parameter

Returns:

Long

Throws:

RdbException

prepareFetchXMLNodeID

public static void prepareFetchXMLNodeID(java.sql.PreparedStatement ps,
                                         java.lang.String value)
                                  throws java.sql.SQLException

Sets the input parameters for the fetchXMLNodeID prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

value - template parameter

Throws:

java.sql.SQLException

fetchXMLLiteralNodeID

public static java.lang.Long fetchXMLLiteralNodeID(PreparedStatementCache sqlCache,
                                                   long hash,
                                                   java.lang.String longLiteralNodeTableName)
                                            throws RdbException

Runs the fetchXMLLiteralNodeID prepared statement. SELECT ID FROM ${a} WHERE HASH = ?

Parameters:

sqlCache - factory and cache of PreparedStatments

hash - template parameter

longLiteralNodeTableName - template parameter

Returns:

Long

Throws:

RdbException

prepareFetchXMLLiteralNodeID

public static void prepareFetchXMLLiteralNodeID(java.sql.PreparedStatement ps,
                                                long hash)
                                         throws java.sql.SQLException

Sets the input parameters for the fetchXMLLiteralNodeID prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

hash - template parameter

Throws:

java.sql.SQLException

storeXML

public static void storeXML(PreparedStatementCache sqlCache,
                            XMLSQL.StoreXMLParams params,
                            java.lang.String bulkLiteralTableName)
                     throws RdbException

Runs the storeXML prepared statement. INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - StoreXMLParams input Interface

bulkLiteralTableName - template parameter

Throws:

RdbException

storeXML

public static void storeXML(PreparedStatementCache sqlCache,
                            long id,
                            java.lang.String value,
                            java.lang.String bulkLiteralTableName)
                     throws RdbException

Runs the storeXML prepared statement. INSERT INTO ${a} (ID, VALUE) VALUES(?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

value - template parameter

bulkLiteralTableName - template parameter

Throws:

RdbException

prepareStoreXML

public static void prepareStoreXML(java.sql.PreparedStatement ps,
                                   long id,
                                   java.lang.String value)
                            throws java.sql.SQLException

Sets the input parameters for the storeXML prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

value - template parameter

Throws:

java.sql.SQLException

storeLongXML

public static void storeLongXML(PreparedStatementCache sqlCache,
                                XMLSQL.StoreLongXMLParams params,
                                java.lang.String bulkLiteralTableName)
                         throws RdbException

Runs the storeLongXML prepared statement. INSERT INTO ${a} (ID, VALUE, HASH) VALUES(?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

params - StoreLongXMLParams input Interface

bulkLiteralTableName - template parameter

Throws:

RdbException

storeLongXML

public static void storeLongXML(PreparedStatementCache sqlCache,
                                long id,
                                java.lang.String value,
                                long hash,
                                java.lang.String bulkLiteralTableName)
                         throws RdbException

Runs the storeLongXML prepared statement. INSERT INTO ${a} (ID, VALUE, HASH) VALUES(?, ?, ?)

Parameters:

sqlCache - factory and cache of PreparedStatments

id - template parameter

value - template parameter

hash - template parameter

bulkLiteralTableName - template parameter

Throws:

RdbException

prepareStoreLongXML

public static void prepareStoreLongXML(java.sql.PreparedStatement ps,
                                       long id,
                                       java.lang.String value,
                                       long hash)
                                throws java.sql.SQLException

Sets the input parameters for the storeLongXML prepared statement.

Parameters:

ps - PreparedStatement to whose parameters are set

id - template parameter

value - template parameter

hash - template parameter

Throws:

java.sql.SQLException