java resultset close_java resultset close before opearate问题

一个statement可以开多个resultset，如果statement是单例情况，而多个resultset中间有交叉。

例如：

public List getHotelList2() {

List hotelList = new ArrayList();

String sql = "SELECT distinct(fetch_id) fetch_id,hotel_id FROM pl_hotel_comments WHERE cow='elong'"; //去掉重复

Statement stmt = null;

ResultSet rs = null;

try {

stmt = Db.getNewStatement(); //防止rs交叉引用出错，这里新开一个statement

rs = stmt.executeQuery(sql);

if(rs != null) {

while(rs.next()) {

Hotel hotel = new Hotel();

hotel.setFetch_id(rs.getString("fetch_id"));

String hotelId = rs.getString("hotel_id");

hotel.setHotel_id(hotelId);

hotel.setImageidList(hotel.getHotelImageidList(hotelId)); //防止rs交叉引用出错

hotelList.add(hotel);

}

}

} catch (SQLException e) {

e.printStackTrace();

} finally {

Db.close();

}

return hotelList;

}

/**

* 获取image列表

* @return

*/

public List getHotelImageidList(String hotelId) {

List imageidList = new ArrayList();

String sql = "SELECT id FROM pl_hotel_images WHERE hotel_id=" + hotelId;

Statement stmt = null;

ResultSet rs = null;

try {

stmt = Db.getNewStatement();

rs = stmt.executeQuery(sql);

if(rs != null) {

while(rs.next()) {

imageidList.add(rs.getString("id"));

}

}

} catch (SQLException e) {

e.printStackTrace();

}

return imageidList;

}

这个查询中要调用另一个方法getHotelImageidList。而另一个方法也要开一个resultset。如果两个是同一个statement，那么就会出现该情况报错。

ps：resultset会随着statement关闭而关闭。可以不手工关闭