{"id":895,"date":"2022-11-21T23:05:48","date_gmt":"2022-11-21T14:05:48","guid":{"rendered":"https:\/\/java.ihavenomoney.co.kr\/?page_id=895"},"modified":"2022-11-22T00:29:43","modified_gmt":"2022-11-21T15:29:43","slug":"java-oracle-where-11","status":"publish","type":"page","link":"https:\/\/java.ihavenomoney.co.kr\/?page_id=895","title":{"rendered":"java Oracle WHERE 1=1"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">remark : java  \ucffc\ub9ac \uc18c\uc2a4 \ubb38 \uc911\uac04\uc5d0 WHERE 1=1 \uac00 \uac00\ub054\uc529 \ubcf4\uc778\ub2e4.<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">and \ubb38 \uc5f0\uacb0\uc744  \uc870\uac74\ubb38 \uc5c6\uc774 \uc9c0\uc800\ubd84\ud558\uc9c0 \uc54a\uc740 \uc18c\uc2a4\ub97c \ub9cc\ub4e4\ub824\uace0 \ud558\ub294 \uae30\ubc95\uc774\ub2e4.<\/h3>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:java decode:true \">public class Hello {\n\n\tpublic static void main(String[] args) {\n\n\t\tString  first =\"1\";\n\t\tString  second =\"2\";\n\t\t\n\t\tStringBuffer sql = new StringBuffer();\n\n\t\tsql.append(\"\\n SELECT * \");\n\t\tsql.append(\"\\n FROM testTbl \");\n\t\tsql.append(\"\\n WHERE 1=1 \");\n\n\t\tif( first != null ){\n\t\t\tsql.append(\"\\n AND first = '1' \");\n\t\t}\n\t\tif( second != null ){\n\t\t\tsql.append(\"\\n AND second = '2' \");\n\t\t}\n\t\t\n\t\tSystem.out.println(sql.toString());\n\t}\n\n}<\/pre><\/div>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uacb0\uacfc<\/h3>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:java decode:true \"> SELECT * \n FROM testTbl \n WHERE 1=1 \n AND first = '1' \n AND second = '1' \n<\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>remark : java \ucffc\ub9ac \uc18c\uc2a4 \ubb38 \uc911\uac04\uc5d0 WHERE 1=1 \uac00 \uac00\ub054\uc529 \ubcf4\uc778\ub2e4. and \ubb38 \uc5f0\uacb0\uc744 \uc870\uac74\ubb38 \uc5c6\uc774 \uc9c0\uc800\ubd84\ud558\uc9c0 \uc54a\uc740 \uc18c\uc2a4\ub97c \ub9cc\ub4e4\ub824\uace0 \ud558\ub294 \uae30\ubc95\uc774\ub2e4. \uacb0\uacfc<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-895","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=895"}],"version-history":[{"count":2,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/895\/revisions"}],"predecessor-version":[{"id":911,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/895\/revisions\/911"}],"wp:attachment":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}