/****************Action****************/
public String execute() throws Exception {
List_Date = this.listCommonService.Common_List(common);//查询所有
if(List_Date!=null && List_Date.size()>0){
for(Common common : List_Date){
if(common.getC_type()!=null && common.getC_type()==null){
List_Date.get(common.getC_id());//传C_id
}
}
}
/****************Service****************/
public List Common_List(Common common) {
List<Common> List_Common = this.commonMapper.Common_List(common); return List_Common;
}
/****************DAO****************/
public List Common_List(Common common);
/****************Mapper.XMl****************/
<!-- 查询导航 -->
<select id="Common_List" parameterType="com.order.model.Common"
resultType="com.order.model.Common">
select *
<include refid="Common_Info" />
order by C_sore asc
<include refid="Common_Linit" />
</select>
<!-- 导航查询条件 -->
<sql id="Common_Info">
from Common where 1=1
<if test="C_title != null and C_title.length() > 0">
and C_title like CONCAT('%',#{C_title},'%')
</if>
<if test="C_createDate != null">
and date(C_createDate) = date(#{C_createDate})
</if>
<if test="C_createDate != null">
and C_type = #{C_id}//分类(C_type)名称等与C_id
</if>
</sql>
/****************页面****************/
<s:iterator id="nav" value="List_Date">
<s:if test="#nav.c_type==null">
<s:property value="#nav.c_id" />
<s:property value="#nav.c_title" />
<s:iterator id="chil" value="List_Date">
<s:if test="#nav.c_id==#chil.c_type">
<s:property value="#chil.c_id" />
<s:property value="#chil.c_title" />
</s:if>
</s:iterator>
</s:if>
</s:iterator>
public String execute() throws Exception {
List_Date = this.listCommonService.Common_List(common);//查询所有
if(List_Date!=null && List_Date.size()>0){
for(Common common : List_Date){
if(common.getC_type()!=null && common.getC_type()==null){
List_Date.get(common.getC_id());//传C_id
}
}
}
/****************Service****************/
public List Common_List(Common common) {
List<Common> List_Common = this.commonMapper.Common_List(common); return List_Common;
}
/****************DAO****************/
public List Common_List(Common common);
/****************Mapper.XMl****************/
<!-- 查询导航 -->
<select id="Common_List" parameterType="com.order.model.Common"
resultType="com.order.model.Common">
select *
<include refid="Common_Info" />
order by C_sore asc
<include refid="Common_Linit" />
</select>
<!-- 导航查询条件 -->
<sql id="Common_Info">
from Common where 1=1
<if test="C_title != null and C_title.length() > 0">
and C_title like CONCAT('%',#{C_title},'%')
</if>
<if test="C_createDate != null">
and date(C_createDate) = date(#{C_createDate})
</if>
<if test="C_createDate != null">
and C_type = #{C_id}//分类(C_type)名称等与C_id
</if>
</sql>
/****************页面****************/
<s:iterator id="nav" value="List_Date">
<s:if test="#nav.c_type==null">
<s:property value="#nav.c_id" />
<s:property value="#nav.c_title" />
<s:iterator id="chil" value="List_Date">
<s:if test="#nav.c_id==#chil.c_type">
<s:property value="#chil.c_id" />
<s:property value="#chil.c_title" />
</s:if>
</s:iterator>
</s:if>
</s:iterator>