<%@ page import="java.sql.*" %>
<%
Connection ocon = null;
Class.forName("org.gjt.mm.mysql.Driver");
ocon = DriverManager.getConnection("jdbc:mysql:///testdb", "foo", "foo");
Statement stmtt = ocon.createStatement();
ResultSet rc = stmtt.executeQuery("Select count(*) from users ");
rc.next();
out.println("Total Records : " + rc.getInt(1) + "</br></br>");
rc = stmtt.executeQuery("Select * from users ");
out.println("<table BORDER='1'>");
out.println("<tr><td><b>email</b> </td><td><b>username</b></td></tr>");
while (rc.next()) {
out.println("<tr><td>" + rc.getString("email")+ "</td><td>" + rc.getString("username")+ "<tr><td>");
}
out.println("</table>");
%>