DEPRECATED This class has been deprecated in favor of using a com.bea.p13n.content.document.ref.RefSQLGenerator
instance configured as needed.
Object
A little holder class for the information required to create and execute a PreparedStatement, plus how to convert a Search/Expression into a StatementParams.
This class is specific to the table structure of the RefDocumentProvider.
Object
StatementParams
Field Summary |
public static final short |
|
public static final short |
|
public static final short |
|
public static final |
|
public static final |
|
public static final |
|
public static final short |
|
public static final short |
|
public static final short |
|
public static final short |
|
public static final short |
|
public static final short |
|
public long |
|
public static final short |
|
public static final short |
|
public static final short |
|
public |
|
public |
|
public |
|
Constructor Summary |
Method Summary |
protected static void |
|
protected static void |
|
protected static |
|
protected static void |
|
public static |
|
public static short |
|
protected static |
|
protected static |
|
public static |
|
public static |
|
protected static |
|
public static boolean |
|
public |
|
public void | |
public static | |
public static |
Methods from class java.lang. |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static final short AND_TYPE
Related Topics
public static final short COLLECTION_CONTAINS_ALL_TYPE
Related Topics
public static final short COLLECTION_CONTAINS_TYPE
Related Topics
public static final DateFormat
dateFormat
public static final String
DOC_MD_TABLE
Related Topics
public static final String
DOC_TABLE
Related Topics
public static final short EQUALS_TYPE
Related Topics
public static final short GREATER_OR_EQUALS_TYPE
Related Topics
public static final short GREATER_THAN_TYPE
Related Topics
public static final short LESS_OR_EQUALS_TYPE
Related Topics
public static final short LESS_THAN_TYPE
Related Topics
public static final short LIKE_TYPE
Related Topics
public long maxReturn
public static final short NOT_EQUALS_TYPE
Related Topics
public static final short NOT_TYPE
Related Topics
public static final short OR_TYPE
Related Topics
public List
params
public com.bea.p13n.content.expression.SortCriteria
sortCriteria
This will be null or empty if no additional sorting is required.
public String
sql
Constructor Detail |
public StatementParams()
Method Detail |
protected static void createBranchStatementParams(Utility to convert a branch expression into a SQL expression.StringBuffer
buf,Expression
expr,List
params, boolean supportsLikeEscapeClause)
throwsDocumentException
DocumentException
protected static void createLeafStatementParams(Utility to convert a valid leaf Expression into a SQL expression.StringBuffer
buf,Expression
expr,List
params, boolean supportsLikeEscapeClause)
throwsDocumentException
DocumentException
protected staticUtility method to convert an Expression into a SQL expression.String
createStatementParams(Expression
expr,List
params, boolean supportsLikeEscapeClause)
throwsDocumentException
DocumentException
protected static void createStatementParams(Utility method to convert an Expression into a SQL expression.StringBuffer
buf,Expression
expr,List
params, boolean supportsLikeEscapeClause)
throwsDocumentException
DocumentException
public staticGet the expression string for the specified expression type.String
getExpressionString(short type)
throwsDocumentException
DocumentException
Related Topics
StatementParams.NOT_EQUALS_TYPE
StatementParams.EQUALS_TYPE
StatementParams.GREATER_THAN_TYPE
StatementParams.LESS_THAN_TYPE
StatementParams.GREATER_OR_EQUALS_TYPE
StatementParams.LESS_OR_EQUALS_TYPE
StatementParams.LIKE_TYPE
StatementParams.COLLECTION_CONTAINS_TYPE
StatementParams.COLLECTION_CONTAINS_ALL_TYPE
StatementParams.AND_TYPE
StatementParams.OR_TYPE
StatementParams.NOT_TYPE
public static short getExpressionType(Get a type constant for the given expression.Expression
expr)
throwsDocumentException
DocumentException
Related Topics
StatementParams.NOT_EQUALS_TYPE
StatementParams.EQUALS_TYPE
StatementParams.GREATER_THAN_TYPE
StatementParams.LESS_THAN_TYPE
StatementParams.GREATER_OR_EQUALS_TYPE
StatementParams.LESS_OR_EQUALS_TYPE
StatementParams.LIKE_TYPE
StatementParams.COLLECTION_CONTAINS_TYPE
StatementParams.COLLECTION_CONTAINS_ALL_TYPE
StatementParams.AND_TYPE
StatementParams.OR_TYPE
StatementParams.NOT_TYPE
protected staticGet the left-hand-side of an expression.PropertyRef
getLeftHandSide(Expression
expr)
throwsDocumentException
DocumentException
Related Topics
ExpressionHelper.getLeftHandSide(Expression)
protected staticGet the right-hand-side of an expression.Object
getRightHandSide(Expression
expr)
throwsDocumentException
DocumentException
Related Topics
ExpressionHelper.getRightHandSide(Expression)
public staticReturn the corresponding SQL operator for the given expression type.String
getSQLOperator(short type)
throwsDocumentException
DocumentException
public staticUtility method to get a StatementParams from Search params.StatementParams
getStatementParams(String
baseSql,Search
params, boolean supportsLikeEscapeClause)
throwsDocumentException
DocumentException
protected staticGet the specified subexpression.Expression
getSubExpression(Expression
expr, int count)
throwsDocumentException
DocumentException
Related Topics
ExpressionHelper.getSubExpression(Expression, int)
public static boolean isLegalSingleValueExpressionType(short type)Determine if a comparator is legal, single-value attribute comparator.
publicPrepare a statement from our sql and input params on the given database connection.PreparedStatement
prepare(Connection
con)
throwsSQLException
SQLException
public void sort(Sort a list of DocumentMetadataDefs based upon our sort criteria.List
list)
throwsDocumentException
DocumentException
public staticConvert a query LIKE value to a SQL LIKE value.String
toSQLLike(String
like, boolean supportsLikeEscapeClause)
public staticConvert an object, which might be a string, to a SQL like string.Object
toSQLLike(Object
obj, boolean supportsLikeEscapeClause)