java导出导入csv文件代码

 导出
        FileOutputStream fos = new FileOutputStream(
                "E:\\wendang" + "结算数据".concat(DateUtil.formatDateByYYYYMMdd(request.getStartDate())).concat("_")
                        .concat(DateUtil.formatDateByYYYYMMdd(request.getEndDate())).concat(".csv"));
        // 写入bom头 用于excel中文查看
        byte[] uft8bom = { (byte) 0xef, (byte) 0xbb, (byte) 0xbf };
        fos.write(uft8bom);
        BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(fos, "UTF-8"));
        bw.write("放款日期,订单号,总金额,还款期数");
        bw.newLine();

bw.close();

 

导入

@ApiOperation(value = "上传文件")
@PostMapping(value = "/writeupload", produces = "application/json; charset=utf-8")
public @ResponseBody BaseResponse writeoffupload(MultipartFile file, final HttpServletResponse resp) {

    log.info("writeupload-----》begin");
    String fileName = file.getOriginalFilename();
    log.info("fileName=={}", fileName);
    BaseResponse result = new BaseResponse();
    String ossFileName = CommonConstants.TEMP_PATH + DateUtil.parseDateByYYYYMMddhhmmss(new Date()) + fileName;
       BufferedOutputStream bos = null;
    BufferedReader reader=null;
    File localFile=null;
    try {
        SecurityUtils.getSubject().checkPermission(PermissionConstant.REPAYMENT_PLAN);
        String operatePeople = (String) SecurityUtils.getSubject().getPrincipal();
        log.info("operatePeople为==={}", operatePeople);
        ValidatorUtil.validateNotNull(operatePeople, "操作人为空");
        //读取文件并保存
        File path=new File(CommonConstants.TEMP_PATH);
        if (!path.exists()) {
            path.mkdirs();
        }
        localFile = new File(ossFileName);
        if (!localFile.exists()) {
            boolean isMake = localFile.createNewFile();
            if (!isMake) {
                result.setResponseCode(CommonResult.PROCESSING.getCode());
                result.setResponseMessage(CommonResult.PROCESSING.getMessage());
                return result;
            }
        }
        file.transferTo(localFile);
        List<String> repayNoList = Lists.newArrayList();
          reader = new BufferedReader(new FileReader(localFile));
        log.info("firstLine=="+reader.readLine());
        boolean flag=true;
        while(flag){
            String line = reader.readLine();
            if(null==line){
                flag=false;
            }else{
                line= line.replaceAll("\"","");
                Pattern p = Pattern.compile("\\s*|\t|\r|\n");
                Matcher m = p.matcher(line);
                String dest = m.replaceAll("");
                repayNoList.add(dest);
            }
        };