intradoc.data
Class QueryUtils

java.lang.Object
  |
  +--intradoc.data.QueryUtils

public class QueryUtils

extends java.lang.Object

Constructor Summary

QueryUtils()

Method Summary

static void	addColumnMapRow(DataResultSet drset, java.lang.String key)
static void	addQueryDef(DataResultSet qlist, java.lang.String name, java.lang.String queryStr, java.lang.String parameters)
static void	addQueryTable(Workspace workspace, ResourceContainer res, java.lang.String tableName, boolean mustExist, java.lang.String cmptName)
static void	appendAscendingOrDescending(java.lang.StringBuffer buf, java.lang.String sortField, java.lang.String sortOrder)
static void	appendParam(java.lang.StringBuffer buffer, int type, java.lang.String value)
static boolean	appendSubclause(java.lang.StringBuffer buf, boolean inClause, java.lang.String keyword, java.lang.String sep, java.lang.String columnText)
static int	computeNumSafeSecurityParenthesis(java.lang.String query)
static int	convertInfoStringToType(java.lang.String typeStr)
static java.lang.String	convertInfoTypeToString(int type)
static boolean	createAndAppendSubclause(java.lang.StringBuffer sql, FieldInfo info, java.lang.String val, java.lang.String op, java.lang.String keyword, java.lang.String sep, boolean inClause)
static boolean	createInsertAndUpdateClauses(java.lang.StringBuffer[] sqlStubs, java.util.Vector fields, DataBinder workBinder, boolean inClause)
static boolean	createInsertClauses(java.lang.StringBuffer nameSql, java.lang.StringBuffer valueSql, FieldInfo info, java.lang.String val, boolean inClause)
static java.lang.String	createSubclause(FieldInfo info, java.lang.String val, java.lang.String op, java.lang.String parentTable)
protected static boolean	createUpdateClause(java.lang.StringBuffer sql, FieldInfo info, java.lang.String val, java.lang.String sep, boolean inClause)
static java.lang.String	enclosingQueryWithSafeParenthesis(java.lang.String query)
protected static boolean	isSafeChar(char ch)
static boolean	validateQuerySortClause(java.lang.String sortClause)

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryUtils

public QueryUtils()

Method Detail

convertInfoStringToType

public static int convertInfoStringToType(java.lang.String typeStr)

convertInfoTypeToString

public static java.lang.String convertInfoTypeToString(int type)

addColumnMapRow

public static void addColumnMapRow(DataResultSet drset,
                                   java.lang.String key)

addQueryDef

public static void addQueryDef(DataResultSet qlist,
                               java.lang.String name,
                               java.lang.String queryStr,
                               java.lang.String parameters)

addQueryTable

public static void addQueryTable(Workspace workspace,
                                 ResourceContainer res,
                                 java.lang.String tableName,
                                 boolean mustExist,
                                 java.lang.String cmptName)
                          throws DataException

DataException

appendSubclause

public static boolean appendSubclause(java.lang.StringBuffer buf,
                                      boolean inClause,
                                      java.lang.String keyword,
                                      java.lang.String sep,
                                      java.lang.String columnText)

appendAscendingOrDescending

public static void appendAscendingOrDescending(java.lang.StringBuffer buf,
                                               java.lang.String sortField,
                                               java.lang.String sortOrder)

createSubclause

public static java.lang.String createSubclause(FieldInfo info,
                                               java.lang.String val,
                                               java.lang.String op,
                                               java.lang.String parentTable)
                                        throws DataException

DataException

createAndAppendSubclause

public static boolean createAndAppendSubclause(java.lang.StringBuffer sql,
                                               FieldInfo info,
                                               java.lang.String val,
                                               java.lang.String op,
                                               java.lang.String keyword,
                                               java.lang.String sep,
                                               boolean inClause)
                                        throws DataException

DataException

createInsertAndUpdateClauses

public static boolean createInsertAndUpdateClauses(java.lang.StringBuffer[] sqlStubs,
                                                   java.util.Vector fields,
                                                   DataBinder workBinder,
                                                   boolean inClause)
                                            throws DataException

DataException

createInsertClauses

public static boolean createInsertClauses(java.lang.StringBuffer nameSql,
                                          java.lang.StringBuffer valueSql,
                                          FieldInfo info,
                                          java.lang.String val,
                                          boolean inClause)
                                   throws DataException

DataException

createUpdateClause

protected static boolean createUpdateClause(java.lang.StringBuffer sql,
                                            FieldInfo info,
                                            java.lang.String val,
                                            java.lang.String sep,
                                            boolean inClause)
                                     throws DataException

DataException

appendParam

public static void appendParam(java.lang.StringBuffer buffer,
                               int type,
                               java.lang.String value)
                        throws DataException

DataException

enclosingQueryWithSafeParenthesis

public static java.lang.String enclosingQueryWithSafeParenthesis(java.lang.String query)

computeNumSafeSecurityParenthesis

public static int computeNumSafeSecurityParenthesis(java.lang.String query)

isSafeChar

protected static boolean isSafeChar(char ch)

validateQuerySortClause

public static boolean validateQuerySortClause(java.lang.String sortClause)