{"id":2870,"date":"2009-06-09T12:00:41","date_gmt":"2009-06-09T12:00:41","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84%ec%99%80-%ed%95%9c%ea%b8%80-%ea%b9%a8%ec%a7%90-%ed%95%b4%ea%b2%b0\/"},"modified":"2015-02-10T21:12:15","modified_gmt":"2015-02-10T12:12:15","slug":"jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84%ec%99%80-%ed%95%9c%ea%b8%80-%ea%b9%a8%ec%a7%90-%ed%95%b4%ea%b2%b0","status":"publish","type":"post","link":"https:\/\/www.happyfam.or.kr\/ysoh\/jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84%ec%99%80-%ed%95%9c%ea%b8%80-%ea%b9%a8%ec%a7%90-%ed%95%b4%ea%b2%b0\/","title":{"rendered":"JDBC \ub4dc\ub77c\uc774\ubc84\uc640 \ud55c\uae00 \uae68\uc9d0 \ud574\uacb0"},"content":{"rendered":"

JSP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \uc774\uc6a9 \ud3fc\uc73c\ub85c \ubd80\ud130 POST \uba54\uc18c\ub4dc\ub85c \uc804\ub2ec\ub41c \ud55c\uae00 \ub370\uc774\ud130\ub97c Insert \ud560 \ub54c \ud55c\uae00\uc774 \uae68\uc9c4\ub2e4\uba74 \ud398\uc774\uc9c0 \ubb38\uc790\uc14b\uc744 \uace0\ub824\ud558\uc5ec \uc5f0\uacb0 URL\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc9c0\uc815\ud55c\ub2e4. \uadf8\ub7ec\uba74 \ud55c\uae00\uc774 \uae68\uc9c0\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\ub97c \ud14c\uc774\ube14\uc5d0 \uc798 \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4. \ubb3c\ub860 request.setCharacterEncoding \uba54\uc18c\ub4dc\uc758 \ud30c\ub77c\uba54\ud130\ub3c4 \ubb38\uc790\uc14b\uc5d0 \ub9de\ub3c4\ub85d \uc62c\ubc14\ub974\uac8c \uc9c0\uc815\ud574\uc57c \ud558\uace0…<\/DIV>
\n
 <\/DIV>
\n
\ud398\uc774\uc9c0 \ubb38\uc790\uc14b\uc774 “EUC-KR” \uc778 \uacbd\uc6b0<\/DIV>
\n

\n

\n
request.setCharacterEncoding(“euc-kr<\/FONT><\/STRONG>“);<\/DIV>
\n
…<\/DIV>String jdbc_url = “jdbc:mysql:\/\/localhost:3306\/jsp_test?useUnicode=true&characterEncoding=euckr<\/FONT><\/STRONG>“;<\/DIV><\/DIV>
\n


\ud398\uc774\uc9c0 \ubb38\uc790\uc14b\uc774 “UTF-8” \uc778 \uacbd\uc6b0<\/DIV>
\n

\n

\n
request.setCharacterEncoding(“utf-8<\/FONT><\/STRONG>“);<\/DIV>
\n
…<\/DIV>
\n
String jdbc_url = “jdbc:mysql:\/\/localhost:3306\/jsp_test?useUnicode=true&characterEncoding=utf8<\/FONT><\/STRONG>“;<\/DIV><\/DIV><\/DIV>
\n

\ub9cc\uc57d MySQL \uc11c\ubc84\uac00 4.x \uae4c\uc9c0\uc758 \ubc84\uc804 \uc774\ub77c\uba74 URL\uc5d0\uc11c “euckr”\uacfc “utf8” \ubd80\ubd84\uc744 \uac01\uac01 “euc-kr”, “utf-8″\ub85c \ubc14\uafd4\uc918\uc57c \ud55c\ub2e4.

\uc544\ub798 \uc608\uc81c \ud504\ub85c\uadf8\ub7a8\uc744 \ucc38\uc870\ud558\uc790.

\ud398\uc774\uc9c0 \ubb38\uc790\uc14b\uc774 “EUC-KR”\uc778 \uacbd\uc6b0.

form.html

\n
<!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<\/STRONG>“>
<title>Insert title here<\/title>
<\/head>
<body>
<form action=”regdb.jsp” method=”post”>
\uc774\ub984 : <input type=”text” name=”name” \/>
<input type=”submit” value=”\uc800\uc7a5” \/>
<\/form>
<\/body>
<\/html><\/DIV>
regdb.jsp

\n

\n
<%@ page language=”java” contentType=”text\/html; charset=EUC-KR<\/STRONG>“
    pageEncoding=”EUC-KR<\/STRONG>“%>
<%@ 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<\/STRONG>“>
<title>Insert title here<\/title>
<\/head>
<body>
<%
request.setCharacterEncoding(“euc-kr<\/STRONG>“);<\/DIV>
\n
Connection conn = null;
Statement stmt = null;<\/DIV>
\n
String jdbc_driver = “com.mysql.jdbc.Driver”;
String jdbc_url    = “jdbc:mysql:\/\/localhost:3306\/jsp_test?useUnicode=true&characterEncoding=euckr<\/STRONG>“;
String jdbc_user   = “jsp_test”;
String jdbc_pwd    = “jsp_test”;<\/DIV>
\n
String sql  = null;<\/DIV>
\n
String name = request.getParameter(“name”);<\/DIV>
\n
sql = “INSERT INTO member_euckr VALUES (‘” + name + “‘)”;<\/DIV>
\n
Class.forName(jdbc_driver);<\/DIV>
\n
conn = DriverManager.getConnection(jdbc_url, jdbc_user, jdbc_pwd);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
%>
<%= sql %><br>
\ub2f9\uc2e0\uc758 \uc774\ub984\uc740
<%= name %>
\uc785\ub2c8\ub2e4.
<\/body>
<\/html><\/DIV><\/DIV>

\ud398\uc774\uc9c0 \ubb38\uc790\uc14b\uc774 “UTF-8″\uc778 \uacbd\uc6b0.

form.html

\n
<!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=UTF-8<\/STRONG>“>
<title>Insert title here<\/title>
<\/head>
<body>
<form action=”regdb.jsp” method=”post”>
\uc774\ub984 : <input type=”text” name=”name” \/>
<input type=”submit” value=”\uc800\uc7a5” \/>
<\/form>
<\/body>
<\/html><\/DIV>
regdb.jsp

\n

\n
<%@ page language=”java” contentType=”text\/html; charset=UTF-8<\/STRONG>“
    pageEncoding=”UTF-8<\/STRONG>“%>
<%@ 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=UTF-8<\/STRONG>“>
<title>Insert title here<\/title>
<\/head>
<body>
<%
request.setCharacterEncoding(“utf-8<\/STRONG>“);<\/DIV>
\n
Connection conn = null;
Statement stmt = null;<\/DIV>
\n
String jdbc_driver = “com.mysql.jdbc.Driver”;
String jdbc_url    = “jdbc:mysql:\/\/localhost:3306\/jsp_test?useUnicode=true&characterEncoding=utf8<\/STRONG>“;
String jdbc_user   = “jsp_test”;
String jdbc_pwd    = “jsp_test”;<\/DIV>
\n
String sql  = null;<\/DIV>
\n
String name = request.getParameter(“name”);<\/DIV>
\n
sql = “INSERT INTO member_utf VALUES (‘” + name + “‘)”;<\/DIV>
\n
Class.forName(jdbc_driver);<\/DIV>
\n
conn = DriverManager.getConnection(jdbc_url,jdbc_user, jdbc_pwd);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
%>
<%= sql %><br>
\ub2f9\uc2e0\uc758 \uc774\ub984\uc740
<%= name %>
\uc785\ub2c8\ub2e4.
<\/body>
<\/html><\/DIV><\/DIV>

\uc704 \uc608\uc81c\uc5d0\uc11c \uc0ac\uc6a9\ub41c \ub450 \ud14c\uc774\ube14 member_euckr\uacfc member_utf\uc758 \uad6c\uc870\ub294 \uac01\uac01 \ub2e4\uc74c\uacfc \uac19\ub2e4.


\n
CREATE TABLE `member_euckr` (
  `name` varchar(20) NOT NULL
) DEFAULT CHARSET=euckr;<\/DIV>

\n
CREATE TABLE `member_utf` (
  `name` varchar(20) NOT NULL
) DEFAULT CHARSET=utf8;<\/DIV><\/DIV><\/p>\n","protected":false},"excerpt":{"rendered":"

JSP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c MySQL\uc6a9 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \uc774\uc6a9 \ud3fc\uc73c\ub85c \ubd80\ud130 POST \uba54\uc18c\ub4dc\ub85c \uc804\ub2ec\ub41c \ud55c\uae00 \ub370\uc774\ud130\ub97c Insert \ud560 \ub54c \ud55c\uae00\uc774 \uae68\uc9c4\ub2e4\uba74 \ud398\uc774\uc9c0 \ubb38\uc790\uc14b\uc744 \uace0\ub824\ud558\uc5ec \uc5f0\uacb0 URL\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc9c0\uc815\ud55c\ub2e4. \uadf8\ub7ec\uba74 \ud55c\uae00\uc774 \uae68\uc9c0\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\ub97c \ud14c\uc774\ube14\uc5d0 \uc798 \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4. \ubb3c\ub860 request.setCharacterEncoding \uba54\uc18c\ub4dc\uc758 \ud30c\ub77c\uba54\ud130\ub3c4 \ubb38\uc790\uc14b\uc5d0 \ub9de\ub3c4\ub85d \uc62c\ubc14\ub974\uac8c \uc9c0\uc815\ud574\uc57c \ud558\uace0…   \ud398\uc774\uc9c0 \ubb38\uc790\uc14b\uc774 “EUC-KR” \uc778 \uacbd\uc6b0 request.setCharacterEncoding(“euc-kr“); …String jdbc_url =\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_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}},"categories":[244],"tags":[28,29,34],"class_list":["post-2870","post","type-post","status-publish","format-standard","hentry","category-jsp","tag-jdbc","tag-jsp","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-Ki","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2870","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=2870"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2870\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=2870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=2870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=2870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}