Skip to content

P
ProyectoFinal-Bootcamp
Switch branch/tag
Find file
Normal viewHistoryPermalink
manage_postulantes.jsp 4.73 KB
Newer Older
cambiado la extension manage_postulante de html por jsp
bd9b5ea9
 
Yovan Martinez committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*,java.sql.Connection,java.sql.ResultSet,com.roshka.proyectofinal.DataBase"%>
        <!DOCTYPE html>
        <html>

        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
            <link href="css/bootstrap.css" rel="stylesheet" type="text/css" />
            <script src="Javascript.js"></script>
            <title>aceptar postulantes</title>
        </head>

        <body>
            <main>

                <div>
                    <h1>Lista de postulante</h1>
                    <table>
                        <!-- <a href="ViewServletPostulante">Aca para lista capo</a> -->
                        <tr>
                            <th>Id postulante</th>
                            <th>Nombre</th>
                            <th>Apellido</th>
                            <th>Numero de Cedula</th>
                            <th>Correo</th>
                            <th>Telefono</th>
                            <th>Direccion de domicilio</th>
                            <th>Experiencia Labporal:</th>
                            <th>Posee notebook</th>
                            <th>Bootcamp_id</th>
                            <th>Estado</th>
                            <th>Aceptar/Rechazar</th>
                        </tr>
                        <%
                        Connection con = DataBase.getConnection();
                        Statement stmt = con.createStatement();
                        ResultSet rs = stmt.executeQuery("SELECT * FROM postulante");
                        while(rs.next()){
                        %>
                            <tr>
                                <td>
                                    <%= rs.getInt("id") %>
                                </td>
                                <td>
                                    <%= rs.getString("nombre") %>
                                </td>
                                <td>
                                    <%= rs.getString("apellido") %>
                                </td>
                                <td>
                                    <%= rs.getInt("nro_cedula") %>
                                </td>
                                <td>
                                    <%= rs.getString("correo") %>
                                </td>
                                <td>
                                    <%= rs.getString("telefono") %>
                                </td>
                                <td>
                                    <%= rs.getString("direccion") %>
                                </td>
                                <td>
                                    <%= rs.getBoolean("experiencia_laboral") %>
                                </td>
                                <td>
                                    <%= rs.getBoolean("notebook") %>
                                </td>
                                <td>
                                    <%= rs.getInt("bootcamp_id") %>
                                </td>
                                <td>
                                    <%
                                    String aceptado= "";
                                    if (rs.getBoolean("aceptado")){
                                        aceptado= "Aceptado";
                                    }else{
                                        aceptado="Rechazado";
                                    }
                                    %>
                                        <%= aceptado %>
                                </td>
                                <td>
                                    <form method="post" action="EditServletPostulante">
                                        <input type="hidden" value=<% %> id=
                                        <%=rs.getInt( "id") %>>
                                            <%
                                        String accion = "";
                                    if (rs.getBoolean("aceptado")){
                                        accion= "Rechazar";
                                    }else{
                                        accion="Aceptar";
                                    }
                                    %>
                                                <input type="submit" value=<%=accion %>
                                                <a href=""></a>
                                    </form>

                                </td>

                            </tr>
                            <%
                }
                %>
                    </table>
                </div>

            </main>

        </body>

        </html>