取数据:
sultSet rs = stmt.executeQuery(...);
HashMap result = new HashMap();
while(rs.next()){
String session_id = rs.getString("session_id");
String year = rs.getString("year");
String name = rs.getString("name");
String key = null;
if(session_id.equals("null")){
key = "nonseason";
}else{
key = year + "," + session_id;
}
if(result.get(key) != null){
String oldValue = (String)result.get(key);
name = oldValue + "|" + name;
} result.put(key,name);
}
request.setAttribute("Result",result);取完后用request.setAttribute("Result",result);把HashMap传递到页面页面代码:
<%
HashMap result = (HashMap)request.getAttribute("Result");
%>
<form name="form" action="要提交的Servlet" method="post">
<select name="select" onchange="form.submit()">
<%
Iterator keysIterator = result.keySet().iterator();
while(keysIterator.hasNext()){
String keyName = (String)keysIterator.next();
out.println("    <option value=\"keyName\">" + keyName + "</option>");
String value = (String)result.get(keyName);
String[] allSub = value.split("|");
for(int i = 0;i < allSub.length;i ++){
out.println("<option value=\"" + allSub[i] + "\">" + allSub + "</option>");
}
}
%>
</select>
</form>