public static class DBBind.Functions
extends java.lang.Object
Aliases for common SQL functions in different database dialects.
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
CHR
Get character from ASCII code
CHAR([0..255])
|
static java.lang.String |
CONCAT
String concatenation
Str1 CONCAT Str2
|
static java.lang.String |
GETDATE
Get System Date
|
static int |
iDBMS |
static java.lang.String |
ILIKE
Case-insensitve LIKE operator (PostgreSQL only)
|
static java.lang.String |
ISNULL
ISNULL(value, default)
Get value or default if value is null
|
static java.lang.String |
LENGTH
Get string length
LENGTH(str)
|
static java.lang.String |
LOWER
Transform String to lowercase
LOWER(str)
|
static java.lang.String |
UPPER
Transform String to uppercase
UPPER(str)
|
Constructor and Description |
---|
DBBind.Functions() |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
strCat(java.lang.String[] aExpressions,
char cPlaceBetween)
Create a SQL expressions which concatenates the given ones
|
static java.lang.String |
toChar(java.lang.Object oData,
int iLength)
Cast into CHARACTER VARYING SQL TYPE
|
public static java.lang.String ISNULL
ISNULL(value, default)
Get value or default if value is nullpublic static java.lang.String CONCAT
String concatenation
Str1 CONCAT Str2public static java.lang.String GETDATE
public static java.lang.String LOWER
Transform String to lowercase
LOWER(str)public static java.lang.String UPPER
Transform String to uppercase
UPPER(str)public static java.lang.String LENGTH
Get string length
LENGTH(str)public static java.lang.String CHR
Get character from ASCII code
CHAR([0..255])public static java.lang.String ILIKE
Case-insensitve LIKE operator (PostgreSQL only)
public static int iDBMS
public static java.lang.String toChar(java.lang.Object oData, int iLength) throws java.lang.UnsupportedOperationException
oData
- Object of any typeiLength
- Maximum length of character data
return java.lang.UnsupportedOperationException
public static java.lang.String strCat(java.lang.String[] aExpressions, char cPlaceBetween)