It is not recommended to pass resultset as a parameter directly

It's going to be a lot of trouble, and it's been taking up a connection
Get ResultSet object, immediately put it into a ArrayList [] inside, after performing this method not only can turn off RS, and can be closed connection, the resources released, and then the array as a parameter passed on it, it has nothing to do with SQL

rs = st.executequery (SQL);
if (rs!=null) {
Rs.last ();
int rows = Rs.getrow ();
if (rows = = 0) return null;
Rs.beforefirst ();
Array = new Java.util.arraylist[rows];
int l = 0;
while (Rs.next ()) {
ARRAY[L] = new ArrayList ();
Array[l].add (0,rs.getstring (1));
Array[l].add (1,new Double (rs.getdouble (2)));
Array[l].add (2,new Double (rs.getdouble (3)));
Array[l].add (3,rs.getstring (4));
l++;
}
}