public List findCustomerSecondeType(Long tyid) throws Exception{
List ret = null ;
MCustomerSecondTypeDAO dao = null;
Session ss = null ;
Connection conn = null;
Statement st = null;
try {
dao = new MCustomerSecondTypeDAO();
ss = dao.createNewSession();
conn = ss.connection();
st = conn.createStatement();
ResultSet rsn =st.executeQuery("select set.id,set.name from m_customer_second_type as set where set.flag='0' and set.ty_id='"+tyid.intValue()+"'");
RowSetDynaClass rsdc2 = new RowSetDynaClass(rsn);
ret = rsdc2.getRows();
} catch (Exception e) {
e.printStackTrace();
log.error(e.getMessage());
throw e;
} finally {
dao.closeSession(ss);
// st.close();
// conn.close();
}
return ret;
}
只有页面得到此list之后可以这样使用:secList为list
for(Iterator it = secList.iterator(); it.hasNext();){
BasicDynaBean secObj = (BasicDynaBean)it.next();
secObj.get("id");
secObj.get("name");
}//enf for
其实有三种方式可以使用:
<c:if test="${not empty list}">
<c:forEach items="${list}" var="cp">
<jsp:useBean id="cp" beanName="cp" type="org.apache.commons.beanutils.DynaBean"/>
%%%%%%%% == <%=cp.get("id")%>,<%=cp.get("adddate")%>,<%=cp.get("point")%><br>
</c:forEach>
</c:if>
==========================================================================<br>
<logic:iterate id="cp" name="list" type="org.apache.commons.beanutils.DynaBean">
<%=cp.get("id")%>,<%=cp.get("adddate")%>,<%=cp.get("point")%><br>
</logic:iterate>
==========================================================================<br>
<logic:iterate id="cp" name="list">
===<bean:write name="cp" property="id"/>,<bean:write name="cp" property="adddate"/><br>
</logic:iterate>