Posted on 2009-11-30 04:46
leekiang 阅读(1514)
评论(0) 编辑 收藏 所属分类:
spring 、
jdbc、事务、并发
1，基本用法
http://blog.163.com/fxf_java/blog/static/59268637200822833715185/
2,JdbcTemplate的连接
http://www.javaeye.com/topic/89845
http://forum.springsource.org/showthread.php?t=63444
3,ConnectionCallback
http://blog.csdn.net/lin49940/archive/2009/10/22/4712883.aspx
public interface ConnectionCallback
Generic callback interface for code that operates on a JDBC Connection.
Allows to execute any number of operations on a single Connection,
using any type and number of Statements.
This is particularly useful for delegating to existing data access code
that expects a Connection to work on and throws SQLException. For newly
written code, it is strongly recommended to use JdbcTemplate's more specific
operations, for example a query or updat variant.
doInConnection
ObjectdoInConnection(Connection con)
throws SQLException,
DataAccessException
- Gets called by
JdbcTemplate.execute with an active JDBC
Connection. Does not need to care about activating or closing the
Connection, or handling transactions.
If called without a thread-bound JDBC transaction (initiated by
DataSourceTransactionManager), the code will simply get executed on the
JDBC connection with its transactional semantics. If JdbcTemplate is
configured to use a JTA-aware DataSource, the JDBC Connection and thus
the callback code will be transactional if a JTA transaction is active.
Allows for returning a result object created within the callback, i.e.
a domain object or a collection of domain objects. Note that there's special
support for single step actions: see JdbcTemplate.queryForObject
etc. A thrown RuntimeException is treated as application exception:
it gets propagated to the caller of the template.
- Parameters:
con - active JDBC Connection
- Returns:
- a result object, or
null if none
- Throws:
SQLException - if thrown by a JDBC method, to be auto-converted
to a DataAccessException by a SQLExceptionTranslator
DataAccessException - in case of custom exceptions- See Also:
JdbcTemplate.queryForObject(String, Class),
JdbcTemplate.queryForRowSet(String)
2,