Java中URLEncoder.encode对应的JS解码

结论：Java的URLEncoder.encode(data, "UTF-8")对应的JS解码操作为：unescape(decodeURI(data));

背景知识：

JS的相关操作escape、encodeURI、encodeURIComponent

1）escape待叙

2）encodeURI待叙

3）encodeURIComponent待叙

Java的URLEncoder.encode待叙

 

示例：

[服务端]Java的data为：PreparedStatementCallback; SQL [insert into OBS.RSP_PRJ(RSP_PRJ_CODE, RSP_PRJ_NAME, BRANCH_ID, BRANCH_NAME, BRANCH_PATH, RSP_PRJ_REQ, RSP_FREQ, RSP_TIMES, DUE_DATE, RES_POS_REQ, RSP_PRJ_STATUS, CREATE_USER, CREATE_TIME, UPDATE_USER, UPDATE_TIME) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'CREATED', ?, ?, ?, ?)]; [jcc][t4][102][10040][3.52.95] 非自动批处理出现故障。虽然已经提交了批处理，但是该批处理的某个成员至少发生了一个异常。\r\n使用 getNextException() 来检索已经过批处理的特定元素的异常。 ERRORCODE=-4228, SQLSTATE=null; nested exception is com.ibm.db2.jcc.a.cn: [jcc][t4][102][10040][3.52.95] 非自动批处理出现故障。虽然已经提交了批处理，但是该批处理的某个成员至少发生了一个异常。\r\n使用 getNextException() 来检索已经过批处理的特定元素的异常。 ERRORCODE=-4228, SQLSTATE=null

 

[服务端]经过URLEncoder.encode之后的代码为：

PreparedStatementCallback%3B+SQL+%5Binsert+into+OBS.RSP_PRJ%28RSP_PRJ_CODE%2C+RSP_PRJ_NAME%2C+BRANCH_ID%2C+BRANCH_NAME%2C+BRANCH_PATH%2C+RSP_PRJ_REQ%2C+RSP_FREQ%2C+RSP_TIMES%2C+DUE_DATE%2C+RES_POS_REQ%2C+RSP_PRJ_STATUS%2C+CREATE_USER%2C+CREATE_TIME%2C+UPDATE_USER%2C+UPDATE_TIME%29+values%28%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%27CREATED%27%2C+%3F%2C+%3F%2C+%3F%2C+%3F%29%5D%3B+%5Bjcc%5D%5Bt4%5D%5B102%5D%5B10040%5D%5B3.52.95%5D+%E9%9D%9E%E8%87%AA%E5%8A%A8%E6%89%B9%E5%A4%84%E7%90%86%E5%87%BA%E7%8E%B0%E6%95%85%E9%9A%9C%E3%80%82%E8%99%BD%E7%84%B6%E5%B7%B2%E7%BB%8F%E6%8F%90%E4%BA%A4%E4%BA%86%E6%89%B9%E5%A4%84%E7%90%86%EF%BC%8C%E4%BD%86%E6%98%AF%E8%AF%A5%E6%89%B9%E5%A4%84%E7%90%86%E7%9A%84%E6%9F%90%E4%B8%AA%E6%88%90%E5%91%98%E8%87%B3%E5%B0%91%E5%8F%91%E7%94%9F%E4%BA%86%E4%B8%80%E4%B8%AA%E5%BC%82%E5%B8%B8%E3%80%82%0D%0A%E4%BD%BF%E7%94%A8+getNextException%28%29+%E6%9D%A5%E6%A3%80%E7%B4%A2%E5%B7%B2%E7%BB%8F%E8%BF%87%E6%89%B9%E5%A4%84%E7%90%86%E7%9A%84%E7%89%B9%E5%AE%9A%E5%85%83%E7%B4%A0%E7%9A%84%E5%BC%82%E5%B8%B8%E3%80%82+ERRORCODE%3D-4228%2C+SQLSTATE%3Dnull%3B+nested+exception+is+com.ibm.db2.jcc.a.cn%3A+%5Bjcc%5D%5Bt4%5D%5B102%5D%5B10040%5D%5B3.52.95%5D+%E9%9D%9E%E8%87%AA%E5%8A%A8%E6%89%B9%E5%A4%84%E7%90%86%E5%87%BA%E7%8E%B0%E6%95%85%E9%9A%9C%E3%80%82%E8%99%BD%E7%84%B6%E5%B7%B2%E7%BB%8F%E6%8F%90%E4%BA%A4%E4%BA%86%E6%89%B9%E5%A4%84%E7%90%86%EF%BC%8C%E4%BD%86%E6%98%AF%E8%AF%A5%E6%89%B9%E5%A4%84%E7%90%86%E7%9A%84%E6%9F%90%E4%B8%AA%E6%88%90%E5%91%98%E8%87%B3%E5%B0%91%E5%8F%91%E7%94%9F%E4%BA%86%E4%B8%80%E4%B8%AA%E5%BC%82%E5%B8%B8%E3%80%82%0D%0A%E4%BD%BF%E7%94%A8+getNextException%28%29+%E6%9D%A5%E6%A3%80%E7%B4%A2%E5%B7%B2%E7%BB%8F%E8%BF%87%E6%89%B9%E5%A4%84%E7%90%86%E7%9A%84%E7%89%B9%E5%AE%9A%E5%85%83%E7%B4%A0%E7%9A%84%E5%BC%82%E5%B8%B8%E3%80%82+ERRORCODE%3D-4228%2C+SQLSTATE%3Dnull

 

[客户端]decodeURI之后（还有一部分未解码）

PreparedStatementCallback%3B+SQL+[insert+into+OBS.RSP_PRJ(RSP_PRJ_CODE%2C+RSP_PRJ_NAME%2C+BRANCH_ID%2C+BRANCH_NAME%2C+BRANCH_PATH%2C+RSP_PRJ_REQ%2C+RSP_FREQ%2C+RSP_TIMES%2C+DUE_DATE%2C+RES_POS_REQ%2C+RSP_PRJ_STATUS%2C+CREATE_USER%2C+CREATE_TIME%2C+UPDATE_USER%2C+UPDATE_TIME)+values(%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+%3F%2C+'CREATED'%2C+%3F%2C+%3F%2C+%3F%2C+%3F)]%3B+[jcc][t4][102][10040][3.52.95]+非自动批处理出现故障。虽然已经提交了批处理，但是该批处理的某个成员至少发生了一个异常。使用+getNextException()+来检索已经过批处理的特定元素的异常。+ERRORCODE%3D-4228%2C+SQLSTATE%3Dnull%3B+nested+exception+is+com.ibm.db2.jcc.a.cn%3A+[jcc][t4][102][10040][3.52.95]+非自动批处理出现故障。虽然已经提交了批处理，但是该批处理的某个成员至少发生了一个异常。使用+getNextException()+来检索已经过批处理的特定元素的异常。+ERRORCODE%3D-4228%2C+SQLSTATE%3Dnull

 

[客户端]再经过unescape之后：PreparedStatementCallback; SQL [insert into OBS.RSP_PRJ(RSP_PRJ_CODE, RSP_PRJ_NAME, BRANCH_ID, BRANCH_NAME, BRANCH_PATH, RSP_PRJ_REQ, RSP_FREQ, RSP_TIMES, DUE_DATE, RES_POS_REQ, RSP_PRJ_STATUS, CREATE_USER, CREATE_TIME, UPDATE_USER, UPDATE_TIME) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'CREATED', ?, ?, ?, ?)]; [jcc][t4][102][10040][3.52.95] 非自动批处理出现故障。虽然已经提交了批处理，但是该批处理的某个成员至少发生了一个异常。\r\n使用 getNextException() 来检索已经过批处理的特定元素的异常。 ERRORCODE=-4228, SQLSTATE=null; nested exception is com.ibm.db2.jcc.a.cn: [jcc][t4][102][10040][3.52.95] 非自动批处理出现故障。虽然已经提交了批处理，但是该批处理的某个成员至少发生了一个异常。\r\n使用 getNextException() 来检索已经过批处理的特定元素的异常。 ERRORCODE=-4228, SQLSTATE=null