Question

select 选框中如何显示sql语句查询出来的内容

Answer 1

<select>
<%
String query="select column1, column2 from table1";
ResultSet rs=mydb.executeQuery(query);
while(rs.next()){
%>
<option value="<%=rs.getString("column1")%>" ><%=rs.getString("column2")%></option>
<%
}
rs.close();%>
</select>

Answer 2

select [columnname], .....

追问

我说的是jsp页面中得select选框中要显示sql中select语句查询出来的数据