毕业设计学生的一个问题,粘贴过来:
这段时间的确比较忙,我尽快给你整理MDA例子,那个下拉菜单是labelvaluebean,后面是个例子:
在action中把lwlxmlist(这是个ArrayList,里面放的是LabelValueBean)放到request中(没有用到spring框架,pub_code是一个代码表,树状结构的,根节点是"LWLXM"):
......
request.setAttribute("
lwlxmlist", new Code().getMenu("LWLXM", "pub_code"));
......
在Code类中,组织一个ArrayList,里面放的是Labelvaluebean(大概的代码如下,没有用Hibernate,用的是我们实验室的一个数据库连接池,主要用来连接国产数据库的,仅供参考):
public ArrayList getMenu(String type_code, String table_name){
try{
ArrayList ret_list=new ArrayList();
SQLBean conn=new SQLBean();
ResultSet rs=conn.executeQuery("select * from "+table_name+" where parent_id=(select id from "+
table_name+" where code='"+type_code+"') order by code");
while(rs.next()){
ret_list.add( new LabelValueBean(rs.getString("description"),(rs.getString("code")==null)?"":rs.getString("code").trim()));
}
conn.close();
return ret_list;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
try{
ArrayList ret_list=new ArrayList();
SQLBean conn=new SQLBean();
ResultSet rs=conn.executeQuery("select * from "+table_name+" where parent_id=(select id from "+
table_name+" where code='"+type_code+"') order by code");
while(rs.next()){
ret_list.add( new LabelValueBean(rs.getString("description"),(rs.getString("code")==null)?"":rs.getString("code").trim()));
}
conn.close();
return ret_list;
}catch(Exception e){
e.printStackTrace();
return null;
}
}
最后,在页面中这样显示下拉菜单:
......
<tr>
<td align="left">
论文类型:
</td>
<td align="left">
<logic:notEmpty name=" lwlxmlist" scope="request">
<html:select property="lwlxm">
<html:optionsCollection name=" lwlxmlist" />
</html:select>
</logic:notEmpty>
<font size=2 color=red><html:errors property="lwlxm" />
</font>
</td>
</tr>
<td align="left">
论文类型:
</td>
<td align="left">
<logic:notEmpty name=" lwlxmlist" scope="request">
<html:select property="lwlxm">
<html:optionsCollection name=" lwlxmlist" />
</html:select>
</logic:notEmpty>
<font size=2 color=red><html:errors property="lwlxm" />
</font>
</td>
</tr>
......
不要忘了在jsp页面中引入html和logic标签:
<
%@taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>
< %@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
< %@taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
< %@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
< %@taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
ok了,这样就有下拉菜单了。