首先假设将数据从库中查出来储存在List中
List<User> users = userDao.findUsers();
假设需要导出的数据此刻在users中;
private static void writeExcel(List<User> users, String filePath) {
// 创建工作簿
Workbook workbook = new HSSFWorkbook();
// 创建Sheet并设置表头
Sheet sheet = workbook.createSheet("用户信息");
Row row0 = sheet.createRow(0);
row0.createCell(0).setCellValue("ID");
row0.createCell(1).setCellValue("姓名");
row0.createCell(2).setCellValue("年龄");
// 遍历List,将数据写入到Excel中
for (int i = 0; i < users.size(); i++)
{ User user = users.get(i); Row row = sheet.createRow(i + 1); row.createCell(0).setCellValue(user.getId());
row.createCell(1).setCellValue(user.getName());
row.createCell(2).setCellValue(user.getAge()); }
// 写入文件
try (FileOutputStream fos = new FileOutputStream(filePath))
{ workbook.write(fos); }
catch (Exception e) {
e.printStackTrace(); }
}
}