<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
Connection con = null;
Statement stmt = null; // insert, select 등의 명령을 위한 변수
ResultSet rs = null; // select 후에 자료를 메모리에 받아오는 변수
String url = "jdbc:mariadb://localhost:3307/jspdb";
String user = "root";
String pass = "maria";
Class.forName("org.mariadb.jdbc.Driver");// add throws ClassNotFoundException
//System.out.println("드라이버 로딩!");
con = DriverManager.getConnection(url, user, pass);
//System.out.println("접속 성공!");
String sql = "select * from person ";
stmt = con.createStatement();
rs = stmt.executeQuery(sql); // select의 경우만
%>
<table border="1">
<%
while(rs.next()) { // next() id 1번부터 출력 됨
int id = rs.getInt("id");
String name = rs.getString("name");
String addr = rs.getString("addr");
String phone = rs.getString("phone");
%>
<tr>
<td><%=id %></td>
<td><%=name %></td>
<td><%=addr %></td>
<td><%=phone %></td>
</tr>
<%
}
%>
</table>
</body>
</html>
