Untitled

<%@ page contentType="text/html; charset=utf-8" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<jsp:useBean id="db" class = "JDBC.ForDataBase"/>
<html lang="he" dir="rtl">
<head>
    <title>חיפוש משתמשים</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link rel="stylesheet" href="style.css" type="text/css" media="screen"/>
    <link rel="shortcut icon" href="images/favicon.ico" />
  </head>
  <body>
  <div id="container">
<jsp:include page="navbar.jsp"></jsp:include>
<%
 String sql="select * from members";
  if(request.getMethod().equals("POST"))
  {
             String username=request.getParameter("username");
             sql="select * from members where username='"+username+"'";
  }
%>
<h1>עמוד מנהל: חיפוש משתמשים</h1>
<jsp:include page="menu2.jsp"></jsp:include>
<table class="two" style="margin-left:10px;">
<br>
<form method="post"  action="selectWhere.jsp"><font color="white" size="5">
<tr>
<td class="two">שם משתמש:</td>
<td><input type="text" name="username" size="19"  id="username"></td>
</tr>
   </table>
   <br>
<input type="submit" name="adsub" value="Submit" id="sub1">
</form>
<br><br>
<table     border="2" bordercolor="red" align="center" bgcolor="gold" cellpadding="10"   width="80%" height="100">
    <tr>
    <th>name</th>
    <th>email</th>
     <th>username</th>
      <th>Password</th>
  </tr>
<%
  sql="select * from members where fullname like 'a%'";
  String[][] result = db.select(sql);
  int j,i;
  for(i=0;i<result.length;i++)
  {
     out.println("<tr>");
     for(j=0;j<result[i].length;j++)
     {
                  out.println("<td>"+result[i][j]+"</td>");
     }
     out.println("</tr>");
  }
%>
</table>
</div>
</body>
</html>