JSP
[JSP]DB데이터 불러오기
송 이
2024. 4. 17. 17:24
<%@page import="dao.DBcon"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@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>MemberLust Page</title>
</head>
<body>
<h1>MemberList Page</h1>
<hr>
<table border="1">
<tr>
<th>id</th><th>name</th><th>email</th>
</tr>
<%
Connection conn = DBcon.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from member");
while(rs.next()){
%>
<tr>
<td><%=rs.getString("id") %></td>
<td><%=rs.getString("NAME") %></td>
<td><%=rs.getString("email") %></td>
</tr>
<%
}
%>
</table>
</body>
</html>