com.liferay.util.dao.orm
Class CustomSQLUtil

java.lang.Object
  com.liferay.util.dao.orm.CustomSQLUtil

public class CustomSQLUtil
extends Object

Method Summary

static String	appendCriteria(String sql, String criteria)
static String	get(String id)
static String	get(String id, QueryDefinition queryDefinition)
static String	get(String id, QueryDefinition queryDefinition, String tableName)
static boolean	isVendorDB2()
static boolean	isVendorHSQL()
static boolean	isVendorInformix()
static boolean	isVendorMySQL()
static boolean	isVendorOracle()
static boolean	isVendorSybase()
static String[]	keywords(String keywords)
static String[]	keywords(String[] keywordsArray)
static String[]	keywords(String[] keywordsArray, boolean lowerCase)
static String[]	keywords(String keywords, boolean lowerCase)
static void	reloadCustomSQL()
static String	removeGroupBy(String sql)
static String	removeOrderBy(String sql)
static String	replaceAndOperator(String sql, boolean andOperator)
static String	replaceGroupBy(String sql, String groupBy)
static String	replaceIsNull(String sql)
static String	replaceKeywords(String sql, String field, boolean last, int[] values)
static String	replaceKeywords(String sql, String field, boolean last, long[] values)
static String	replaceKeywords(String sql, String field, String operator, boolean last, String[] values)
static String	replaceOrderBy(String sql, OrderByComparator obc)

Methods inherited from class java.lang.Object

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

Method Detail

appendCriteria

public static String appendCriteria(String sql,
                                    String criteria)

get

public static String get(String id)

get

public static String get(String id,
                         QueryDefinition queryDefinition)

get

public static String get(String id,
                         QueryDefinition queryDefinition,
                         String tableName)

isVendorDB2

public static boolean isVendorDB2()

isVendorHSQL

public static boolean isVendorHSQL()

isVendorInformix

public static boolean isVendorInformix()

isVendorMySQL

public static boolean isVendorMySQL()

isVendorOracle

public static boolean isVendorOracle()

isVendorSybase

public static boolean isVendorSybase()

keywords

public static String[] keywords(String keywords)

keywords

public static String[] keywords(String keywords,
                                boolean lowerCase)

keywords

public static String[] keywords(String[] keywordsArray)

keywords

public static String[] keywords(String[] keywordsArray,
                                boolean lowerCase)

reloadCustomSQL

public static void reloadCustomSQL()
                            throws SQLException

Throws:

SQLException

removeGroupBy

public static String removeGroupBy(String sql)

removeOrderBy

public static String removeOrderBy(String sql)

replaceAndOperator

public static String replaceAndOperator(String sql,
                                        boolean andOperator)

replaceGroupBy

public static String replaceGroupBy(String sql,
                                    String groupBy)

replaceIsNull

public static String replaceIsNull(String sql)

replaceKeywords

public static String replaceKeywords(String sql,
                                     String field,
                                     boolean last,
                                     int[] values)

replaceKeywords

public static String replaceKeywords(String sql,
                                     String field,
                                     boolean last,
                                     long[] values)

replaceKeywords

public static String replaceKeywords(String sql,
                                     String field,
                                     String operator,
                                     boolean last,
                                     String[] values)

replaceOrderBy

public static String replaceOrderBy(String sql,
                                    OrderByComparator obc)