java 多次查询数据库_java – 多次查询数据库的首选方式？

是的,您可以重用Statement对象,但executeQuery返回的ResultSet对象已关闭已打开的结果集.

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.

所以发生以下情况：

// load driver

Connection con = DriverManager.getConnection(..);

Statement stmt = con.createStatement();

ResultSet result = stmt.executeQuery("select ..");

// do something with result ... or not

ResultSet result2 = stmt.executeQuery("select ...");

// result is now closed, you cannot read from it anymore

// do something with result2

stmt.close(); // will close the resultset bound to it

protected void initialize() throws SQLException {

updateCount = -1;

resultQueue.clear();

genKeyResultSet = null;

tds.clearResponseQueue();

// FIXME Should old exceptions found now be thrown instead of lost?

messages.exceptions = null;

messages.clearWarnings();

closeAllResultSets();

}