|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.eclipse.datatools.sqltools.sql.util.SQLUtil
public class SQLUtil
Contains various SQL processing utilities.
Field Summary | |
---|---|
static java.util.regex.Pattern |
ID_PATTERN
|
static int |
MATCHING_DOUBLE_QUOTES
|
static int |
MATCHING_SINGLE_QUOTES
|
static int |
MAX_NAME_LENGTH_FOR_MESSAGE_DIALOGS
|
static int |
NO_MATCHING_QUOTES
|
static int |
NO_QUOTES
|
static java.util.regex.Pattern |
STRING_PATTERN
|
Constructor Summary | |
---|---|
SQLUtil()
|
Method Summary | |
---|---|
static int |
convert2SQLType(java.lang.String datatype)
|
static java.lang.String |
describeSQL(java.lang.String sql,
int length)
Describe the sql string by truncating the characters after length-3 and appending ellipses if it's longer than length . |
static boolean |
equalsIgnoreQuote(java.lang.String s1,
java.lang.String s2,
boolean caseSensitive)
Returns whether the 2 Strings are equal by ignoring the surrounding quotes |
static int |
findQuotes(java.lang.String content)
|
static java.lang.String[] |
getAvaiableCurrencySymbols()
Returns all the currency symbols |
static boolean |
isBinaryType(IDatatype datatype)
|
static boolean |
isBinaryType(java.lang.String datatype)
|
static boolean |
isNumericType(IDatatype datatype)
|
static boolean |
isNumericType(int datatype)
|
static boolean |
isNumericType(java.lang.String datatype)
|
static boolean |
isStringType(IDatatype datatype)
|
static boolean |
isStringType(int sqlType)
|
static boolean |
isStringType(java.lang.String datatype)
|
static java.lang.String[] |
parseDatabaseObject(java.lang.String objstr)
"objstr" is a string representing a database object. |
static java.lang.String |
quote(java.lang.String in,
char quoteChar)
Surrounds the input string with quoteChar and doubles every quoteChar inside the string. |
static java.lang.String |
quote(java.lang.String content,
java.lang.String quoteMark)
surround content with quoteMark and double every quoteMark inside content |
static java.lang.String[] |
splitDotStr(java.lang.String input)
|
static java.lang.String |
toHexString(byte[] bytes)
|
static java.lang.String |
unquote(java.lang.String quoted)
Removes the surrounding quotation mark (' or ") and restores 2 successive quotation marks to 1. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final int NO_QUOTES
public static final int MATCHING_SINGLE_QUOTES
public static final int MATCHING_DOUBLE_QUOTES
public static final int NO_MATCHING_QUOTES
public static final java.util.regex.Pattern ID_PATTERN
public static final java.util.regex.Pattern STRING_PATTERN
public static int MAX_NAME_LENGTH_FOR_MESSAGE_DIALOGS
Constructor Detail |
---|
public SQLUtil()
Method Detail |
---|
public static java.lang.String[] parseDatabaseObject(java.lang.String objstr)
objstr
- a string identifying a database object.
public static int findQuotes(java.lang.String content)
public static java.lang.String quote(java.lang.String in, char quoteChar)
in
- the input stringquoteChar
- quotation character, usually it's ' or "
public static java.lang.String quote(java.lang.String content, java.lang.String quoteMark)
content
- quoteMark
-
public static java.lang.String unquote(java.lang.String quoted)
quoted
- quoted string
public static java.lang.String describeSQL(java.lang.String sql, int length)
length-3
and appending ellipses if it's longer than length
.
sql
- length
-
public static final java.lang.String toHexString(byte[] bytes)
bytes
- The array of bytes to convert to ASCII hex form.
public static java.lang.String[] splitDotStr(java.lang.String input)
public static java.lang.String[] getAvaiableCurrencySymbols()
public static boolean equalsIgnoreQuote(java.lang.String s1, java.lang.String s2, boolean caseSensitive)
s1
- s2
- caseSensitive
- whether to consider case
public static boolean isBinaryType(IDatatype datatype)
public static boolean isBinaryType(java.lang.String datatype)
public static boolean isNumericType(java.lang.String datatype)
public static int convert2SQLType(java.lang.String datatype)
public static boolean isNumericType(int datatype)
public static boolean isNumericType(IDatatype datatype)
public static boolean isStringType(java.lang.String datatype)
public static boolean isStringType(IDatatype datatype)
public static boolean isStringType(int sqlType)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |