{"id":2837,"date":"2009-03-30T07:20:38","date_gmt":"2009-03-30T07:20:38","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84\/"},"modified":"2015-02-10T21:12:16","modified_gmt":"2015-02-10T12:12:16","slug":"jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84","status":"publish","type":"post","link":"https:\/\/www.happyfam.or.kr\/ysoh\/jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84\/","title":{"rendered":"JDBC \ub4dc\ub77c\uc774\ubc84"},"content":{"rendered":"

JSP\uc640 MySQL\uc744 \uc5f0\ub3d9\ud558\ub824\uba74 \uc6b0\uc120 MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \ub2e4\uc6b4 \ubc1b\uc544\uc57c \ud55c\ub2e4. MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\ub294 http:\/\/www.mysql.com \uc811\uc18d \ud6c4 Downloads \uba54\ub274\ub97c \ud074\ub9ad\ud558\uc5ec \ub2e4\uc6b4\ubc1b\uc744 \uc218 \uc788\ub2e4. <\/p>\n

\"\uc0ac\uc6a9\uc790

http:\/\/www.mysql.com<\/p><\/div>
Downloads \uba54\ub274 \ud074\ub9ad \ud6c4 \ub098\ud0c0\ub098\ub294 \ud654\uba74\uc5d0\uc11c \uc88c\uce21\uc758 Connectors \ud56d\ubaa9\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790

Connector \ud56d\ubaa9<\/p><\/div>
Connector \ud56d\ubaa9\uc744 \ud074\ub9ad\ud558\uba74 \uc11c\ube0c \ud56d\ubaa9\uc774 \ub098\ud0c0\ub098\ub294\ub370 \uc5ec\uae30\uc11c Connector\/J \ud56d\ubaa9\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790

Connector\/J \ud56d\ubaa9<\/p><\/div>
\ud770 \ubc14\ud0d5\ud654\uba74 \uc6b0\uce21\uc5d0\uc11c Source ans Binaries (zip) \uc758 Download\ub97c \ud074\ub9ad\ud558\uba74 MySQL \uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \ubc1b\uc744 \uc218 \uc788\ub2e4. \ub9cc\uc57d Download \ud56d\ubaa9\uc774 \uc5c6\ub2e4\uba74 Pick a mirror \ud56d\ubaa9\uc744 \ud074\ub9ad\ud55c \ud6c4 \ud0dc\uadf9\uae30\uac00 \ud45c\uc2dc\ub418\ub294 \ubbf8\ub7ec\uc0ac\uc774\ud2b8\ub97c \ud074\ub9ad\ud558\uba74 \ub2e4\uc6b4\ub3c4\ub4dc \ubc1b\uc744 \uc218 \uc788\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790

MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84 <\/p><\/div>
\ud30c\uc77c \ub2e4\uc6b4\ub85c\ub4dc \ucc3d\uc774 \ub728\uba74 \uc801\ub2f9\ud55c \ud3f4\ub354\ub97c \uc9c0\uc815\ud55c \ud6c4 \uc800\uc7a5\uc744 \ud55c\ub2e4\uc74c \uc555\ucd95\ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9 \uc800\uc7a5 \ud30c\uc77c\uc744 \uc5f0\ub2e4. \uc5ec\uae30\uc11c\ub294 \uc5f4\uae30 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ub2e4\uc6b4\ub85c\ub4dc\uc640 \ub3d9\uc2dc\uc5d0 \ubc14\ub85c \uc555\ucd95\ud504\ub85c\uadf8\ub7a8(\uc54c\uc9d1) \ud504\ub85c\uadf8\ub7a8\uc774 \uc2e4\ud589\ub418\ub3c4\ub85d \ud558\uc600\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790

mysql-connector-java-5.1.7-bin.jar \ub2e4\uc6b4\ub85c\ub4dc<\/p><\/div>
\ub2e4\uc6b4\ub85c\ub4dc\uac00 \uc644\ub8cc\ub418\uba74 \uc54c\uc9d1\uacfc \uac19\uc740 \uc555\ucd95\ud504\ub85c\uadf8\ub7a8\uc774 \uc2e4\ud589\ub41c\ub2e4. \uc5ec\uae30\uc11c \uc88c\uce21 \uba54\ub274\ub97c \ud074\ub9ad\ud558\uc5ec “mysql-connector-java-5.1.7-bin.jar” \ud30c\uc77c\uc774 \uc800\uc7a5\ub41c \ud3f4\ub354\ub97c \ucc3e\ub294\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790

\uc54c\uc9d1\uc73c\ub85c mysql-connector-java-5.1.7-bin.jar\uc744 \ud655\uc778\ud55c \ub0b4\uc6a9<\/p><\/div>
\uc774\ud074\ub9bd\uc2a4\ub97c \uc774\uc6a9 JSP \ud504\ub85c\uadf8\ub7a8\uc744 \uac1c\ubc1c\ud560 \ub54c \uc2e4\ud589\uc5d0 \ud544\uc694\ud55c \uc790\ubc14 \ud074\ub798\uc2a4 \ud30c\uc77c\ub4e4\uc740 “\ud504\ub85c\uc81d\ud2b8 – WEB-INF – lib”\uc5d0 \uc800\uc7a5\ub3fc\uc57c \ud55c\ub2e4. \ub530\ub77c\uc11c \uc774\ud074\ub9bd\uc2a4\ub97c \uc2e4\ud589\ud558\uc5ec \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c “WebContent – WEB-INF” \ud3f4\ub354\ub97c \ucc3e\uc544 \uadf8 \uc544\ub798 “lib”\ub77c\ub294 \ud3f4\ub354\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud55c\ub2e4. \uc774\ub97c \uc704\ud574 “WEB-INF” \uc704\uc5d0\uc11c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ub2e4\uc74c \uadf8\ub9bc\uacfc \uac19\uc774 “New -> Folder” \ud56d\ubaa9\uc744 \uc120\ud0dd\ud55c\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790

JDBC \ub4dc\ub77c\uc774\ubc84\uac00 \uc704\uce58\ud560 \ud3f4\ub354 \ub9cc\ub4e4\uae30<\/p><\/div>
“New Folder” \ucc3d\uc774 \ub728\uba74 “Folder Name”\uc5d0 “lib”\ub97c \uc785\ub825\ud558\uace0 “Finish” \uba54\ub274\ub97c \ud074\ub9ad\ud55c\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790

WEB-INF\uc5d0 lib \ud3f4\ub354 \ub9cc\ub4e4\uae30<\/p><\/div>
\uc774\ud074\ub9bd\uc2a4\uc5d0\uc11c “lib” \ud3f4\ub354\uac00 \ub9cc\ub4e4\uc5b4\uc9c4 \uac83\uc774 \ud655\uc778\ub410\uc73c\uba74 \uc54c\uc9d1\uc5d0 \uc555\ucd95\ub41c “mysql-connector-java-5.1.7-bin.jar” \ud30c\uc77c\uc744 \ucc3e\uc544 “lib” \ud3f4\ub354\uc5d0 \ub4dc\ub798\uadf8\uc564\ub4dc\ub86d \ub4f1\uc744 \uc774\uc6a9\ud574 \ubcf5\uc0ac\ud55c\ub2e4. \uc774\ub85c\uc368 JSP\uc640 MySQL \uc0ac\uc774\uc758 \uc5f0\ub3d9\uc774 \uac00\ub2a5\ud574\uc84c\ub2e4.
 

\"\uc0ac\uc6a9\uc790

WEB-INF \uc548\uc758 lib \ud3f4\ub354\uc5d0 JDBC \ub4dc\ub77c\uc774\ubc84 \ubcf5\uc0ac\ud558\uae30<\/p><\/div>
MySQL \uc0ac\uc6a9\uc790 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uadf8\ub9ac\uace0 MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\uac00 \uc62c\ubc14\ub974\uac8c \uc124\uce58 \ub418\uc5c8\ub294\uc9c0\ub97c \ud655\uc778\ud558\uae30 \uc704\ud574 \ub2e4\uc74c \ud504\ub85c\uadf8\ub7a8 “mysqlConn.jsp”\ub97c \uc785\ub825\ud558\uc5ec \uc2e4\ud589\ud574 \ubcf8\ub2e4. \uc2e4\ud589 \uacb0\uacfc \uc544\ubb34\ub7f0 \uba54\uc138\uc9c0\ub3c4 \ucd9c\ub825\ub418\uc9c0 \uc54a\uc558\ub2e4\uba74 \uc62c\ubc14\ub974\uac8c \uc124\uce58\ub41c \uac83\uc774\ub2e4.<\/p>\n

<%@ page language=”java” contentType=”text\/html; charset=EUC-KR”
    pageEncoding=”EUC-KR”%>
<%@ page import = “java.sql.*” %>
<!DOCTYPE html PUBLIC “-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN”
“http:\/\/www.w3.org\/TR\/html4\/loose.dtd”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text\/html; charset=EUC-KR”>
<title>Insert title here<\/title>
<\/head>
<body>
<%
Class.forName(“com.mysql.jdbc.Driver”);<\/p>\n

Connection conn = null;<\/p>\n

String url = “jdbc:mysql:\/\/localhost:3306\/jsp?user=jsp&password=your_password”;
conn = DriverManager.getConnection(url);
conn.close();
%>
<\/body>
<\/html><\/div>\n

\"\uc0ac\uc6a9\uc790

mysqlConn.jsp \uc2e4\ud589\uacb0\uacfc<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

JSP\uc640 MySQL\uc744 \uc5f0\ub3d9\ud558\ub824\uba74 \uc6b0\uc120 MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \ub2e4\uc6b4 \ubc1b\uc544\uc57c \ud55c\ub2e4. MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\ub294 http:\/\/www.mysql.com \uc811\uc18d \ud6c4 Downloads \uba54\ub274\ub97c \ud074\ub9ad\ud558\uc5ec \ub2e4\uc6b4\ubc1b\uc744 \uc218 \uc788\ub2e4. Downloads \uba54\ub274 \ud074\ub9ad \ud6c4 \ub098\ud0c0\ub098\ub294 \ud654\uba74\uc5d0\uc11c \uc88c\uce21\uc758 Connectors \ud56d\ubaa9\uc744 \ud074\ub9ad\ud55c\ub2e4. Connector \ud56d\ubaa9\uc744 \ud074\ub9ad\ud558\uba74 \uc11c\ube0c \ud56d\ubaa9\uc774 \ub098\ud0c0\ub098\ub294\ub370 \uc5ec\uae30\uc11c Connector\/J \ud56d\ubaa9\uc744 \ud074\ub9ad\ud55c\ub2e4. \ud770 \ubc14\ud0d5\ud654\uba74 \uc6b0\uce21\uc5d0\uc11c Source ans Binaries (zip) \uc758 Download\ub97c \ud074\ub9ad\ud558\uba74 MySQL \uc6a9 JDBC\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":2838,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[242],"tags":[27,28,34],"class_list":["post-2837","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-java","tag-java","tag-jdbc","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile22.uf.121B2A0B4A9A0E97216884.png?fit=585%2C693&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-JL","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/comments?post=2837"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2837\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media\/2838"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=2837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=2837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=2837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}