Package net.ontopia.persistence.proxy

Class SQLGenerator

java.lang.Object

net.ontopia.persistence.proxy.SQLGenerator

public class SQLGenerator
extends Object

INTERNAL: Utility class that can generate SQL statements.

Constructor Summary

Constructors

Constructor	Description
SQLGenerator()

Method Summary

Modifier and Type	Method	Description
static void	bindMultipleParameters(Iterator<IdentityIF> identities, FieldInfoIF finfo, PreparedStatement stm, int batchSize)
static void	bindMultipleParameters(Iterator<IdentityIF> identities, FieldInfoIF finfo, PreparedStatement stm, int offset, int batchSize)
static String	getDeleteStatement(String table, String[] where_columns)	INTERNAL: Generates a SQL delete statement for the specified table with a where clause referencing the given columns.
static String	getDeleteStatement(String table, FieldInfoIF[] where_fields)	INTERNAL: Generates a SQL delete statement for the specified table with a where clause referencing the given field infos.
static String	getInsertStatement(String table, String[] value_columns)	INTERNAL: Generates a SQL insert statement for the specified table with a value clause referencing the given columns.
static String	getInsertStatement(String table, FieldInfoIF[] value_fields)	INTERNAL: Generates a SQL insert statement for the specified table with a value clause referencing the given field infos.
static String	getSelectStatement(String table, String[] select_columns, String[] where_columns, int multiple)	INTERNAL: Generates a SQL select statement for the specified table with a select clause and a where clause referencing the given columns.
static String	getSelectStatement(String jointable, String datatable, String[] jointable_keys, String[] datatable_keys, String[] datatable_select_columns, String[] jointable_where_columns, int multiple)	INTERNAL: Generates a SQL select statement that joins two tables.
static String	getSelectStatement(String table, FieldInfoIF[] select_fields, FieldInfoIF[] where_fields, int multiple)	INTERNAL: Generates a SQL select statement for the specified table with a select clause and a where clause referencing the given field infos.
static String	getUpdateStatement(String table, String[] set_columns, String[] where_columns)	INTERNAL: Generates a SQL update statement for the specified table with a set clause and a where clause referencing the given columns.
static String	getUpdateStatement(String table, FieldInfoIF[] set_fields, FieldInfoIF[] where_fields)	INTERNAL: Generates a SQL update statement for the specified table with a set clause and a where clause referencing the given field infos.
static String	processMultipleLoadParameters(Collection<IdentityIF> identities, String sql)

Methods inherited from class java.lang.Object

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

Constructor Details

SQLGenerator

public SQLGenerator()

Method Details

getDeleteStatement

public static String getDeleteStatement(String table,
 FieldInfoIF[] where_fields)

INTERNAL: Generates a SQL delete statement for the specified table with a where clause referencing the given field infos.

getDeleteStatement

public static String getDeleteStatement(String table,
 String[] where_columns)

INTERNAL: Generates a SQL delete statement for the specified table with a where clause referencing the given columns.

getInsertStatement

public static String getInsertStatement(String table,
 FieldInfoIF[] value_fields)

INTERNAL: Generates a SQL insert statement for the specified table with a value clause referencing the given field infos.

getInsertStatement

public static String getInsertStatement(String table,
 String[] value_columns)

INTERNAL: Generates a SQL insert statement for the specified table with a value clause referencing the given columns.

getUpdateStatement

public static String getUpdateStatement(String table,
 FieldInfoIF[] set_fields,
 FieldInfoIF[] where_fields)

INTERNAL: Generates a SQL update statement for the specified table with a set clause and a where clause referencing the given field infos.

getUpdateStatement

public static String getUpdateStatement(String table,
 String[] set_columns,
 String[] where_columns)

INTERNAL: Generates a SQL update statement for the specified table with a set clause and a where clause referencing the given columns.

getSelectStatement

public static String getSelectStatement(String table,
 FieldInfoIF[] select_fields,
 FieldInfoIF[] where_fields,
 int multiple)

INTERNAL: Generates a SQL select statement for the specified table with a select clause and a where clause referencing the given field infos.

getSelectStatement

public static String getSelectStatement(String table,
 String[] select_columns,
 String[] where_columns,
 int multiple)

INTERNAL: Generates a SQL select statement for the specified table with a select clause and a where clause referencing the given columns.

getSelectStatement

public static String getSelectStatement(String jointable,
 String datatable,
 String[] jointable_keys,
 String[] datatable_keys,
 String[] datatable_select_columns,
 String[] jointable_where_columns,
 int multiple)

INTERNAL: Generates a SQL select statement that joins two tables.

processMultipleLoadParameters

public static String processMultipleLoadParameters(Collection<IdentityIF> identities,
 String sql)

bindMultipleParameters

public static void bindMultipleParameters(Iterator<IdentityIF> identities,
 FieldInfoIF finfo,
 PreparedStatement stm,
 int batchSize)
                                   throws SQLException

Throws:

SQLException

bindMultipleParameters

public static void bindMultipleParameters(Iterator<IdentityIF> identities,
 FieldInfoIF finfo,
 PreparedStatement stm,
 int offset,
 int batchSize)
                                   throws SQLException

Throws:

SQLException