Liferay 6.2-ce-ga5

com.liferay.util.dao.orm
Class CustomSQLUtil

java.lang.Object
  extended by 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)

Liferay 6.2-ce-ga5