利用JDBC连接取数据并导入到EXCEL中

来源：互联网发布：sql替换字符串编辑：程序博客网时间：2024/05/22 08:03
public void run(){        String sql = "select * from SFA_CUST_WZ";        try{            FileOutputStream fos = new FileOutputStream("d:\\foo.xls");              HSSFWorkbook wb = new HSSFWorkbook();              HSSFSheet s = wb.createSheet();              wb.setSheetName(0, "Matrix");                          _pstmt = _conn.getConn().prepareStatement(sql);            //取结果集            ResultSet _rs = _pstmt.executeQuery();            //取数据结构            ResultSetMetaData _rsm =  _rs.getMetaData();            //取表字段总数            int i = _rsm.getColumnCount();            //获取字段集合            String [] columnName = new String[i];            int j = 0;            for (int ri = 1; ri <= i; ri ++,j++) {                columnName[j] = _rsm.getColumnName(ri);            }            //取值并写入xls            int k = 0;            while(_rs.next()){                HSSFRow row = s.createRow(k);                 for (j = 0; j < i; j++ ) {                    HSSFCell cell = row.createCell(j);                     cell.setCellValue(_rs.getString(columnName[j]));                  }                k++;            }            wb.write(fos);              fos.close();             _rs.close();        }catch(Exception e){e.printStackTrace();}    }