com.liferay.util.dao.orm
Class CustomSQLUtil
java.lang.Object
com.liferay.util.dao.orm.CustomSQLUtil
public class CustomSQLUtil
- extends java.lang.Object
- Author:
- Brian Wing Shun Chan, Bruno Farache, Raymond Augé
|
Method Summary |
static java.lang.String |
appendCriteria(java.lang.String sql,
java.lang.String criteria)
|
static java.lang.String |
get(java.lang.String id)
|
static boolean |
isVendorDB2()
|
static boolean |
isVendorInformix()
|
static boolean |
isVendorMySQL()
|
static boolean |
isVendorOracle()
|
static boolean |
isVendorSybase()
|
static java.lang.String[] |
keywords(java.lang.String keywords)
|
static java.lang.String[] |
keywords(java.lang.String[] keywordsArray)
|
static java.lang.String[] |
keywords(java.lang.String[] keywordsArray,
boolean lowerCase)
|
static java.lang.String[] |
keywords(java.lang.String keywords,
boolean lowerCase)
|
static void |
reloadCustomSQL()
|
static java.lang.String |
removeGroupBy(java.lang.String sql)
|
static java.lang.String |
removeOrderBy(java.lang.String sql)
|
static java.lang.String |
replaceAndOperator(java.lang.String sql,
boolean andOperator)
|
static java.lang.String |
replaceGroupBy(java.lang.String sql,
java.lang.String groupBy)
|
static java.lang.String |
replaceIsNull(java.lang.String sql)
|
static java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values)
|
static java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values)
|
static java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
java.lang.String operator,
boolean last,
java.lang.String[] values)
|
static java.lang.String |
replaceOrderBy(java.lang.String sql,
com.liferay.portal.kernel.util.OrderByComparator obc)
|
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
appendCriteria
public static java.lang.String appendCriteria(java.lang.String sql,
java.lang.String criteria)
get
public static java.lang.String get(java.lang.String id)
isVendorDB2
public static boolean isVendorDB2()
isVendorInformix
public static boolean isVendorInformix()
isVendorMySQL
public static boolean isVendorMySQL()
isVendorOracle
public static boolean isVendorOracle()
isVendorSybase
public static boolean isVendorSybase()
keywords
public static java.lang.String[] keywords(java.lang.String keywords)
keywords
public static java.lang.String[] keywords(java.lang.String keywords,
boolean lowerCase)
keywords
public static java.lang.String[] keywords(java.lang.String[] keywordsArray)
keywords
public static java.lang.String[] keywords(java.lang.String[] keywordsArray,
boolean lowerCase)
reloadCustomSQL
public static void reloadCustomSQL()
throws java.sql.SQLException
- Throws:
java.sql.SQLException
removeGroupBy
public static java.lang.String removeGroupBy(java.lang.String sql)
removeOrderBy
public static java.lang.String removeOrderBy(java.lang.String sql)
replaceAndOperator
public static java.lang.String replaceAndOperator(java.lang.String sql,
boolean andOperator)
replaceGroupBy
public static java.lang.String replaceGroupBy(java.lang.String sql,
java.lang.String groupBy)
replaceIsNull
public static java.lang.String replaceIsNull(java.lang.String sql)
replaceKeywords
public static java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values)
replaceKeywords
public static java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values)
replaceKeywords
public static java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
java.lang.String operator,
boolean last,
java.lang.String[] values)
replaceOrderBy
public static java.lang.String replaceOrderBy(java.lang.String sql,
com.liferay.portal.kernel.util.OrderByComparator obc)