javabean:
public class ProBean {
private String id ;
private String functionName;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getFunctionName() {
return functionName;
}
public void setFunctionName(String functionName) {
this.functionName = functionName;
}
}
读取数据库方法:
public static List getPro(){
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
List typeList=null;
try{
typeList=new ArrayList();
conn=ConnDB.getConn();
String sql="select * from t_Function";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
ProBean pb=new ProBean();
pb.setId(rs.getString("id"));
pb.setFunctionName(rs.getString("functionName"));
typeList.add(pb);
}
}catch(SQLException ex){
ex.printStackTrace();
}finally{
try {
if(rs!=null){
rs.close();
rs=null;
}
if(ps!=null){
ps.close();
ps=null;
}
if(conn!=null){
conn.close();
conn=null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return typeList;
}
action:
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
request.setAttribute("infor1", "新添加的项目名不能与已有项目名一致");
request.setAttribute("infor2", "更改项目名");
request.setAttribute("infor3", "删除项目名");
ArrayList al=(ArrayList)ProGet.getPro();
request.setAttribute("al", al);
return mapping.findForward("project");
}
jsp页面:
<c:forEach items="${al }" var="arrayList" >
<option value="${arrayList.id }">${arrayList.functionName } </option>
</c:forEach>
经常误写成:
<c:forEach items="${al }" var="arrayList" >
<option value="${arrayList.id }">${arrayList.getFunctionName() }</option>
</c:forEach>