把数据库select出来的信息,放在Vector中
<select>
<%for(int i=0;i<vector.size();i++){%>
<option value="<%=vector.get(i)%>"><%=vector.get(i)%>
<%}%>
</select>
<select>
<%for(int i=0;i<vector.size();i++){%>
<option value="<%=vector.get(i)%>"><%=vector.get(i)%>
<%}%>
</select>
解决方案 »
- 急~ 关于Struts2标签的问题..高手给我看看
- 这个怎么实现?
- 关于oracle中空格查询问题
- struts+hibernate+spring代码,webwork+hibernate+velocity代码下载
- 请问如何在JSP中取得当前页面所在的网站的网址和端口?
- Unsupported syntax for refreshRow() 是什么原因?紧急!!
- 我应该留下吗?
- (急)jsp中<input type=file>标签的跨平台问题
- jdbc连接报Response has already been committed什么问题呢
- 在css中如何设置页面背景颜色
- 弱手提问:怎么获得一个列表框中的值?
- 请教这个action的写法!!
<p><html:select property="XFAQGLR_PXQK" name="record" size="1">
<html:option value="有">有</html:option>
<html:option value="无">无</html:option>
</html:select></p>
<html:options collection="rows" name="row" property="code"/>
</html:select>
rows是你在action中定义的ArrayList或者vector等,row是里面的hashmap或者bean,select选择的值在Actionform的code中。所以可以很方便的设初值。
<select name="toTalk" >
<option value="all" selected><font size="2">全体在聊</font></option>
<%
sql="select * from T_LT_ONLINE_USER";//
rs=chatonlineBean.executeQuery(sql);//连接数据库
String tempname=new String();
while(rs.next())
{
tempname=rs.getString("YHMC");
if(!tempname.equals(logname))
{
out.println("<option>");
out.println(tempname);
out.println("</option>");
}
}
%>
</select>
但愿有帮助
String roomName[]=new String[100];
int i=0,j=0,k=0,p=0;
String sql="select distinct expAddr from expName";
rs1=DBBean.executeQuery(sql);
while(rs1.next())
{
roomName[i]=rs1.getString("expAddr");
i++;
}
...........
<select style="WIDTH: 150px;POSITION: absolute; CLIP: rect(0px 150px 20px 130px)"
onchange="location.href=form1.menu1.options.value;text2.value=menu1.value;text2.select();" name=menu1>
<option selected>--请选择实验地点--</option>
<% while(j<i)
{
%>
<option value="change.jsp?search=<%= roomName[j] %>"><%= roomName[j] %></option>
<% j++;
} %>
</select>
* description : 主要从数据库中根据sql动态生成下拉列表.
* @author: Morgan
* Company: http://www.mytv365.com
* Copyright: Copyright (c) 2004
* @version 1.0
*/package com.morgan.other;import java.sql.*;public class SelectList{
public SelectList() { } public static String getListString(java.sql.Connection conn,String sql,String display) {
String listString="";
try{
java.sql.Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
listString=listString+"<option>"+rs.getString(display)+"</option><br>";
}
rs.close();
}catch(Exception e){ listString=""; }
return listString;
} public static String getListString(java.sql.Connection conn,String sql,String value,String display) {
String listString="";
try{
java.sql.Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
listString=listString+"<option value='"+rs.getString(value)+"'>"+rs.getString(display)+"</option><br>";
}
rs.close();
}catch(Exception e){ listString=""; }
return listString;
}
public static void main(String[] args)
{
System.out.println("Hello World!");
}
}