20_jsp만_list처리_jsp

회원리스트

m_list

회원 리스트 <br>
<table width="100%" border="1">
<tr>
	<td>아이디</td><td>비번</td><td>권한</td><td>이름</td><td>이메일</td>
</tr>

 

<%
	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;

	Class.forName("com.mysql.jdbc.Driver");

	String jdbcDriver = "jdbc:mysql://localhost:3306/dev42db?" + "useUnicode=true&characterEncoding=euckr";
	String dbUser = "dev42id";
	String dbPass = "dev42pw";
	conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);

	pstmt = conn.prepareStatement("SELECT * FROM tb_member");

	rs = pstmt.executeQuery();

	while (rs.next()) {
%>
<tr>
	<td><%=rs.getString("m_id")%></td>
	<td><%=rs.getString("m_pw")%></td>
	<td><%=rs.getString("m_level")%></td>
	<td><%=rs.getString("m_name")%></td>
	<td><%=rs.getString("m_email")%></td>
</tr>
<%
	}
	rs.close();
	pstmt.close();
	conn.close();
%>
</table>