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
   |  
</head>
 
    <body>
        <jsp:include page="En_tete.jsp"/>
 
        <div id="bloc-contenu">
            <div id="col-centre">
 
                <%
                            Connection cx = DAO.Connexion.getConnecion();
                            java.sql.Statement st = cx.createStatement();
                            ResultSet rs = st.executeQuery("select * from pdt");
                            java.sql.Statement statement = cx.createStatement();
                            ResultSet rst = statement.executeQuery("select * from article");
                            java.sql.Statement stat = cx.createStatement();
                            ResultSet result = stat.executeQuery("select * from article2");
 
 
 
                %>
                <form name="Formulaire" method="post" action="Prestataire.jsp">
                    <table border="2">
                        <tr>
 
                            <td>Familles : </td><td><select name="rub"> <%while (rs.next()) {%><option value="<%=rs.getInt(1)%>"><%=rs.getString(2)%><%}%></select></td>
                            <td>Sous famille : </td><td><select onchange="true" name="type"> <%while (rst.next()) {%><option value="<%=rst.getInt(1)%>"><%=rst.getString(2)%><%}%></select></td>
                            <td>Article     :  </td><td><select onchange="true" name="type"> <%while (result.next()) {%><option value="<%=result.getInt(1)%>"><%=result.getString(2)%><%}%></select></td></td>
                            <td>Prix : </td>
                            <td><input name="price" type="text" value=""  size="18" maxlength="255" id="textinput5"/></td>
                            <td>Quantité : </td>
                            <td class="calc_td_resultat" >
                                <input type="text" readonly="readonly" name="calc_resultat" id="textinput5"  onkeydown="javascript:key_detect_calc('calc',event);" />
                            </td>
 
                        </tr>
                        <tr><td colspan="2"><input type="text" name="fml" id="textinput5" value=Select_C()></td></tr>
                        <td><input type="submit" name="button" value =" Valider">
                        </td>
 
                    </table>
                    <br>
                    <jsp:include page="calculatrice.jsp"/>
 
                </form>
 
 
 
            </div>
        </div>
 
 
        <jsp:include page="Menu.jsp"/>
        <jsp:include page="Bas_page.jsp"/>
    </body>
</html> | 
Partager