Untitled


<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.Statement"%>
<%ResultSet resultset=null;%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

<html>
    <head>
        <style>
table, th, td {
    border: 2px solid black;
    border-collapse: collapse;
}
th, td {
    padding: 5px;
    text-align: left;
}
</style>
        <title></title>
    </head>
    <body>
        <%!String driverName="com.mysql.jdbc.Driver";%>
        <%!String url="jdbc:mysql://localhost/trainees";%>
        <%!String user="root";%>
        <%!String pwd="";%>

        <form action="allocateStream.jsp">
            <%
Connection con = null;
PreparedStatement ps = null;

try{
    Class.forName("org.gjt.mm.mysql.Driver");
    con = DriverManager.getConnection(url, user, pwd);
    String sql ="SELECT * FROM stream";
    ps = con.prepareStatement(sql);
    ResultSet rs = ps.executeQuery();
    %>
    <center><table style="width:50%"></table>
    <table> <!--Text> Widgets for the customer's name and address -->
                    <tr>
                     <th colspan="2"><center>Allocate Stream</th></tr></center>

                    <tr>
                        <td>Employee Id</td> <td><input type="text" size="30" name="empId" size="30" />
                        </td>
                    </tr>
                    <tr>
                        <td><center><p>Stream Id</center></p></td>
            </tr>
        <select name="stream">
            <% while(rs.next()){ %>

            <option><%= rs.getInt("StreamId")%></option>


            <% } %>
        </select>

                        <tr>
                         <th colspan="2"><center><input type="submit" value="Submit"></th>
                     </tr>
                </table>

        <%

}
catch(Exception e)
{
    out.println(e);
}
%>

        </form>

    </body>
</html>