java web 企业人力资源管理系统

package com.wy.tool; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.List; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import com.wy.form.EmployeeForm; public class ReadExcel { /** * read the Excel file * @param path the path of the Excel file * @return * @throws IOException */ public List<EmployeeForm> readExcel(String path) throws IOException { if (path == null || Common.EMPTY.equals(path)) { return null; } else { String postfix = getPostfix(path); if (!Common.EMPTY.equals(postfix)) { if (Common.OFFICE_EXCEL_2003_POSTFIX.equals(postfix)) { return readXls(path); } else if (Common.OFFICE_EXCEL_2010_POSTFIX.equals(postfix)) { return readXlsx(path); } } else { System.out.println(path + Common.NOT_EXCEL_FILE); } } return null; } public static String getPostfix(String path) { if (path == null || Common.EMPTY.equals(path.trim())) { return Common.EMPTY; } if (path.contains(Common.POINT)) { return path.substring(path.lastIndexOf(Common.POINT) + 1, path.length()); } return Common.EMPTY; } public List<EmployeeForm> readXlsx(String path) throws IOException { System.out.println(Common.PROCESSING + path); InputStream is = new FileInputStream(path); XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is); EmployeeForm student = null; List<EmployeeForm> list = new ArrayList<EmployeeForm>(); // Read the Sheet for (int numSheet = 0; numSheet < xssfWorkbook.getNumberOfSheets(); numSheet++) { XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet); if (xssfSheet == null) { continue; } // Read the Row for (int rowNum = 1; rowNum <= xssfSheet.getLastRowNum(); rowNum++) { XSSFRow xssfRow = xssfSheet.getRow(rowNum); if (xssfRow != null) { student= new EmployeeForm(); XSSFCell id = xssfRow.getCell(0); XSSFCell sNO = xssfRow.getCell(1); XSSFCell name = xssfRow.getCell(2); XSSFCell sex = xssfRow.getCell(3); XSSFCell age = xssfRow.getCell(4); XSSFCell IDcard = xssfRow.getCell(5); XSSFCell born = xssfRow.getCell(6); XSSFCell nation = xssfRow.getCell(7); XSSFCell marriage = xssfRow.getCell(8); XSSFCell visage = xssfRow.getCell(9); XSSFCell aHome = xssfRow.getCell(10); XSSFCell tel = xssfRow.getCell(11); XSSFCell address = xssfRow.getCell(12); XSSFCell afterSchool = xssfRow.getCell(13); XSSFCell speciality = xssfRow.getCell(14); XSSFCell culture = xssfRow.getCell(15); XSSFCell startime = xssfRow.getCell(16); XSSFCell departmentId = xssfRow.getCell(17); XSSFCell typework = xssfRow.getCell(18); XSSFCell creatime = xssfRow.getCell(19); XSSFCell createName = xssfRow.getCell(20); XSSFCell mbz = xssfRow.getCell(21); student.setId(getValue(id)); student.setEm_serialNumber(getValue(sNO)); student.setEm_name(getValue(name)); student.setEm_sex(getValue(sex)); student.setEm_age(getValue(age)); student.setEm_IDCard(getValue(IDcard)); student.setEm_born(getValue(born)); student.setEm_nation(getValue(nation)); student.setEm_marriage(getValue(marriage)); student.setEm_visage(getValue(visage)); student.setEm_ancestralHome(getValue(aHome)); student.setEm_tel(getValue(tel)); student.setEm_address(getValue(address)); student.setEm_afterschool(getValue(afterSchool)); student.setEm_speciality(getValue(speciality)); student.setEm_culture(getValue(culture)); student.setEm_startime(getValue(startime)); student.setEm_departmentId(getValue(departmentId)); student.setEm_typework(getValue(typework)); student.setEm_creatime(getValue(creatime)); student.setEm_bz(getValue(mbz)); list.add(student); } } } return list; } /** * Read the Excel 2003-2007 * @param path the path of the Excel * @return * @throws IOException */ public List<EmployeeForm> readXls(String path) throws IOException { System.out.println(Common.PROCESSING + path); InputStream is = new FileInputStream(path); HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is); EmployeeForm student = null; List<EmployeeForm> list = new ArrayList<EmployeeForm>(); // Read the Sheet for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) { HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet); if (hssfSheet == null) { continue; } // Read the Row for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) { HSSFRow hssfRow = hssfSheet.getRow(rowNum); if (hssfRow != null) { student = new EmployeeForm(); HSSFCell id = hssfRow.getCell(0); HSSFCell sNO = hssfRow.getCell(1); HSSFCell name = hssfRow.getCell(2); HSSFCell sex = hssfRow.getCell(3); HSSFCell age = hssfRow.getCell(4); HSSFCell IDcard = hssfRow.getCell(5); HSSFCell born = hssfRow.getCell(6); HSSFCell nation = hssfRow.getCell(7); HSSFCell marriage = hssfRow.getCell(8); HSSFCell visage = hssfRow.getCell(9); HSSFCell aHome = hssfRow.getCell(10); HSSFCell tel = hssfRow.getCell(11); HSSFCell address = hssfRow.getCell(12); HSSFCell afterSchool = hssfRow.getCell(13); HSSFCell speciality = hssfRow.getCell(14); HSSFCell culture = hssfRow.getCell(15); HSSFCell startime = hssfRow.getCell(16); HSSFCell departmentId = hssfRow.getCell(17); HSSFCell typework = hssfRow.getCell(18); HSSFCell creatime = hssfRow.getCell(19); HSSFCell createName = hssfRow.getCell(20); HSSFCell bz = hssfRow.getCell(21); student.setId(getValue(id)); student.setEm_serialNumber(getValue(sNO)); student.setEm_name(getValue(name)); student.setEm_sex(getValue(sex)); student.setEm_age(getValue(age)); student.se