一个数组与集合的问题,请帮我看看,先谢谢了!~

Question

严重问题
ArrayList data=new ArrayList();
ResultSet rs;
............
 while (rs.next()) {
                    String[] dataInRs=new String[columnCount];
                for (int q = 0; q < columnCount; q++) {
                    int t = q + 1;
                    dataInRs[q] = rs.getString(t);               
                }
              data.add(dataInRs);   
            }

Answer 1

我是想动态封装 一个 ResultSet 的,一条数据根据columnCount的大小初始化一个数组,
在将这个数组放入ArrayList中,但是,以我刚才的写发,只能看到最后一条数据,
有谁能帮我看看吗

Answer 2

终于对了,代码我贴出来,有兴趣的看看
package myFram;import java.util.*;
import java.sql.*;
import myFram.util.*;public class UserQuery {    private String[] columu_name = null;
    private ArrayList data = null;
    private HashMap hp = new HashMap();
    private Connection con = null;
    private Statement sql = null;
    private ResultSet rs = null;
    private ResultSetMetaData rm = null;
    
    int columnCount;    public HashMap getResult() {
        try {
            con = SQLFactory.gainConnection();
            sql = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_READ_ONLY);            rs = sql.executeQuery("select * from room");
            rm = rs.getMetaData();
            columnCount = rm.getColumnCount();
            columu_name = new String[columnCount];
            for (int i = 0; i < columnCount; i++) {
                int j = i + 1;
                columu_name[i] = rm.getColumnName(j);
            }
            
            data = new ArrayList();
           
         
            while (rs.next()) {
                String[] dataInRs = new String[columnCount];
                for (int q = 0; q < columnCount; q++) {
                    int t = q + 1;
                    dataInRs[q] = rs.getString(t);
                    System.out.println(dataInRs[q]);
                }
              data.add(dataInRs);
              
            }
           
             
            hp.put("sizeOfColumn", new Integer(columnCount));
           
            hp.put("column_name", columu_name);
            hp.put("data", data);
            System.out.println("Here is ok~~~~~~~~~");
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            SQLFactory.releaseConnection(rs, null, sql, con);
        }
        return hp;
    }}