java导入text文件

/**
 * 插入导入的记录
 *
 * @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 {

       
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值