{"id":99665,"date":"2020-04-18T14:04:03","date_gmt":"2020-04-18T06:04:03","guid":{"rendered":"http:\/\/4563.org\/?p=99665"},"modified":"2020-04-18T14:04:03","modified_gmt":"2020-04-18T06:04:03","slug":"%e6%95%91%e4%ba%ba%e4%b8%80%e5%91%bd%e8%83%9c%e9%80%a0%e4%b8%83%e7%ba%a7%e6%b5%ae%e5%b1%a0%ef%bc%8c%e8%bf%99%e4%b8%aa%e5%93%a5%e5%93%a5%e4%bb%ac%e6%95%91%e6%88%91-sqlmybatisdruid","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=99665","title":{"rendered":"\u6551\u4eba\u4e00\u547d\u80dc\u9020\u4e03\u7ea7\u6d6e\u5c60\uff0c\u8fd9\u4e2a\u54e5\u54e5\u4eec\u6551\u6211-sql`mybatis`druid"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  \u6551\u4eba\u4e00\u547d\u80dc\u9020\u4e03\u7ea7\u6d6e\u5c60\uff0c\u8fd9\u4e2a\u54e5\u54e5\u4eec\u6551\u6211-sql`mybatis`druid               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : sunziren <\/span>  <span><i><\/i> 64<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u95ee\u9898\uff1a\u540c\u4e00\u4e2a sql\uff0c\u653e\u5230 plsql \u6267\u884c\u6ca1\u95ee\u9898\uff0c\u653e\u5230\u9879\u76ee\u4e2d\u7528 mybstis \u5c31\u51fa\u4e0d\u6765\u3002 sql\uff1a select * from (select xn,qxdm,nj,xk,gxsj,nvl(cbbb,&#8217;null&#8217;)cbbb from jczd_gjjcxy) t pivot( max(t.cbbb) for xk in ( &#8216;\u9053\u5fb7\u4e0e\u6cd5\u5236&#8217; as cnt1, &#8216;\u8bed\u6587&#8217; as cnt2, &#8216;\u6570\u5b66&#8217; as cnt3, &#8216;\u97f3\u4e50&#8217; as cnt4, &#8216;\u7f8e\u672f&#8217; as cnt5, &#8216;\u79d1\u5b66&#8217; as cnt6, &#8216;\u82f1\u8bed&#8217; as cnt7, &#8216;\u4e66\u6cd5&#8217; as cnt8, &#8216;\u4fe1\u606f\u6280\u672f&#8217; as cnt9 ) ) where 1=1 \u62a5\u9519\u5185\u5bb9\uff1a 1.Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual FOR pos 116, line 2, column 25, token FOR :\uff08\u4e0a\u9762\u7684 sql \uff09 2.uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, expect RPAREN, actual FOR pos 116, line 2, column 25, token FOR\uff1a\uff08\u4e0a\u9762\u7684 sql \uff09 3.com.alibaba.druid.sql.parser.ParserException: syntax error, expect RPAREN, actual FOR pos 116, line 2, column 25, token FOR \u8865\u5145\uff1a 1.\u6b63\u5e38 sql \u80fd\u5728\u9879\u76ee\u7528\uff0c\u5c31\u8fd9\u4e2a\u4e0d\u80fd\u518d\u9879\u76ee\u4e2d\u7528\uff0c\u4f46\u8fd9\u4e2a sql \u5728 plsql \u662f\u5b8c\u5168\u80fd\u6267\u884c\u7684\u3002 2.\u8fd9\u4e2a sql \u7528\u6765\u884c\u8f6c\u5217\u3002 3.\u5361\u5728\u8fd9\u4e00\u5929\u4e86\uff0c\u6551\u547d\u3002 4.\u5e2e\u5f97\u4e0a\u7684\u56de\u590d\u5fc5\u611f\u8c22<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>0<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>\u6551\u4eba\u4e00\u547d\u80dc\u9020\u4e03\u7ea7\u6d6e\u5c60\uff0c\u8fd9\u4e2a\u54e5\u54e5\u4eec\u6551&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/99665"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99665"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/99665\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99665"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}