com.semarchy.mdm.runtime.admin.util
Class SQLQueryUtil
java.lang.Object
com.semarchy.mdm.runtime.admin.util.SQLQueryUtil
public class SQLQueryUtil
- extends Object
FIXME currently oracle request only update this to support postgres
- Author:
- amergey
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 |
ID_COL_NAME
public static final String ID_COL_NAME
- See Also:
- Constant Field Values
SQLQueryUtil
public SQLQueryUtil()
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.