21 lines
2.8 KiB
SQL
21 lines
2.8 KiB
SQL
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('ICBC', '001', null, null, 'url=http://192.168.80.26:6700/servlet/ICBCCMPAPIReqServlet&&signUrl=http://192.168.80.26:6710&&proxyHost=192.168.80.26&&signProxyHost=192.168.80.26&&proxyPort=6700&&signProxyPort=6710&&CERD_ID=X123456.y.1001', 'CERD_ID=X123456.y.1001', 'S', null, 'ICBC_CHECK_HEART', 'S', '192.168.80.26', '20140508162001');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('ICBC', '002', null, null, 'url=http://192.168.80.25:6700/servlet/ICBCCMPAPIReqServlet&&signUrl=http://192.168.80.25:6710&&proxyHost=192.168.80.25&&signProxyHost=192.168.80.25&&proxyPort=6700&&signProxyPort=6710&&CERD_ID=X12345.y.1001', 'CERD_ID=X12345.y.1001', 'S', null, 'ICBC_CHECK_HEART', 'S', '192.168.80.25', '20140508162007');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('ICBC', '003', null, null, 'url=http://192.168.80.57:6700/servlet/ICBCCMPAPIReqServlet&&signUrl=http://192.168.80.57:6710&&proxyHost=192.168.80.57&&signProxyHost=192.168.80.57&&proxyPort=6700&&signProxyPort=6710&&CERD_ID=paf001.y.1001', 'CERD_ID=paf001.y.1001', 'S', null, 'ICBC_CHECK_HEART', 'S', '192.168.80.57', '20140508162001');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('ICBC', '004', null, null, 'url=http://192.168.80.58:6700/servlet/ICBCCMPAPIReqServlet&&signUrl=http://192.168.80.58:6710&&proxyHost=192.168.80.58&&signProxyHost=192.168.80.58&&proxyPort=6700&&signProxyPort=6710&&CERD_ID=paf002.y.1001', 'CERD_ID=paf002.y.1001', 'S', null, 'ICBC_CHECK_HEART', 'S', '192.168.80.58', '20140508162007');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('ICBC', '005', null, null, 'url=http://192.168.80.59:6700/servlet/ICBCCMPAPIReqServlet&&signUrl=http://192.168.80.59:6710&&proxyHost=192.168.80.59&&signProxyHost=192.168.80.59&&proxyPort=6700&&signProxyPort=6710&&CERD_ID=paf003.y.1001', 'CERD_ID=paf003.y.1001', 'S', null, 'ICBC_CHECK_HEART', 'S', '192.168.80.59', '20140508162001');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('ICBC', '006', null, null, 'url=http://192.168.80.60:6700/servlet/ICBCCMPAPIReqServlet&&signUrl=http://192.168.80.60:6710&&proxyHost=192.168.80.60&&signProxyHost=192.168.80.60&&proxyPort=6700&&signProxyPort=6710&&CERD_ID=paf004.y.1001', 'CERD_ID=paf004.y.1001', 'S', null, 'ICBC_CHECK_HEART', 'S', '192.168.80.60', '20140508162007');
|
|
commit;
|
|
|
|
|