/** * 插入导入的记录 * * @param url * @return */ public ApiResponse insertImportOriginBigData(String url, String importType) { boolean flag = true; if (importType.equals("increment")) { flag = incrementOriginBigDataInsert(url); } else if (importType.equals("cover")) { flag = coverOriginBigDataInsert(url); } if (flag == true) { Map<String, Object> details = Params.of("showResult", "导入数据成功!"); return ApiResponse.success("提交成功!", details); } else { Map<String, Object> details = Params.of("showResult", "请检查数据!"); return ApiResponse.success("提交失败!", details); } } //增量数据记录导入 public boolean incrementOriginBigDataInsert(String file) { String userId = SecurityContext.getCurrentUser().getId(); String companyId = String.valueOf(SecurityContext.getCurrentUser().getProperty("COMPANY_ID")); boolean flag = true; //查询大数据类型 Map<String, Object> param = new HashMap<String, Object>(); param.put("code", "ORIGIN_BIG_DATA_TYPE"); List<AttCommonWordBook> attCommonWordBookList = dao.queryForList(AttCommonWordBook.class, "query.att_common_wordbook.code", param); List<AttOriginBigData> list = new ArrayList<AttOriginBigData>(); try { BufferedReader br = null;// 编码方式为utf-8,txt保存时编码方式也要选择为utf-8 try { br = new BufferedReader((new InputStreamReader(new FileInputStream(new File(file)), "GBK"))); } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (FileNotFoundException e) { e.printStackTrace(); } String line; try { while ((line = br.readLine()) != null) { String originBigData = line.trim();//得到每行数据 String[] originBigDataArray = originBigData.split("\\|");//解析每行数据 if(originBigDataArray.length!=10) { flag = false; return flag; } if (originBigDataArray != null && originBigDataArray.length > 0) { AttOriginBigData attOriginBigData = new AttOriginBigData(); String id = Dao.getUUID(); attOriginBigData.setId(id); /** 打卡日期 **/ if (originBigDataArray[0].contains("null")) { attOriginBigData.setLockinDay(""); } else { attOriginBigData.setLockinDay(originBigDataArray[0]); } /** 导入组织全称 **/ if (originBigDataArray[1].contains("null")) { attOriginBigData.setOrgName(""); } else { attOriginBigData.setOrgName(originBigDataArray[1]); } /** 导入科室 **/ if (originBigDataArray[2].contains("null")) { attOriginBigData.setOfficeName(""); } else { attOriginBigData.setOfficeName(originBigDataArray[2]); } if (originBigDataArray[3].contains("null")) { attOriginBigData.setEmpCode(""); } else {
java导入text文件
最新推荐文章于 2023-12-14 15:39:04 发布