我应该先关闭哪个，PreparedStatement 还是 Connection?

2022-01-24 00:00:00 connection prepared-statement jdbc java

在 JDBC 中使用 PreparedStatement 时，我应该先关闭 PreparedStatement 还是先关闭 Connection?我刚刚看到一个代码示例，其中首先关闭了 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.

是否有标准的、可接受的方式来执行此操作?有关系吗?关闭 Connection 是否也会导致 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?

推荐答案

声明.我希望你关闭(按顺序)

The statement. I would expect you to close (in order)

  1. 结果集
  2. 声明
  3. 连接

(并一路检查空值！)

即以反向顺序关闭.

如果你使用 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().

相关文章