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