<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
    <HEAD>
        <TITLE> Search Meeting </TITLE>
        <META NAME="Generator" CONTENT="EditPlus">
        <META NAME="Author" CONTENT="">
        <META NAME="Keywords" CONTENT="">
        <META NAME="Description" CONTENT="">
        <%@ page import ="java.sql.*" %>
        <%@ page import="dbqueries.*" %>
        <script type='text/javascript' src='zapatec.js'></script>        
        <!-- Custom includes -->	
        <!-- import the calendar script -->
        <script type="text/javascript" src="calendar.js"></script>
        
        <!-- import the language module -->
        <script type="text/javascript" src="calendar-en.js"></script>
        
        <!-- Theme css -->
        <link href="forest.css" rel="stylesheet" type="text/css"> 
    </HEAD>
    
    <jsp:include page="banner.html"></jsp:include>
    
    <body background="_themes/aftrnoon/background_aftrnoon.gif" bgcolor="#FFFFFF" text="#000000" link="#983738" vlink="#703637" alink="#C76565"><!--mstheme-->
          
          <%
            String s1 = (String) session.getAttribute("id");
            Connection con = DataBase.getConnection();
            Statement st = con.createStatement();
            String query = "select first_name from sdms.signup where empid =" + s1;
            ResultSet rs = st.executeQuery(query);
            if (rs.next()) {
                String s2 = rs.getString("first_name");
                // out.println(s2);
%>
          
 
        <p align="left">&nbsp;</p>
        <p align="left">&nbsp;</p>
        <p align="center"><b><font size="4">Meeting initiated by <%=s2%> <%}%> are :-</font></b></p>
        <p align="left">&nbsp;</p>
        
        <%
            query = "SELECT meetingid, agenda FROM sdms.scheduledmeetings where empid =" + s1;
            rs = st.executeQuery(query);
        %>
        
       
            
          
        
        <div align="center">
  <center>
        <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="54%">
            <tr>
                <td width="30%" bgcolor="#FFFF00" align="center"><b>Meeting ID</b></td>
                <td width="70%" bgcolor="#FFFF00" align="center"><b>Agenda</b></td>
            </tr>
            <%
            while (rs.next()) {
                String s3 = rs.getString("agenda");
                int i = rs.getInt("meetingid");
                           %>
            <tr>
                <td width="30%" align="center"><%=i%></td>
                <td width="70%" align="center"><a href="meetingresult.jsp?meetingAgenda=<%=s3%>"> <%=s3%> <% }%></a></td>
            </tr>
        </table>
        </center>
</div>
        
    </body>
</HTML>