{"id":65,"date":"2020-10-08T14:57:52","date_gmt":"2020-10-08T05:57:52","guid":{"rendered":"https:\/\/java.ihavenomoney.co.kr\/?p=65"},"modified":"2020-10-29T11:33:57","modified_gmt":"2020-10-29T02:33:57","slug":"jsp-%eb%94%94%eb%b9%84-%ec%97%b0%ea%b2%b0","status":"publish","type":"post","link":"https:\/\/java.ihavenomoney.co.kr\/?p=65","title":{"rendered":"[jsp] \ub514\ube44 \uc5f0\uacb0"},"content":{"rendered":"<pre class=\"lang:java decode:true \">&lt;%@ page language=\"java\" contentType=\"text\/html; charset=UTF-8\" pageEncoding=\"UTF-8\"%&gt;\r\n&lt;%@ page import = \"java.sql.DriverManager\" %&gt;\r\n&lt;%@ page import = \"java.sql.Connection\" %&gt;\r\n&lt;%@ page import = \"java.sql.PreparedStatement\" %&gt;\r\n&lt;%@ page import = \"java.sql.ResultSet\" %&gt;\r\n&lt;%@ page import = \"java.sql.SQLException\" %&gt;\r\n\r\n&lt;%\r\nString connectionURL = \"jdbc:mysql:\/\/***.***.***.***:3306\/IBE?characterEncoding=UTF-8&amp;serverTimezone=UTC\"; \r\n\r\nConnection connection = null; \r\nPreparedStatement pstmt = null;\r\nResultSet rs = null;\r\n\r\nString code = request.getParameter(\"code\"); \/\/Code\r\nif(code == null) code=\"\";\r\n\r\nString Decode = code;\r\n\r\ntry{\r\n\tif(code.length()==2){\r\n\t\tClass.forName(\"com.mysql.jdbc.Driver\").newInstance(); \r\n\t\tconnection = DriverManager.getConnection(connectionURL, \"****user\", \"*********\");\r\n\t    \r\n\t    String query =\"SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ? LIMIT 0, 1\";\r\n\t    \r\n\t    pstmt = connection.prepareStatement(query); \r\n\t    pstmt.setString(1,code);\r\n\t       \t\t\r\n\t    rs = pstmt.executeQuery();\r\n\t    \r\n\t\t    while(rs.next()){\r\n\t\t    \tDecode = rs.getString(\"airline_korean\");\r\n\t\t    }\r\n\t   \r\n\t\t    out.println(Decode);\r\n\t   \r\n    }else\t\r\n    \tout.println(code);\r\n\t\r\n}\r\ncatch(Exception ex){\r\n\tout.println(ex.toString());\r\n}finally{\r\n\tif(rs != null) try{rs.close();}catch(SQLException ex){}           \r\n\tif(pstmt != null) try{pstmt.close();}catch(SQLException ex){}   \r\n\tif(connection != null) try{connection.close();}catch(SQLException ex){}\r\n}\r\n%&gt;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-97 size-full\" src=\"https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/JSP_DB_connect.jpg\" alt=\"\" width=\"648\" height=\"414\" srcset=\"https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/JSP_DB_connect.jpg 648w, https:\/\/java.ihavenomoney.co.kr\/wp-content\/uploads\/2020\/10\/JSP_DB_connect-300x192.jpg 300w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&lt;%@ page language=&#8221;java&#8221; contentType=&#8221;text\/html; charset=UTF-8&#8243; pageEncoding=&#8221;UTF-8&#8243;%&gt; &lt;%@ page import = &#8220;java.sql.DriverManager&#8221; %&gt; &lt;%@ page import = &#8220;java.sql.Connection&#8221; %&gt; &lt;%@ page import = &#8220;java.sql.PreparedStatement&#8221; %&gt; &lt;%@ page import = &#8220;java.sql.ResultSet&#8221; %&gt; &lt;%@ page import = &#8220;java.sql.SQLException&#8221; %&gt; &lt;% String connectionURL = &#8220;jdbc:mysql:\/\/***.***.***.***:3306\/IBE?characterEncoding=UTF-8&amp;serverTimezone=UTC&#8221;; Connection connection = null; PreparedStatement pstmt = null; ResultSet rs = null; String code &hellip;<br \/><a href=\"https:\/\/java.ihavenomoney.co.kr\/?p=65\" class=\"more-link pen_button pen_element_default pen_icon_arrow_double\"><span class=\"screen-reader-text\">[jsp] \ub514\ube44 \uc5f0\uacb0<\/span> \ub354\ubcf4\uae30<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-65","post","type-post","status-publish","format-standard","hentry","category-jsp-"],"_links":{"self":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/65","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"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=65"}],"version-history":[{"count":7,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":318,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/318"}],"wp:attachment":[{"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/java.ihavenomoney.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}