<select name="username">
<%
String sql = "SELECT id, name FROM table1 ORDER BY name";
Connection con = DriverManager.getConnection(url, username, password);
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next())
{
%>
<option value="<%=rs.getInt("id")%>"><%=rs.getString("name")%></option>
<%
}
rs.close();
ps.close();
con.close();
%>
</select>
<%
String sql = "SELECT id, name FROM table1 ORDER BY name";
Connection con = DriverManager.getConnection(url, username, password);
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next())
{
%>
<option value="<%=rs.getInt("id")%>"><%=rs.getString("name")%></option>
<%
}
rs.close();
ps.close();
con.close();
%>
</select>
解决方案 »
- hibernate 查询数据的问题
- 软件工程将毕业 烦恼啊
- Jsp页面中标签的DTD在工程的什么地方 能找到?
- 类似校内,开心的这种sns网站容易做吗?
- 想学习SOA和WebService请问该如何入手
- The server encountered an internal error () that prevented it from fulfilling this request.
- 如何在JAX-RPC DII的调用方式中使用SOAP Handler ?
- 文件下载
- 为什么在SCO下面中文字符就变问号了呢?
- 获取文本域type为file的里面的值
- web service入门学习笔记
- org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated withthe session
/*
取出数据数据
......
*/
<select name="example">
<%
while(rs.next())
{
%>
<option value='<%=rs.getInt("id")%>'><%=rs.getString("name")%></option>
<%
}
rs.close();
%>
</select>