# json-mapping-tool **Repository Path**: yunyongzhang/json-mapping-tool ## Basic Information - **Project Name**: json-mapping-tool - **Description**: 银行流水转标准化json - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 1 - **Created**: 2024-12-03 - **Last Updated**: 2024-12-03 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README ##### 1、`CCBMappingParser` 将建行流水的json文件,转为标准化json格式的文件 ~~~java public static void main(String[] args) { CCBMappingParser ccbMappingParser = new CCBMappingParser(); String ccbJson = "{\"卡号/账号\":\"6217002870088479298\",\"客户名称\":\"朱**\",\"起始日期\":\"20220430\",\"结束日期\":\"20220530\",\"交易明细\":[{\"序号\":\"1\",\"摘要\":\"银联入账\",\"币别\":\"人民币元\",\"钞汇\":\"钞\",\"交易日期\":\"20220521\",\"交易金额\":\"100.00\",\"账户余额\":\"101.66\",\"交易地点/附言\":\"（云闪付APP）\",\"对方账号与户名\":\"6214835734747353/朱**\"},{\"序号\":\"2\",\"摘要\":\"ETC欠费补扣\",\"币别\":\"人民币元\",\"钞汇\":\"钞\",\"交易日期\":\"20220521\",\"交易金额\":\"-2.85\",\"账户余额\":\"98.81\",\"交易地点/附言\":\"高速ETC记账卡批量扣款\",\"对方账号与户名\":\"034201420000000000001/湖北记账卡清算户\"}]}"; String ccbTrans = ccbMappingParser.parseCCBTrans(ccbJson); System.out.println(ccbTrans); } ~~~ ##### 2、`ICBCMappingParser` 将工行json流水, 转标准化json ~~~java public static void main(String[] args) { ICBCMappingParser icbcMappingParser = new ICBCMappingParser(); String icbcJson = "{\"卡号\":\"6212883202002754926\",\"户名\":\"朱**\",\"起止日期\":\"2022-05-25 — 2022-06-02\",\"交易明细\":[{\"交易日期\":\"2022-05-2810:40:28\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+3,678.54\",\"余额\":\"12,034.73\",\"对方户名\":\"银盛支付服务股份有限公司备付金\",\"对方账号\":\"991584000207\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2810:42:12\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+946.39\",\"余额\":\"12,981.12\",\"对方户名\":\"嘉联支付有限公司备付金\",\"对方账号\":\"991584001126\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2810:45:49\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+3,559.23\",\"余额\":\"16,540.35\",\"对方户名\":\"银盛支付服务股份有限公司备付金\",\"对方账号\":\"991584000207\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2810:47:05\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+9,845.55\",\"余额\":\"26,385.90\",\"对方户名\":\"嘉联支付有限公司备付金\",\"对方账号\":\"991584001126\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2810:48:47\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+3,181.44\",\"余额\":\"29,567.34\",\"对方户名\":\"银盛支付服务股份有限公司备付金\",\"对方账号\":\"991584000207\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2810:49:32\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+16,110.90\",\"余额\":\"45,678.24\",\"对方户名\":\"嘉联支付有限公司备付金\",\"对方账号\":\"991584001126\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2811:09:10\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"无卡支付\",\"地区\":\"4600\",\"收入支出金额\":\"-10,600.00\",\"余额\":\"35,078.24\",\"对方户名\":\"中国银联无卡快捷支付业务专户\",\"对方账号\":\"3602001111200515565\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2818:22:13\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"消费\",\"地区\":\"3202\",\"收入支出金额\":\"-66.00\",\"余额\":\"35,012.24\",\"对方户名\":\"中国银联无卡快捷支付业务专户\",\"对方账号\":\"3602001111200515565\",\"渠道\":\"快捷支付\"},{\"交易日期\":\"2022-05-2914:07:04\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"无卡支付\",\"地区\":\"4600\",\"收入支出金额\":\"-1,880.90\",\"余额\":\"33,131.34\",\"对方户名\":\"中国银联无卡快捷支付业务专户\",\"对方账号\":\"3602001111200515565\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2914:07:24\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"信用卡还款\",\"地区\":\"1201\",\"收入支出金额\":\"-19,778.08\",\"余额\":\"13,353.26\",\"对方户名\":\"光大卡中心信用卡\",\"对方账号\":\"000133100001\",\"渠道\":\"中间业务后台方式\"},{\"交易日期\":\"2022-05-2914:07:44\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"信用卡还款\",\"地区\":\"1201\",\"收入支出金额\":\"-12,170.62\",\"余额\":\"1,182.64\",\"对方户名\":\"中信银行信用卡\",\"对方账号\":\"000133100001\",\"渠道\":\"中间业务后台方式\"},{\"交易日期\":\"2022-05-2914:49:47\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+4,375.80\",\"余额\":\"5,558.44\",\"对方户名\":\"嘉联支付有限公司备付金\",\"对方账号\":\"991584001126\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2915:02:46\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+4,573.32\",\"余额\":\"10,131.76\",\"对方户名\":\"银盛支付服务股份有限公司备付金\",\"对方账号\":\"991584000207\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2915:03:45\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+944.77\",\"余额\":\"11,076.53\",\"对方户名\":\"嘉联支付有限公司备付金\",\"对方账号\":\"991584001126\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-05-2915:04:37\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"银联入账\",\"地区\":\"3202\",\"收入支出金额\":\"+7,458.75\",\"余额\":\"18,535.28\",\"对方户名\":\"嘉联支付有限公司备付金\",\"对方账号\":\"991584001126\",\"渠道\":\"网上银行\"},{\"交易日期\":\"2022-06-0209:07:21\",\"账号\":\"3202105801009634289\",\"储种\":\"活期\",\"序号\":\"00000\",\"币种\":\"人民币\",\"钞汇\":\"钞\",\"摘要\":\"理财\",\"地区\":\"3202\",\"收入支出金额\":\"-156.00\",\"余额\":\"18,379.28\",\"对方户名\":\"快钱支付清算信息有限公司\",\"对方账号\":\"215500684\",\"渠道\":\"快捷支付\"}]}"; String icbcTrans = icbcMappingParser.parseICBCTrans(icbcJson); System.out.println(icbcTrans); } ~~~ 备注：须引入`com.fasterxml.jackson.core` 下的 `jackson-databind` 依赖