java中的resultset,在Java中处理ResultSet的有效方法

I'm using a ResultSet in Java, and am not sure how to properly close it. I'm considering using the ResultSet to construct a HashMap and then closing the ResultSet after that. Is this HashMap technique efficient, or are there more efficient ways of handling this situation? I need both keys and values, so using a HashMap seemed like a logical choice.

If using a HashMap is the most efficient method, how do I construct and use the HashMap in my code?

Here's what I've tried:

public HashMap resultSetToHashMap(ResultSet rs) throws SQLException {

ResultSetMetaData md = rs.getMetaData();

int columns = md.getColumnCount();

HashMap row = new HashMap();

while (rs.next()) {

for (int i = 1; i <= columns; i++) {

row.put(md.getColumnName(i), rs.getObject(i));

}

}

return row;

}

解决方案

Iterate over the ResultSet

Create a new Object for each row, to store the fields you need

Add this new object to ArrayList or Hashmap or whatever you fancy

Close the ResultSet, Statement and the DB connection

Done

EDIT: now that you have posted code, I have made a few changes to it.

public List resultSetToArrayList(ResultSet rs) throws SQLException{

ResultSetMetaData md = rs.getMetaData();

int columns = md.getColumnCount();

ArrayList list = new ArrayList(50);

while (rs.next()){

HashMap row = new HashMap(columns);

for(int i=1; i<=columns; ++i){

row.put(md.getColumnName(i),rs.getObject(i));

}

list.add(row);

}

return list;

}