public class GenericSQLModifier
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
mySqlLikeOverride |
Constructor and Description |
---|
GenericSQLModifier(java.sql.Connection connection) |
GenericSQLModifier(java.sql.Connection connection,
boolean sqlLite) |
GenericSQLModifier(java.lang.String databaseType,
boolean sqlLite) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getDatabaseType() |
static void |
main(java.lang.String[] args) |
java.lang.String |
modifySQL(java.lang.String sql) |
java.lang.String |
modifySQL(java.lang.String sql,
boolean logResult) |
boolean |
requiresLikeQueryTextToBeUpperCased() |
public GenericSQLModifier(java.sql.Connection connection, boolean sqlLite) throws java.lang.Exception
connection
- the connectionsqlLite
- true if connection is SQLLite, false if SQLjava.lang.Exception
public GenericSQLModifier(java.sql.Connection connection) throws java.lang.Exception
connection
- the connectionjava.lang.Exception
public GenericSQLModifier(java.lang.String databaseType, boolean sqlLite) throws java.lang.Exception
databaseType
- may be "MySQL", "ACCESS", "PostgreSQL", "DB2*",
"Microsoft SQL Server", "HSQL Database Engine"sqlLite
- if true, database is SQLLite, if false database is SQLjava.lang.Exception
public java.lang.String getDatabaseType()
public java.lang.String modifySQL(java.lang.String sql, boolean logResult)
sql
- logResult
- log result if truepublic java.lang.String modifySQL(java.lang.String sql)
public boolean requiresLikeQueryTextToBeUpperCased()
public static void main(java.lang.String[] args) throws java.lang.Exception
java.lang.Exception