支付宝与微信对账文件解析

一，对账文件解析

　　1）在支付中会涉及到对账问题，那么对账文件解析就是个较为棘手的事情，那今天就来看下常见的对账文件格式与解析；

二，常见对账文件格式

　　1）支付宝与微信的对账文件都是.csv格式，这样的对账文件可以使用exceld打开，也可以使用文本编辑器打开，

　　     其他类型对账文件大多是XML文件，下面来看下是什么样子的文件

　　　　支付宝文件

　　　　1.样式

　　　　

　　　　2.exceld打开样式

　　　　3.编辑器打开样式

　　微信文件

　　　　1.文本打开样式

　　　　

　　

　　XML文件

　　　 1.XML类型文件是我们常常遇到的类型，解析方式要根据内容情况来进行

三，解析

　　1）根据不同的内容设置不同的解析方法

　　2）微信csv文件解析示例(支付宝同理)

//读取文件
        File file = new File("F:/test/wexin.csv");
        //解决中文乱码
        InputStreamReader isr=null;
        BufferedReader buff =null;
        try {
            isr = new InputStreamReader(new FileInputStream(file), "UTF-8");
             buff = new BufferedReader(isr);
            String line=null;
            //数据容器
            List<WwXin> wxinlist=new ArrayList<WwXin>();
            WwXin wXin =null;
            while ((line=buff.readLine())!=null) {
                //去除`
                String replace = line.replace("`", "");
                String[] split = replace.split(",");
                //去除后两行，第一行也是不需要存到数据库的，在后续操作中去掉第一条数据
                if(split.length==24) {
                    //符合要求
                    wXin=new WwXin();
                    wXin.setTime(split[0]);
                    wXin.setId(split[1]);
                    wXin.setShh(split[2]);
                    wXin.setZshh(split[3]);
                    wXin.setSbh(split[4]);
                    wXin.setWxddh(split[5]);
                    wXin.setShddh(split[6]);
                    wXin.setYhbs(split[7]);
                    wXin.setJylx(split[8]);
                    wXin.setJyzt(split[9]);
                    wXin.setFkyh(split[10]);
                    wXin.setHbzl(split[11]);
                    wXin.setZje(split[12]);
                    wXin.setDjjlj(split[13]);
                    wXin.setWxtkdh(split[14]);
                    wXin.setHztkdh(split[15]);
                    wXin.setTkje(split[16]);
                    wXin.setLjje(split[17]);
                    wXin.setTklx(split[18]);
                    wXin.setTkzt(split[19]);
                    wXin.setSbmc(split[20]);
                    wXin.setShsjb(split[21]);
                    wXin.setSxf(split[22]);
                    wXin.setFl(split[23]);
                    //添加
                    wxinlist.add(wXin);
                }
            }
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            try {
                if(isr!=null) {
                    isr.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
            try {
                if(buff!=null) {
                    buff.close();    
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

　　3）XMl文件解析（要根据具体格式具体解析）

List<AccountQueryAccountLogVO> list = new ArrayList<AccountQueryAccountLogVO>();
        try {
            //创建SAXReader对象读取proudct4.xml文件
            SAXReader reader = new SAXReader();
            //从本地读取文件，读取xml
            File file = new File("F:/test/2017-12-26.xml");
            Document document = reader.read(file);
            //读取根节点
            Element rootElement = document.getRootElement();
            //获取全部节点
            Iterator<Element> it1 = rootElement.elementIterator();
            //遍历子节点
            while(it1.hasNext()){//判断是否有下一个子元素
                //子节点
                Element productEle = it1.next();
                Iterator<Element> it2 = productEle.elementIterator();
                //遍历product标签的子元素
                while(it2.hasNext()){
                    //获取每个子元素
                    Element eles = it2.next();
                    Iterator<Element> it3 = eles.elementIterator();
                    while(it3.hasNext()){
                        //获取每个子元素
                        Element next = it3.next();
                        Iterator<Element> it4 = next.elementIterator();
                        AccountQueryAccountLogVO accountQueryAccountLogVO =null;
                        while (it4.hasNext()) {
                            Element next2 = it4.next();
                            Iterator<Element> it5 = next2.elementIterator();
                            accountQueryAccountLogVO= new AccountQueryAccountLogVO();
                            while (it5.hasNext()) {
                                Element next3 = it5.next();
                                String name = next3.getName();
                                switch (name) {
                                case "balance":
                                    String data = (String)next3.getData();
                                    accountQueryAccountLogVO.setBalance(data);
                                    break;
                                case "buyer_account":
                                    String buyerAccount = (String)next3.getData();
                                    accountQueryAccountLogVO.setBuyerAccount(buyerAccount);
                                    break;
                                case "currency":
                                    String currency = (String)next3.getData();
                                    accountQueryAccountLogVO.setCurrency(currency);
                                    break;
                                case "deposit_bank_no":
                                    String depositBankNo = (String)next3.getData();
                                    accountQueryAccountLogVO.setDepositBankNo(depositBankNo);
                                    break;
                                case "goods_title":
                                    String goodsTitle = (String)next3.getData();
                                    accountQueryAccountLogVO.setGoodsTitle(goodsTitle);
                                    break;
                                case "income":
                                    String income = (String)next3.getData();
                                    accountQueryAccountLogVO.setIncome(income);
                                    break;
                                case "iw_account_log_id":
                                    String iwAccountLogId = (String)next3.getData();
                                    accountQueryAccountLogVO.setIwAccountLogId(iwAccountLogId);
                                    break;
                                    
                                case "merchant_out_order_no":
                                    String merchantOutOrderNo = (String)next3.getData();
                                    accountQueryAccountLogVO.setMerchantOutOrderNo(merchantOutOrderNo);
                                    break;
                                case "outcome":
                                    String outcome = (String)next3.getData();
                                    accountQueryAccountLogVO.setOutcome(outcome);
                                    break;
                                case "partner_id":
                                    String partnerId = (String)next3.getData();
                                    accountQueryAccountLogVO.setPartnerId(partnerId);
                                    break;
                                case "rate":
                                    String rate = (String)next3.getData();
                                    accountQueryAccountLogVO.setRate(rate);
                                    break;
                                case "seller_account":
                                    String sellerAccount = (String)next3.getData();
                                    accountQueryAccountLogVO.setSellerAccount(sellerAccount);
                                    break;
                                case "seller_fullname":
                                    String seller = (String)next3.getData();
                                    accountQueryAccountLogVO.setSellerAccount(seller);
                                    break;
                                case "service_fee":
                                    String serviceFee = (String)next3.getData();
                                    accountQueryAccountLogVO.setServiceFee(serviceFee);
                                    break;
                                case "sign_product_name":
                                    String signProductName = (String)next3.getData();
                                    accountQueryAccountLogVO.setSignProductName(signProductName);
                                    break;
                                case "sub_trans_code_msg":
                                    String subTransCodeMsg = (String)next3.getData();
                                    accountQueryAccountLogVO.setSubTransCodeMsg(subTransCodeMsg);
                                    break;
                                case "total_fee":
                                    String totalFee = (String)next3.getData();
                                    accountQueryAccountLogVO.setTotalFee(totalFee);
                                    break;
                                case "trade_no":
                                    String tradeNo = (String)next3.getData();
                                    accountQueryAccountLogVO.setTradeNo(tradeNo);
                                    break;
                                case "trade_refund_amount":
                                    String tradeRefundAmount = (String)next3.getData();
                                    accountQueryAccountLogVO.setTradeRefundAmount(tradeRefundAmount);
                                    break;
                                case "trans_code_msg":
                                    String transCodeMsg = (String)next3.getData();
                                    accountQueryAccountLogVO.setTransCodeMsg(transCodeMsg);;
                                    break;
                                case "trans_date":
                                    String transDate = (String)next3.getData();
                                    accountQueryAccountLogVO.setTransDate(transDate);
                                    break;
                                default:
                                    break;
                                }
                            }
                            list.add(accountQueryAccountLogVO);
                        }
                    }
                    
                }
            }
        } catch (DocumentException e) {
            e.printStackTrace();
        }
    }