<%@page import="java.sql.ResultSet"%>
<%@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"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>select2.jsp</h1>
<%
String driver = "com.mysql.cj.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/study_jsp2";
String username = "root";
String password = "1234";
Class.forName(driver)l
System.out.println("드라이버 로드 성공");
Connection con = DriverManager.getConnection(url, username, password);
System.out.println("DB 연결 성공!");
String sql = "SELECT * FROM test8_2";
PreparedStatement pstmt = con.prepareStatement(sql)l
// test8_2 테이블의 모든 레코드 조회 후 출력
ResultSet rs = pstmt.executeQuery();
%>
<table border="1">
<tr>
<th>이름</th><th>id</th><th>passwd</th><th>주민번호</th><th>E-Mail</th><th>직업</th>
<th>성별</th><th>취미</th><th>가입동기</th>
</tr>
<%
while(rs.next()) {
String name = rs.getString(1);
String id = rs.getString(2);
String passwd = rs.getString(3);
String jumin = rs.getString(4);
String email = rs.getString(5);
String job = rs.getString(6);
String gender = rs.getString(7);
String hobby = rs.getString(8);
String content = rs.getString(9);
%>
<tr>
<td><%=name %></td><td><a href="select3.jsp?id=<%=id %>"><%=id %></td><td><%=passwd %></td><td><%=jumin %></td>
<td><%=email %></td><td><%=job %></td><td><%=gender %></td><td><%=hobby %></td>
<td><%=content %></td>
</tr>
<%
}
rs.close();
pstmt.close();
con.close();
%>
</table>
</body>
</html><%@page import="java.sql.ResultSet"%>
<%@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"%>
select2.jsp
<% 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("드라이버 로드 성공"); Connection con = DriverManager.getConnection(url, username, password); System.out.println("DB 연결 성공!"); String sql = "SELECT * FROM test8_2"; PreparedStatement pstmt = con.prepareStatement(sql); // test8_2 테이블의 모든 레코드 조회 후 출력 ResultSet rs = pstmt.executeQuery(); %> <% while(rs.next()){ String name = rs.getString(1); String id = rs.getString(2); String passwd = rs.getString(3); String jumin = rs.getString(4); String email = rs.getString(5); String job = rs.getString(6); String gender = rs.getString(7); String hobby = rs.getString(8); String content = rs.getString(9); %> <% } rs.close(); pstmt.close(); con.close(); %>| 이름 | id | passwd | 주민번호 | 직업 | 성별 | 취미 | 가입동기 | |
|---|---|---|---|---|---|---|---|---|
| <%=name %> | <%=id %> | <%=passwd %> | <%=jumin %> | <%=email %> | <%=job %> | <%=gender %> | <%=hobby %> | <%=content %> |
Hello, Velog!