struts2 Excel导入数据库

package com.ssh.action; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.InputStream; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import com.opensymphony.xwork2.ActionSupport; import com.ssh.bean.PageBean; import com.ssh.entity.Person; import com.ssh.excel.ExcelWorkSheet; import com.ssh.service.PersonService; public class PersonAction extends ActionSupport{ /** * */ private static final long serialVersionUID = 1L; private Person person; private PersonService personService; private int page; private PageBean pageBean; String info =""; private File excelFile; private String excelFileFileName; private ExcelWorkSheet<Person> excelWroksheet; private String uname; private String address; private int id; private String uid; private String age; public String savePerson() throws Exception { this.personService.save(person); return SUCCESS; } public String listPerson()throws Exception{ /* List<Person> list = this.personService.findAllPerson(); System.out.println(list); #request.list1页面 ServletActionContext.getRequest().setAttribute("list1", list);*/ this.pageBean = personService.queryForPage(5, page,"from Person"); return SUCCESS; } public String personxx()throws Exception{ person = this.personService.findById(getId()); return SUCCESS; } public String updatePerson()throws Exception{ this.personService.update(person); return SUCCESS; } public String deletePerson()throws Exception{ this.personService.delete(person); return SUCCESS; } public String findPerson()throws Exception{ String hql = "from Person where 1=1 "; if(person.getUname().trim().length()!=0&&person.getUname()!=null) { hql="from Person where uname like'%"+person.getUname().trim()+"%'"; } if(person.getAge().trim().length()!=0&&person.getAge()!=null) { hql=hql+"and age='"+person.getAge().trim()+"'"; } if(person.getUid().trim().length()!=0&&person.getUid()!=null) { hql=hql+"and uid='"+person.getUid().trim()+"'"; } if(person.getAddress().trim().length()!=0&&person.getAddress()!=null) { hql=hql+"and address='"+person.getAddress().trim()+"'"; } List<Person>list = this.personService.findPerson(hql); this.pageBean = personService.queryForPage(5, page,hql); return SUCCESS; } public String check()throws Exception{ List<Person> listperson = this.personService.findUid(person.getUid()); if(listperson!=null&&listperson.size()>0){ info="身份证号重复"; }else{ info="身份证号可以使用"; } System.out.println(info); return SUCCESS; } private Workbook createWorkBook(InputStream is)throws Exception{ if(excelFileFileName.toLowerCase().endsWith("xls")){ return new HSSFWorkbook(is); } if(excelFileFileName.toLowerCase().endsWith("xlsx")){ return new XSSFWorkbook(is); } return null; } public String importExcel()throws Exception{ Workbook workbook = createWorkBook(new FileInputStream(excelFile)); Sheet sheet = workbook.getSheetAt(0); excelWroksheet = new ExcelWorkSheet<Person>(); excelWroksheet.setSheetName(sheet.getSheetName()); Row firstRow = sheet.getRow(0); Iterator<Cell> iterator = firstRow.iterator(); List<String> cellNames = new ArrayList<String>(); while(iterator.hasNext()){ cellNames.add(iterator.next().getStringCellValue()); } //Number age=0; //Number uid=0; excelWroksheet.setColumns(cellNames); for(int i=1;i<=sheet.getLastRowNum();i++){ Row row = sheet.getRow(i); Person person = new Person(); person.setUname(row.getCell(0).getStringCellValue()); System.out.println(person.getUname()); person.setAge(row.getCell(1).getStringCellValue()); System.out.println(person.getAge()); person.setUid(row.getCell(2).getStringCellValue()); System.out.println(person.getUid()); person.setAddress(row.getCell(3).getStringCellValue()); System.out.println(person.getAddress()); this.personService.save(person); //excelWroksheet.getData().add(person); } return SUCCESS; } public void setPersonService(PersonService personService) { this.personService = personService; } public Person getPerson() { return person; } public void setPerson(Person person) { this.person = person; } public String getUname() { return uname; } public void setUname(String uname) { this.uname = uname; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUid() { return uid; } public void setUid(String uid) { this.uid = uid; } public String getAge() { return age; } public void setAge(String age) { this.age = age; } public int getPage() { return page; } public void setPage(int page) { this.page = page; } public PageBean getPageBean() { return pageBean; } public void setPageBean(PageBean pageBean) { this.pageBean = pageBean; } public static long getSerialVersionUID() { return serialVersionUID; } public String getInfo() { return info; } public void setInfo(String info) { this.info = info; } public File getExcelFile() { return excelFile; } public void setExcelFile(File excelFile) { this.excelFile = excelFile; } public String getExcelFileFileName() { return excelFileFileName; } public void setExcelFileFileName(String excelFileFileName) { this.excelFileFileName = excelFileFileName; } public ExcelWorkSheet<Person> getExcelWroksheet() { return excelWroksheet; } public void setExcelWroksheet(ExcelWorkSheet<Person> excelWroksheet) { this.excelWroksheet = excelWroksheet; } public PersonService getPersonService() { return personService; } }