下拉列表有数据, 需要修改数据时,必须选中数据库表对应的值?
(1) 第一种方式: 通过判断比较
<td> <select size="1" name="job">
<%
if (emp.getJob().equals("CLERK")) {
%>
<option value="CLERK" selected="selected">CLERK</option>
<option value="SALESMAN">SALESMAN</option>
<option value="ANALYST">ANALYST</option>
<option value="PRESIDENT">PRESIDENT</option>
<%
} else if (emp.getJob().equals("SALESMAN")) {
%>
<option value="CLERK">CLERK</option>
<option value="SALESMAN" selected="selected">SALESMAN</option>
<option value="ANALYST">ANALYST</option>
<option value="PRESIDENT">PRESIDENT</option>
<%
} else if (emp.getJob().equals("ANALYST")) {
%>
<option value="CLERK">CLERK</option>
<option value="SALESMAN">SALESMAN</option>
<option value="ANALYST" selected="selected">ANALYST</option>
<option value="PRESIDENT">PRESIDENT</option>
<%
} else if (emp.getJob().equals("PRESIDENT")) {
%>
<option value="CLERK">CLERK</option>
<option value="SALESMAN">SALESMAN</option>
<option value="ANALYST">ANALYST</option>
<option value="PRESIDENT" selected="selected">PRESIDENT</option>
<%
}
%>
</select></td>
<td> <select size="1" name="deptno">
<option value="10" <% if(emp.getDeptno()==10) out.println("selected='selected'"); %>>ACCOUNTING</option>
<option value="20" <% if(emp.getDeptno()==20) out.println("selected='selected'"); %>>RESEARCH</option>
<option value="30" <% if(emp.getDeptno()==30) out.println("selected='selected'"); %>>SALES</option>
<option value="50" <% if(emp.getDeptno()==50) out.println("selected='selected'"); %>>TOOL</option>
<option value="40" <% if(emp.getDeptno()==40) out.println("selected='selected'"); %>>OPERATIONS</option>
</select></td>