POI web导入导出类封装！

/** * Excel到入老师信息 */ @SuppressWarnings("unchecked") public String readExcel(){ try { InputStream in = new FileInputStream(excelFile); List<TeacherView> lists=null; Map<String,String> teaMap=new HashMap<String, String>(); teaMap.put("schId", schID); //读取学校的老师信息 final List<TeacherView> teaList=teacherService.queryTeacherAllSchool(teaMap); final List<Subjects> subList = subjectService.selectSubjectList(Integer.parseInt(schID));//根据学校读取科目 final Map<String,String> telMap=new HashMap<String, String>(); final Map<String,String> nameMap=new HashMap<String, String>(); final Map<String,String> classAndSub=new HashMap<String, String>(); Map<String, Object> resultMap=LoadXLS.load(in,3,new LoadXLSCallBack<TeacherView>(){ @Override public TeacherView getObject(List<String> list) { int gbnum=0; TeacherView tv=new TeacherView(); String teacherName=list.get(1).trim();//老师姓名 String mobile=list.get(2).trim();//电话 String roleName=list.get(3).trim();//角色名称 String sex=list.get(4).trim();//性别 String address=list.get(5); if(address!=null && address!=""){ address=address.trim(); } String classInfo=list.get(6);//班级 if(classInfo!=null && classInfo!=""){ classInfo=classInfo.trim(); } String subInfo=list.get(7);//科目 if(subInfo!=null && subInfo!=""){ subInfo=subInfo.trim(); } String errorMsg=""; if(teacherName.length()<1){ errorMsg+="老师名称不能为空,"; }else{ if(telMap.get(teacherName)==null){ telMap.put(teacherName, teacherName); Map<String,Object> map=new HashMap<String, Object>(); map.put("teacherName", teacherName); int teacherrow=teacherService.teacherNameIsExist(map); if(teacherrow==-1){ errorMsg+="老师姓名已存在,"; }else{ tv.setTeacherName(teacherName); } }else{ errorMsg+="导入数据中老师姓名已存在,"; } } if(mobile.length()<1){ errorMsg+="电话不能为空,"; }else{ //获取电话号码 判断电话号码是否合法 // Pattern p = Pattern.compile("^((13[0-9])|(15[^4,\\D])|(18[-9]))\\d{8}$"); // Matcher m = p.matcher(mobile); if(!AllUtils.isMobileNO(mobile)){ errorMsg+="电话号码格式错误,"; } //if(telMap.get(mobile)==null && nameMap.get(teacherName)==null){ if(telMap.containsKey(mobile) && nameMap.containsKey(teacherName)){ errorMsg+="老师姓名和电话存在重复,"; }else{ telMap.put(mobile, mobile); telMap.put(teacherName, teacherName); if(teaList!=null && teaList.size()>0){ for (TeacherView t:teaList) { if(t!=null){ if(mobile.equals(t.getMobile()) && teacherName.equals(t.getTeacherName())){ errorMsg+="老师已存在,"; break; } } } } } } if(roleName.length()<1){ errorMsg+="角色名称不能为空,"; }else{ int roleID = teacherService.getRoleIdByName(roleName); if (roleID == 0) { errorMsg+="角色名称错误,"; }else{ tv.setRoleId(roleID+""); tv.setRoleName(roleName);//角色名称 //如果是年级组长则判断年级是否存在 /*System.out.println(roleName); if("年级组长".equals(roleName)){ if(!classInfo.isEmpty()){ for (GradeBaseInfo gb:gradeList) { if(gb!=null){ if(gb.getGradeName()==classInfo){ tv.setGradeId(gb.getId()+""); break; } } } if(tv.getGradeId()==null || tv.getGradeId()==""){ errorMsg+="年级不存在,"; } } }*/ } } if(sex.length()<1){ errorMsg+="性别不能为空,"; }else{ //获取性别 判断性别是否合法 if(!("男".equals(sex) || "女".equals(sex))){ errorMsg+="性别错误,"; } } /** * 判断科目 */ boolean bool=false; String subID=""; if(subInfo!=null && subInfo.length()>0){ for (Subjects subjects : subList) { if(subjects!=null){ if(subjects.getSubjectname().equals(subInfo)){ bool=true; tv.setSub(subjects.getSubjectID().toString()); subID=subjects.getSubjectID().toString(); break; }else{ bool=false; } } } } //判断科目是否存在 if(bool==false && subID!=""){ errorMsg+="科目不存在,"; } if(!classInfo.isEmpty() && subID.isEmpty()){ errorMsg+="科目不能为空,"; } if(classInfo.isEmpty() && !subID.isEmpty()){ errorMsg+="班级不能为空,"; } //判断班级是否存在 String classIds=""; if(!classInfo.isEmpty()){ //String className=teacherView int index = classInfo.replace("，", ",").indexOf(","); // 如果在导入的Excel中一个老师管辖多个班级，“三(1),三(2)”这样的情况，对班级进行分割判断，然后添加 if (index > 0) { String[] str =classInfo.replace("，", ",").split(","); for (int j = 0; j < str.length; j++) { Map<String,Object> classMap=new HashMap<String, Object>(); String className=str[j]; className=className.replace("（", "("); className=className.replace("）", ")"); classMap.put("className", className); classMap.put("schId", schID); // 根据班级名称和学校ID,去查找班级信息 try { ClassBaseInfo cbs = classBaseService.selectClassBaseByName(classMap); if(cbs==null){ errorMsg+="班级名称错误,"; }else{ if(cbs.getId()!=null){ classIds+=cbs.getId()+","; if(subID!="" && subID!=null){ if(classAndSub.containsKey((subID+cbs.getId()))){ errorMsg+="班级科目绑定重复,"; } classAndSub.put((subID+cbs.getId()), (subID+cbs.getId())); } } } } catch (Exception e) { } } } // 当一个老师只管理一个班级的时候 if (index == -1) { try { Map<String,Object> classMap=new HashMap<String, Object>(); classInfo=classInfo.replace("（", "("); classInfo=classInfo.replace("）", ")"); classMap.put("className",classInfo); classMap.put("schId",schID); //查找班级的名称是否存在 ClassBaseInfo cbs = classBaseService.selectClassBaseByName(classMap); if (cbs== null) { errorMsg+="班级名称错误,"; }else{ if(cbs.getId()!=null){ classIds+=cbs.getId()+","; if(subID!="" && subID!=null){ if(classAndSub.containsKey((subID+cbs.getId()))){ errorMsg+="班级科目绑定重复,"; } classAndSub.put((subID+cbs.getId()), (subID+cbs.getId())); } } } } catch (Exception e) { } } } //去除最后，读取班级集合 if(classIds!="" && classIds!=null){ classIds=classIds.substring(0,classIds.length()-1); } //数据库老师名存在性判断 //去除最后， if(errorMsg!="" && errorMsg!=null){ errorMsg=errorMsg.substring(0,errorMsg.length()-1); } tv.setMobile(mobile); tv.setRoleName(roleName); tv.setSex(sex); tv.setAddress(address); tv.setOwnerClass(classInfo); tv.setSchId(Integer.parseInt(schID)); tv.setErrMsg(errorMsg); tv.setClassIds(classIds); return tv; } @Override public int getColumnSize() { return 8; } @Override public String[] getHeadColumn() { // TODO Auto-generated method stub return new String[]{"序号","姓名","手机号码","角色","性别","住址","管辖