Skip to content

Commit 39e5e20

Browse files
eomjinyoungeomjinyoung
committed
.
1 parent d985aa7 commit 39e5e20

33 files changed

Lines changed: 1894 additions & 0 deletions

‎Lesson04/.gitignore‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
/build

‎Lesson04/.settings/gradle/org.springsource.ide.eclipse.gradle.core.prefs‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
#org.springsource.ide.eclipse.gradle.core.preferences.GradleProjectPreferences
2+
#Sun Jan 12 16:48:45 KST 2014
3+
org.springsource.ide.eclipse.gradle.rootprojectloc=

‎Lesson04/step01/src/spms/servlets/MemberListServlet.java‎

Lines changed: 62 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,62 @@
1+
package spms.servlets;
2+
3+
import java.io.IOException;
4+
import java.io.PrintWriter;
5+
import java.sql.Connection;
6+
import java.sql.DriverManager;
7+
import java.sql.ResultSet;
8+
import java.sql.Statement;
9+
10+
import javax.servlet.GenericServlet;
11+
import javax.servlet.ServletException;
12+
import javax.servlet.ServletRequest;
13+
import javax.servlet.ServletResponse;
14+
import javax.servlet.annotation.WebServlet;
15+
16+
@WebServlet("/member/list")
17+
public class MemberListServlet extends GenericServlet {
18+
private static final long serialVersionUID = 1L;
19+
20+
@Override
21+
public void service(ServletRequest request, ServletResponse response)
22+
throws ServletException, IOException {
23+
Connection conn = null;
24+
Statement stmt = null;
25+
ResultSet rs = null;
26+
27+
try {
28+
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
29+
conn = DriverManager.getConnection(
30+
"jdbc:mysql://localhost/studydb", //JDBC URL
31+
"study", // DBMS 사용자 아이디
32+
"study"); // DBMS 사용자 암호
33+
stmt = conn.createStatement();
34+
rs = stmt.executeQuery(
35+
"SELECT MNO,MNAME,EMAIL,CRE_DATE" +
36+
" FROM MEMBERS" +
37+
" ORDER BY MNO ASC");
38+
39+
response.setContentType("text/html; charset=UTF-8");
40+
PrintWriter out = response.getWriter();
41+
out.println("<html><head><title>회원목록</title></head>");
42+
out.println("<body><h1>회원목록</h1>");
43+
while(rs.next()) {
44+
out.println(
45+
rs.getInt("MNO") + "," +
46+
rs.getString("MNAME") + "," +
47+
rs.getString("EMAIL") + "," +
48+
rs.getDate("CRE_DATE") + "<br>"
49+
);
50+
}
51+
out.println("</body></html>");
52+
} catch (Exception e) {
53+
throw new ServletException(e);
54+
55+
} finally {
56+
try {if (rs != null) rs.close();} catch(Exception e) {}
57+
try {if (stmt != null) stmt.close();} catch(Exception e) {}
58+
try {if (conn != null) conn.close();} catch(Exception e) {}
59+
}
60+
61+
}
62+
}

‎Lesson04/step02/src/spms/servlets/MemberAddServlet.java‎

Lines changed: 33 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,33 @@
1+
package spms.servlets;
2+
3+
import java.io.IOException;
4+
import java.io.PrintWriter;
5+
6+
import javax.servlet.ServletException;
7+
import javax.servlet.annotation.WebServlet;
8+
import javax.servlet.http.HttpServlet;
9+
import javax.servlet.http.HttpServletRequest;
10+
import javax.servlet.http.HttpServletResponse;
11+
12+
@WebServlet("/member/add")
13+
public class MemberAddServlet extends HttpServlet {
14+
private static final long serialVersionUID = 1L;
15+
16+
@Override
17+
protected void doGet(
18+
HttpServletRequest request, HttpServletResponse response)
19+
throws ServletException, IOException {
20+
response.setContentType("text/html; charset=UTF-8");
21+
PrintWriter out = response.getWriter();
22+
out.println("<html><head><title>회원 등록</title></head>");
23+
out.println("<body><h1>회원 등록</h1>");
24+
out.println("<form action='add' method='post'>");
25+
out.println("이름: <input type='text' name='name'><br>");
26+
out.println("이메일: <input type='text' name='email'><br>");
27+
out.println("암호: <input type='password' name='password'><br>");
28+
out.println("<input type='submit' value='추가'>");
29+
out.println("<input type='reset' value='취소'>");
30+
out.println("</form>");
31+
out.println("</body></html>");
32+
}
33+
}

‎Lesson04/step02/src/spms/servlets/MemberListServlet.java‎

Lines changed: 63 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,63 @@
1+
package spms.servlets;
2+
3+
import java.io.IOException;
4+
import java.io.PrintWriter;
5+
import java.sql.Connection;
6+
import java.sql.DriverManager;
7+
import java.sql.ResultSet;
8+
import java.sql.Statement;
9+
10+
import javax.servlet.GenericServlet;
11+
import javax.servlet.ServletException;
12+
import javax.servlet.ServletRequest;
13+
import javax.servlet.ServletResponse;
14+
import javax.servlet.annotation.WebServlet;
15+
16+
@WebServlet("/member/list")
17+
public class MemberListServlet extends GenericServlet {
18+
private static final long serialVersionUID = 1L;
19+
20+
@Override
21+
public void service(ServletRequest request, ServletResponse response)
22+
throws ServletException, IOException {
23+
Connection conn = null;
24+
Statement stmt = null;
25+
ResultSet rs = null;
26+
27+
try {
28+
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
29+
conn = DriverManager.getConnection(
30+
"jdbc:mysql://localhost/studydb", //JDBC URL
31+
"study", // DBMS 사용자 아이디
32+
"study"); // DBMS 사용자 암호
33+
stmt = conn.createStatement();
34+
rs = stmt.executeQuery(
35+
"SELECT MNO,MNAME,EMAIL,CRE_DATE" +
36+
" FROM MEMBERS" +
37+
" ORDER BY MNO ASC");
38+
39+
response.setContentType("text/html; charset=UTF-8");
40+
PrintWriter out = response.getWriter();
41+
out.println("<html><head><title>회원목록</title></head>");
42+
out.println("<body><h1>회원목록</h1>");
43+
out.println("<p><a href='add'>신규 회원</a></p>");
44+
while(rs.next()) {
45+
out.println(
46+
rs.getInt("MNO") + "," +
47+
rs.getString("MNAME") + "," +
48+
rs.getString("EMAIL") + "," +
49+
rs.getDate("CRE_DATE") + "<br>"
50+
);
51+
}
52+
out.println("</body></html>");
53+
} catch (Exception e) {
54+
throw new ServletException(e);
55+
56+
} finally {
57+
try {if (rs != null) rs.close();} catch(Exception e) {}
58+
try {if (stmt != null) stmt.close();} catch(Exception e) {}
59+
try {if (conn != null) conn.close();} catch(Exception e) {}
60+
}
61+
62+
}
63+
}

‎Lesson04/step03/src/spms/servlets/MemberAddServlet.java‎

Lines changed: 74 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,74 @@
1+
package spms.servlets;
2+
3+
import java.io.IOException;
4+
import java.io.PrintWriter;
5+
import java.sql.Connection;
6+
import java.sql.DriverManager;
7+
import java.sql.PreparedStatement;
8+
9+
import javax.servlet.ServletException;
10+
import javax.servlet.annotation.WebServlet;
11+
import javax.servlet.http.HttpServlet;
12+
import javax.servlet.http.HttpServletRequest;
13+
import javax.servlet.http.HttpServletResponse;
14+
15+
@WebServlet("/member/add")
16+
public class MemberAddServlet extends HttpServlet {
17+
private static final long serialVersionUID = 1L;
18+
19+
@Override
20+
protected void doGet(
21+
HttpServletRequest request, HttpServletResponse response)
22+
throws ServletException, IOException {
23+
response.setContentType("text/html; charset=UTF-8");
24+
PrintWriter out = response.getWriter();
25+
out.println("<html><head><title>회원 등록</title></head>");
26+
out.println("<body><h1>회원 등록</h1>");
27+
out.println("<form action='add' method='post'>");
28+
out.println("이름: <input type='text' name='name'><br>");
29+
out.println("이메일: <input type='text' name='email'><br>");
30+
out.println("암호: <input type='password' name='password'><br>");
31+
out.println("<input type='submit' value='추가'>");
32+
out.println("<input type='reset' value='취소'>");
33+
out.println("</form>");
34+
out.println("</body></html>");
35+
}
36+
37+
@Override
38+
protected void doPost(
39+
HttpServletRequest request, HttpServletResponse response)
40+
throws ServletException, IOException {
41+
Connection conn = null;
42+
PreparedStatement stmt = null;
43+
44+
try {
45+
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
46+
conn = DriverManager.getConnection(
47+
"jdbc:mysql://localhost/studydb", //JDBC URL
48+
"study", // DBMS 사용자 아이디
49+
"study"); // DBMS 사용자 암호
50+
stmt = conn.prepareStatement(
51+
"INSERT INTO MEMBERS(EMAIL,PWD,MNAME,CRE_DATE,MOD_DATE)"
52+
+ " VALUES (?,?,?,NOW(),NOW())");
53+
stmt.setString(1, request.getParameter("email"));
54+
stmt.setString(2, request.getParameter("password"));
55+
stmt.setString(3, request.getParameter("name"));
56+
stmt.executeUpdate();
57+
58+
response.setContentType("text/html; charset=UTF-8");
59+
PrintWriter out = response.getWriter();
60+
out.println("<html><head><title>회원등록결과</title></head>");
61+
out.println("<body>");
62+
out.println("<p>등록 성공입니다!</p>");
63+
out.println("</body></html>");
64+
65+
} catch (Exception e) {
66+
throw new ServletException(e);
67+
68+
} finally {
69+
try {if (stmt != null) stmt.close();} catch(Exception e) {}
70+
try {if (conn != null) conn.close();} catch(Exception e) {}
71+
}
72+
73+
}
74+
}

‎Lesson04/step03/src/spms/servlets/MemberListServlet.java‎

Lines changed: 63 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,63 @@
1+
package spms.servlets;
2+
3+
import java.io.IOException;
4+
import java.io.PrintWriter;
5+
import java.sql.Connection;
6+
import java.sql.DriverManager;
7+
import java.sql.ResultSet;
8+
import java.sql.Statement;
9+
10+
import javax.servlet.GenericServlet;
11+
import javax.servlet.ServletException;
12+
import javax.servlet.ServletRequest;
13+
import javax.servlet.ServletResponse;
14+
import javax.servlet.annotation.WebServlet;
15+
16+
@WebServlet("/member/list")
17+
public class MemberListServlet extends GenericServlet {
18+
private static final long serialVersionUID = 1L;
19+
20+
@Override
21+
public void service(ServletRequest request, ServletResponse response)
22+
throws ServletException, IOException {
23+
Connection conn = null;
24+
Statement stmt = null;
25+
ResultSet rs = null;
26+
27+
try {
28+
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
29+
conn = DriverManager.getConnection(
30+
"jdbc:mysql://localhost/studydb", //JDBC URL
31+
"study", // DBMS 사용자 아이디
32+
"study"); // DBMS 사용자 암호
33+
stmt = conn.createStatement();
34+
rs = stmt.executeQuery(
35+
"SELECT MNO,MNAME,EMAIL,CRE_DATE" +
36+
" FROM MEMBERS" +
37+
" ORDER BY MNO ASC");
38+
39+
response.setContentType("text/html; charset=UTF-8");
40+
PrintWriter out = response.getWriter();
41+
out.println("<html><head><title>회원목록</title></head>");
42+
out.println("<body><h1>회원목록</h1>");
43+
out.println("<p><a href='add'>신규 회원</a></p>");
44+
while(rs.next()) {
45+
out.println(
46+
rs.getInt("MNO") + "," +
47+
rs.getString("MNAME") + "," +
48+
rs.getString("EMAIL") + "," +
49+
rs.getDate("CRE_DATE") + "<br>"
50+
);
51+
}
52+
out.println("</body></html>");
53+
} catch (Exception e) {
54+
throw new ServletException(e);
55+
56+
} finally {
57+
try {if (rs != null) rs.close();} catch(Exception e) {}
58+
try {if (stmt != null) stmt.close();} catch(Exception e) {}
59+
try {if (conn != null) conn.close();} catch(Exception e) {}
60+
}
61+
62+
}
63+
}

0 commit comments

Comments
 (0)