/**
* 导入
* @throws IllegalAccessException
* @throws IOException
*/
public void excelImport() throws IllegalAccessException, IOException{
Department d = (Department) getSession().getAttribute("login_dep");
// 定义返回代码
String html = "<!DOCTYPE html><head><meta charset='utf-8' /></head><body><script>alert('数据上传完毕,总共${count}条数据,其中成功${success}条,失败${error}条。');location.href='qyjbxx_getList.do';</script></body></html>";
// 定义数据列
List<String> ywColumns = Arrays.asList("qyfl","qymc","shxydm","fddbrxm","fddbrsfz","jycs","qylx","sshy",
"zczb","jyfw","ybjyxm","slrq","hzrq","employeeCity");
// 定义错误接受数组 key=行号 value=实体类
List<Entry<Integer, String>> errorLog = new ArrayList<Map.Entry<Integer,String>>();
// 读取Excel内容并封装到实体类,key=行号 value=实体类
List<Entry<Integer, Object>> entryList =
ExcelUtils. importDataByExcel(excelFile, Qyjbxx.class, ywColumns, new IExcelHandle() {
@Override
public Object handle(String name, Object object) throws Exception {
String value = (String)object;
if ("qyfl".equals(name)){
if ("先证后核类".equals(value)){
return "0";
}else if("暂时保留类".equals(value)){
return "1";
}else if("暂停行使类".equals(value)){
return "2";
}else if(
* 导入
* @throws IllegalAccessException
* @throws IOException
*/
public void excelImport() throws IllegalAccessException, IOException{
Department d = (Department) getSession().getAttribute("login_dep");
// 定义返回代码
String html = "<!DOCTYPE html><head><meta charset='utf-8' /></head><body><script>alert('数据上传完毕,总共${count}条数据,其中成功${success}条,失败${error}条。');location.href='qyjbxx_getList.do';</script></body></html>";
// 定义数据列
List<String> ywColumns = Arrays.asList("qyfl","qymc","shxydm","fddbrxm","fddbrsfz","jycs","qylx","sshy",
"zczb","jyfw","ybjyxm","slrq","hzrq","employeeCity");
// 定义错误接受数组 key=行号 value=实体类
List<Entry<Integer, String>> errorLog = new ArrayList<Map.Entry<Integer,String>>();
// 读取Excel内容并封装到实体类,key=行号 value=实体类
List<Entry<Integer, Object>> entryList =
ExcelUtils. importDataByExcel(excelFile, Qyjbxx.class, ywColumns, new IExcelHandle() {
@Override
public Object handle(String name, Object object) throws Exception {
String value = (String)object;
if ("qyfl".equals(name)){
if ("先证后核类".equals(value)){
return "0";
}else if("暂时保留类".equals(value)){
return "1";
}else if("暂停行使类".equals(value)){
return "2";
}else if(