我应该先关闭,PreparedStatement还是Connection? [英] Which should I close first, the PreparedStatement or the Connection?
问题描述
在JDBC中使用 PreparedStatement
时,应先关闭 PreparedStatement
,还是关闭连接
先?我只是看到一个代码示例,其中 Connection
首先关闭,但似乎更合乎逻辑的关闭 PreparedStatement
第一。
When using a PreparedStatement
in JDBC, should I close the PreparedStatement
first or the Connection
first? I just saw a code sample in which the Connection
is closed first, but it seems to me more logical to close the PreparedStatement
first.
有没有标准的,可接受的方法来做到这一点?有关系吗?关闭连接
也会导致 PreparedStatement
关闭,因为 PreparedStatement
与 Connection
对象直接相关?
Is there a standard, accepted way to do this? Does it matter? Does closing the Connection
also cause the PreparedStatement
to be closed, since the PreparedStatement
is directly related to the Connection
object?
推荐答案
该声明。
- 结果集
- li>
- 连接
(沿途检查空值!)
ie
如果您使用Spring JdbcTemplate (或类似的)或者,您可以使用 Apache Commons DbUtils 和 DbUtils.close()
或 DbUtils.closeQuietly()
。
If you use Spring JdbcTemplate (or similar) then that will look after this for you. Alternatively you can use Apache Commons DbUtils and DbUtils.close()
or DbUtils.closeQuietly()
.
这篇关于我应该先关闭,PreparedStatement还是Connection?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!