{"id":5023,"date":"2017-12-28T17:37:21","date_gmt":"2017-12-28T08:37:21","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=5023"},"modified":"2020-05-28T14:12:03","modified_gmt":"2020-05-28T05:12:03","slug":"oracle-12c-%ec%84%a4%ec%b9%98-%ed%9b%84-%ea%b3%84%ec%a0%95-%ec%84%b1%ec%83%9d-%eb%b0%8f-jdbc-%ec%97%b0%ea%b2%b0-%ed%85%8c%ec%8a%a4%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=5023","title":{"rendered":"Oracle 12c \uc124\uce58 \ud6c4 \uacc4\uc815 \uc0dd\uc131 \ubc0f JDBC \uc5f0\uacb0 \ud14c\uc2a4\ud2b8"},"content":{"rendered":"<p>\uc624\ub77c\ud074 12c(12.2.0.1.0)\uc744 \uc124\uce58\ud558\uace0 \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uace0 \ud544\uc694\ud55c \uad8c\ud55c\uc744 \ubd80\uc5ec\ud55c \ud6c4 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud574 \uba87\uac00\uc9c0 \ub370\uc774\ud130\ub97c INSERT\ud574\uc11c \ucd5c\uc885\uc801\uc73c\ub85c JDBC\ub85c \uc5f0\uacb0\ud574 \ucffc\ub9ac\ub97c \ub0a0\ub824 \ub370\uc774\ud130\ub97c \ubc1b\ub294 \ud14c\uc2a4\ud2b8\ub97c \ud558\uace0 \uba87\uac00\uc9c0 \ub0b4\uc6a9\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \ucc38\uace0\ub85c \uc624\ub77c\ud074 12c\uc5d0\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uacf5\uac04 \ub370\uc774\ud130 \ucc98\ub9ac\ub97c \uc704\ud55c \uae30\ub2a5\uc774 \uac19\uc774 \uc124\uce58\uac00 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uc624\ub77c\ud074\uc744 \uc124\uce58\ud558\uace0 \ub2e4\uc74c \uba85\ub839\uc744 \ud1b5\ud574 \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uace0 \ud574\ub2f9 \uacc4\uc815\uc5d0 \ud544\uc694\ud55c \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4. Console \ucc3d\uc5d0\uc11c \uc2e4\ud589\ud55c \uacbd\uc6b0\uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">\r\n# sys \uacc4\uc815\uc73c\ub85c \uc811\uc18d\r\nsqlplus \/ as sysdba\r\n\r\n# \uacc4\uc815 \uc0dd\uc131(\ub85c\uceec \uc0ac\uc6a9\uc790\uac00 \uc544\ub2cc \uacf5\ud1b5 \uc0ac\uc6a9\uc790 \uc0dd\uc131\uc758 \uacbd\uc6b0 \ubc18\ub4dc\uc2dc c##\uc744 \ubd99\uc5ec\uc918\uc57c \ud568)\r\ncreate user c##dip2k identified by PASSWORD;\r\n\r\n# \uacc4\uc815 \uc7a0\uadfc \ud574\uc81c\r\nalter user c##dip2k account unlock;\r\n\r\n# \ub85c\uadf8\uc778 \ubc0f \ud14c\uc774\ube14 \uc0dd\uc131 \uad8c\ud55c \ubd80\uc5ec\r\ngrant connect, resource to c##dip2k\r\n\r\n# Tablespace \uad8c\ud55c \ubd80\uc5ec(INSERT \ubb38 \uc2e4\ud589 \uac00\ub2a5\ud558\ub3c4\ub85d \ud568)\r\nalter user c##dip2k default tablespace users quota unlimited on users;\r\n<\/pre>\n<p>\uc774\uc81c \ub2e4\uc2dc sqlplus\ub97c \uc2e4\ud589\ud574 \uc55e\uc11c \uc0dd\uc131\ud55c \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud558\uace0 test_mytable\uc774\ub77c\ub294 \uc774\ub984\uc758 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc624\ub77c\ud074\uc6a9 JDBC jar \ud30c\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uace0 \ub2e4\uc74c java \ucf54\ub4dc\ub97c \ud1b5\ud574 \uc5f0\uacb0\uc744 \ud14c\uc2a4\ud2b8\ud569\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">\r\npackage test_oracle_jdbc;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\n\r\npublic class MainEntry {\r\n    public static void main(String[] args) {\r\n        String URL = \"jdbc:oracle:thin:@127.0.0.1:1521:orcl\";\r\n        String USER = \"c##dip2k\";\r\n        String PASSWORD = \"PASSWORD\";\r\n        String query = \"SELECT * from test_mytable\";\r\n\t\t\r\n        Connection conn = null;\r\n        Statement stmt = null;\r\n        ResultSet rs = null;\r\n\t\t\r\n        try {\r\n            Class.forName(\"oracle.jdbc.driver.OracleDriver\");\r\n\t\t\t\r\n            conn = DriverManager.getConnection(URL, USER, PASSWORD);\r\n            stmt = conn.createStatement();\r\n            rs = stmt.executeQuery(query);\r\n\t\t\t\r\n            while(rs.next()) {\r\n                String v = rs.getString(1);\r\n\t\t\t\t\r\n                System.out.println(v);\r\n            }\r\n        } catch(Exception e) {\r\n            e.printStackTrace();\r\n        } finally {\r\n            try {\r\n                if(rs != null) rs.close();\r\n                if(stmt != null) stmt.close();\r\n                if(conn != null) conn.close();\r\n            } catch(SQLException e) {}\r\n        }\r\n    }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub77c\ud074 12c(12.2.0.1.0)\uc744 \uc124\uce58\ud558\uace0 \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uace0 \ud544\uc694\ud55c \uad8c\ud55c\uc744 \ubd80\uc5ec\ud55c \ud6c4 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud574 \uba87\uac00\uc9c0 \ub370\uc774\ud130\ub97c INSERT\ud574\uc11c \ucd5c\uc885\uc801\uc73c\ub85c JDBC\ub85c \uc5f0\uacb0\ud574 \ucffc\ub9ac\ub97c \ub0a0\ub824 \ub370\uc774\ud130\ub97c \ubc1b\ub294 \ud14c\uc2a4\ud2b8\ub97c \ud558\uace0 \uba87\uac00\uc9c0 \ub0b4\uc6a9\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \ucc38\uace0\ub85c \uc624\ub77c\ud074 12c\uc5d0\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uacf5\uac04 \ub370\uc774\ud130 \ucc98\ub9ac\ub97c \uc704\ud55c \uae30\ub2a5\uc774 \uac19\uc774 \uc124\uce58\uac00 \ub429\ub2c8\ub2e4. \uc624\ub77c\ud074\uc744 \uc124\uce58\ud558\uace0 \ub2e4\uc74c \uba85\ub839\uc744 \ud1b5\ud574 \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uace0 \ud574\ub2f9 \uacc4\uc815\uc5d0 \ud544\uc694\ud55c \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4. Console \ucc3d\uc5d0\uc11c \uc2e4\ud589\ud55c \uacbd\uc6b0\uc785\ub2c8\ub2e4. # &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=5023\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;Oracle 12c \uc124\uce58 \ud6c4 \uacc4\uc815 \uc0dd\uc131 \ubc0f JDBC \uc5f0\uacb0 \ud14c\uc2a4\ud2b8&#8221;<\/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":[60],"tags":[],"class_list":["post-5023","post","type-post","status-publish","format-standard","hentry","category-java"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5023"}],"version-history":[{"count":8,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5023\/revisions"}],"predecessor-version":[{"id":9638,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5023\/revisions\/9638"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5023"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}