Java 如何使用jsp根据选择框中的结果集值设置所选选项
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/19701843/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how to set selected option based on result set value in select box using jsp
提问by Hareesh
i'm getting user table values from database using the following code
我使用以下代码从数据库中获取用户表值
<%
String userid=(String)session.getAttribute("userid");
Connection con=Singleton.getMySqlConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from user where mail='"+userid+"'");
%>
and display the values in jsp page like
并在jsp页面中显示值，如
<%while(rs.next()){%>
<div class="divRegTableColF"><label for="USER_FIRST_NAME">First name: </label></div>
<%if((rs.getString(2))!=null){%>
<div class="divRegTableColS"><span> <input class="inputRegBox" name="fname" id="USER_FIRST_NAME" size="60" maxlength="50" value="<%=rs.getString(2)%>"></span>
</div>
<%}
else
{%>
<input class="inputRegBox" name="fname" id="USER_FIRST_NAME" size="60" maxlength="50" value=""></span><span class="astRegPad"><font color="#000000">*</font>
<%}%>
<select class="inputRegBox" name="country" size=1 maxlength=30 value="<%=rs.getString(13)%>">
<option>select</option>
<option >Afghanistan</option>
<option >Aland Islands</option>
<option>Albania</option>
<option>Algeria</option>
<option>American Samoa</option>
<option>Andorra</option>
<option>Angola</option>
<option>Anguilla</option>
<option>Antarctica</option>
<option>Antigua and Barbuda</option>
<option>Argentina</option>
<option>Armenia</option>
<option>Aruba</option>
<option>Australia</option>
<option>Austria</option>
<option>Azerbaijan</option>
<option>Bahamas</option>
<option>Bahrain</option>
<option>Bangladesh</option>
<option>Barbados</option>
<option>Belarus</option>
<option>Belgium</option>
<option>Belize</option>
<option>Benin</option>
<option>Bermuda</option>
<option>Bhutan</option>
<option>Bolivia</option>
<option>Bonaire, Saint Eustatius and Saba</option>
<option>Bosnia and Herzegovina</option>
<option>Botswana</option>
<option>Bouvet Island</option>
<option>Brazil</option>
</select>
</div></div>
</div>
<%}%>
enter code here
i'm getting the country value in select box.how to selected option value and display that value in select box.
我在选择框中获取国家/地区值。如何选择选项值并在选择框中显示该值。
采纳答案by Krish R
Add condition in option selected tag, since am not jsp developer, But easily you will add all the option value in array and execute,
在选项选择标签中添加条件，因为我不是 jsp 开发人员，但是很容易你将所有选项值添加到数组中并执行，
<select class="inputRegBox" name="country" size=1 maxlength=30 >
<option value="Afghanistan" <%if((rs.getString(13))=='Afghanistan'){%> selected <%}%> >Afghanistan</option>
</select>
