批量操作时使用动态数组:ArrayList

在做数据表导出Excel时，看到一篇“基于Ｊａｖａ　Ｅｘｃｅｌ　ＡＰＩ的数据库数据

导入导出方法研究与实现”期刊，受到启发，其实就是每一条记录都添加到List里，全部记录一起操作，我之前都是一条条做，效率很低。草稿弄没了写的少了点，就那意思- -，代码

 

           rs = sql.executeQuery("select * from xsb");

                     ResultSetMetaDatarsmd = rs.getMetaData();

                     intcolumnCount = rsmd.getColumnCount();

                     String[]fieldTitle = new String[columnCount];

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

                            fieldTitle[i- 1] = rsmd.getColumnName(i);

                     }

                     Listnotes = new ArrayList();

                     while(rs.next()) {

                            Listnote = new ArrayList();

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

                                   note.add(rs.getString(i));

                            }

                            notes.add(note);

                     }