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
| <tr>
<td align="center">
<strong>LC</strong>
<select name="XXXX" size="1" multiple="multiple">
<script type="text/javascript">
for(i=0;i<document.NomDeLaFormContenantLaListe.XXXX.length;i++)
{
if(document.NomDeLaFormContenantLaListe.ope_type.options[i].selected == true)
i++;
}
//-->
</script>
<%
connection = dataSource.getConnection();
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
/**
* Retrieve the last update date
**/
result = statement.executeQuery("select distinct(XXXX)from fcm_operation order by ope_type ");
out.print("<option selected></option>");
while (result.next())
{
try
{
out.print("<option>" + result.getString("XXXX") + "</option>");
}
catch (NullPointerException e)
{
}
}
result.close();
statement.close();
connection.close();
%>
</select> |
Partager