com.semarchy.mdm.runtime.admin.util
Class SQLQueryUtil

java.lang.Object
  extended by com.semarchy.mdm.runtime.admin.util.SQLQueryUtil

public class SQLQueryUtil
extends Object

FIXME currently oracle request only update this to support postgres

Author:
amergey

Field Summary
static String ID_COL_NAME
           
 
Constructor Summary
SQLQueryUtil()
           
 
Method Summary
static void appendEqualsPattern(StringBuilder pBuilder, String pColName, String pValue)
           
static void appendIn(StringBuilder pBuilder, String pColName, Object[] pList)
           
static void appendIsNull(StringBuilder pBuilder, String pColName)
           
static void appendLikePattern(StringBuilder pBuilder, String pColName, String pPattern)
           
static void appendOrderBy(StringBuilder pBuilder, String pOrderBy)
           
static void appendRowLimit(StringBuilder pBuilder, int pMaxRows, boolean pAfter)
           
static void appendRowLimit(StringBuilder pBuilder, int pRow, int pMaxRows)
           
static void appendSelect(StringBuilder pBuilder, String[] pColNames, String pTableName, String pClassName, boolean pRowNum)
           
static void appendSince(StringBuilder pBuilder, String pColName, com.semarchy.mdm.ws.admin.Unit pUnit, Integer pValue, boolean pAfter)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

ID_COL_NAME

public static final String ID_COL_NAME
See Also:
Constant Field Values
Constructor Detail

SQLQueryUtil

public SQLQueryUtil()
Method Detail

appendSelect

public static void appendSelect(StringBuilder pBuilder,
                                String[] pColNames,
                                String pTableName,
                                String pClassName,
                                boolean pRowNum)

appendOrderBy

public static void appendOrderBy(StringBuilder pBuilder,
                                 String pOrderBy)

appendRowLimit

public static void appendRowLimit(StringBuilder pBuilder,
                                  int pMaxRows,
                                  boolean pAfter)

appendRowLimit

public static void appendRowLimit(StringBuilder pBuilder,
                                  int pRow,
                                  int pMaxRows)

appendLikePattern

public static void appendLikePattern(StringBuilder pBuilder,
                                     String pColName,
                                     String pPattern)

appendEqualsPattern

public static void appendEqualsPattern(StringBuilder pBuilder,
                                       String pColName,
                                       String pValue)

appendIsNull

public static void appendIsNull(StringBuilder pBuilder,
                                String pColName)

appendIn

public static void appendIn(StringBuilder pBuilder,
                            String pColName,
                            Object[] pList)

appendSince

public static void appendSince(StringBuilder pBuilder,
                               String pColName,
                               com.semarchy.mdm.ws.admin.Unit pUnit,
                               Integer pValue,
                               boolean pAfter)


Copyright © 2015. All Rights Reserved.