<%@page import="java.sql.*"%>
<%@page import="Dna.Sources.Dbconnection"%>
<%@ page session="true" %>
<!DOCTYPE html>
<!--[if lt IE 7]>      <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
<!--[if IE 7]>         <html class="no-js lt-ie9 lt-ie8"> <![endif]-->
<!--[if IE 8]>         <html class="no-js lt-ie9"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]-->
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
        <title>SECURING AGGREGATE</title>
        <meta name="description" content="">
        <meta name="viewport" content="width=device-width">
       
        <link rel="stylesheet" href="css/bootstrap.css">
        <link rel="stylesheet" href="css/bootstrap-responsive.css">
        <link rel="stylesheet" href="css/custom-styles.css">
        <link rel="stylesheet" href="css/font-awesome.css">
        <link rel="stylesheet" href="css/component.css">
        <link rel="stylesheet" href="css/font-awesome-ie7.css">
         <link rel="icon" href="images/13.jpg">
        
        <script src="js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
    </head>
    
      <%
if(request.getParameter("msg")!=null){%>
    
    out.print("<script>alert('Activated Sucessfully..!')</script>");
}  

<%}
if(request.getParameter("m1")!=null){%>

 out.print("<script>alert('Login Failed..!')</script>");
 <%
}
%>

    <body>
        <!--[if lt IE 7]>
            <p class="chromeframe">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> or <a href="http://www.google.com/chromeframe/?redirect=true">activate Google Chrome Frame</a> to improve your experience.</p>
        <![endif]-->

        <!-- This code is taken from http://twitter.github.com/bootstrap/examples/hero.html -->

        <!-- Site header starts here -->

            


             <!-- main content starts here -->

            <div class="container b-radius-top">
                <div class="top-bar b-radius">
                   
                    <div class="social">
                        <ul>
                           
                        </ul>
                    </div>
                </div>
                <div class="site-header">


                     <!-- Site Name starts here -->

                    <div class="site-name">
                        <h1>SECURING AGGREGATE QUERIES FOR DNA DATABASES</h1>
                    
                    </div>

                    <!-- Site Name ends -->

                     <!-- Menu starts here -->
                    <div class="menu">
                        <div class="navbar">
                            <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
                               <i class="fw-icon-th-list"></i>
                            </a>
                            <div class="nav-collapse collapse">
                                <ul class="nav">
                                   <li><a href="cloud2home.jsp">Home</a></li>
                                    <li class="active"><a href="user_details.jsp">View Researchers</a></li>
                             
                                    <li><a href="viewuserfiles.jsp">View files</a></li> 
                                    
                                    <li><a href="logout.jsp">logout</a></li>
                                </ul>
                             
                            </div>
                        </div>
                    </div>

                    <!-- Menu ends -->
                </div>
				<h3 class="section-name" >
					<span>
						User Details
					</span>
                                </h3>
                            <br>
                            <br>
               <center>
                   <table border="1" width="700px" hieght="1200px" style="text-align: center;background-color:#ff99ff">
                   
                       <tr style="color:black;">
                          <th>Name</th>
                               
                                <th>Email</th>
                                <th>Birth Day </th>
                              
                          
                                <th>Status</th>
                                <th>Activate</th>
                         </tr>
                         <tr>
                                <%
                                    try {
                                        Connection con;
                                        Statement st;
                                        ResultSet rs;
                                        con = Dbconnection.getConnection();
                                        st = con.createStatement();
                                        rs = st.executeQuery("select * from user");
                                        while (rs.next()) {
                                            String email=rs.getString("email");
                                            
            %>
                                <td><%=rs.getString("username")%></td>
                              
                                <td><%=rs.getString("email")%></td>
                                <td><%=rs.getString("dob")%></td>
                                
                              
                                 <td><%=rs.getString("status")%></td>
                                
                                 <td><a href="uactivate.jsp?<%=email%>" >Activate</a> </td>
                               </tr>
                            <%}
                                } catch (Exception ex) {
                                    ex.printStackTrace();
                                }
                            %>
                        </table>
               </center>
                            <br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
				</div>
                </div>
		</section>	
	

		<script type="text/javascript" src="assets/js/jquery-2.1.0.min.js"></script>
		<script type="text/javascript" src="assets/js/modernizr-2.8.0.min.js"></script>
		<script type="text/javascript" src="assets/js/plugins.js"></script>
		<script type="text/javascript" src="assets/js/functions.js"></script>
		<script type="text/javascript" src="assets/js/jquery.ajaxchimp.min.js"></script>

	</body>
	</html>
