将ResultSet结果集中的数据导入到Excel表

将ResultSet结果集中的数据导入到Excel表中，记录一下，方便以后使用。

 

 

public static boolean DB2Excel(ResultSet rs, String fileName) {
			boolean flag = false;
			WritableWorkbook workBook = null;
			WritableSheet sheet = null;
			Label label = null;

			try {
				// 创建Excel表
				String path = AutoStatisticUser.class.getResource("").getPath()
						+ fileName;
				workBook = Workbook.createWorkbook(new File(path));
				// 创建Excel表中的sheet
				sheet = workBook.createSheet("First Sheet", 0);
				// 向Excel中添加数据
				ResultSetMetaData rsmd = rs.getMetaData();
				int columnCount = rsmd.getColumnCount();
				String columnName = null;
				int row = 0;
				// 添加标题
				for (int i = 0; i < columnCount; i++) {
					columnName = rsmd.getColumnName(i + 1);
					label = new Label(i, row, columnName);
					System.out.println("标题：" + i + "---" + row + "---"
							+ columnName);
					sheet.addCell(label);
				}
				row++;
				System.out.println("写入标题成功");
				while (rs.next()) {
					for (int i = 0; i < columnCount; i++) {
						label = new Label(i, row, rs.getString(i + 1));
						System.out.println("标题：" + i + "---" + row + "---"
								+ rs.getString(i + 1));
						sheet.addCell(label);
					}
					row++;
				}
				System.out.println("写入内容成功");
				// 关闭文件
				workBook.write();
				System.out.println("数据成功写入Excel");
				flag = true;
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				try {
					workBook.close();
				} catch (Exception e2) {
					e2.printStackTrace();
				}
			}
			return flag;
		}

 

 

 

 

需要jar包：jxl-2.6.3.jar