admin_panel_queries.jsp.bak

<%@page import="java.sql.*"%>
<%@page import="oaapDao.*"%>

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<body>



<div class="container">

<%
try{
 oaapAdminDao oad=new oaapAdminDao();
  Connection con=oad.getConnection();  
     

PreparedStatement ps=con.prepareStatement("select * from ooa_contactus");




   ResultSet rs=ps.executeQuery();
 
int count=0,i=1;
%>
<h1 style="text-align:center">User Queries</h1>

<table class="table table-hover">
	<thead>
      <tr>
        <th>Name</th>
        <th>Email</th>
        <th>Message</th>
       
      </tr>
    </thead>
<tbody>

	<% 
	 while(rs.next())
     {
  
	   %>
      <tr>
        <td><%=rs.getString(1)%></td>
        <td><%=rs.getString(2)%></td>
        <td><%=rs.getString(3)%></td>
  
        
      </tr>
<%

	 }
}
catch(Exception e){
out.print(e);
}
%>
  </tbody>
  </table>
</div>

</body>
</html>