我有一个项目,其中有一个模型类,具有三列的 Person:id、name 和 Country,它正确地保留到 PostgreSQL。结果正确地找到在List
对象。但我想导出List
数据(显示在页面上)到 Excel。
我做了一个名为PersonExcelView
:
public class PersonExcelView extends AbstractExcelView {
private PersonService personService;
@Override
protected void buildExcelDocument(Map<String, Object> arg0, HSSFWorkbook arg1, HttpServletRequest arg2,
HttpServletResponse arg3) throws Exception {
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet excelSheet = workbook.createSheet("PersonList");
setExcelHeader(excelSheet);
List personList = (List) personService.getPersonList();
setExcelRows(excelSheet,personList);
}
public void setExcelHeader(HSSFSheet excelSheet) {
HSSFRow excelHeader = excelSheet.createRow(0);
excelHeader.createCell(0).setCellValue("Id");
excelHeader.createCell(1).setCellValue("Name");
excelHeader.createCell(2).setCellValue("Country");
}
public void setExcelRows(HSSFSheet excelSheet, List personList){
int record = 1;
for (Person person : personService.listPersons()) {
HSSFRow excelRow = excelSheet.createRow(record++);
excelRow.createCell(0).setCellValue(person.getId());
excelRow.createCell(1).setCellValue(person.getName());
excelRow.createCell(2).setCellValue(person.getCountry());
}
}}
这是我的PersonServiceImpl
class:
@Service
public class PersonServiceImpl implements PersonService {
private PersonDAO personDAO;
public void setPersonDAO(PersonDAO personDAO) {
this.personDAO = personDAO;
}
@Override
@Transactional
public void addPerson(Person p) {
this.personDAO.addPerson(p);
}
@Override
@Transactional
public void updatePerson(Person p) {
this.personDAO.updatePerson(p);
}
@Override
@Transactional
public List<Person> listPersons() {
return this.personDAO.listPersons();
}
@Override
@Transactional
public Person getPersonById(int id) {
return this.personDAO.getPersonById(id);
}
@Override
@Transactional
public void removePerson(int id) {
this.personDAO.removePerson(id);
}
@Override
public List<Person> getPersonList() {
// TODO Auto-generated method stub
return listPersons();
}
}
这是我的控制器代码:
@RequestMapping(value = "/export", method = RequestMethod.POST)
public ModelAndView getExcel() {
List personList = (List) personService.getPersonList();
return new ModelAndView("PersonExcelView", "personList", personList);
}
这是 JSP:
<a href="SpringMVCHibernate/export">Export</a></h3>
当我单击“导出”时,它不会将数据导出到 Excel 中。错误在哪里?