org.ofbiz.entity.jdbc
Class SqlJdbcUtil

java.lang.Object
  org.ofbiz.entity.jdbc.SqlJdbcUtil

public class SqlJdbcUtil
extends java.lang.Object

GenericDAO Utility methods for general tasks

Field Summary

static int	CHAR_BUFFER_SIZE
protected static java.util.Map<java.lang.String,java.lang.Integer>	fieldTypeMap
static java.lang.String	module

Constructor Summary

SqlJdbcUtil()

=?" if not null or "IS null" if null, all AND separated=?" if not null or "IS null" if null, all AND separated

Method Summary

static void	addValue(java.lang.StringBuffer buffer, ModelField field, java.lang.Object value, java.util.List<EntityConditionParam> params)
static void	addValue(java.lang.StringBuilder buffer, ModelField field, java.lang.Object value, java.util.List<EntityConditionParam> params)
static void	addValueSingle(java.lang.StringBuffer buffer, ModelField field, java.lang.Object value, java.util.List<EntityConditionParam> params)
static void	addValueSingle(java.lang.StringBuilder buffer, ModelField field, java.lang.Object value, java.util.List<EntityConditionParam> params)
static java.lang.String	filterColName(java.lang.String colName)
static int	getType(java.lang.String fieldType)
static void	getValue(java.sql.ResultSet rs, int ind, ModelField curField, GenericEntity entity, ModelFieldTypeReader modelFieldTypeReader)
static java.lang.String	makeFromClause(ModelEntity modelEntity, DatasourceInfo datasourceInfo) Makes the FROM clause and when necessary the JOIN clause(s) as well
static java.lang.String	makeOrderByClause(ModelEntity modelEntity, java.util.List<java.lang.String> orderBy, boolean includeTablenamePrefix, DatasourceInfo datasourceInfo)
static java.lang.String	makeOrderByClause(ModelEntity modelEntity, java.util.List<java.lang.String> orderBy, DatasourceInfo datasourceInfo)
static java.lang.String	makeViewTable(ModelEntity modelEntity, DatasourceInfo datasourceInfo)
static java.lang.String	makeViewWhereClause(ModelEntity modelEntity, java.lang.String joinStyle)
static java.lang.String	makeWhereClause(ModelEntity modelEntity, java.util.List modelFields, java.util.Map<java.lang.String,java.lang.Object> fields, java.lang.String operator, java.lang.String joinStyle)
static java.lang.String	makeWhereStringFromFields(java.util.List modelFields, java.util.Map<java.lang.String,java.lang.Object> fields, java.lang.String operator) Makes a WHERE clause String with "
static java.lang.String	makeWhereStringFromFields(java.util.List modelFields, java.util.Map<java.lang.String,java.lang.Object> fields, java.lang.String operator, java.util.List<EntityConditionParam> entityConditionParams) Makes a WHERE clause String with "
static void	setPkValues(SQLProcessor sqlP, ModelEntity modelEntity, GenericEntity entity, ModelFieldTypeReader modelFieldTypeReader) Get all primary keys from the model entity and bind their values to the an SQL statement (SQL-Processor)
static void	setValue(SQLProcessor sqlP, ModelField modelField, GenericEntity entity, ModelFieldTypeReader modelFieldTypeReader)
static void	setValue(SQLProcessor sqlP, ModelField modelField, java.lang.String entityName, java.lang.Object fieldValue, ModelFieldTypeReader modelFieldTypeReader)
static void	setValues(SQLProcessor sqlP, java.util.List<ModelField> list, GenericEntity entity, ModelFieldTypeReader modelFieldTypeReader) The elements (ModelFields) of the list are bound to an SQL statement (SQL-Processor)
static void	setValuesWhereClause(SQLProcessor sqlP, java.util.List<ModelField> list, GenericValue dummyValue, ModelFieldTypeReader modelFieldTypeReader) The elements (ModelFields) of the list are bound to an SQL statement (SQL-Processor), but values must not be null.

Methods inherited from class java.lang.Object

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

Field Detail

module

public static final java.lang.String module

CHAR_BUFFER_SIZE

public static final int CHAR_BUFFER_SIZE

See Also:

Constant Field Values

fieldTypeMap

protected static java.util.Map<java.lang.String,java.lang.Integer> fieldTypeMap

Constructor Detail

SqlJdbcUtil

public SqlJdbcUtil()

Method Detail

makeFromClause

public static java.lang.String makeFromClause(ModelEntity modelEntity,
                                              DatasourceInfo datasourceInfo)
                                       throws GenericEntityException

Makes the FROM clause and when necessary the JOIN clause(s) as well

Throws:

GenericEntityException

makeWhereStringFromFields

public static java.lang.String makeWhereStringFromFields(java.util.List modelFields,
                                                         java.util.Map<java.lang.String,java.lang.Object> fields,
                                                         java.lang.String operator)

Makes a WHERE clause String with "=?" if not null or " IS null" if null, all AND separated

makeWhereStringFromFields

public static java.lang.String makeWhereStringFromFields(java.util.List modelFields,
                                                         java.util.Map<java.lang.String,java.lang.Object> fields,
                                                         java.lang.String operator,
                                                         java.util.List<EntityConditionParam> entityConditionParams)

Makes a WHERE clause String with "=?" if not null or " IS null" if null, all AND separated

makeWhereClause

public static java.lang.String makeWhereClause(ModelEntity modelEntity,
                                               java.util.List modelFields,
                                               java.util.Map<java.lang.String,java.lang.Object> fields,
                                               java.lang.String operator,
                                               java.lang.String joinStyle)
                                        throws GenericEntityException

Throws:

GenericEntityException

makeViewWhereClause

public static java.lang.String makeViewWhereClause(ModelEntity modelEntity,
                                                   java.lang.String joinStyle)
                                            throws GenericEntityException

Throws:

GenericEntityException

makeOrderByClause

public static java.lang.String makeOrderByClause(ModelEntity modelEntity,
                                                 java.util.List<java.lang.String> orderBy,
                                                 DatasourceInfo datasourceInfo)
                                          throws GenericModelException

Throws:

GenericModelException

makeOrderByClause

public static java.lang.String makeOrderByClause(ModelEntity modelEntity,
                                                 java.util.List<java.lang.String> orderBy,
                                                 boolean includeTablenamePrefix,
                                                 DatasourceInfo datasourceInfo)
                                          throws GenericModelException

Throws:

GenericModelException

makeViewTable

public static java.lang.String makeViewTable(ModelEntity modelEntity,
                                             DatasourceInfo datasourceInfo)
                                      throws GenericEntityException

Throws:

GenericEntityException

filterColName

public static java.lang.String filterColName(java.lang.String colName)

setValues

public static void setValues(SQLProcessor sqlP,
                             java.util.List<ModelField> list,
                             GenericEntity entity,
                             ModelFieldTypeReader modelFieldTypeReader)
                      throws GenericEntityException

The elements (ModelFields) of the list are bound to an SQL statement (SQL-Processor)

Parameters:

sqlP -

list -

entity -

Throws:

GenericEntityException

setValuesWhereClause

public static void setValuesWhereClause(SQLProcessor sqlP,
                                        java.util.List<ModelField> list,
                                        GenericValue dummyValue,
                                        ModelFieldTypeReader modelFieldTypeReader)
                                 throws GenericEntityException

The elements (ModelFields) of the list are bound to an SQL statement (SQL-Processor), but values must not be null.

Parameters:

sqlP -

list -

dummyValue -

modelFieldTypeReader -

Throws:

GenericEntityException

setPkValues

public static void setPkValues(SQLProcessor sqlP,
                               ModelEntity modelEntity,
                               GenericEntity entity,
                               ModelFieldTypeReader modelFieldTypeReader)
                        throws GenericEntityException

Get all primary keys from the model entity and bind their values to the an SQL statement (SQL-Processor)

Parameters:

sqlP -

modelEntity -

entity -

modelFieldTypeReader -

Throws:

GenericEntityException

getValue

public static void getValue(java.sql.ResultSet rs,
                            int ind,
                            ModelField curField,
                            GenericEntity entity,
                            ModelFieldTypeReader modelFieldTypeReader)
                     throws GenericEntityException

Throws:

GenericEntityException

setValue

public static void setValue(SQLProcessor sqlP,
                            ModelField modelField,
                            GenericEntity entity,
                            ModelFieldTypeReader modelFieldTypeReader)
                     throws GenericEntityException

Throws:

GenericEntityException

setValue

public static void setValue(SQLProcessor sqlP,
                            ModelField modelField,
                            java.lang.String entityName,
                            java.lang.Object fieldValue,
                            ModelFieldTypeReader modelFieldTypeReader)
                     throws GenericEntityException

Throws:

GenericEntityException

getType

public static int getType(java.lang.String fieldType)
                   throws GenericNotImplementedException

Throws:

GenericNotImplementedException

addValueSingle

public static void addValueSingle(java.lang.StringBuffer buffer,
                                  ModelField field,
                                  java.lang.Object value,
                                  java.util.List<EntityConditionParam> params)

addValueSingle

public static void addValueSingle(java.lang.StringBuilder buffer,
                                  ModelField field,
                                  java.lang.Object value,
                                  java.util.List<EntityConditionParam> params)

addValue

public static void addValue(java.lang.StringBuffer buffer,
                            ModelField field,
                            java.lang.Object value,
                            java.util.List<EntityConditionParam> params)

addValue

public static void addValue(java.lang.StringBuilder buffer,
                            ModelField field,
                            java.lang.Object value,
                            java.util.List<EntityConditionParam> params)