<%@include file = "Include_Files.jsp"%>

<%
	Connection con = DriverManager.getConnection(url, userid, passDB);
	Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	ResultSet rs = stmt.executeQuery(search_query);

%>
	<table id = "search_table" cellpadding = "5" border = "2">
	<tr>
		<th>Name</th>
		<th>Family Name</th>
		<th>Email Address</th>
		<th>Username</th>
		<th>Password</th>
	</tr>
<%
	while (rs.next())
	{
%>
	<TR>
	<TD><%=rs.getString(1)%></TD>
	<TD><%=rs.getString(2)%></TD>
	<TD><%=rs.getString(3)%></TD>
	<TD><%=rs.getString(4)%></TD>
	<TD><%=rs.getString(5)%></TD>
	</TR>
<%
	}
	stmt.close();
	con.close();
%>

	</table>