|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectcom.liferay.util.dao.orm.CustomSQL
public class CustomSQL
| Field Summary | |
|---|---|
static java.lang.String |
DB2_FUNCTION_IS_NOT_NULL
|
static java.lang.String |
DB2_FUNCTION_IS_NULL
|
static java.lang.String |
INFORMIX_FUNCTION_IS_NOT_NULL
|
static java.lang.String |
INFORMIX_FUNCTION_IS_NULL
|
static java.lang.String |
MYSQL_FUNCTION_IS_NOT_NULL
|
static java.lang.String |
MYSQL_FUNCTION_IS_NULL
|
static java.lang.String |
SYBASE_FUNCTION_IS_NOT_NULL
|
static java.lang.String |
SYBASE_FUNCTION_IS_NULL
|
| Constructor Summary | |
|---|---|
CustomSQL()
|
|
| Method Summary | |
|---|---|
java.lang.String |
appendCriteria(java.lang.String sql,
java.lang.String criteria)
|
java.lang.String |
get(java.lang.String id)
|
protected java.lang.String[] |
getConfigs()
|
boolean |
isVendorDB2()
Returns true if Hibernate is connecting to a DB2 database. |
boolean |
isVendorInformix()
Returns true if Hibernate is connecting to an Informix
database. |
boolean |
isVendorMySQL()
Returns true if Hibernate is connecting to a MySQL database. |
boolean |
isVendorOracle()
Returns true if Hibernate is connecting to an Oracle
database. |
boolean |
isVendorPostgreSQL()
Returns true if Hibernate is connecting to a PostgreSQL
database. |
boolean |
isVendorSybase()
Returns true if Hibernate is connecting to a Sybase
database. |
java.lang.String[] |
keywords(java.lang.String keywords)
|
java.lang.String[] |
keywords(java.lang.String[] keywordsArray)
|
java.lang.String[] |
keywords(java.lang.String[] keywordsArray,
boolean lowerCase)
|
java.lang.String[] |
keywords(java.lang.String keywords,
boolean lowerCase)
|
protected void |
read(java.lang.ClassLoader classLoader,
java.lang.String source)
|
void |
reloadCustomSQL()
|
java.lang.String |
removeGroupBy(java.lang.String sql)
|
java.lang.String |
removeOrderBy(java.lang.String sql)
|
java.lang.String |
replaceAndOperator(java.lang.String sql,
boolean andOperator)
|
java.lang.String |
replaceGroupBy(java.lang.String sql,
java.lang.String groupBy)
|
java.lang.String |
replaceIsNull(java.lang.String sql)
|
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values)
|
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values)
|
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
java.lang.String operator,
boolean last,
java.lang.String[] values)
|
java.lang.String |
replaceOrderBy(java.lang.String sql,
com.liferay.portal.kernel.util.OrderByComparator obc)
|
protected java.lang.String |
transform(java.lang.String sql)
|
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
|---|
public static final java.lang.String DB2_FUNCTION_IS_NOT_NULL
public static final java.lang.String DB2_FUNCTION_IS_NULL
public static final java.lang.String INFORMIX_FUNCTION_IS_NOT_NULL
public static final java.lang.String INFORMIX_FUNCTION_IS_NULL
public static final java.lang.String MYSQL_FUNCTION_IS_NOT_NULL
public static final java.lang.String MYSQL_FUNCTION_IS_NULL
public static final java.lang.String SYBASE_FUNCTION_IS_NOT_NULL
public static final java.lang.String SYBASE_FUNCTION_IS_NULL
| Constructor Detail |
|---|
public CustomSQL()
throws java.sql.SQLException
java.sql.SQLException| Method Detail |
|---|
public java.lang.String appendCriteria(java.lang.String sql,
java.lang.String criteria)
public java.lang.String get(java.lang.String id)
public boolean isVendorDB2()
true if Hibernate is connecting to a DB2 database.
true if Hibernate is connecting to a DB2 databasepublic boolean isVendorInformix()
true if Hibernate is connecting to an Informix
database.
true if Hibernate is connecting to an Informix
databasepublic boolean isVendorMySQL()
true if Hibernate is connecting to a MySQL database.
true if Hibernate is connecting to a MySQL databasepublic boolean isVendorOracle()
true if Hibernate is connecting to an Oracle
database. Oracle has a nasty bug where it treats '' as a
NULL value. See
http://thedailywtf.com/forums/thread/26879.aspx for more information on
this nasty bug.
true if Hibernate is connecting to an Oracle
databasepublic boolean isVendorPostgreSQL()
true if Hibernate is connecting to a PostgreSQL
database.
true if Hibernate is connecting to a PostgreSQL
databasepublic boolean isVendorSybase()
true if Hibernate is connecting to a Sybase
database.
true if Hibernate is connecting to a Sybase databasepublic java.lang.String[] keywords(java.lang.String keywords)
public java.lang.String[] keywords(java.lang.String keywords,
boolean lowerCase)
public java.lang.String[] keywords(java.lang.String[] keywordsArray)
public java.lang.String[] keywords(java.lang.String[] keywordsArray,
boolean lowerCase)
public void reloadCustomSQL()
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.lang.String removeGroupBy(java.lang.String sql)
public java.lang.String removeOrderBy(java.lang.String sql)
public java.lang.String replaceAndOperator(java.lang.String sql,
boolean andOperator)
public java.lang.String replaceGroupBy(java.lang.String sql,
java.lang.String groupBy)
public java.lang.String replaceIsNull(java.lang.String sql)
public java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values)
public java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values)
public java.lang.String replaceKeywords(java.lang.String sql,
java.lang.String field,
java.lang.String operator,
boolean last,
java.lang.String[] values)
public java.lang.String replaceOrderBy(java.lang.String sql,
com.liferay.portal.kernel.util.OrderByComparator obc)
protected java.lang.String[] getConfigs()
protected void read(java.lang.ClassLoader classLoader,
java.lang.String source)
throws java.lang.Exception
java.lang.Exceptionprotected java.lang.String transform(java.lang.String sql)
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||