|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--org.edg.data.util.SQLUtils
Useful methods for dealing with SQL
Field Summary | |
static java.lang.String |
VENDOR_MYSQL
|
static java.lang.String |
VENDOR_ORACLE
|
Constructor Summary | |
SQLUtils()
|
Method Summary | |
static void |
addColumn(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String columnName,
java.lang.String columnType,
java.lang.String vendor)
|
static void |
cleanup(java.sql.Connection rls)
|
static boolean |
columnExists(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String columnName,
java.lang.String vendor)
Does a given column exist in a given table ? |
static void |
deleteColumn(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String columnName,
java.lang.String vendor)
|
static java.util.List |
getColumnDefinitions(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String pattern,
java.lang.String vendor)
return a string[] which contains {name, type} pairs in order where the name matches the given pattern |
static java.util.List |
getColumnNames(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String pattern,
java.lang.String vendor)
return a string[] which contains column name in order where the name matches the given pattern |
static int |
getColumnSize(ConnectionFactory connFac,
java.lang.String tableName,
java.lang.String columnName)
|
static int |
getColumnSize(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String columnName)
|
static java.lang.String |
getTypeForColumn(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String columnName,
java.lang.String vendor)
|
static boolean |
isDuplicateMessage(java.sql.SQLException e)
check if the SQL Exception is because of unique key constraint violation |
static java.util.List |
queryFourParamThirdAndFourthIntReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2,
int param3,
int param4)
|
static boolean |
queryOneParamHasString(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param)
|
static java.sql.Date |
queryOneParamIntReturnDate(java.sql.Connection conn,
java.lang.String sql,
int param)
|
static float |
queryOneParamIntReturnFloat(java.sql.Connection conn,
java.lang.String sql,
int param)
|
static int |
queryOneParamIntReturnInt(java.sql.Connection conn,
java.lang.String sql,
int param)
|
static java.util.List |
queryOneParamIntReturnListStringArray(java.sql.Connection conn,
java.lang.String sql,
int param)
|
static java.lang.String |
queryOneParamIntReturnString(java.sql.Connection conn,
java.lang.String sql,
int param)
|
static java.util.List |
queryOneParamIntReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
int param)
|
static java.sql.Timestamp |
queryOneParamIntReturnTimestamp(java.sql.Connection conn,
java.lang.String sql,
int param)
|
static java.sql.Date |
queryOneParamReturnDate(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param)
|
static int |
queryOneParamReturnInt(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param)
|
static java.lang.String |
queryOneParamReturnString(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param)
|
static java.util.List |
queryOneParamReturnStringList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param)
|
static java.util.List |
queryOneParamReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param)
Execute query which returns a result set where the row is a pair of string. |
static int |
queryReturnInt(java.sql.Connection conn,
java.lang.String sql)
|
static java.lang.String |
queryReturnString(java.sql.Connection conn,
java.lang.String sql)
|
static java.util.List |
queryReturnStringList(java.sql.Connection conn,
java.lang.String sql)
|
static java.util.List |
queryReturnStringPairList(java.sql.Connection conn,
java.lang.String sql)
Execute query which returns a result set where the row is a pair of string. |
static java.util.List |
queryReturnThreeStringsList(java.sql.Connection conn,
java.lang.String sql)
|
static java.util.List |
queryReturnTwoStringsList(java.sql.Connection conn,
java.lang.String sql)
|
static java.lang.String |
queryThreeParamReturnString(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2,
java.lang.String param3)
|
static java.util.List |
queryThreeParamSecondAndThirdIntReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
int param2,
int param3)
Execute query which returns a result set where the row is a pair of string. |
static java.util.List |
queryThreeParamThirdIntReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2,
int param3)
|
static java.util.List |
queryTwoParamIntReturnListStringArray(java.sql.Connection conn,
java.lang.String sql,
int param1,
int param2)
|
static java.util.List |
queryTwoParamIntReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
int param1,
int param2)
|
static int |
queryTwoParamReturnInt(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2)
|
static java.lang.String |
queryTwoParamReturnString(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2)
|
static java.util.List |
queryTwoParamReturnStringList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2)
|
static java.util.List |
queryTwoParamReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2)
Execute query which returns a result set where the row is a pair of string. |
static java.util.List |
queryTwoParamSecondIntReturnStringPairList(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
int param2)
Execute query which returns a result set where the row is a pair of string. |
static void |
rollback(java.lang.String method,
java.sql.Connection conn)
|
static java.sql.Date |
singleDateValue(java.sql.ResultSet rs)
return the first col of the first row of a ResultSet |
static float |
singleFloatValue(java.sql.ResultSet rs)
return the first col of the first row of a ResultSet |
static int |
singleIntValue(java.sql.ResultSet rs)
return the first col of the first row of a ResultSet |
static java.sql.Timestamp |
singleTimestampValue(java.sql.ResultSet rs)
return the first col of the first row of a ResultSet |
static java.lang.String |
singleValue(java.sql.ResultSet rs)
return the first col of the first row of a ResultSet |
static int |
update(java.sql.Connection conn,
java.lang.String sql)
do an executeUpdate() with a statement having one
parameter |
static int |
updateManyParam(java.sql.Connection conn,
java.lang.String sql,
java.lang.String[] params)
|
static int |
updateOneParam(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param)
|
static int |
updateOneParamAndNullDate(java.sql.Connection conn,
java.lang.String sql,
int param2)
|
static int |
updateOneParamAndNullFloat(java.sql.Connection conn,
java.lang.String sql,
int param2)
|
static int |
updateOneParamAndNullInt(java.sql.Connection conn,
java.lang.String sql,
int param2)
|
static int |
updateOneParamAndNullString(java.sql.Connection conn,
java.lang.String sql,
int param2)
|
static int |
updateThreeParam(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2,
java.lang.String param3)
|
static int |
updateTwoParam(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
java.lang.String param2)
|
static int |
updateTwoParamFirstAndSecondInt(java.sql.Connection conn,
java.lang.String sql,
int param1,
int param2)
|
static int |
updateTwoParamFirstFloatAndSecondInt(java.sql.Connection conn,
java.lang.String sql,
float param1,
int param2)
|
static int |
updateTwoParamFirstInt(java.sql.Connection conn,
java.lang.String sql,
int param1,
java.lang.String param2)
|
static int |
updateTwoParamFirstTimestampAndSecondInt(java.sql.Connection conn,
java.lang.String sql,
java.sql.Timestamp param1,
int param2)
|
static int |
updateTwoParamSecondInt(java.sql.Connection conn,
java.lang.String sql,
java.lang.String param1,
int param2)
|
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 VENDOR_MYSQL
public static final java.lang.String VENDOR_ORACLE
Constructor Detail |
public SQLUtils()
Method Detail |
public static final int update(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
executeUpdate()
with a statement having one
parameter
conn
- the connection to usesql
- the string for the PreparedStatement
java.sql.SQLException
public static final int updateOneParam(java.sql.Connection conn, java.lang.String sql, java.lang.String param) throws java.sql.SQLException
java.sql.SQLException
public static final int updateTwoParam(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateTwoParamSecondInt(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateTwoParamFirstInt(java.sql.Connection conn, java.lang.String sql, int param1, java.lang.String param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateTwoParamFirstAndSecondInt(java.sql.Connection conn, java.lang.String sql, int param1, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateTwoParamFirstFloatAndSecondInt(java.sql.Connection conn, java.lang.String sql, float param1, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateTwoParamFirstTimestampAndSecondInt(java.sql.Connection conn, java.lang.String sql, java.sql.Timestamp param1, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateOneParamAndNullString(java.sql.Connection conn, java.lang.String sql, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateOneParamAndNullInt(java.sql.Connection conn, java.lang.String sql, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateOneParamAndNullFloat(java.sql.Connection conn, java.lang.String sql, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateOneParamAndNullDate(java.sql.Connection conn, java.lang.String sql, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final int updateThreeParam(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2, java.lang.String param3) throws java.sql.SQLException
java.sql.SQLException
public static final int updateManyParam(java.sql.Connection conn, java.lang.String sql, java.lang.String[] params) throws java.sql.SQLException
java.sql.SQLException
public static final java.lang.String queryReturnString(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public static final int queryReturnInt(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public static final java.lang.String queryOneParamReturnString(java.sql.Connection conn, java.lang.String sql, java.lang.String param) throws java.sql.SQLException
java.sql.SQLException
public static final java.lang.String queryOneParamIntReturnString(java.sql.Connection conn, java.lang.String sql, int param) throws java.sql.SQLException
java.sql.SQLException
public static final java.sql.Date queryOneParamReturnDate(java.sql.Connection conn, java.lang.String sql, java.lang.String param) throws java.sql.SQLException
java.sql.SQLException
public static final java.sql.Date queryOneParamIntReturnDate(java.sql.Connection conn, java.lang.String sql, int param) throws java.sql.SQLException
java.sql.SQLException
public static final java.sql.Timestamp queryOneParamIntReturnTimestamp(java.sql.Connection conn, java.lang.String sql, int param) throws java.sql.SQLException
java.sql.SQLException
public static final int queryOneParamIntReturnInt(java.sql.Connection conn, java.lang.String sql, int param) throws java.sql.SQLException
java.sql.SQLException
public static final float queryOneParamIntReturnFloat(java.sql.Connection conn, java.lang.String sql, int param) throws java.sql.SQLException
java.sql.SQLException
public static final java.lang.String queryTwoParamReturnString(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2) throws java.sql.SQLException
java.sql.SQLException
public static final java.lang.String queryThreeParamReturnString(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2, java.lang.String param3) throws java.sql.SQLException
java.sql.SQLException
public static final boolean queryOneParamHasString(java.sql.Connection conn, java.lang.String sql, java.lang.String param) throws java.sql.SQLException
java.sql.SQLException
public static final int queryOneParamReturnInt(java.sql.Connection conn, java.lang.String sql, java.lang.String param) throws java.sql.SQLException
java.sql.SQLException
public static int queryTwoParamReturnInt(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2) throws java.sql.SQLException
java.sql.SQLException
public static java.util.List queryReturnStringList(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public static java.util.List queryReturnTwoStringsList(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public static java.util.List queryReturnThreeStringsList(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
public static final java.util.List queryOneParamReturnStringList(java.sql.Connection conn, java.lang.String sql, java.lang.String param) throws java.sql.SQLException
java.sql.SQLException
public static final java.util.List queryTwoParamReturnStringList(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2) throws java.sql.SQLException
java.sql.SQLException
public static final java.util.List queryReturnStringPairList(java.sql.Connection conn, java.lang.String sql) throws java.sql.SQLException
conn
- the rls connectionsql
- the sql statement
java.sql.SQLException
public static final java.util.List queryOneParamReturnStringPairList(java.sql.Connection conn, java.lang.String sql, java.lang.String param) throws java.sql.SQLException
conn
- rls the rls connectionsql
- the sql statementparam
- a paran
java.sql.SQLException
public static final java.util.List queryOneParamIntReturnStringPairList(java.sql.Connection conn, java.lang.String sql, int param) throws java.sql.SQLException
java.sql.SQLException
public static java.util.List queryOneParamIntReturnListStringArray(java.sql.Connection conn, java.lang.String sql, int param) throws java.sql.SQLException
java.sql.SQLException
public static java.util.List queryTwoParamIntReturnListStringArray(java.sql.Connection conn, java.lang.String sql, int param1, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final java.util.List queryTwoParamReturnStringPairList(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2) throws java.sql.SQLException
conn
- the connectionsql
- the sql statementparam1
- a paramparam2
- another param
java.sql.SQLException
public static final java.util.List queryTwoParamIntReturnStringPairList(java.sql.Connection conn, java.lang.String sql, int param1, int param2) throws java.sql.SQLException
java.sql.SQLException
public static final java.util.List queryTwoParamSecondIntReturnStringPairList(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, int param2) throws java.sql.SQLException
conn
- the connectionsql
- the sql statementparam1
- a String paramparam2
- an int parameter
java.sql.SQLException
public static final java.util.List queryThreeParamSecondAndThirdIntReturnStringPairList(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, int param2, int param3) throws java.sql.SQLException
conn
- the connectionsql
- the sql statementparam1
- a String paramparam2
- an int parameterparam3
- another int param
java.sql.SQLException
public static final java.util.List queryThreeParamThirdIntReturnStringPairList(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2, int param3) throws java.sql.SQLException
java.sql.SQLException
public static final java.util.List queryFourParamThirdAndFourthIntReturnStringPairList(java.sql.Connection conn, java.lang.String sql, java.lang.String param1, java.lang.String param2, int param3, int param4) throws java.sql.SQLException
java.sql.SQLException
public static final int getColumnSize(ConnectionFactory connFac, java.lang.String tableName, java.lang.String columnName) throws java.sql.SQLException
java.sql.SQLException
public static final int getColumnSize(java.sql.Connection conn, java.lang.String tableName, java.lang.String columnName) throws java.sql.SQLException
java.sql.SQLException
public static final boolean columnExists(java.sql.Connection conn, java.lang.String tableName, java.lang.String columnName, java.lang.String vendor) throws java.sql.SQLException
conn
- tableName
- columnName
- vendor
-
true
if the column exists
java.sql.SQLException
public static final java.lang.String getTypeForColumn(java.sql.Connection conn, java.lang.String tableName, java.lang.String columnName, java.lang.String vendor) throws java.sql.SQLException
java.sql.SQLException
public static final java.util.List getColumnDefinitions(java.sql.Connection conn, java.lang.String tableName, java.lang.String pattern, java.lang.String vendor) throws java.sql.SQLException
conn
- the underlying connectiontableName
- name of the table to look inpattern
- the pattern for the columnsvendor
- the db vendor
java.sql.SQLException
- If a problem occurs with the DBpublic static final java.util.List getColumnNames(java.sql.Connection conn, java.lang.String tableName, java.lang.String pattern, java.lang.String vendor) throws java.sql.SQLException
conn
- the underlying connectiontableName
- name of the table to look inpattern
- the pattern for the columnsvendor
- the db vendor
java.sql.SQLException
- If a problem occurs with the DBpublic static final void addColumn(java.sql.Connection conn, java.lang.String tableName, java.lang.String columnName, java.lang.String columnType, java.lang.String vendor) throws java.sql.SQLException
java.sql.SQLException
public static final void deleteColumn(java.sql.Connection conn, java.lang.String tableName, java.lang.String columnName, java.lang.String vendor) throws java.sql.SQLException
java.sql.SQLException
public static final java.lang.String singleValue(java.sql.ResultSet rs) throws java.sql.SQLException
ResultSet
java.sql.SQLException
public static final int singleIntValue(java.sql.ResultSet rs) throws java.sql.SQLException
ResultSet
java.sql.SQLException
public static final float singleFloatValue(java.sql.ResultSet rs) throws java.sql.SQLException
ResultSet
java.sql.SQLException
public static final java.sql.Date singleDateValue(java.sql.ResultSet rs) throws java.sql.SQLException
ResultSet
java.sql.SQLException
public static final java.sql.Timestamp singleTimestampValue(java.sql.ResultSet rs) throws java.sql.SQLException
ResultSet
java.sql.SQLException
public static final boolean isDuplicateMessage(java.sql.SQLException e)
e
- the exception
true
if it is.public static void cleanup(java.sql.Connection rls)
public static void rollback(java.lang.String method, java.sql.Connection conn)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |