读取Excel数据，保存到数据库

    private static void readFileWithTeacher(Sheet sheet) {
        int rowNum = sheet.getLastRowNum(); //获取最后一行的编号.比实际行数少一行
        if(rowNum<1){
            return ;
        }
        Row firstRow = sheet.getRow(0);
        if(firstRow==null){
            return ;
        }
        Map<String,String> map = new HashMap<String,String>(); 
        map.put("职工号", "tno");
        map.put("姓名", "name");
        map.put("密码", "password");
        map.put("职称", "title");
        map.put("联系方式", "tel");
        map.put("邮箱", "email");
        map.put("性别", "gender");

        List<String> list = new ArrayList<String>();
        int colNum = firstRow.getPhysicalNumberOfCells();
        for (int i = 0; i < colNum; i++) {
            list.add(map.get(firstRow.getCell(i).getStringCellValue()));
        }
        for (int i = 1; i <= rowNum; i++) {
            Row row = sheet.getRow(i);
            if(row==null){
                continue;
            }
            Teacher teacher = new Teacher();
            for (int j = 0; j < list.size(); j++) {
                teacher.set(list.get(j), row.getCell(j).getStringCellValue());
            }
            teacher.set("role_id", 2).set("password", HashKit.md5(HashKit.sha1(teacher.getStr("password"))));
            teacher.save();
        }
    }