com.retek.commons.domain.core.persistence.db.oracle
Class DbUtil
java.lang.Object
com.retek.commons.domain.core.persistence.db.oracle.DbUtil
- public class DbUtil
- extends java.lang.Object
Method Summary |
static void |
addInClause(java.lang.StringBuffer bufferSQL,
java.util.Collection values,
boolean useQuotes)
|
static void |
addTableJoin(java.lang.StringBuffer sql,
java.lang.String tableOneJoinColumn,
java.lang.String tableTwoJoinColumn)
|
static boolean |
addToWhereClauseForIn(java.lang.StringBuffer sql,
java.lang.String colName,
java.util.Set colValues,
java.lang.String appender,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.lang.Class expectedClass,
java.util.Collection refs,
boolean caseSensitive,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.lang.Class expectedClass,
java.util.Collection refs,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
boolean caseSensitive,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
java.lang.String appender,
boolean caseSensitive,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
java.lang.String appender,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.util.Collection values,
boolean caseSensitive,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.util.Collection expectedClasses,
java.util.Collection refs,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.util.Collection values,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
Enum enum,
java.lang.String appender,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Object colVal,
java.util.List bindVariablesList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
RDate startDate,
RDate endDate,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
RDate startDate,
RDate endDate,
java.lang.String appender,
java.util.List bindVariableList)
|
static boolean |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
boolean caseSensitive,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
java.util.List bindVariableList)
|
static boolean |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
java.lang.String appender,
boolean caseSensitive,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
java.lang.String appender,
java.util.List bindVariableList)
|
static void |
addToWhereClauseForSearchWithNoAppender(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Object colVal,
java.util.List bindVariablesList)
|
static void |
buildUnionInClause(java.lang.StringBuffer bufferSQL,
java.util.Collection values,
int maxSize,
boolean useQuotes)
|
static void |
checkForInvalidReferences(java.util.Collection searchRefs,
java.util.Collection foundRefs)
|
static void |
checkForInvalidReferences(java.util.Set searchRefs,
java.util.Set foundRefs)
|
static java.util.Set |
extractIdStrings(java.util.Set refs)
|
static java.lang.String |
formatLikeStr(java.lang.String str)
|
static void |
handleAppend(java.lang.StringBuffer sql)
|
static void |
handleAppend(java.lang.StringBuffer sql,
java.lang.String appender)
|
static void |
handleOrAppend(java.lang.StringBuffer buffer)
|
static java.lang.String |
handleSqlDate(RDate sqlDate,
java.util.List bindVariableList)
Create sql date query clause. |
static java.lang.String |
handleSqlDate(RDate sqlDate,
java.util.List bindVariableList,
boolean truncateTime)
Create sql date query clause. |
static void |
setParameters(RetekPreparedStatement stmt,
java.util.List bindVariablesList)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
DbUtil
public DbUtil()
addTableJoin
public static void addTableJoin(java.lang.StringBuffer sql,
java.lang.String tableOneJoinColumn,
java.lang.String tableTwoJoinColumn)
addToWhereClauseForIn
public static boolean addToWhereClauseForIn(java.lang.StringBuffer sql,
java.lang.String colName,
java.util.Set colValues,
java.lang.String appender,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static boolean addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
java.lang.String appender,
boolean caseSensitive,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
java.lang.String appender,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static boolean addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
boolean caseSensitive,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.String colVal,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
Enum enum,
java.lang.String appender,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
RDate startDate,
RDate endDate,
java.lang.String appender,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
RDate startDate,
RDate endDate,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
java.lang.String appender,
boolean caseSensitive,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
boolean caseSensitive,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Class expectedBusinessInterface,
DistributedReference ref,
java.lang.String appender,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.util.Collection values,
boolean caseSensitive,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.util.Collection values,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.lang.Class expectedClass,
java.util.Collection refs,
boolean caseSensitive,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.lang.Class expectedClass,
java.util.Collection refs,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer buffer,
java.lang.String columnName,
java.util.Collection expectedClasses,
java.util.Collection refs,
java.util.List bindVariableList)
addToWhereClauseForSearch
public static void addToWhereClauseForSearch(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Object colVal,
java.util.List bindVariablesList)
addToWhereClauseForSearchWithNoAppender
public static void addToWhereClauseForSearchWithNoAppender(java.lang.StringBuffer sql,
java.lang.String colName,
java.lang.Object colVal,
java.util.List bindVariablesList)
addInClause
public static void addInClause(java.lang.StringBuffer bufferSQL,
java.util.Collection values,
boolean useQuotes)
buildUnionInClause
public static void buildUnionInClause(java.lang.StringBuffer bufferSQL,
java.util.Collection values,
int maxSize,
boolean useQuotes)
formatLikeStr
public static java.lang.String formatLikeStr(java.lang.String str)
handleAppend
public static void handleAppend(java.lang.StringBuffer sql,
java.lang.String appender)
handleAppend
public static void handleAppend(java.lang.StringBuffer sql)
handleOrAppend
public static void handleOrAppend(java.lang.StringBuffer buffer)
handleSqlDate
public static final java.lang.String handleSqlDate(RDate sqlDate,
java.util.List bindVariableList)
- Create sql date query clause. This variation of the operation truncates time in the TO_DATE
format function.
- Parameters:
sqlDate
- date variablebindVariableList
- bind variable list
- Returns:
- sql string for the date clause
handleSqlDate
public static final java.lang.String handleSqlDate(RDate sqlDate,
java.util.List bindVariableList,
boolean truncateTime)
- Create sql date query clause.
Note: If you are truncating time using the TRUNC function, set the truncateTime paramater
to false.
- Parameters:
sqlDate
- date variablebindVariableList
- bind variable listtruncateTime
- indicator whether to truncate time in the TO_DATE format function
- Returns:
- sql string for the date clause
setParameters
public static void setParameters(RetekPreparedStatement stmt,
java.util.List bindVariablesList)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
extractIdStrings
public static java.util.Set extractIdStrings(java.util.Set refs)
checkForInvalidReferences
public static void checkForInvalidReferences(java.util.Set searchRefs,
java.util.Set foundRefs)
throws InvalidReferenceException
- Throws:
InvalidReferenceException
- Is thrown if not all searchRefs contained in foundRefs
checkForInvalidReferences
public static void checkForInvalidReferences(java.util.Collection searchRefs,
java.util.Collection foundRefs)
throws InvalidReferenceException
- Throws:
InvalidReferenceException
- Is thrown if not all searchRefs contained in foundRefs
Copyright © 2005 Retek Inc. All Rights Reserved.
- Generated at Fri, 01/21/2005 14:25