{"id":545,"date":"2011-05-31T18:24:02","date_gmt":"2011-05-31T09:24:02","guid":{"rendered":"https:\/\/www.jaswill.co.jp\/blog\/2011\/05\/31\/preparedstatement\/"},"modified":"2011-05-31T18:24:02","modified_gmt":"2011-05-31T09:24:02","slug":"preparedstatement","status":"publish","type":"post","link":"https:\/\/www.jaswill.co.jp\/blog\/2011\/05\/31\/preparedstatement\/","title":{"rendered":"PreparedStatement\u3067\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u3092\u542b\u3080\u6587\u5b57\u5217\u3092\u691c\u7d22\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<p>\u3053\u3093\u3070\u3093\u306f\u3002kinoko\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u4eca\u3001Java\uff08Servlet\u3084JSP\u306a\u3069\uff09\u306b\u3064\u3044\u3066\u52c9\u5f37\u4e2d\u306a\u306e\u3067\u3059\u304c\u3001PreparedStatement\u3067 &#8216;?&#8217; \u3092\u4f7f\u3063\u3066\u30d1\u30e9\u30e1\u30fc\u30bf\u30af\u30a8\u30ea\u3092\u767a\u884c\u3059\u308b\u3068\u304d\u306b\u3001\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u3092\u542b\u3080\u6587\u5b57\u5217\u3092\u76f4\u63a5\u30a8\u30b9\u30b1\u30fc\u30d7\u3057\u3066\u691c\u7d22\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u305b\u3093\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>PreparedStatement pstmt = conn.prepareStatement(&#8220;select * from&nbsp;hogehoge where hoge <span class=\"highlight\">like<\/span> ? {escape &#8216;\\\\&#8217;}&#8221;);<\/p>\n<p>\u3053\u308c\u306f\u51fa\u6765\u306a\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u305d\u3053\u3067\u3001\u81ea\u4f5c\u95a2\u6570\u3092\u4f7f\u3063\u3066\u4e00\u6587\u5b57\u305a\u3064\u7f6e\u63db\u3059\u308b\u65b9\u6cd5\u3067\u89e3\u6c7a\u3057\u305f\u306e\u3067\u3001\u899a\u3048\u66f8\u304d\u3002<\/p>\n<p>\/\/ SQL\u6587\u51fa\u529b\u7528\u306b &#8216;%&#8217; \u3068 &#8216;_&#8217; \u306e\u7f6e\u63db\u3092\u884c\u3046<br \/>&nbsp;private String EscapeSQL(String input) {<br \/>&nbsp;&nbsp;input = SQLescape(input, &#8220;%&#8221;, &#8220;<a href=\"\/\/\\\\%\">\\\\%<\/a>&#8220;);<br \/>&nbsp;&nbsp;input = SQLescape(input, &#8220;_&#8221;, &#8220;\\\\_&#8221;);<br \/>&nbsp;&nbsp;return input;<br \/>&nbsp;}<\/p>\n<p>public String SQLescape(String input, String pattern, String replacement) {<br \/>&nbsp;&nbsp;\/\/\u7f6e\u63db\u5bfe\u8c61\u6587\u5b57\u306eindex\u3092\u53d6\u5f97\u3057\u3001\u306a\u3051\u308c\u3070\u4f55\u3082\u305b\u305a\u306b\u623b\u3059<br \/>&nbsp;&nbsp;int index = input.indexOf(pattern);<br \/>&nbsp;&nbsp;if(index == -1) {<br \/>&nbsp;&nbsp;&nbsp;return input;<br \/>&nbsp;&nbsp;}<br \/>&nbsp;&nbsp;StringBuffer buffer = new StringBuffer();<br \/>&nbsp;&nbsp;buffer.append(input.substring(0, index) + replacement);<br \/>&nbsp;&nbsp;if(index + pattern.length() &lt; input.length()) {<br \/>&nbsp;&nbsp;&nbsp;String rest = input.substring(index + pattern.length(), input.length());<br \/>&nbsp;&nbsp;&nbsp;buffer.append(SQLescape(rest, pattern, replacement));<br \/>&nbsp;&nbsp;}<br \/>&nbsp;&nbsp;return buffer.toString();<br \/>&nbsp;}<\/p>\n<p>&nbsp;<\/p>\n<p>\u3084\u3063\u3071\u308a\u3001SQL\u3063\u3066\u96e3\u3057\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u3070\u3093\u306f\u3002kinoko\u3067\u3059\u3002 &nbsp; \u4eca\u3001Java\uff08Servlet\u3084JSP\u306a\u3069\uff09\u306b\u3064\u3044\u3066\u52c9\u5f37\u4e2d\u306a\u306e\u3067\u3059\u304c\u3001PreparedStatement\u3067 &#8216;?&#8217; \u3092\u4f7f\u3063\u3066\u30d1\u30e9\u30e1\u30fc\u30bf\u30af\u30a8\u30ea\u3092\u767a\u884c\u3059\u308b\u3068\u304d\u306b\u3001\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u3092\u542b\u3080\u6587\u5b57\u5217\u3092\u76f4\u63a5\u30a8\u30b9\u30b1\u30fc\u30d7\u3057\u3066\u691c\u7d22\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u305b\u3093\u3002  [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[488],"tags":[],"class_list":["post-545","post","type-post","status-publish","format-standard","hentry","category-it"],"views":64,"_links":{"self":[{"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/posts\/545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/comments?post=545"}],"version-history":[{"count":0,"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/posts\/545\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/media?parent=545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/categories?post=545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jaswill.co.jp\/blog\/wp-json\/wp\/v2\/tags?post=545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}