|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface SQLHandler
Method Summary | |
---|---|
void |
executeQuery(String sql)
Executes the given query. |
int |
executeUpdate(String sql)
Executes the given statement. |
int |
executeUpdateAndCommit(String sql)
Executes the given statement and commits. |
boolean |
exists(String sql)
Returns true if the query returned a record. |
DataSource |
getDataSource()
|
long |
getItemAsLong(String sql)
Returns the long extracted from the result of the given query. |
String |
getItemAsString(String sql)
Returns the value extracted from the result of the given query. |
Set<String> |
getItemsAsStringSet(String sql)
Returns the items extracted from the result of the given query. |
boolean |
isDoExecuteUpdates()
|
Method Detail |
---|
int executeUpdate(String sql)
sql
- The sql statement
void executeQuery(String sql)
sql
- The sql queryint executeUpdateAndCommit(String sql)
sql
- The sql statement
long getItemAsLong(String sql)
UnitilsException
is thrown.
sql
- The sql string for retrieving the items
String getItemAsString(String sql)
UnitilsException
is thrown.
sql
- The sql string for retrieving the items
Set<String> getItemsAsStringSet(String sql)
sql
- The sql string for retrieving the items
boolean exists(String sql)
sql
- The sql string for checking the existence
DataSource getDataSource()
boolean isDoExecuteUpdates()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |