15 lines
1.1 KiB
SQL
15 lines
1.1 KiB
SQL
--更换软证书
|
|
update CAPSOFTROUTE set HEADPARAM='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=paf002.y.1001&&tmOut=30000',
|
|
bodyparam='CERD_ID=paf002.y.1001'
|
|
where BANKCODE='ICBC' AND FRSPRNO='002';
|
|
|
|
update CAPSOFTROUTE set HEADPARAM='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=paf002.y.1001&&tmOut=30000',
|
|
bodyparam='CERD_ID=paf002.y.1001'
|
|
where BANKCODE='ICBC' AND FRSPRNO='005';
|
|
|
|
update CAPSOFTROUTE set HEADPARAM='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=paf002.y.1001&&tmOut=30000',
|
|
bodyparam='CERD_ID=paf002.y.1001'
|
|
where BANKCODE='ICBC' AND FRSPRNO='006';
|
|
|
|
--开启工行所有前置机开关
|
|
update CAPSOFTROUTE set FTSSTS='S' WHERE BANKCODE='ICBC'; |