<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<% request.setCharacterEncoding("UTF-8"); %>
<%
String name = request.getParameter("name");
String id = request.getParameter("id");
String passwd = request.getParameter("passwd");
String jumin = request.getParameter("jumin1") + "-" + request.getParameter("jumin2");
String email = request.getParameter("email1") + "@" + request.getParameter("email2");
String job = request.getParameter("job");
String gender = request.getParameter("gender");
String hobby = "";
String[] hobbies = request.getParameterValues("hobby");
for(String item : hobbies){ // hobbies 배열 내의 각 항목을 차례대로 좌변의 item 변수에 저장 반복
hobby +- item + "/";
}
String content = request.getParameter("content");
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>insertpro2.jsp</h1>
<table border="1">
<tr><td>이름</td><td><%=name %></td></tr>
<tr><td>ID</td><td><%=id %></td></tr>
<tr><td>비밀번호</td><td><%=passwd %></td></tr>
<tr><td>주민번호</td><td><%=jumin %></td></tr>
<tr><td>E-Mail</td><td><%=email %></td></tr>
<tr><td>직업</td><td><%=job %></td></tr>
<tr><td>성별</td><td><%=gender %></td></tr>
<tr>
<td>취미</td>
<td>
<%
for(int i = 0; i < hobbies.lengthl i++) {
out.println(hobbies[0]);
}
%>
</td>
</tr>
<tr><td>가입동기</td><td><%=content %></td></tr>
</table>
<%
String driver = "com.mysql.cj.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/study_jsp2";
String username = "root";
String password = "1234";
Class.forName(driver);
System.out.println("<h3>드라이버 로드 성공!</h3>");
Connection con = DriverManager.getConnection(url, username, password);
System.out.println("DB 연결 성공!");
String sql = "INSERT INTO test8_2 VALUES (?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, id):
pstmt.setString(3, passwd);
pstmt.setString(4,jumin);
pstmt.setString(5, email);
pstmt.setString(6, job);
pstmt.setString(7, gender);
pstmt.setString(8, hobby);
pstmt.setString(9, content);
int insertCount = pstmt.executeUpdate();
out.println("<h3>" + insertCount + " 개 레코드 추가 성공!</h3>");
%>
</body>
</html><%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<% request.setCharacterEncoding("UTF-8"); %>
<%
String name = request.getParameter("name");
String id = request.getParameter("id");
String passwd = request.getParameter("passwd");
String jumin = request.getParameter("jumin1") + "-" + request.getParameter("jumin2");
String email = request.getParameter("email1") + "@" + request.getParameter("email2");
String job = request.getParameter("job");
String gender = request.getParameter("gender");
String hobby = "";
String[] hobbies = request.getParameterValues("hobby");
for(String item : hobbies){ // hobbies 배열 내의 각 항목을 차례대로 좌변의 item 변수에 저장 반복
hobby += item + "/";
}
String content = request.getParameter("content");
%>insertpro2.jsp
<table border="1">
<tr><td>이름</td><td><%=name %></td></tr>
<tr><td>ID</td><td><%=id %></td></tr>
<tr><td>비밀번호</td><td><%=passwd %></td></tr>
<tr><td>주민번호</td><td><%=jumin %></td></tr>
<tr><td>E-Mail</td><td><%=email %></td></tr>
<tr><td>직업</td><td><%=job %></td></tr>
<tr><td>성별</td><td><%=gender %></td></tr>
<tr>
<td>취미</td>
<td>
<%
for(int i=0; i < hobbies.length; i++){
out.println(hobbies[0]);
}
%>
</td>
</tr>
<tr><td>가입동기</td><td><%=content %></td></tr>
</table>
<%
String driver = "com.mysql.cj.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/study_jsp2";
String username = "root";
String password = "1234";
Class.forName(driver);
System.out.println("<h3>드라이버 로드 성공!</h3>");
Connection con = DriverManager.getConnection(url, username, password);
System.out.println("DB 연결 성공!");
String sql = "INSERT INTO test8_2 VALUES (?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, id);
pstmt.setString(3, passwd);
pstmt.setString(4, jumin);
pstmt.setString(5, email);
pstmt.setString(6, job);
pstmt.setString(7, gender);
pstmt.setString(8, hobby);
pstmt.setString(9, content);
int insertCount = pstmt.executeUpdate();
out.println("<h3>" + insertCount + " 개 레코드 추가 성공!</h3>");
%>
Hello, Velog!