将JDBC的ResultSet转为二维链表List<List<String>>

package com.gh.utils;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.List;

public class Transform {

    //将查询出来的结果集转为表结构
    public static List<List<String>> rsToTable(ResultSet rs) throws SQLException {
        List<List<String>> table = new LinkedList();
        ResultSetMetaData rsmd = rs.getMetaData();  //获得表结构
        int tlen = rsmd.getColumnCount();   //字段数量，用于for循环
        List<String> structure = new LinkedList();
        for (int i = 1; i <= tlen; i++) {
            structure.add(rsmd.getColumnName(i));    //获得字段名
        }
        table.add(structure);
        while(rs.next()){
            List<String> record = new LinkedList();
            for (int i = 1; i <= tlen; i++) {
                record.add(rs.getString(i));
            }
            table.add(record);
        }
        return table;
    }
}