1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
<%
String string = "select r.ARTICLE,r.PARAGRAPHE,r.LIGNE,r.INTITULE,d.TYPE from intendensao.rubrique r,intendensao.depenses d,intendensao.budget b where r.ID_RUBRIQUE=d.ID_RUBRIQUE and r.exercice='"+exercice+"'";
MyConnection connexion = new MyConnection();
ResultSet result = connexion.getRequest(string);
while(result.next()){
%>
<tr>
<td><%=result.getString("ARTICLE")%></td>
<td><%=result.getString("LIGNE")%></td>
<td><%=result.getString("PARAGRAPHE")%></td>
<td><%=result.getString("INTITULE")%></td>
<td><%=result.getString("TYPE")%></td>
<td><html:text property="creditOuvert" value="0" /></td>
<td><html:text property="disponible" value="0" /></td>
</tr>
<%
}
%>
<tr>
<td colspan="7"><html:submit value="enregistrer" /></td>
</tr>
</tbody> |
Partager