|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.qi4j.library.sql.datasource.Databases
public class Databases
Utility methods for performing SQL calls. Wraps a given DataSource.
Nested Class Summary | |
---|---|
static interface |
Databases.ResultSetVisitor
Visitor for the ResultSet. |
static interface |
Databases.StatementVisitor
Visitor for PreparedStatements. |
Constructor Summary | |
---|---|
Databases(DataSource source)
Create a new Databases wrapper for a given DataSource |
Method Summary | |
---|---|
Input<ResultSet,SQLException> |
query(String sql)
Perform SQL query and provide results as an Input. |
void |
query(String sql,
Databases.ResultSetVisitor visitor)
Perform SQL query and let visitor handle results. |
Input<ResultSet,SQLException> |
query(String sql,
Databases.StatementVisitor visitor)
Perform SQL query and provide results as an Input. |
void |
query(String sql,
Databases.StatementVisitor statement,
Databases.ResultSetVisitor resultsetVisitor)
Perform SQL query and let visitor handle results. |
int |
update(String sql)
Perform SQL update statement |
int |
update(String sql,
Databases.StatementVisitor visitor)
Perform SQL update statement. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public Databases(DataSource source)
source
- Method Detail |
---|
public int update(String sql) throws SQLException
sql
-
SQLException
public int update(String sql, Databases.StatementVisitor visitor) throws SQLException
sql
- visitor
-
SQLException
public void query(String sql, Databases.ResultSetVisitor visitor) throws SQLException
sql
- visitor
-
SQLException
public void query(String sql, Databases.StatementVisitor statement, Databases.ResultSetVisitor resultsetVisitor) throws SQLException
sql
- statement
- resultsetVisitor
-
SQLException
public Input<ResultSet,SQLException> query(String sql)
sql
-
public Input<ResultSet,SQLException> query(String sql, Databases.StatementVisitor visitor)
sql
-
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |