I have 2 classes that implement a good portion of the Jdbc stuff that
I have been using pretty heavily over the last year for various
projects.
The implementation is:
SsDbUtils - A set of Static Functions that implement the JDBC calls
* Integer queryForInt(Connection conn, String sql, Object[] args)
Run a Query and return the 1st row, 1st Column as an Integer
* String queryForString(Connection conn, String sql, Object[] args)
Run a Query and Return the 1st row, 1st Column as a String
* Integer insertWithIntKey(Connection conn, String sql, Object[]
args, String[] keys)
Insert Statement that returns an Integer based Key
* boolean update(Connection conn, String sql, Object[] args)
Run an Update SQL with Args and return True or False
* List query(Connection conn, String sql, Object[] args, RowMapper map)
Run a SQL statement and Convert the ResultSet using the Given RowMapper
* List queryLimit(Connection conn, String sql, Object[] args,
RowMapper map, int iStart, int iCount)
Run a SQL Statement adding a Limit Clause or using a Cursor if
the Db doesn't support
Limits
RowMapper - A simple interface that has one required function mapRow
Does this sound like something that could be put in the DbUtils
library as another JDBC option? Is it something that would be useful
to others?
Thanks
--
Scott Carr
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@commons.apache.org
For additional commands, e-mail: dev-h...@commons.apache.org
