resultset 代码复用

最新推荐文章于 2021-03-15 11:57:53 发布

weixin_33762321

最新推荐文章于 2021-03-15 11:57:53 发布

阅读量220

点赞数

文章标签： python

原文链接：https://my.oschina.net/u/2308739/blog/815722

版权

2019独角兽企业重金招聘Python工程师标准>>>

http://stackoverflow.com/questions/17609375/does-reusing-a-statement-and-resultset-release-resources-from-its-previous-usage

the Statement API says:

By default, only one ResultSet object per Statement object can be open at the same time. Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects. All execution methods in the Statement interface implicitly close a statment's current ResultSet object if an open one exists.

resultset 代码复用：

        prmstatmenttimestamp.setInt(1, mod_t);
                    rstimestamp=prmstatmenttimestamp.executeQuery();
                    rstimestamp.next();
                    String mod_tsting=rstimestamp.getString(1);
                    prmstatmenttimestamp.setInt(1, xvcmodt);
                    rstimestamp=prmstatmenttimestamp.executeQuery();
                    rstimestamp.next();

代码会提示：Resource leak: 'rstimestamp' is not closed at this location

其实参考上面的说明可知，only one ResultSet object per Statement object。所以对于如果想复用statement 可以考虑：

转载于:https://my.oschina.net/u/2308739/blog/815722