|
Awake SQL v1.2.1 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.awakefw.sql.api.util.SqlUtil
public class SqlUtil
Provides methods to get database product info & other utilities to format SQL statements.
Field Summary | |
---|---|
static String |
ADAPTIVE_SERVER_ENTERPRISE
Constant for defining Sybase Adaptive Server Enterprise product |
static String |
DB2
Constant for defining DB2 product |
static String |
H2
Constant for defining H2 |
static String |
HSQLDB
Constant for defining HyperSQL |
static String |
INFORMIX
Constant for defining Informix |
static String |
INGRES
Constant for defining INGRES |
static String |
MYSQL
Constant for defining MySQL product |
static String |
ORACLE
Constant for defining Oracle product |
static String |
POSTGRESQL
Constant for defining PostgreSQL product |
static String |
SQL_ANYWHERE
Constant for defining Sybase SQL Anywhere product |
static String |
SQL_SERVER
Constant for defining SQL Server product |
static String |
TERADATA
Constant for defining Teradata |
Constructor Summary | |
---|---|
SqlUtil(Connection connection)
Constructor. |
Method Summary | |
---|---|
String |
getDatabaseProductName()
Returns the database product name. |
boolean |
isAdaptiveServerEnterprise()
Returns true if the database engine is Adaptive Server Enterprise. |
boolean |
isDB2()
Returns true if the database engine is DB2. |
boolean |
isH2()
Returns true if the database engine is HSQLDB (HyperSQL Database). |
boolean |
isHSQLDB()
Returns true if the database engine is HSQLDB (HyperSQL Database). |
boolean |
isInformix()
Returns true if the database engine is Informix. |
boolean |
isIngres()
Returns true if the database engine is Ingres. |
boolean |
isMySQL()
Returns true if the database engine is MySQL. |
boolean |
isOracle()
Returns true if the database engine is Oracle Database. |
boolean |
isPostgreSQL()
Returns true if the database engine is PostgreSQL. |
boolean |
isSQLAnywhere()
Returns true if the database engine is SQL Anywhere. |
boolean |
isSQLServer()
Returns true if the database engine is SQL Server. |
boolean |
isTeradata()
Returns true if the database engine is SQL Server. |
static String |
listToSqlList(List<?> objects)
Transforms a List into a SQL 'IN(..., ...)' of objects separated
with commas. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final String ADAPTIVE_SERVER_ENTERPRISE
public static final String DB2
public static final String H2
public static final String HSQLDB
public static final String INFORMIX
public static final String INGRES
public static final String MYSQL
public static final String ORACLE
public static final String POSTGRESQL
public static final String SQL_ANYWHERE
public static final String SQL_SERVER
public static final String TERADATA
Constructor Detail |
---|
public SqlUtil(Connection connection) throws SQLException
connection
- the JDBC Connection
SQLException
Method Detail |
---|
public String getDatabaseProductName()
public boolean isAdaptiveServerEnterprise()
public boolean isDB2()
public boolean isH2()
public boolean isHSQLDB()
public boolean isInformix()
public boolean isIngres()
public boolean isMySQL()
public boolean isOracle()
public boolean isPostgreSQL()
public boolean isSQLAnywhere()
public boolean isSQLServer()
public boolean isTeradata()
public static String listToSqlList(List<?> objects)
'IN(..., ...)'
of objects separated
with commas.
objects
- the List of objects
'IN(..., ...)'
format.
|
Awake SQL v1.2.1 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |