{"id":2848,"date":"2009-03-30T07:55:00","date_gmt":"2009-03-30T07:55:00","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-jsp%ec%99%80-mysql-%ec%97%b0%eb%8f%99\/"},"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%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-jsp%ec%99%80-mysql-%ec%97%b0%eb%8f%99","status":"publish","type":"post","link":"https:\/\/www.happyfam.or.kr\/ysoh\/jdbc-%eb%93%9c%eb%9d%bc%ec%9d%b4%eb%b2%84%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-jsp%ec%99%80-mysql-%ec%97%b0%eb%8f%99\/","title":{"rendered":"JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \uc774\uc6a9\ud55c JSP\uc640 MySQL \uc5f0\ub3d9"},"content":{"rendered":"

\uc6b0\ub9ac\ub294 \uc55e\uc11c MySQL\uc758 \uae30\ubcf8 \uc0ac\ud56d\uc5d0 \ub300\ud574 \ubc30\uc6b8 \ub54c “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\ub97c \ud1b5\ud574 “mysql” \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc744 \uc2e4\ud589\ud568\uc73c\ub85c\uc368 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\uace0 \uba87\uba87 \ub370\uc774\ud130 \uc870\uc791\uc744 \uc704\ud55c \uba85\ub839\uc744 \uc2e4\ud589\ud558\uc600\ub2e4. \uc774 \uacfc\uc815\uc740 \ud06c\uac8c \ub124 \uac00\uc9c0 \ub2e8\uacc4\ub85c \ub098\ub204\uc5b4 \uc0dd\uac01\ud560 \uc218 \uc788\ub2e4. <\/p>\n

<\/div>\n
\uba3c\uc800 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub85c\uc758 \uc5f0\uacb0 \ub2e8\uacc4\uc774\ub2e4. \uc774 \ub2e8\uacc4\ub294 “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc744 \uc2e4\ud589\ud558\uace0 \uc554\ud638\ub97c \uc785\ub825\ud568\uc73c\ub85c\uc368 \uc774\ub8e8\uc5b4\uc9c4\ub2e4.<\/div>\n
<\/div>\n
\n
mysql  -u  jsp  -p<\/div>\n<\/div>\n
<\/div>\n
\uc774 \uba85\ub839\uc740  \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 “jsp”\uac00 \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9 \uc11c\ubc84\uc5d0 \uc5f0\uacb0 \ub370\uc774\ud130 \uc870\uc791\uc744 \ud560 \uc218 \uc788\ub3c4\ub85d \ud55c\ub2e4. \uc774 \ub54c \uc11c\ubc84\uc640\uc758 \uc5f0\uacb0\uc744 \uc704\ud574 \uc8fc\uc5b4\uc9c0\ub294 \uc815\ubcf4\ub294 \uc138 \uac00\uc9c0\ub2e4. \uccab \uc9f8 \uc0ac\uc6a9\uc790\uc544\uc774\ub514, \ub458 \uc9f8 \ube44\ubc00\ubc88\ud638, \uadf8\ub9ac\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uac00 \uc2e4\ud589\ub418\uace0 \uc788\ub294 \ucef4\ud4e8\ud130 \uc815\ubcf4\ub2e4. \uc704 \uba85\ub839\uc5d0\uc11c \ucef4\ud4e8\ud130 \uc815\ubcf4\ub294 \uc8fc\uc5b4\uc9c0\uc9c0 \uc54a\uc558\uc9c0\ub9cc \uc2e4\uc81c\ub85c\ub294 “-h” \uc635\uc158 \ub4a4\uc5d0 \ub3c4\uba54\uc778\ub124\uc784 \ub610\ub294 IP \uc8fc\uc18c\uc640 \uac19\uc740 \ucef4\ud4e8\ud130 \uc774\ub984\uc744 \uc904 \uc218 \uc788\uc73c\uba70 \uc774 \uc635\uc158\uc774 \uc0dd\ub7b5\ub418\uba74 “-h localhost”\uac00 \uc8fc\uc5b4\uc9c4 \uac83\uacfc \ub3d9\uc77c\ud558\ub2e4. \ub530\ub77c\uc11c \uc704 \uba85\ub839\uc740<\/div>\n
<\/div>\n
\n
mysql  -u  jsp  -p  -h localhost<\/div>\n<\/div>\n
<\/div>\n
\uc640 \uac19\ub2e4.<\/div>\n
<\/div>\n
\ub458 \uc9f8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub85c\uc758 \uc5f0\uacb0\uc774 \uc644\ub8cc\ub418\uba74 \ub2e4\uc74c \uba85\ub839\uc744 \uc774\uc6a9 \uc0ac\uc6a9\ud558\uace0\uc790 \ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4.<\/div>\n
<\/div>\n
\n
use  jsp ;<\/div>\n<\/div>\n
\uc774 \uba85\ub839\uc740 MySQL \uc11c\ubc84\uac00 \uad00\ub9ac\ud558\uace0 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc911 “jsp” \ub97c \uc0ac\uc6a9\ud558\uaca0\ub2e4\ub294 \uc758\ubbf8\uc774\ub2e4. \ub9cc\uc57d \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud558\uc9c0 \uc54a\uace0 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \ub54c \ub9ce\uc740 \uacbd\uc6b0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc120\ud0dd\ub418\uc9c0 \uc54a\uc558\ub2e4\ub294 \uc624\ub958 \uba54\uc138\uc9c0\ub97c \ucd9c\ub825\ud55c\ub2e4.<\/div>\n
<\/div>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud55c \ud6c4\uc5d0\ub294 <\/div>\n
<\/div>\n
\n
SELECT, INSERT, DELETE, UPDATE, CREATE, DROP, ALTER<\/div>\n

 <\/p><\/div>\n

<\/div>\n
\ub4f1\uacfc \uac19\uc740 \ud55c \uac01\uc885 SQL \uba85\ub839\uc744 \uc2e4\ud589 \ub370\uc774\ud130\ub97c \uc870\uc791\ud55c\ub2e4.<\/div>\n
<\/div>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc870\uc791\uc774 \uc644\ub8cc\ub410\uc73c\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud074\ub77c\uc774\uc5b8\ud2b8\uc640 \uc11c\ubc84 \uc0ac\uc774\uc758 \uc5f0\uacb0\uc740 \ub04a\ub294\ub2e4. \uc774 \ucc98\ub7fc \uc5f0\uacb0, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd, \ucffc\ub9ac\uc2e4\ud589, \uc5f0\uacb0\uc885\ub8cc \ub124 \ub2e8\uacc4 \uacfc\uc815\uc774 \ud558\ub098\uc758 \uc8fc\uae30\ub85c \uc774\ub8e8\uc5b4\uc9c4\ub2e4. JSP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c\ub3c4 \uc774\uc640 \uac19\uc774 \ub124 \ub2e8\uacc4\uc758 \uacfc\uc815\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc5f0\ub3d9\uc774 \uc774\ub8e8\uc5b4\uc9c4\ub2e4. \uadf8\ub7ec\uba74 \uac04\ub2e8\ud55c \ud68c\uc6d0\uac00\uc785 \ud3fc\uacfc \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud574 JSP\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5f0\ub3d9\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc790.<\/div>\n
<\/div>\n
\uc544\ub798 “MemberJoin.html”\uc740 \uac00\uc785\uc744 \uc704\ud574 \ud68c\uc6d0\uc815\ubcf4\ub97c \uc785\ub825\ud558\ub294 HTML \ud3fc\uc774\ub2e4. <\/div>\n
<\/p>\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”>
<title>Insert title here<\/title>
<\/head>
<body>
<form action=”MemberJoin.jsp<\/span>” method=”post”>
<table>
    <tr>
        <td>\ud68c\uc6d0\uc544\uc774\ub514<\/td>
        <td><input type=”text” size=”10″ maxlength=”16″ name=”userid<\/span>“><\/td>
    <\/tr>
    <tr>
        <td>\ube44\ubc00\ubc88\ud638<\/td>
        <td>
            <input type=”password” size=”10″ maxlength=”16″ name=”userpwd1<\/span>“>
            <input type=”password” size=”10″ maxlength=”16″ name=”userpwd2<\/span>“>
        <\/td>
    <\/tr>
    <tr>
        <td>\uc774\ub984<\/td>
        <td><input type=”text” size=”10″ maxlength=”20″ name=”username<\/span>“><\/td>
    <\/tr>
    <tr>
        <td>\uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638<\/td>
        <td>
            <input type=”text” size=”6″ maxlength=”6″ name=”jumin1<\/span>“> –
            <input type=”password” size=”7″ maxlength=”7″ name=”jumin2<\/span>“>
        <\/td>
    <\/tr>
    <tr>
        <td>&nbsp;<\/td>
        <td>
            <input type=”submit” value=”\ub4f1\ub85d”>
            <input type=”reset” value=”\ucd08\uae30\ud654”>
        <\/td>
    <\/tr>
<\/table>
<\/form>
<\/body>
<\/html><\/div>\n

\"\uc0ac\uc6a9\uc790

MemberView.html \uc2e4\ud589\uacb0\uacfc<\/p><\/div><\/div>\n

\uc774 \ud3fc\uc5d0\uc11c \ud68c\uc6d0 \uc815\ubcf4\ub97c \uc785\ub825\ubc1b\ub294 \ucc3d\uc758 \uc774\ub984\uc744 \uae30\uc5b5\ud558\uc790. \uc774 \ud3fc\uc5d0 \uc785\ub825\ub41c \uc815\ubcf4\ub294 “\ub4f1\ub85d” \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \uc544\ub798 “MemberJoin.jsp” \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c \uc804\ub2ec\ud55c\ub2e4. \uadf8\ub7ec\uba74 “MemberJoin.jsp”\ub294 \ub370\uc774\uc11c\ubca0\uc774\uc2a4 \uc11c\ubc84\uc640 \uc5f0\uacb0, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd\uc758 \ub2e8\uacc4\ub97c \uac70\uccd0 \uc785\ub825\ub41c \uc815\ubcf4\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\uae30 \uc704\ud55c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud55c \ub2e4\uc74c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc640\uc758 \uc5f0\uacb0\uc744 \uc885\ub8cc\ud558\uba74 \ub41c\ub2e4. \uadf8\ub7ec\uba74 \uac01 \ub2e8\uacc4\ubcc4\ub85c JSP\uc5d0\uc11c \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud558\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uc790.<\/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”>
<%<\/p>\n

request.setCharacterEncoding(“euc-kr”);<\/p>\n

String userId   = request.getParameter(“userid”);
String userPwd1 = request.getParameter(“userpwd1”);
String userPwd2 = request.getParameter(“userpwd2”);
String userName = request.getParameter(“username”);
String jumin1   = request.getParameter(“jumin1”);
String jumin2   = request.getParameter(“jumin2”);<\/p>\n

Class.forName(“com.mysql.jdbc.Driver<\/span>“);<\/p>\n

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

String url = “jdbc:mysql:\/\/localhost:3306\/jsp?user=jsp&password=your_password<\/span>“;
String sql = “INSERT INTO members VALUES (‘”
             + userId +”‘, md5(‘”+ userPwd1 +”‘),'”+ userName +”‘,'”+ jumin1 +”‘,md5(‘”+ jumin2 +”‘))”;
System.out.print(sql);
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
stmt.execute(sql);
stmt.close();
conn.close();
%>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text\/html; charset=EUC-KR”>
<title>Insert title here<\/title>
<\/head>
<body>
<table>
    <tr>
        <td>\ud68c\uc6d0\uc544\uc774\ub514<\/td>
        <td><%= userId %><\/td>
    <\/tr>
    <tr>
        <td>\ube44\ubc00\ubc88\ud638<\/td>
        <td><%= userPwd1 %><\/td>
    <\/tr>
    <tr>
        <td>\uc774\ub984<\/td>
        <td><%= userName %><\/td>
    <\/tr>
    <tr>
        <td>\uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638<\/td>
        <td><%= jumin1 %>-<%= jumin2 %><\/td>
    <\/tr>
<\/table>
<\/body>
<\/html><\/div>\n

<\/div>\n

\uba3c\uc800 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc5f0\ub3d9\uc744 \uc704\ud574 JDBC \ub4dc\ub77c\uc774\ubc84\ub97c \ub85c\ub529\ud574\uc57c \ud55c\ub2e4. \ub4dc\ub77c\uc774\ubc84\uc758 \ub85c\ub529\uc740 “Class.forName” \uba54\uc18c\ub4dc\ub97c \uc774\uc6a9\ud55c\ub2e4. \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ubcf4\uba74<\/p><\/div>\n

<\/div>\n
Class.forName(“com.mysql.jdbc.Driver<\/span>“);<\/div>\n
<\/div>\n
\ubd80\ubd84\uc774 \ub4dc\ub77c\uc774\ubc84\ub97c \ub85c\ub529\ud558\ub294 \ubd80\ubd84\uc774\ub2e4. \uc774 \uba54\uc18c\ub4dc\ub97c \uc2e4\ud589\ud558\uae30 \uc704\ud574 \ud544\uc694\ud55c \ud30c\ub77c\uba54\ud130\ub294 \uac12\uc740 \ub4dc\ub77c\uc774\ubc84\ub97c \ub2e4\uc6b4\ub85c\ub4dc \ud560 \ub54c \ub9e4\ub274\uc5bc\uc5d0 \ud568\uaed8 \uc81c\uacf5\ub418\uba70, MySQL \ub4dc\ub77c\uc774\ubc84\uc758 \uacbd\uc6b0 “com.mysql.jdbc.Driver” \uc774\ub2e4. \ub4dc\ub77c\uc774\ubc84\uac00 \uc131\uacf5\uc801\uc73c\ub85c \ub85c\ub529\ub418\uc5b4\uc57c JSP\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\ub3d9 \ud504\ub85c\uadf8\ub7a8\uc744 \uc791\uc131\ud560 \uc218 \uc788\ub2e4.<\/div>\n
<\/div>\n
\ub4dc\ub77c\uc774\ubc84\uac00 \ub85c\ub529 \ub410\uc73c\uba74 “DriverManager.getConnection” \uba54\uc18c\ub4dc\ub97c \uc774\uc6a9 JSP\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc640\uc758 \uc5f0\uacb0\uc744 \uc2e4\ud589\ud55c\ub2e4. \uc774 \uba54\uc18c\ub4dc\ub97c \uc2e4\ud589\ud558\uae30 \uc704\ud574 \ud544\uc694\ud55c \ud30c\ub77c\uba54\ud130 \uc5ed\uc2dc \ub4dc\ub77c\uc774\ubc84 \ubc30\ud3ec\uc2dc \ub9e4\ub274\uc5bc\uc5d0 \ud568\uaed8 \uc81c\uacf5\ub418\uba70 \ub4dc\ub77c\uc774\ubc84 \ubcc4\ub85c \uace0\uc720\ud55c \ud328\ud134\uc744 \uac00\uc9c0\ub294\ub370 MySQL\uc758 \uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc740 \ud615\uc2dd\uc744 \uac00\uc9c4\ub2e4.<\/div>\n
<\/div>\n
\n
“jdbc:mysql:\/\/hostname<\/span>:3306\/databasename<\/span>?user=userid<\/span>&password=userpassword“<\/span><\/span><\/div>\n

<\/div>\n

<\/div>\n
\uc774\ub97c \ucee4\ub125\uc158\uc2a4\ud2b8\ub9c1\uc774\ub77c \ud558\ub294\ub370 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc0ac\uc6a9\ub41c \ucee4\ub125\uc158\uc2a4\ud2b8\ub9c1<\/div>\n
<\/div>\n
\n
“jdbc:mysql:\/\/localhost:3306\/jsp?user=jsp&password=your_password<\/span>“<\/div>\n

<\/div>\n

<\/div>\n
\ub97c \uc0b4\ud3b4\ubcf4\uba74 “localhost”\uc5d0 \uc811\uc18d\ud558\ub77c\ub294 \uc758\ubbf8\uc774\uba70, \uc0ac\uc6a9\uc790 \uc544\uc774\ub514\ub294 “jsp”, \ube44\ubc00\ubc88\ud638\ub294 “your_password” \uadf8\ub9ac\uace0 \uc0ac\uc6a9\ud558\ub824\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 “jsp” \uc784\uc744 \uc54c \uc218 \uc788\ub2e4. “DriverManager.getConnection” \uba54\uc18c\ub4dc\uc5d0 \uc758\ud574 \uc5f0\uacb0\ub41c \uacb0\uacfc\ub294 Connection \ud074\ub798\uc2a4 \uac1d\uccb4\ub97c \uc0dd\uc131\ud55c \ud6c4 \uc800\uc7a5\ud55c\ub2e4.<\/div>\n
<\/div>\n
\n
conn = DriverManager.getConnection(url);<\/div>\n

<\/div>\n

<\/div>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd\uacfc \ud568\uaed8 \uc11c\ubc84\uc640\uc758 \uc5f0\uacb0\uc774 \uc774\ub8e8\uc5b4\uc9c0\uba74 \ucffc\ub9ac\uc2e4\ud589 \ub2e8\uacc4\uc5d0 \ub4e4\uc5b4\uac04\ub2e4. \uc774 \ud504\ub85c\uadf8\ub7a8\uc740 \ud68c\uc6d0\uac00\uc785\uc744 \uc704\ud55c \ud504\ub85c\uadf8\ub7a8\uc774\ubbc0\ub85c \ub9cc\uc57d \uc785\ub825\ub41c \ud68c\uc6d0\uc815\ubcf4\uac00 \uc785\ub825 \ucc3d\uc5d0<\/div>\n
<\/div>\n
hong<\/div>\n
1234<\/div>\n
12345<\/div>\n
Hong Gil Dong<\/div>\n
123456<\/div>\n
7654321<\/div>\n
<\/div>\n
\uc21c\uc73c\ub85c \uc785\ub825 \ub410\ub2e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 SQL\uc744 \ub9cc\ub4e4\uc5b4 \uc2e4\ud589\ud558\uc5ec \ud68c\uc6d0\uc815\ubcf4\ub97c \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud574\uc57c \ud55c\ub2e4.<\/div>\n
<\/div>\n
\n
INSERT INTO members VALUES
(‘hong’, md5(‘1234’), ‘Hong Gil Dong’, ‘123456’, md5(‘7654321’))<\/div>\n<\/div>\n
<\/div>\n
\uc704 SQL \uc5d0\uc11c md5(‘1234’)\uc640 md5(‘7654321’)\uc740 ‘1234’, ‘7654321’\uc744 \uc554\ud638\ud654 \uc54c\uace0\ub9ac\uc998\uc778 MD5 \uc54c\uace0\ub9ac\uc998\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc554\ud638\ud654 \ud558\ub77c\ub294 \uc758\ubbf8\uc774\ub2e4. \uadf8\ub7ec\ubbc0\ub85c members \ud14c\uc774\ube14\uc5d0 \ube44\ubc00\ubc88\ud638\uc640 \uc8fc\ubbfc\ub4f1\ub85d\ubc88\ud638 \ub4b7 \uc790\ub9ac\ub294 \uc554\ud638\ud654\ub418\uc5b4 ‘1234’, ‘7654321’\uc774 \uc544\ub2cc \uc804\ud600 \ub2e4\ub978 \uac12\uc73c\ub85c \uc800\uc7a5\ub41c\ub2e4. \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ud68c\uc6d0 \uc815\ubcf4\ub294 “request.getParameter” \uba54\uc18c\ub4dc\ub97c \uc774\uc6a9 \uc804\ub2ec\ubc1b\uc73c\uba70,<\/div>\n
<\/div>\n
\n
“INSERT INTO members VALUES (‘”
+ userId +”‘, md5(‘”+ userPwd1 +”‘),'”+ userName +”‘,'”+ jumin1 +”‘,md5(‘”+ jumin2 +”‘))”<\/div>\n

<\/div>\n

\ubd80\ubd84\uc774 \ud68c\uc6d0\uc815\ubcf4\ub97c \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\uae30\uc704\ud55c “INSERT” \ubb38\uc744 \ub9cc\ub4dc\ub294 \ubd80\ubd84\uc774\ub2e4. JSP \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130 \uc870\uc791\uc744 \uc704\ud55c SQL \ubb38\uc744 \ub9cc\ub4e0 \ud6c4\uc5d0\ub294 Connection \uac1d\uccb4\uc758 \uba54\uc18c\ub4dc “createStatement”\ub97c \uc774\uc6a9 Statement \uac1d\uccb4\ub97c \uc0dd\uc131\ud55c \ud6c4 \uc774 \uac1d\uccb4\uc758 “execute” \uba54\uc18c\ub4dc\ub97c \uc774\uc6a9 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/div>\n
<\/div>\n
\n
stmt = conn.createStatement();
stmt.execute(sql);<\/div>\n

<\/div>\n

\ucffc\ub9ac \uc2e4\ud589 \ud6c4 \ubaa8\ub4e0 \ub370\uc774\ud130 \uc870\uc791\uc774 \ub9c8\ubb34\ub9ac\ub418\uba74 Statment \uac1d\uccb4\uc640 Connection \uac1d\uccb4\uc758 “close” \uba54\uc18c\ub4dc\ub97c \uc774\uc6a9 \ud560\ub2f9\ub41c \uc790\uc6d0\uc744 \ub3cc\ub824\uc8fc\uace0 \uc5f0\uacb0\uc744 \ub04a\ub294\ub2e4.<\/div>\n
<\/div>\n
stmt.close();
conn.close();<\/div>\n

<\/p>\n

 <\/div>\n
\"\uc0ac\uc6a9\uc790

MemberJoin.jsp \uc2e4\ud589\uacb0\uacfc<\/p><\/div>
\ub2e4\uc74c \ud504\ub85c\uadf8\ub7a8 “MemberView.jsp”\ub294 “members” \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub41c \ub808\ucf54\ub4dc\ub97c \ucd9c\ub825\ud558\ub294 JSP \ud504\ub85c\uadf8\ub7a8\uc774\ub2e4. \ud14c\uc774\ube14 \uac80\uc0c9\uc744 \uc704\ud574\uc11c \uc0ac\uc6a9\ud558\ub294 SQL\uc740 “SELECT” \ubb38\uc774\ub2e4. “SELECT” \ubb38\uc740 “INSERT”, “DELETE”,”UPDATE” \ubb38\uacfc\ub294 \ub2ec\ub9ac \ucc98\ub9ac\ud574\uc57c \ud558\ub294 \ubd80\ubd84\uc774 \ub354 \ud544\uc694\ud558\ub2e4. “SELECT” \ubb38\uc744 \uc2e4\ud57c\ud560 \ub54c\ub3c4 \uc11c\ubc84\uc5f0\uacb0, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd, \ucffc\ub9ac\uc2e4\ud589, \uc5f0\uacb0\ub04a\uae30\uc758 \ub124 \ub2e8\uacc4\uac00 \ud544\uc694\ud558\ub2e4. \uadf8\ub7ec\ub098 “SELECT” \ubb38\uc758 \uacbd\uc6b0 \uac80\uc0c9\ub41c \uacb0\uacfc\ub97c \uc0ac\uc6a9\uc790\uc5d0\uac8c \ucd9c\ub825\ud574\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0 \ucffc\ub9ac\uc2e4\ud589 \ud6c4 \uac80\uc0c9\ub41c \ub808\ucf54\ub4dc\ub97c \ubc18\ubcf5\ubb38\uc744 \ud1b5\ud574 \ucd94\ucd9c\ud558\uace0 \ucd9c\ub825\ud558\ub294 \ubd80\ubd84\uc774 \ucd94\uac00\ub41c\ub2e4.<\/div>\n

<\/div>\n
\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”>
<%
Class.forName(“com.mysql.jdbc.Driver”);<\/p>\n

Connection conn = null;
Statement  stmt = null;
ResultSet  rs = null;<\/span><\/p>\n

String url = “jdbc:mysql:\/\/localhost:3306\/jsp?user=jsp&password=your_password”;
String sql = “SELECT userid, username, jumin1 FROM members”;
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();<\/p>\n

rs = stmt.executeQuery(sql);<\/span>
%>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text\/html; charset=EUC-KR”>
<title>Insert title here<\/title>
<\/head>
<body>
<%
while (rs.next()<\/span>) {
%>
\uc544\uc774\ub514 : <%= rs.getString(“userid”)<\/span> %><br \/>
\uc774\ub984 : <%= rs.getString(“username”)<\/span> %><br \/>
\uc8fc\ubbfc\ub4f1\ub85d : <%= rs.getString(“jumin1”)<\/span> %><br \/>
<%
}
%>
<\/body>
<\/html>
<%
stmt.close();
conn.close();
%><\/div>\n

\uc704 \ud504\ub85c\uadf8\ub7a8\uc744 \uc0b4\ud3b4\ubcf4\uba74 ResultSet \uac1d\uccb4 rs\ub97c \uc120\uc5b8\ud558\uace0 \uc788\ub2e4. \uc774 \uac1d\uccb4\ub294 \ucffc\ub9ac\uc2e4\ud589 \ub2e8\uacc4\uc5d0\uc11c \uadf8 \uacb0\uacfc\ub97c \uc800\uc7a5\ud55c\ub2e4. \uc774 \ub54c “SELECT” \ubb38\uc758 \uc2e4\ud589\uc744 \uc704\ud574 stmt.execute\uac00 \uc544\ub2cc stmt.executeQuery \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc74c\uc5d0 \uc8fc\ubaa9\ud558\uc790. \uc800\uc7a5\ub41c \uacb0\uacfc\ub294 ResultSet \ud615\uc73c\ub85c \uac80\uc0c9\ub41c \ubaa8\ub4e0 \ub808\ucf54\ub4dc\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. \uc5ec\uae30\uc11c \uac01\uac01\uc758 \ub808\ucf54\ub4dc\ub85c \uc811\uadfc\uc744 \ud558\uae30 \uc704\ud574\uc11c\ub294 “next” \uba54\uc18c\ub4dc\ub97c \uc774\uc6a9\ud55c\ub2e4. “next” \uba54\uc18c\ub4dc\uac00 \ud638\ucd9c\ub418\uba74 \ud604 \ub808\ucf54\ub4dc\uc5d0\uc11c \ub2e4\uc74c \ub808\ucf54\ub4dc\ub85c \ucee4\uc11c\ub97c \uc774\ub3d9\ud55c\ub2e4. \ucee4\uc11c\ub780 \ub808\ucf54\ub4dc\ub97c \uac00\ub9ac\ud0a4\ub294 \ud3ec\uc778\ud130\ub97c \uc758\ubbf8\ud55c\ub2e4. \ub9cc\uc57d \ub9c8\uc9c0\ub9c9 \ub808\ucf54\ub4dc\uc778 \uacbd\uc6b0 false\ub97c \ub3cc\ub824\uc900\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \ubc18\ubcf5\ubb38\uc744 \uc774\uc6a9\ud558\uba74 \ubaa8\ub4e0 \ub808\ucf54\ub4dc\ub97c \uc77d\uc744 \uc218 \uc788\ub2e4. <\/span><\/span><\/span><\/div>\n

<\/div>\n
\ud604\uc7ac \ub808\ucf54\ub4dc\uc5d0\uc11c \uac01 \ud544\ub4dc\uac12\uc744 \uc5bb\uae30 \uc704\ud574\uc11c\ub294 “rs.getString” \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \ud30c\ub77c\uba54\ud130\ub85c\ub294 \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud544\ub4dc\uba85\uc744 \uc900\ub2e4. \ub2e4\uc74c\uc740 “MemberView.jsp”\ub97c \uc2e4\ud589\ud55c \uacb0\uacfc\uc774\ub2e4.<\/span><\/span><\/span><\/span><\/div>\n
\"\uc0ac\uc6a9\uc790

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

\uc6b0\ub9ac\ub294 \uc55e\uc11c MySQL\uc758 \uae30\ubcf8 \uc0ac\ud56d\uc5d0 \ub300\ud574 \ubc30\uc6b8 \ub54c “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\ub97c \ud1b5\ud574 “mysql” \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc744 \uc2e4\ud589\ud568\uc73c\ub85c\uc368 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\uace0 \uba87\uba87 \ub370\uc774\ud130 \uc870\uc791\uc744 \uc704\ud55c \uba85\ub839\uc744 \uc2e4\ud589\ud558\uc600\ub2e4. \uc774 \uacfc\uc815\uc740 \ud06c\uac8c \ub124 \uac00\uc9c0 \ub2e8\uacc4\ub85c \ub098\ub204\uc5b4 \uc0dd\uac01\ud560 \uc218 \uc788\ub2e4. \uba3c\uc800 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub85c\uc758 \uc5f0\uacb0 \ub2e8\uacc4\uc774\ub2e4. \uc774 \ub2e8\uacc4\ub294 “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc744 \uc2e4\ud589\ud558\uace0 \uc554\ud638\ub97c \uc785\ub825\ud568\uc73c\ub85c\uc368 \uc774\ub8e8\uc5b4\uc9c4\ub2e4. mysql  -u  jsp  -p \uc774 \uba85\ub839\uc740\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":2849,"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":[15,28,29,108],"class_list":["post-2848","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-jsp","tag-eclipse","tag-jdbc","tag-jsp","tag-108"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile2.uf.11429B284A9A0E99491831.png?fit=524%2C328&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-JW","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2848","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=2848"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media\/2849"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=2848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=2848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=2848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}