Untitled

<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>

<%
	Connection  conn = null;
	Statement	stmt = null;
	ResultSet	rset = null;

	String SQL="";

	Class.forName("org.gjt.mm.mysql.Driver").newInstance();
	conn = DriverManager.getConnection("jdbc:mysql://localhost/mercymateo");
	stmt = conn.createStatement();
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento sin t&iacute;tulo</title>
</head>

<body>

<table width="350" border="0" cellspacing="2" cellpadding="0">
  <tr>
    <th width="51">ID</th>
    <th width="119">Nombre</th>
    <th width="172">Apellido</th>
    <th width="51">Edad</th>
    <th width="119">DNI</th>
    <th width="172">Correo</th>
    <th width="119">Hobby</th>
    <th width="172">Genero</th>
  </tr>
  <%
	  SQL="select * from estudiante";

	  rset = stmt.executeQuery(SQL);

	  while(rset.next()){
  %>
  <tr>
    <td align="center"><%= rset.getInt("id") %></td>
    <td><%= rset.getString("nombre") %></td>
    <td><% =rset.getString("apellido")); %></td>
    <td align="center"><%= rset.getInt("edad") %></td>
    <td><%= rset.getInt("dni") %></td>
    <td><% =rset.getString("correo"); %></td>
    <td align="center"><%= rset.getString("hobby") %></td>
    <td><%= rset.getString("genero") %></td>
  </tr>
  <%
  	}
	rset.close();
  %>
</table>
</body>
</html>
<%
stmt.close();
conn.close();
%>