{"id":190,"date":"2016-10-27T08:43:24","date_gmt":"2016-10-27T08:43:24","guid":{"rendered":"http:\/\/www.hadooh.com\/?p=190"},"modified":"2016-10-28T01:09:34","modified_gmt":"2016-10-28T01:09:34","slug":"sequence-parameter-query-convert-to-named-parameter-query","status":"publish","type":"post","link":"https:\/\/www.hadooh.com\/?p=190","title":{"rendered":"sequence parameter query convert to named parameter query"},"content":{"rendered":"

\uc5b4\ub5a4 \ubbf8\uce5c\ucffc\ub9ac\uac19\uc740 \uacbd\uc6b0 \ubb3c\uc74c\ud45c \ud30c\ub77c\ubbf8\ud130\ub97c \uba87\uc2ed\uc5d0\uc11c \ubc31\uac1c\uc815\ub3c4\ub85c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\uac00 \uc788\ub294\ub370,\u00a0\ucffc\ub9ac\ub97c \ubd84\uc11d\ud558\uae30\uc5d0 \ubb34\uc9c0 \ud798\ub4e4\uc5b4\uc11c \ubb3c\uc74c\ud45c\ucffc\ub9ac\ub97c named\ucffc\ub9ac\ub85c \ubcc0\uacbd\ud574\uc8fc\ub294 jsp\ud398\uc774\uc9c0\ub97c \ub9cc\ub4e4\uc5c8\ub2e4.<\/p>\n

\uae30\ubcf8\uc18c\uc2a4\ub294 “\uae4c\uba39\uc9c0\ub9d0\uc790!(\uc774\uae00\ub8e8\uc2a4)” \u00a0\uad8c\ub0a8\ub2d8 \ube14\ub85c\uadf8\ub2d8\uc5d0\uac8c\uc11c \uac00\uc838\uc654\uc73c\uba70
\nhttp:\/\/egloos.zum.com\/kwon37xi\/v\/1897209<\/a>
\n\uc0ac\uc6a9\uc0c1 \ud3b8\uc758 \ub54c\ubb38\uc5d0 \ub098\ud55c\ud14c \ub9de\uac8c \uc870\uae08 \uc218\uc815\ud588\ub2e4.<\/p>\n

\"\ucffc\ub9ac\ud569\uce58\uae30\"<\/a><\/p>\n

JoinQuery.jsp
\n———————————————————————————————————<\/p>\n

<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\">\r\n<%@ page contentType=\"text\/html;charset=UTF-8\" pageEncoding=\"UTF-8\"%>\r\n<%@ page import=\"java.util.*\"%>\r\n<%!\r\n\/** \ud30c\ub77c\ubbf8\ud130 \uac1c\uc218 *\/\r\npublic static final int NUMBER_OF_PARAMS = 200;\r\n\r\n\/** \ucffc\ub9ac\uc640 \ud30c\ub77c\ubbf8\ud130 \ud569\uce58\uae30 *\/\r\npublic static String joinQuery(String query, String [] params, String [] isString) {\r\n    int currentIndex = query.indexOf('?');\r\n    if (currentIndex < 0) {\r\n        return query;\r\n    }\r\n    StringBuffer resultQuery = new StringBuffer(query.substring(0, currentIndex));\r\n\r\n    int countOfQuestionMark = getCountOfQuestionMark(query);\r\n    System.out.println(\"\ubb3c\uc74c\ud45c \uac1c\uc218 : \" + countOfQuestionMark);\r\n\r\n    for (int i = 0; i < countOfQuestionMark; i++) {\r\n        if (params[i] == null) {\r\n            resultQuery.append(\"NULL\");\r\n        } else if (isChecked(isString, i)) {\r\n            resultQuery.append(converToSqlString(params[i]));\r\n        } else {\r\n            resultQuery.append(params[i]);\r\n        }\r\n\r\n        if (i == countOfQuestionMark - 1) {\r\n            resultQuery.append(query.substring(currentIndex + 1));\r\n        } else {\r\n            int nextIndex = query.indexOf('?', currentIndex + 1);\r\n            resultQuery.append(query.substring(currentIndex + 1, nextIndex));\r\n            currentIndex = nextIndex;\r\n        }\r\n    }\r\n\r\n    return resultQuery.toString();\r\n}\r\n\r\n\/** \ubb38\uc790\uc5f4\ub85c \uc9c0\uc815\ub41c \uac83\uc778\uac00? *\/\r\npublic static boolean isChecked(String [] isString, int value) {\r\n    if (isString == null) {\r\n        return false;\r\n    }\r\n\r\n    String valueStr = String.valueOf(value);\r\n    for (int i=0; i < isString.length; i++) {\r\n        if (valueStr.equals(isString[i])) {\r\n            return true;\r\n        }\r\n    }\r\n    return false;\r\n}\r\n\r\n\/** \ubb38\uc790\uc5f4\uc5d0 \ub4e4\uc5b4 \uc788\ub294 ' \ub97c ''\ub85c \ubc14\uafbc\ub2e4. *\/\r\npublic static String converToSqlString(String str) {\r\n    return \"'\" + str.replaceAll(\"'\", \"''\") + \"'\";\r\n}\r\n\r\n\/** \ubb38\uc790\uc5f4\uc5d0 \ud3ec\ud568\ub41c ?\uc758 \uac1c\uc218 *\/\r\npublic static int getCountOfQuestionMark(String str) {\r\n    int count = 0;\r\n    int currentIndex = 0;\r\n    String temp = str;\r\n    while ((currentIndex = temp.indexOf(\"?\", currentIndex)) > 0) {\r\n        count++;\r\n        currentIndex++;\r\n    }\r\n\r\n    return count;\r\n}\r\n\r\n\/** HTML \ud2b9\uc218\ubb38\uc790 \ubcc0\ud658 *\/\r\npublic static String value(String str) {\r\n    if (str == null) {\r\n        return \"\";\r\n    }\r\n\r\n    String temp = str;\r\n    temp = temp.replaceAll(\"&\", \"&amp;\");\r\n    temp = temp.replaceAll(\"<\", \"&lt;\");\r\n    temp = temp.replaceAll(\">\", \"&gt;\");\r\n    temp = temp.replaceAll(\"\\\"\", \"&quot;\");\r\n    return temp;\r\n}\r\n\r\npublic static String value(String [] params, int index) {\r\n    if (params == null) {\r\n        return \"\";\r\n    } else if (index >= params.length) {\r\n        return \"\";\r\n    }\r\n\r\n    return value(params[index]);\r\n}\r\n%>\r\n\r\n<%\r\nrequest.setCharacterEncoding(\"UTF-8\");\r\n\r\nString query = request.getParameter(\"query\");\r\nString [] params = request.getParameterValues(\"params\");\r\nString [] isString = request.getParameterValues(\"isstring\");\r\n%>\r\n<html>\r\n    <head>\r\n        <title>\ucffc\ub9ac\uc640 \ud30c\ub77c\ubbf8\ud130 \ud569\uce58\uae30<\/title>\r\n        <style type=\"text\/css\">\r\n\t\t\thtml, body {\r\n\t\t\t\tmargin:0;\r\n\t\t\t\theight:100%;\r\n\t\t\t}\r\n\t\t\t#wrapper {\r\n\t\t\t\tmargin:0 auto;\r\n\t\t\t\twidth:100%;\r\n\t\t\t\theight:100%; \r\n\t\t\t}\r\n\t\t\t#resultArea {\r\n\t\t\t\theight:300px;\r\n\t\t\t\twidth:100%;\r\n\t\t\t\tbackground:red;\r\n\t\t\t}\r\n\t\t\t#leftArea {\r\n\t\t\t\tfloat:left;\r\n\t\t\t\twidth:900px;\r\n\t\t\t\tmin-height:100%;\r\n\t\t\t\tbackground:#FFD149;\r\n\t\t\t\tmargin-left: 5px;\r\n\t\t\t}\r\n\t\t\t#rightArea {\r\n\t\t\t\tmin-height:100%;\r\n\t\t\t\tbackground:#3EBAEB;\r\n\t\t\t\tborder-left:3px solid #000;\r\n\t\t\t}\r\n\t\t<\/style>\r\n    <\/head>\r\n    <body>\r\n    <script type=\"text\/javascript\">\r\n    function getParam(obj){\r\n    \tvar parameters = document.getElementById(\"parameters\");\r\n    \tvar lines = parameters.value.split(\"\\n\");\r\n\r\n    \tvar input_params = document.getElementsByName(\"params\");\r\n    \t\r\n    \tfor(var i=0;i<lines.length;i++){\r\n    \t\tinput_params[i].value = \":\"+lines[i].trim();\r\n    \t\t\r\n    \t}\r\n    }\r\n    <\/script>\r\n    <div id=\"wrapper\">\r\n\t    <div id=\"resultArea\">\r\n\t\t    <h1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;== \ucffc\ub9ac \ud569\uce58\uae30 ==<\/h1>\r\n\t\t    <%if (query != null && query.trim().length() > 0) { %>\r\n\t\t        <h2>\ucffc\ub9ac \ud569\uce5c \uacb0\uacfc<\/h2>\r\n\t\t        <textarea rows=\"15\" cols=\"120\" style=\"font-size: 12px;\"><%= joinQuery(query, params, isString) %><\/textarea>\r\n\t\t    <hr \/>\r\n\t\t    <%} %>\r\n\t    <\/div>\r\n\t    <form action=\"JoinQuery.jsp\" method=\"post\">\r\n\t\t        <div id=\"leftArea\">\r\n\t\t        \t<span>\uc544\ub798\uc5d0 PreparedStatement \ucffc\ub9ac \ubb38\uc7a5\uc744 \ub123\uc73c\uc138\uc694<\/span>\r\n\t\t        \t<textarea name=\"query\" rows=\"40\" cols=\"120\" style=\"font-size: 12px;\"><%=value(query)%><\/textarea>\r\n\t\t        <\/div>\r\n\t\t        <div id=\"rightArea\"><span>\uc544\ub798\uc5d0 \ud30c\ub77c\ubbf8\ud130 \ubaa9\ub85d\uc744 \ub123\uc73c\uc138\uc694<\/span><input type=\"submit\" value=\"\ud569\uce58\uae30\" \/>\r\n\t\t        \t<textarea id=\"parameters\" rows=\"40\" cols=\"30\" style=\"font-size: 12px;\" onchange=\"getParam()\"><\/textarea>\r\n\t\t\t        <div id=\"inputDiv\" style=\"visibility: hidden;\">\r\n\t\t\t\t        <%for (int i=0; i < NUMBER_OF_PARAMS; i++) { %>\r\n\t\t\t\t            <input style=\"font-size: 12px;\" name=\"isstring\" type=\"checkbox\" value=\"<%=i%>\" <%=isChecked(isString, i) ? \"checked\" : \"\" %> \/> \ubb38\uc790\ud615?\r\n\t\t\t\t            <input style=\"font-size: 12px;\" name=\"params\" type=text\" width=\"120\" size=\"120\" value=\"<%=value(params, i)%>\"\/>\r\n\t\t\t\t            <br \/>\r\n\t\t\t\t        <%} %>\r\n\t\t\t\t    <\/div>\r\n\t\t        <\/div>\r\n\t    <\/form>\r\n    <\/div>\r\n    \r\n    <\/body>\r\n<\/html><\/pre>\n
———————————————————————————————————<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc5b4\ub5a4 \ubbf8\uce5c\ucffc\ub9ac\uac19\uc740 \uacbd\uc6b0 \ubb3c\uc74c\ud45c \ud30c\ub77c\ubbf8\ud130\ub97c \uba87\uc2ed\uc5d0\uc11c \ubc31\uac1c\uc815\ub3c4\ub85c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\uac00 \uc788\ub294\ub370,\u00a0\ucffc\ub9ac\ub97c \ubd84\uc11d\ud558\uae30\uc5d0 \ubb34\uc9c0 \ud798\ub4e4\uc5b4\uc11c \ubb3c\uc74c\ud45c\ucffc\ub9ac\ub97c named\ucffc\ub9ac\ub85c \ubcc0\uacbd\ud574\uc8fc\ub294 jsp\ud398\uc774\uc9c0\ub97c \ub9cc\ub4e4\uc5c8\ub2e4. \uae30\ubcf8\uc18c\uc2a4\ub294 “\uae4c\uba39\uc9c0\ub9d0\uc790!(\uc774\uae00\ub8e8\uc2a4)” \u00a0\uad8c\ub0a8\ub2d8 \ube14\ub85c\uadf8\ub2d8\uc5d0\uac8c\uc11c \uac00\uc838\uc654\uc73c\uba70 http:\/\/egloos.zum.com\/kwon37xi\/v\/1897209 \uc0ac\uc6a9\uc0c1 \ud3b8\uc758 \ub54c\ubb38\uc5d0 \ub098\ud55c\ud14c \ub9de\uac8c \uc870\uae08 \uc218\uc815\ud588\ub2e4. JoinQuery.jsp ——————————————————————————————————— <!DOCTYPE html PUBLIC “-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN” “http:\/\/www.w3.org\/TR\/html4\/loose.dtd”> <%@ page contentType=”text\/html;charset=UTF-8″ pageEncoding=”UTF-8″%> <%@ page import=”java.util.*”%> <%! \/** \ud30c\ub77c\ubbf8\ud130 \uac1c\uc218 *\/ public static … Continue reading sequence parameter query convert to named parameter query<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/190"}],"collection":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=190"}],"version-history":[{"count":11,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/190\/revisions"}],"predecessor-version":[{"id":203,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/190\/revisions\/203"}],"wp:attachment":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}