.csv文件解析工具类

public class CSVUtils {
	public static List<IssueBean> csv(String filePath) {
        IssueBean issueBean = null;
        //生成CsvReader对象，以，为分隔符，GBK编码方式
        CsvReader r = null;
        try {
            List<IssueBean> issueBeans = new ArrayList<IssueBean>();
            String csvFilePath = filePath;
            r = new CsvReader(csvFilePath, ',', Charset.forName("GBK"));
            //读取表头
            r.readHeaders();
            //逐条读取记录，直至读完
            while (r.readRecord()) {
                issueBean = new IssueBean();
                Request request = new Request();
                Body body = new Body();
                //body.setPolicyNo(r.get("policyNo"));
                body.setActualPremium(r.get("actualPremium"));
                body.setPremium(r.get("premium"));
                body.setActualPremium(r.get("actualPremium"));
                body.setSumInsured(r.get("sumInsured"));
                body.setEffectStartTime(r.get("effectStartTime"));
                body.setEffectEndTime(r.get("effectEndTime"));
                body.setApplyNum(r.get("applyNum"));

                Map<String, String> map = new HashMap<String, String>();
                map.put("creditAmount", r.get("creditAmount"));
                map.put("houseAddress", r.get("houseAddress"));
                map.put("loanContractNo", r.get("loanContractNo"));
                map.put("mortgageLoanTerm", r.get("mortgageLoanTerm"));
                map.put("interviewDate", r.get("interviewDate"));
                map.put("areaCode", r.get("areaCode"));
                body.setExtendInfo(map);

                List<Bills> bills = new ArrayList<Bills>();
                Bills bills1 = new Bills();
                bills1.setFee(r.get("fee"));
                bills.add(bills1);
                body.setBills(bills);

                ArrayList<CoverageList> coverageLists = new ArrayList<CoverageList>();
                CoverageList coverageList = new CoverageList();
                //coverageList.setCoverageNo(r.get("coverageNo"));
                coverageList.setPremium(r.get("premium"));
                coverageList.setSumInsured(r.get("sumInsured"));
                coverageList.setEffectStartTime(r.get("effectStartTime"));
                coverageList.setEffectEndTime(r.get("effectEndTime"));
                coverageList.setEffectPeriod(r.get("effectPeriod"));
                coverageLists.add(coverageList);
                body.setCoverageList(coverageLists);

                Holder holder = new Holder();
                //holder.setPersonNo(r.get("personNo"));
                holder.setCertType(r.get("holderCertType"));
                holder.setCertNo(r.get("holderCertNo"));
                holder.setCertName(r.get("holderCertName"));
                holder.setPhone(r.get("holderPhone"));
                body.setHolder(holder);

                List<Insureds> insuredsList = new ArrayList<Insureds>();
                Insureds insureds = new Insureds();
                insureds.setCertType(r.get("insuredsCertType"));
                insureds.setCertNo(r.get("insuredsCertNo"));
                insureds.setCertName(r.get("insuredsCertName"));
                body.setInsureds(insuredsList);
                insuredsList.add(insureds);
                request.setBody(body);

                Header header = new Header();
                request.setHeader(header);
                issueBean.setRequest(request);
                issueBean.setSignature("aGgUJ1n4j1/ksz+E041m0jgxYJeGU4Be77m5TNEhki6QBUJZir3M+4kc/n5pAXbW85dmZCUBr1cqHkz+bqUDumRc3JdoPmMRLywtg1zpFaiIWuSdVcW9x411un6iQVIYkHirc+xqHyH0FiOnP54Va77jwtW0JG6FxafKxNobwc4pnJ7P9mucBwx5fpNm7yE3zK7Dht/bFs+1BsZIHOGOFWdIiE0QyU4JRsvc0JTlqAGt6y++7RkeUaRaqvt03t0jmVEs/B0RSA7hUTYjAfA2GAwXG79Qm73t5d0ngOqvRbv2URFxLCSM8tRp4juoiOrkPgMgwLQTIIlipZjVzdQ+Bg==");
                issueBeans.add(issueBean);
            }
            r.close();
            return issueBeans;
        } catch (Exception e) {
            throw new RuntimeException(e.getMessage());
        } finally {
            r.close();
        }
    }

    public static void main(String[] args) {
        List<IssueBean> issueBeans = csv("C:\\Users\\EDZ\\Desktop\\0336-BAY-20200827.csv");
        System.out.println(issueBeans.size());
        for (IssueBean issueBean : issueBeans) {
            System.out.println(JSONObject.toJSONString(issueBean));
        }
        
    }