<select></select> Llenado

[piyolo]

Por el codigo libre...

<select name="Emps" onChange = "SelectOptionEmps()">
<option selected>Empresa</option>
<%
Conect conec = new Conect();
Connection cnxn = null;

String sql1 ="SELECT emp_nom, emp_id FROM emp_dest ORDER BY emp_id";
cnxn = conec.conectar();

Statement sentencia1 = cnxn.createStatement();
ResultSet results1 = sentencia1.executeQuery(sql1);
while (results1.next()) { // process results one row at a time
int Emp_Id = results1.getInt(2);
String Emp_Nom = results1.getString(1);
out.println(" <option value = "+Emp_Id+">"+Emp_Nom+"</option>");
}

out.println(" </select>");
out.println(" </td>");
%>

En onChange = "SelectOptionEmps() // Solo mando a llamar a la pagina a si misma