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

SQLGenerator()

Method Summary

static void	bindMultipleParameters(Iterator identities, FieldInfoIF finfo, PreparedStatement stm, int batchSize)
static void	bindMultipleParameters(Iterator identities, FieldInfoIF finfo, PreparedStatement stm, int offset, int batchSize)
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	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	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	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	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	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	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	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	processMultipleLoadParameters(Collection identities, String sql)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLGenerator

public SQLGenerator()

Method Detail

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 identities,
                                                   String sql)

bindMultipleParameters

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

Throws:

SQLException

bindMultipleParameters

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

Throws:

SQLException